<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hello Jim<br><br>I executed your query, I am not getting the same results as you are.<br>Right now we are in the process of releasing pgRouting 2.1<br>I used the pgr_DrivingDistance developed for the 2.1 version.<br>The github branch develop has the latest but its changing a lot during this days.<br><br>Vicky<br><br><br><br><div><hr id="stopSpelling">Date: Fri, 28 Aug 2015 20:45:45 -0400<br>From: jim@jimkeener.com<br>To: pgrouting-users@lists.osgeo.org; postgis-users@lists.osgeo.org<br>Subject: [pgrouting-users] pgr_drivingdistance problem<br><br>
When I run <a href="http://docs.pgrouting.org/2.0/en/src/driving_distance/doc/dd_driving_distance.html" target="_blank"><code>pgr_drivingdistance</code></a>
on an small extract (578 rows) (attached) from an <a href="http://download.geofabrik.de/north-america/us/pennsylvania.html" target="_blank">extract
of Pennsylvania's osm pbf file</a> not all edges are being
followed.
I first downloaded the pbf. Then I imported it with <a href="https://github.com/pgRouting/osm2pgrouting" target="_blank"><code>osm2pgrouting</code></a>
<code>
<pre>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
</pre>
</code>
and then running
<code>
<pre>CREATE TABLE smallways AS
SELECT * FROM ways
WHERE ST_DISTANCE(the_geom, ST_GEOMFROMTEXT('POINT(-79.900121 40.448889)', 4326)) < 0.2;
</pre>
</code>
and creating the appropriate indices to build a test environment
(the output of which
is the small extract (578 rows)(attached)).
To test <code>pgr_drivingdistance</code>, I did the following:
<code>
<pre>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);
</pre>
</code>
and then loading that view into QGIS, I see the following:
<a href="cid:part5.06050408.08070207@jimkeener.com" target="_blank"><img src="cid:part4.07070907.04000409@jimkeener.com" style="width:800;clear:both;"></a>
<br style="clear:both;">
Why are some edges not being selected? I initially thought it was
the <code>(source, target)</code> (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.
<code><font face="sans-serif"></font><br>
<br>
<font face="sans-serif">Jim</font><br>
</code>
<br>_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users</div> </div></body>
</html>