<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Michael,<br><br>Not a direct answer, but I assume you are using the TIGER/Line all lines shapefiles to start with. One question is have you taken out all the non-street edges? If you haven't you can greatly reduce the size of table you are working with, so you may be able to use a more direct approach. A second question is are you going to use this for local or for long distance routing as well? The TIGER road network is not designed for routing (it would have z values in addition to x and y values if it was). As a result, there are "intersections" in the TIGER data that are really over/under passes, to say nothing of one-way streets that aren't identified. For routing over very small areas, this isn't fatal, but things get funny as the size of the area increases.<br><br>Dan<br><br>Dan<br><br><br><br>--- On <b>Fri, 9/9/11, Michael Papet
<i><mpapet@yahoo.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Michael Papet <mpapet@yahoo.com><br>Subject: [pgrouting-users] Newbie: point_to_id and very large tiger_2010 tables<br>To: pgrouting-users@lists.osgeo.org<br>Received: Friday, September 9, 2011, 11:21 AM<br><br><div id="yiv2096063595"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit;" valign="top">Hi,<br><br>I'm a GIS newbie that has TIGER_2010 data for U.S.-California loaded in PostGIS as a pilot.<br><br>For California alone, the edges table stores the multilinestring data has 3 million rows. I need to load/use all 50 States when I am done. Attempts to run assign_vertex_id on California alone go on for a few days then just dies with nothing inserted.<br><br>It seems to me that I should just add a column to the edges table (or a view or something related
to edges) to permanently store the value returned by the point_to_id function instead of trying to generate a giant temporary table. <br><br>Am I headed in the right direction? What are the consequences I have to work through? I am competent at editing the SQL functions. I just don't know what the consequences of storing the data generated in point_to_id function
somewhere else has on other pg_routing functions. <br><br>Thanks in advance for your patience answering a newbie question.<br><br>Michael.<br><br></td></tr></tbody></table></div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Pgrouting-users mailing list<br><a ymailto="mailto:Pgrouting-users@lists.osgeo.org" href="/mc/compose?to=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></div></blockquote></td></tr></table>