[Belgium] ogr2ogr GeoJSON to MariaDB/MySQL

[Jonathan Beliën]

Hi everyone,

I have a small issue when converting a GeoJSON file to a MariaDB table.
The datatype of every column is set to "TEXT" in my MariaDB table. I tried
to find a solution to set the correct datatype but without any success.

The only ""solution"" I found is to convert from GeoJSON to CSV ;
Then to convert from CSV to MySQL using "AUTODETECT_TYPE" and
"AUTODETECT_WIDTH" open options.
It works but I suppose there is a smarter and cleaner solution.

Any idea ?

Thanks !
Have a great day.

Jonathan
-------------- section suivante --------------
Une pièce jointe HTML a été nettoyée...
URL: <http://lists.osgeo.org/pipermail/belgium/attachments/20160425/a69aed63/attachment.html>