Fork me on GitHub

GeoJsonRead

Signature

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

Description

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.

Examples

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