[postgis-users] posted speed for a given road

[suraj birla]

Thanks Mike.

I downloaded  OSM .pbf file and now I need osm2pgsql tool to extract the
data. Is there a installer available for centos machine?  There are
instruction on the web to compile the code from github but it requires some
dependent. If the installer is available, that would be great.

Any link?





On Sun, Sep 17, 2017 at 6:07 PM, Mike Toews <mwtoews at gmail.com> wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170919/e7852de2/attachment.html>