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 |