PostGIS - st_intersects using polygons that cross antimeridan/equator?

Question

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 `st_intersects` function. 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: st_point(170.0,45.0) st_point(170.0,-45.0) 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)

Answer 1

Full disclosure, my experience is with Esri's ArcGIS not with PostGIS. In examining the website for PostGIS, I've discovered that it is an open source product, and I love open source products but they do require more support than traditional products. My suggestion to you is visit https://postgis.net/support/ and pick a support option that works for you. Please feel free to reach out to me if I can assist you further, but my experience with ArcGIS and other software products, has been the support community is the best way to get questions answered. Best of luck to you!