[pgrouting-users] osm_relations table does not get populated

[Tokura Gou]

 Hello Vicky and thanks for your response,

Maybe due to formatting issues the data and the command were not visible.


1. Data:
https://github.com/pgRouting/osm2pgrouting/files/11598959/haywards-heath-uk-small-extract.txt
2. Exact command: osm2pgrouting -f home/map.osm -c
"/usr/local/share/osm2pgrouting/mapconfig.xml" -d city_routing -U
[username] -W [password] --clean --tags --addnodes


On Fri, Jun 2, 2023 at 6:25 PM Vicky Vergara <vicky at erosion.dev> wrote:

> Hello,
> I can not reproduce your problem:
> What is needed:
> 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.
> 2) the exact command that is been used (use mylogin and mypass instead of
> the real ones when posting the command)
>
> Regards
> Vicky
>
>
> On Fri, Jun 2, 2023 at 3:52 AM Tokura Gou <tokura.gou at gmail.com> wrote:
>
>> *Problem*
>>
>> When running osm2pgrouting on a typical .osm file with the --addnodes
>> option, osm_relations table stays empty.
>>
>> *To Reproduce*
>>
>> osm2pgrouting -f home/map.osm -c "/usr/local/share/osm2pgrouting/mapconfig.xml" -d city_routing -U [username] -W [password] --clean --tags --addnodes
>>
>> *Expectation*
>>
>> I use the --addnodes flag as per the documentation and I can see that
>> osm_nodes and osm_ways tables do get populated. However, osm_relations has
>> 0 records after running osm2pgrouting and "Final osm_relations:" is
>> never mentioned in the output:
>>
>> 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
>>
>> *Sample Data*
>>
>> A sample .osm file is attached (please rename from txt to osm if
>> needed), however I have tried other .osm exports that contain osm relations
>> with the same result.
>>
>> haywards-heath-uk-small-extract.txt
>> <https://github.com/pgRouting/osm2pgrouting/files/11598959/haywards-heath-uk-small-extract.txt>
>>
>> *Platform/versions*
>>
>> 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
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20230603/0622c8a9/attachment.htm>