Richard<div>Thanks very much for your suggestion.<div><br></div><div>I'mk going to test osm2po for creating pgRouting compatible tables and it seems great.</div><div><br></div><div>I will post to the list some more considerations at the end of my tests.</div>
<div><br></div><div>Lorenzo</div><div><br><div class="gmail_quote">2011/1/18 Richard Marsden <span dir="ltr"><<a href="mailto:winwaed@gmail.com">winwaed@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#FFFFFF"><div>Try the osm2po program instead. This can handle large files, and recently I was able to use it to import planet.osm. Osm2po create an SQL script which you then execute. Planet.osm took a few days to import - Italy should be a lot quicker!</div>
<div><br></div><div>Search the archives of this list server - I had a couple of queries which were quickly answered. They may help you, especially if you are new to PostGis and pgRouting (as I am).</div><div><br></div><div>
Richard.</div><div><div></div><div class="h5"><div><br></div><div><br></div><div><br>On Jan 18, 2011, at 10:42 AM, lorenzo amato <<a href="mailto:lorenzo.amato@geosdi.org" target="_blank">lorenzo.amato@geosdi.org</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Hi list<div>I'm trying to import a large osm file (italy.osm from cloudmade) into postgis using the osm2pgrouting tool without success.</div>
<div>I read somewhere in the list (or in the wikies) that osm2pgrouting uses a large amount of memory. </div><div><br></div><div>So i tried to lounch osm2pgrouting on a workstation with 32G RAM ... without success.</div>
<div>
<br></div><div>I also found this thread:</div><div><br></div><div><a href="http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/discussion/topic/297.html" style="color:rgb(64, 100, 128)" target="_blank"></a><a href="http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/discussion/topic/297.html" target="_blank">http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/discussion/topic/297.html</a></div>
<div><br></div><div><br></div><div>and this wiki page</div><div><br></div><div><a href="http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/wiki/osm2pgroutingPatchToAppendFile.html" style="color:rgb(64, 100, 128)" target="_blank"></a><a href="http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/wiki/osm2pgroutingPatchToAppendFile.html" target="_blank">http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/wiki/osm2pgroutingPatchToAppendFile.html</a></div>
<div><br></div><div>but some errors occurred whan I tryed to apply the patch.</div><div><br></div><div>Any help?</div></span><div><br></div>Or any other way to import large OSM data for routing?<br clear="all"><br>-- <br>
Lorenzo Amato<br><a href="mailto:lorenzo.amato@geosdi.org" target="_blank"></a><a href="mailto:lorenzo.amato@geosdi.org" target="_blank">lorenzo.amato@geosdi.org</a><br><a href="mailto:lorenzotlc@gmail.com" target="_blank"></a><a href="mailto:lorenzotlc@gmail.com" target="_blank">lorenzotlc@gmail.com</a><br>
<a href="mailto:lorenzo.amato@nsdi.it" target="_blank"></a><a href="mailto:lorenzo.amato@nsdi.it" target="_blank">lorenzo.amato@nsdi.it</a><br>
<br>Consiglio Nazionale delle Ricerche<br>Istituto di Metodologie per l'Analisi Ambientale - geoSDI<br>
</div></blockquote></div></div><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Pgrouting-users mailing list</span><br><span><a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a></span><br>
<span><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></span><br></div></blockquote></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Lorenzo Amato<br><a href="mailto:lorenzo.amato@geosdi.org">lorenzo.amato@geosdi.org</a><br><a href="mailto:lorenzotlc@gmail.com">lorenzotlc@gmail.com</a><br><a href="mailto:lorenzo.amato@nsdi.it">lorenzo.amato@nsdi.it</a><br>
<br>Consiglio Nazionale delle Ricerche<br>Istituto di Metodologie per l'Analisi Ambientale - geoSDI<br>
</div></div>