1
2
3
4
5
6
7
|
ST_Length - GeometryCollection (Long/Lat metric - GreatCircle)
:memory: #use in-memory database
SELECT ST_Length(GeomFromText('GEOMETRYCOLLECTION(POINT(0.1 0.1), LINESTRING(0.7 0.7, 0.7 0.8, 0.8 0.8, 0.8 0.7, 0.7 0.8), POLYGON((0.5 0.5, 0.5 0.6, 0.6 0.6, 0.6 0.5, 0.5 0.5),(0.55 0.55, 0.56 0.55, 0.56 0.56, 0.56 0.56, 0.055 0.55)))'), 0);
1 # rows (not including the header row)
1 # columns
ST_Length(GeomFromText('GEOMETRYCOLLECTION(POINT(0.1 0.1), LINESTRING(0.7 0.7, 0.7 0.8, 0.8 0.8, 0.8 0.7, 0.7 0.8), POLYGON((0.5 0.5, 0.5 0.6, 0.6 0.6, 0.6 0.5, 0.5 0.5),(0.55 0.55, 0.56 0.55, 0.56 0.56, 0.56 0.56, 0.055 0.55)))'), 0)
49082.124419:6
|
