Fork me on GitHub

GeoJsonWrite

Signature

GeoJsonWrite(VARCHAR path, VARCHAR tableName);

Description

Writes table tableName to a GeoJSON file located at path.

Examples

-- Write a spatial table to a GeoJSON file:
CREATE TABLE TEST(ID INT PRIMARY KEY, THE_GEOM POINT);
INSERT INTO TEST VALUES (1, 'POINT(0 1)');
CALL GeoJsonWrite('/home/user/test.geojson', 'TEST');

-- Read it back:
CALL GeoJsonRead('/home/user/test.geojson', 'TEST2');
SELECT * FROM TEST2;
-- Answer:
-- | THE_GEOM    | ID |
-- |-------------|----|
-- | POINT(0 1)  | 1  |
See also