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