1
2
3
4
5
6
7
|
shiftlongitude - positive and negative longitude polygon, interior rings
:memory: #use in-memory database
SELECT AsText(ST_Shift_Longitude(GeomFromText('POLYGON((-175 0, -176 10, 175 10, 176 0, -175 0),(-177 1, -177 2, -178 2, -178 1, -177 1),(-179 4, 179 4, 179 5, -179 5, -179 4))', 4326)))
1 # rows (not including the header row)
1 # columns
AsText(ST_Shift_Longitude(GeomFromText('POLYGON((-175 0, -176 10, 175 10, 176 0, -175 0),(-177 1, -177 2, -178 2, -178 1, -177 1),(-179 4, 179 4, 179 5, -179 5, -179 4))', 4326)))
POLYGON((185 0, 184 10, 175 10, 176 0, 185 0), (183 1, 183 2, 182 2, 182 1, 183 1), (181 4, 179 4, 179 5, 181 5, 181 4))
|
