<div dir="ltr"><div>Hello,<br></div><div><br>In the data file you've provided, named 'haywards-heath-uk-small-extract.txt', </div><div>there are 8 OpenStreetMap (OSM) relation objects [2]</div><div>that are marked as either 'boundary=*' or 'landuse=residential'. </div><div>It appears that none of these are related to routes or are included in the 'mapconfig.xml' [1] file.<br><br>Could you please specify which OSM relation you're missing from your table?<br></div><div><br></div><div>Could you also test it with another input data set?  Specifically, one that includes a 'highway=*' osm relation in the extract. </div><div><br></div><div>[1] <a href="https://github.com/pgRouting/osm2pgrouting/blob/main/mapconfig.xml">https://github.com/pgRouting/osm2pgrouting/blob/main/mapconfig.xml</a></div><div>[2] osmium cat haywards-heath-uk-small-extract.osm.xml -t relation  -f opl | cut -d' ' -f8</div><div>[3] <a href="https://taginfo.openstreetmap.org/keys/highway#overview">https://taginfo.openstreetmap.org/keys/highway#overview</a><br><br></div><div>Regards,</div><div>  Imre</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Tokura Gou <<a href="mailto:tokura.gou@gmail.com">tokura.gou@gmail.com</a>> ezt írta (időpont: 2023. jún. 3., Szo, 19:11):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">

<div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px">Hello Vicky and thanks for your response,</div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px"><br style="line-height:1.5"></div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px">Maybe due to formatting issues the data and the command were not visible.</div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px"><br style="line-height:1.5"></div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px"><br style="line-height:1.5"></div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px">1. Data: <span style="line-height:1.5"><a href="https://github.com/pgRouting/osm2pgrouting/files/11598959/haywards-heath-uk-small-extract.txt" rel="noreferrer nofollow noopener" style="line-height:1.5;text-decoration:underline" target="_blank">https://github.com/pgRouting/osm2pgrouting/files/11598959/haywards-heath-uk-small-extract.txt</a></span></div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px">2. Exact command: <span style="line-height:1.5">osm2pgrouting -f home/map.osm -c "/usr/local/share/osm2pgrouting/mapconfig.xml" -d city_routing -U [username] -W [password] --clean --tags --addnodes</span></div><div style="line-height:1.5;font-family:Arial,sans-serif;font-size:14px"><br style="line-height:1.5;color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">

</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 2, 2023 at 6:25 PM Vicky Vergara <<a href="mailto:vicky@erosion.dev" target="_blank">vicky@erosion.dev</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>Hello,<br></div>I can not reproduce your problem:<br></div>What is needed:<br><div>1) The exact data that has been used, can be in the form of a link to a shared file, the wget command to download from osm.<br></div><div>2) the exact command that is been used (use mylogin and mypass instead of the real ones when posting the command)</div><div><br></div><div>Regards</div><div>Vicky<br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 2, 2023 at 3:52 AM Tokura Gou <<a href="mailto:tokura.gou@gmail.com" target="_blank">tokura.gou@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">

<p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><strong style="font-weight:600;line-height:1.5;box-sizing:border-box">Problem</strong></p><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)">When running<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm2pgrouting</code><span style="line-height:1.5"> </span>on a typical<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">.osm</code><span style="line-height:1.5"> </span>file with the<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">--addnodes</code><span style="line-height:1.5"> </span>option,<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm_relations</code><span style="line-height:1.5"> </span>table stays empty.</p><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><strong style="font-weight:600;line-height:1.5;box-sizing:border-box">To Reproduce</strong></p><div style="line-height:1.5;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23);overflow:auto"><pre style="font-size:11.9px;line-height:1.45;margin:0px 0px 16px;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;white-space:pre-wrap;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:16px;overflow:auto;border-radius:6px"><code style="font-family:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:1em;white-space:pre-wrap;line-height:1;background:transparent;box-sizing:border-box;margin:0px;border-radius:6px;display:inline">osm2pgrouting -f home/map.osm -c "/usr/local/share/osm2pgrouting/mapconfig.xml" -d city_routing -U [username] -W [password] --clean --tags --addnodes

</code></pre></div><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><strong style="font-weight:600;line-height:1.5;box-sizing:border-box">Expectation<p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)">I use the<span style="line-height:1.5"> <code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">--addnodes</code><span style="line-height:1.5"> flag as per the documentation and I can see that<span style="line-height:1.5"> <code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm_nodes</code><span style="line-height:1.5"> and<span style="line-height:1.5"> <code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm_ways</code><span style="line-height:1.5"> tables do get populated. However,<span style="line-height:1.5"> <code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm_relations</code><span style="line-height:1.5"> has 0 records after running<span style="line-height:1.5"> <code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm2pgrouting</code><span style="line-height:1.5"> and "Final osm_relations:" is never mentioned in the output:<div style="line-height:1.5;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23);overflow:auto"><pre style="font-size:11.9px;line-height:1.45;margin:0px 0px 16px;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;white-space:pre-wrap;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:16px;overflow:auto;border-radius:6px"><code style="font-family:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:1em;white-space:pre-wrap;line-height:1;background:transparent;box-sizing:border-box;margin:0px;border-radius:6px;display:inline">Creating tables...

TABLE: ways_vertices_pgr created ... OK.

TABLE: ways created ... OK.

TABLE: pointsofinterest created ... OK.

TABLE: configuration created ... OK.

TABLE: osm_nodes created ... OK.

TABLE: osm_ways created ... OK.

TABLE: osm_relations created ... OK.

Opening configuration file: /usr/local/share/osm2pgrouting/mapconfig.xml

    Parsing configuration

Exporting configuration ...

  - Done

Counting lines ...

  - Done

Opening data file: home/map.osm  total lines: 175957

    Parsing data

Current osm_nodes:      48000

Final osm_nodes:        48375

Current osm_ways:       6000

Final osm_ways:         6320

...

End Of file

    Finish Parsing data

Adding auxiliary tables to database...

Export Ways ...

...

Creating indexes ...

Processing Points of Interest ...

Adding functions for processing Points of Interest ...

To process pointsOfInterest table:

osm2pgr_pois_update(radius default 200, within default 50)

  - Using areas of (radius)mts on POIS

  - Using edges that are at least (within) mts of each POI

POIS that do not have a closest edge is considered as too far

#########################

size of streets: 6320

Execution started at: Tue May 30 10:07:09 2023

Execution ended at:   Tue May 30 10:07:21 2023

Elapsed time: 11.767 Seconds.

User CPU time: -> 1.12268 seconds

</code></pre></div><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><strong style="font-weight:600;line-height:1.5;box-sizing:border-box">Sample Data</strong></p><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)">A sample<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">.osm</code><span style="line-height:1.5"> </span>file is attached (please rename from<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">txt</code><span style="line-height:1.5"> </span>to<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm</code><span style="line-height:1.5"> </span>if needed), however I have tried other<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">.osm</code><span style="line-height:1.5"> </span>exports that contain<span style="line-height:1.5"> </span><code style="font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;white-space:break-spaces;line-height:1;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:0.2em 0.4em;margin:0px;border-radius:6px">osm</code><span style="line-height:1.5"> </span>relations with the same result.</p><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><a href="https://github.com/pgRouting/osm2pgrouting/files/11598959/haywards-heath-uk-small-extract.txt" rel="noreferrer nofollow noopener" style="line-height:1.5;text-decoration:underline;box-sizing:border-box" target="_blank">haywards-heath-uk-small-extract.txt</a></p><p dir="auto" style="font-size:14px;line-height:1.5;margin:0px 0px 16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23)"><strong style="font-weight:600;line-height:1.5;box-sizing:border-box">Platform/versions</strong></p><div style="line-height:1.5;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;box-sizing:border-box;color:rgb(230,237,243);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";background-color:rgb(13,17,23);overflow:auto;margin-bottom:0px"><pre style="font-size:11.9px;line-height:1.45;margin:0px 0px 16px;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;white-space:pre-wrap;background-color:rgba(0,0,0,0);box-sizing:border-box;padding:16px;overflow:auto;border-radius:6px"><code style="font-family:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:1em;white-space:pre-wrap;line-height:1;background:transparent;box-sizing:border-box;margin:0px;border-radius:6px;display:inline">SELECT version();

PostgreSQL 15.3 (Debian 15.3-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

SELECT postgis_full_version();

POSTGIS="3.3.2 4975da8" [EXTENSION] PGSQL="150" GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"

SELECT pgr_version();

3.4.1</code></pre></div>

</div>

_______________________________________________<br>

Pgrouting-users mailing list<br>

<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>

<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>

</blockquote></div>

_______________________________________________<br>

Pgrouting-users mailing list<br>

<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>

<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>

</blockquote></div>

_______________________________________________<br>

Pgrouting-users mailing list<br>

<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>

<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>

</blockquote></div>