1
2
3
4
5
6
7
|
shiftlongitude - polygon with interior, all positive
:memory: #use in-memory database
SELECT AsText(ST_Shift_Longitude(GeomFromText('POLYGON((185 0, 184 10, 175 10, 176 0, 185 0),(176 2, 181 2, 181 4, 176 4, 176 2))', 4326)))
1 # rows (not including the header row)
1 # columns
AsText(ST_Shift_Longitude(GeomFromText('POLYGON((185 0, 184 10, 175 10, 176 0, 185 0),(176 2, 181 2, 181 4, 176 4, 176 2))', 4326)))
POLYGON((185 0, 184 10, 175 10, 176 0, 185 0), (176 2, 181 2, 181 4, 176 4, 176 2))
|
