On 3 July 2018 at 12:50, Devdatta Tengshe <[email protected]> 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 _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
