[postgis-users] What's the Fastest way to find if Polygons cover an input point?

Mateusz Loskot mateusz at loskot.net
Tue Jul 3 03:56:19 PDT 2018

On 3 July 2018 at 12:50, Devdatta Tengshe <devdatta at tengshe.in> wrote:
> Currently I'm using the following query to figure out if we can potentially
> service the customer:
> Select count(id) from service_areas where
> ST_CoveredBy(ST_SetSRID(ST_MakePoint(78.46239,17.30360),4326), geom);

Try https://postgis.net/docs/ST_Within.html

Best regards,
Mateusz Loskot, http://mateusz.loskot.net

More information about the postgis-users mailing list