[gdal-dev] Ignoring index in OGR2OGR

[Felipe Matas]

 :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 <even.rouault at spatialys.com> escribió:  
 
  
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) 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 set a spatial index with ogr2ogr? I check the doc, sadly I wasn't able get an answer.
  
  Thx.
   
  _______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
 -- 
http://www.spatialys.com
My software is free, but my time generally not.   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220516/002cd13c/attachment.htm>