[pgrouting-users] Pgrouting-users Digest, Vol 83, Issue 16

James_Keener · August 29, 2015, 4:07pm

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@lists.osgeo.org wrote:

Send Pgrouting-users mailing list submissions to
  pgrouting-users@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@lists.osgeo.org

You can reach the person managing the list at
  pgrouting-users-owner@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@hotmail.com>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] pgr_drivingdistance problem
Message-ID: <BAY177-W30521CFE1B5B17FE5E53BA8A6D0@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@jimkeener.com
To: pgrouting-users@lists.osgeo.org; postgis-users@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

End of Pgrouting-users Digest, Vol 83, Issue 16
***********************************************