1
2
3
4
5
6
7
8
|
GeoJSON MultiPolygon
:memory: #use in-memory database
SELECT AsGeoJSON(GeomFromText('MULTIPOLYGON(((5 5, 6 5, 6 6, 5 6, 5 5)), ((3 3, 4 3, 4 4, 3 4, 4 4)))', 4326), 2, 5);
1 # rows (not including the header row)
1 # columns
AsGeoJSON(GeomFromText('MULTIPOLYGON(((5 5, 6 5, 6 6, 5 6, 5 5)), ((3 3, 4 3, 4 4, 3 4, 4 4)))', 4326), 2, 5)
{"type":"MultiPolygon","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG:4326"}},"bbox":[3,3,6,6],"coordinates":[[[[5,5],[6,5],[6,6],[5,6],[5,5]]],[[[3,3],[4,3],[4,4],[3,4],[4,4]]]]}:0 # trailing ":0" required to avoid truncation !!!
|
