Hi Suraj, There is nothing specific in PostGIS that would help you determine this. You essentially need to load your data with the attributes (such as speed limit), and then you can query this information from a point.
I'd suggest looking into projects like OSM for this data, using a read-only API or importing to PostGIS to query: http://wiki.openstreetmap.org/wiki/Speed_limits http://wiki.openstreetmap.org/wiki/Overpass_API http://wiki.openstreetmap.org/wiki/PostGIS Cheers, Mike On 18 September 2017 at 12:16, suraj birla <[email protected]> wrote: > Hi, > > Is it possible to find posted speed for a given lat/lon in POSTGIS by > loading road shapfile? > > Currently we are using google API to get the posted speed. > > Thanks > Suraj _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
