I have a multipolygon of geography type (multi_bounds) and a point. I'm trying to figure out the fastest way to query whether the multipolygon contains the point. In this case if the point is part of the boundary it should still return true.
I've tried CoveredBy: WHERE ST_CoveredBy(ST_SetSRID(ST_MakePoint
long, :lat), 4326), multi_bounds::geometry)
Where :long and :lat are arguments provided by yesql.
And I've tried contains: WHERE ST_Contains(multi_bounds::geometry, ST_SetSRID(ST_MakePointlong, :lat), 4326))
I don't see a noticeable difference and I'm wondering what the best practice is here.
I did try ST_CoveredBy without casting multi_bounds to geometry but I couldn't get past an error: org.postgresql.util.PSQLException: ERROR: BOOM! Could not generate outside point!
أكثر...
I've tried CoveredBy: WHERE ST_CoveredBy(ST_SetSRID(ST_MakePoint
long, :lat), 4326), multi_bounds::geometry) Where :long and :lat are arguments provided by yesql.
And I've tried contains: WHERE ST_Contains(multi_bounds::geometry, ST_SetSRID(ST_MakePoint
long, :lat), 4326)) I don't see a noticeable difference and I'm wondering what the best practice is here.
I did try ST_CoveredBy without casting multi_bounds to geometry but I couldn't get past an error: org.postgresql.util.PSQLException: ERROR: BOOM! Could not generate outside point!
أكثر...