[postgis-users] posted speed for a given road

[Mike Toews]

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 <surajbirla at gmail.com> 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