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

[Mateusz Loskot]

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