[pgrouting-users] Pgrouting-users Digest, Vol 83, Issue 16
James Keener
jim at jimkeener.com
Sat Aug 29 09:07:16 PDT 2015
Thanks for your response Vicky!
I think I've figured out what the issue is: I'm not too bright!
I was expecting all reachable edges to be selected, but I was wrong.
All usable VERTICES are selected.
Cheers! and Thank you very much!
Jim
Aside:
I had originally built and installed from 0a8be6a
I've since purged the files from
/usr/lib/postgresql/9.3/lib/ and /usr/share/postgresql/9.3/extension/
and built and installed a14a70d which should be HEAD of develop_2_1_0 on
git://github.com/pgRouting/pgrouting.git
On 08/29/2015 12:19 AM, pgrouting-users-request at lists.osgeo.org wrote:
> Send Pgrouting-users mailing list submissions to
> pgrouting-users at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
> or, via email, send a message with subject or body 'help' to
> pgrouting-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
> pgrouting-users-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pgrouting-users digest..."
>
>
> Today's Topics:
>
> 1. Re: pgr_drivingdistance problem (Vicky Vergara)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 28 Aug 2015 23:19:12 -0500
> From: Vicky Vergara <vicky_vergara at hotmail.com>
> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> Subject: Re: [pgrouting-users] pgr_drivingdistance problem
> Message-ID: <BAY177-W30521CFE1B5B17FE5E53BA8A6D0 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello Jim
>
> I executed your query, I am not getting the same results as you are.
> Right now we are in the process of releasing pgRouting 2.1
> I used the pgr_DrivingDistance developed for the 2.1 version.
> The github branch develop has the latest but its changing a lot during this days.
>
> Vicky
>
>
>
> Date: Fri, 28 Aug 2015 20:45:45 -0400
> From: jim at jimkeener.com
> To: pgrouting-users at lists.osgeo.org; postgis-users at lists.osgeo.org
> Subject: [pgrouting-users] pgr_drivingdistance problem
>
>
>
>
>
>
>
> When I run pgr_drivingdistance
> on an small extract (578 rows) (attached) from an extract
> of Pennsylvania's osm pbf file not all edges are being
> followed.
> I first downloaded the pbf. Then I imported it with osm2pgrouting
>
> osmosis --read-pbf file=pennsylvania-latest.osm.pbf --write-xml pennsylvania-latest.osm
> osm2pgrouting -file pennsylvania-latest.osm -conf /usr/share/osm2pgrouting/mapconfig.xml -dbname osm3 -user jim -skipnodes -passwd hunter2
>
>
> and then running
>
> CREATE TABLE smallways AS
> SELECT * FROM ways
> WHERE ST_DISTANCE(the_geom, ST_GEOMFROMTEXT('POINT(-79.900121 40.448889)', 4326)) < 0.2;
>
>
> and creating the appropriate indices to build a test environment
> (the output of which
> is the small extract (578 rows)(attached)).
> To test pgr_drivingdistance, I did the following:
>
> CREATE OR REPLACE VIEW testing AS
> SELECT gid,
> the_geom
> FROM ( SELECT
> seq,
> id1 AS vertext_id,
> id2 AS gid,
> cost
> FROM pgr_drivingdistance(
> 'SELECT gid AS id, source, target,
> length AS cost, reverse_cost
> FROM smallways',
> 179103,
> 0.5,
> false,
> true) ) t
> INNER JOIN smallways USING (gid);
>
>
> and then loading that view into QGIS, I see the following:
>
>
> Why are some edges not being selected? I initially thought it was
> the (source, target) (labels in screenshot) ordering,
> but that doesn't seem to be the case, as some edges such as 148517
> to the SW of the annotated starting point, seems to be in good
> order.
>
>
>
>
> Jim
>
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20150828/64754341/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: with2.1.png
> Type: image/png
> Size: 181272 bytes
> Desc: not available
> URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20150828/64754341/attachment.png>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: Screenshot - 08282015 - 075732 PM.jpg
> Type: image/jpeg
> Size: 41978 bytes
> Desc: not available
> URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20150828/64754341/attachment.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: Screenshot - 08282015 - 075732 PM.png
> Type: image/png
> Size: 125238 bytes
> Desc: not available
> URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20150828/64754341/attachment-0001.png>
>
> ------------------------------
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
> End of Pgrouting-users Digest, Vol 83, Issue 16
> ***********************************************
>
More information about the Pgrouting-users
mailing list