[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] posted speed for a given road
From:       suraj birla <surajbirla () gmail ! com>
Date:       2017-09-20 0:32:41
Message-ID: CACA5SkDnkLiUFxZZJ5ga_cuZ9x3iA+opFUkcxu0mOx8YNzARog () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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@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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

[Attachment #5 (text/html)]

<div dir="ltr">Thanks Mike.<div><br></div><div>I downloaded   OSM .pbf file and now I \
need  <span style="background-color:rgb(249,249,249);color:rgb(0,0,0);font-family:monospace,Courier;font-size:1.2em;white-space:pre-wrap">osm2pgsql</span> \
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.<br></div><div><br></div><div>Any \
link?</div><div><br></div><div><br></div><div><br></div><div><br></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Sun, Sep 17, 2017 at 6:07 PM, \
Mike Toews <span dir="ltr">&lt;<a href="mailto:mwtoews@gmail.com" \
target="_blank">mwtoews@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi Suraj,<br> <br>
There is nothing specific in PostGIS that would help you determine<br>
this. You essentially need to load your data with the attributes (such<br>
as speed limit), and then you can query this information from a point.<br>
<br>
I&#39;d suggest looking into projects like OSM for this data, using a<br>
read-only API or importing to PostGIS to query:<br>
<a href="http://wiki.openstreetmap.org/wiki/Speed_limits" rel="noreferrer" \
target="_blank">http://wiki.openstreetmap.org/<wbr>wiki/Speed_limits</a><br> <a \
href="http://wiki.openstreetmap.org/wiki/Overpass_API" rel="noreferrer" \
target="_blank">http://wiki.openstreetmap.org/<wbr>wiki/Overpass_API</a><br> <a \
href="http://wiki.openstreetmap.org/wiki/PostGIS" rel="noreferrer" \
target="_blank">http://wiki.openstreetmap.org/<wbr>wiki/PostGIS</a><br> <br>
Cheers,<br>
Mike<br>
<div><div class="h5"><br>
On 18 September 2017 at 12:16, suraj birla &lt;<a \
href="mailto:surajbirla@gmail.com">surajbirla@gmail.com</a>&gt; wrote:<br> &gt; \
Hi,<br> &gt;<br>
&gt; Is it possible to find posted speed for a given lat/lon in POSTGIS by<br>
&gt; loading road shapfile?<br>
&gt;<br>
&gt; Currently we are using google API to get the posted speed.<br>
&gt;<br>
&gt; Thanks<br>
&gt; Suraj<br>
</div></div>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></blockquote></div><br></div>



[Attachment #6 (text/plain)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]