File: fromgeojson28.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (8 lines) | stat: -rw-r--r-- 449 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
 
FromGeoJSON - PointZ with SRID and bbox
:memory: #use in-memory database
SELECT AsEWkt(GeomFromGeoJSON('{"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[-1,1,-1,1],"coordinates":[-1,1,2.3]}'))
1 # rows (not including the header row)
1 # columns
AsEWkt(GeomFromGeoJSON('{"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[-1,1,-1,1],"coordinates":[-1,1,2.3]}')):0
SRID=3003;POINT(-1 1 2.3)