[pgrouting-users] pgr_drivingdistance problem

[Vicky Vergara]

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-0001.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-0002.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-0001.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-0003.png>