New to using PostGIS and have two situations that I'm working with.
In the one case, I have a polygon that crossed the antemeridian and was detecting whether a two separate points located within that polygon one on the west and one on the east side of the antimeridian intersects with the polygon (data types used are geometries). I found I had to use the
st_shift_longitude on the geometries passed to the
The other situation is a polygon crossing the equator with points above and below the equator within the polygon.
st_intersects doesn't detect both points intersect the polygon. Do the latitudes need to be shifted in this case? I didn't see a shift latitude function available.
I'm using the following points and polygon at the equator:
and the polygon 'POLYGON((165 40,175 40,175 -50,165 -50,165 40))'
I'd expect that the st_intersect function return true for both points, however, it's only returning true for st_point(170.0,-45.0)