[pgrouting-users] osm_relations table does not get populated

[Vicky Vergara]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20230602/c5d11322/attachment-0001.htm>