Find which Polygon a Point belongs to

[codemountain]

Hello, starting to test the package and very cool.

We have areas (polygon GeoJson data) stored in a ServiceArea model.

When someone submits a form, we get there GeoLocation from which i can create a Point.

I'm not sure how to proceed to write the query that would find which ServiceArea record that Point would be in. No plans to have overlapping ServiceArea if that is a concern.

I think there must be a query that is more efficient then looping thru all records one by one in a foreach loop and check if point is in that polygon/area ?

Thank you for any insight.

[saibotk]

Hey sorry this took so long.

Yes you can use ST_Contains for this. See https://postgis.net/docs/ST_Contains.html

Something along the lines of

ServiceArea::stWhere(ST::contains('area_colum_name', $userLocationPoint))->first();

Does that solve your question?