Fork me on GitHub



GeoJsonRead(VARCHAR path);
GeoJsonRead(VARCHAR path, VARCHAR tableName);


Reads a GeoJSON file from path and creates the corresponding spatial table tableName.

If the tablename parameter is not specified, then the resulting table has the same name as the GeoJSON file.

Warning on the input file name

When a tablename is not specified, special caracters in the input file name are not allowed. The possible caracters are as follow: A to Z, _ and 0 to 9.


CALL GeoJsonRead('/home/user/data.geojson');

→ Here data.geojson will produce a table named data.

CALL GeoJsonRead('/home/user/data.geojson', 'NEW_DATA');

→ Here data.geojson will produce a table named NEW_DATA.

See also