<div dir="ltr">Got it sorted, thanks for the help<div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 19 May 2018 at 15:47, Vicky Vergara <span dir="ltr"><<a href="mailto:vicky@georepublic.de" target="_blank">vicky@georepublic.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Dave:<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">your table "tmp" does only has id and the_geom columns</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sat, May 19, 2018 at 6:45 AM, Dave Potts <span dir="ltr"><<a href="mailto:mrdapotts@gmail.com" target="_blank">mrdapotts@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I tried this and got an error message to the effect missing column<div><br></div><div><div>med_proj=# \d tmp;</div><div>                                     Table "public.tmp"</div><div>  Column  |          Type           | Collation | Nullable |             Default             </div><div>----------+-------------------<wbr>------+-----------+----------+<wbr>------------------------------<wbr>---</div><div> id       | integer                 |           | not null | nextval('tmp_id_seq'::regclass<wbr>)</div><div> the_geom | geometry(Geometry,3857) |           |          | </div><div><br></div><div>med_proj=# \d tmp_noded;</div><div>                                     Table "public.tmp_noded"</div><div>  Column  |          Type           | Collation | Nullable |                Default                </div><div>----------+-------------------<wbr>------+-----------+----------+<wbr>------------------------------<wbr>---------</div><div> id       | integer                 |           | not null | nextval('tmp_noded_id_seq'::re<wbr>gclass)</div><div> old_id   | bigint                  |           |          | </div><div> sub_id   | bigint                  |           |          | </div><div> source   | bigint                  |           |          | </div><div> target   | bigint                  |           |          | </div><div> the_geom | geometry(Geometry,3857) |           |          | </div><div><br></div><div>Invoking this, should put the results in tmp_noded, which according to the above and the manual at <a href="https://docs.pgrouting.org/2.6/en/pgr_nodeNetwork.html" target="_blank">https://docs.pgrouting.org/<wbr>2.6/en/pgr_nodeNetwork.html</a> has all the right column</div><div><br></div><div>Doing this</div><div>med_proj=# select pgr_createTopology('tmp',1);</div><div><br></div><div>Given an error,  I don't  think there is anything wrong with the functions, it most be my table layout, but according to the documents,everything is correct.  </div><div>NOTICE:  PROCESSING:</div><div>NOTICE:  pgr_createTopology('tmp', 1, 'the_geom', 'id', 'source', 'target', rows_where := 'true', clean := f)</div><div>NOTICE:  Performing checks, please wait .....</div><div>NOTICE:  ----> PGR ERROR in pgr_createTopology: Column source not found</div><div>HINT:    ----> Check your column name</div><div>NOTICE:  Unexpected error raise_exception</div><div> pgr_createtopology </div><div>--------------------</div><div> FAIL</div><div><br></div><div>any ideas what I am doing wrong ?</div><span class="m_-9064226576920302699HOEnZb"><font color="#888888"><div><br></div><div>Dave.</div><div><br></div><br><br></font></span></div></div><div class="m_-9064226576920302699HOEnZb"><div class="m_-9064226576920302699h5"><div class="gmail_extra"><br><div class="gmail_quote">On 17 May 2018 at 21:35, Vicky Vergara <span dir="ltr"><<a href="mailto:vicky@georepublic.de" target="_blank">vicky@georepublic.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi Dave,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Have you tried:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><a href="https://docs.pgrouting.org/2.6/en/pgr_nodeNetwork.html" target="_blank">https://docs.pgrouting.org/2.6<wbr>/en/pgr_nodeNetwork.html</a></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Its has some issues, but does a reasonable work for pgRouting purposes.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Fixing the geometry would be using postGIS</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_-9064226576920302699m_7848898926883235316h5">On Thu, May 17, 2018 at 2:47 PM, Dave Potts <span dir="ltr"><<a href="mailto:mrdapotts@gmail.com" target="_blank">mrdapotts@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_-9064226576920302699m_7848898926883235316h5"><div dir="ltr">Hi,<div><br></div><div>I am trying to convert a shapefile of linestrings into a suitable form for pgroute.  The type of issue that I am getting is that from a casual look its looks fine, but if you drill down in to the map, you find there are some line segments should connect, but they don't due to the way that the data was entered.<br><br>Q. Has anybody attempt this type of thing before and what if any solutions did they find ?</div><span class="m_-9064226576920302699m_7848898926883235316m_-7830270667210858399HOEnZb"><font color="#888888"><div>Dave. </div></font></span></div>
<br></div></div>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="m_-9064226576920302699m_7848898926883235316m_-7830270667210858399gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44, 
81739 München, Germany

Vicky Vergara
Operations Research

eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>

Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9

Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl

<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/pgrouting-users</a><br></blockquote></div><br></div>
</div></div><br>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="m_-9064226576920302699gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44, 
81739 München, Germany

Vicky Vergara
Operations Research

eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>

Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9

Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl

<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
</div></div><br>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.<wbr>org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/pgrouting-<wbr>users</a><br></blockquote></div><br></div>