Re: [gdal-dev] Ignoring index in OGR2OGR

2022-05-16 Thread Felipe Matas via gdal-dev
:O I never thought that option would be there. Sadly, OGR2OGR seems to use the auto-increment option, so the server request an index, anyone except the geom column. I try use the FID value, but still can't set the index. Thx! El lunes, 16 de mayo de 2022, 04:19:38 p. m. GMT-4, Even Rouault

Re: [gdal-dev] Ignoring index in OGR2OGR

2022-05-16 Thread Even Rouault
Felipe, If you look at https://gdal.org/drivers/vector/mysql.html, you can see a SPATIAL_INDEX layer creation being mentioned. So try adding -lco SPATIAL_INDEX=NO to your ogr2ogr command line Even Le 16/05/2022 à 22:13, Felipe Matas via gdal-dev a écrit : Hi, I'm trying to use Dolt (a new db

[gdal-dev] Ignoring index in OGR2OGR

2022-05-16 Thread Felipe Matas via gdal-dev
Hi, I'm trying to use Dolt (a new db) with spatial data, it works with a MySQL syntax/core, so I'm able to use ogr2ogr to export data to the database, well half of it, the db actually don't support spatial index, and ogr2ogr use a spatial index, is there a way to upload a spatial file without se