search

cvvergara / osm2pgrouting

Import tool for OpenStreetMap data to pgRouting database
http://www.pgrouting.org
GNU General Public License v2.0
0 stars 0 forks source link

Libosmium cmake file updated and installing info for Ubuntu #13

Closed cayetanobv closed 6 years ago

cayetanobv commented 6 years ago

Libosmium cmake file updated and installing info for Ubuntu

cayetanobv commented 6 years ago

Compiled and tested with big problematic file and all it works fine:

***************************************************
           COMMAND LINE CONFIGURATION             *
***************************************************
Filename = /tmp/output_data.osm
Configuration file = /usr/share/osm2pgrouting/mapconfig.xml
host = localhost
port = 5437
dbname = routing
username = postgres
password = postgres
schema= test_schema
prefix = 
suffix = 
Drop tables
Don't create indexes
Add OSM nodes
***************************************************
Testing database connection: routing
database connection successful: routing
Connecting to the database
connection success

Dropping tables...
TABLE: test_schema.ways dropped ... OK.
TABLE: test_schema.ways_vertices_pgr dropped ... OK.
TABLE: test_schema.pointsofinterest dropped ... OK.
TABLE: test_schema.configuration dropped ... OK.
TABLE: test_schema.osm_nodes dropped ... OK.
TABLE: test_schema.osm_ways dropped ... OK.
TABLE: test_schema.osm_relations dropped ... OK.

Creating tables...
TABLE: test_schema.ways_vertices_pgr created ... OK.
TABLE: test_schema.ways created ... OK.
TABLE: test_schema.pointsofinterest created ... OK.
TABLE: test_schema.configuration created ... OK.
TABLE: test_schema.osm_nodes created ... OK.
TABLE: test_schema.osm_ways created ... OK.
TABLE: test_schema.osm_relations created ... OK.
Opening configuration file: /usr/share/osm2pgrouting/mapconfig.xml
    Parsing configuration

Exporting configuration ...
  - Done 
Counting lines ...
  - Done 
Opening data file: /tmp/output_data.osm total lines: 5150594
    Parsing data

Current osm_nodes:  1580000
Final osm_nodes:    1599211
Current osm_ways:   160000
Final osm_ways: 177210

Final osm_relations:    101
End Of file

    Finish Parsing data

Adding auxiliary tables to database...

Export Ways ...
    Processing 177210 ways:
[*****|                                             ] (11%) Total processed: 20000   Vertices inserted: 37850   Split ways inserted 37539
[***********|                                       ] (22%) Total processed: 40000   Vertices inserted: 19201   Split ways inserted 23557
[****************|                                  ] (33%) Total processed: 60000   Vertices inserted: 18650   Split ways inserted 23188
[**********************|                            ] (45%) Total processed: 80000   Vertices inserted: 11938   Split ways inserted 18677
[****************************|                      ] (56%) Total processed: 100000  Vertices inserted: 8092    Split ways inserted 14336
[*********************************|                 ] (67%) Total processed: 120000  Vertices inserted: 7311    Split ways inserted 12987
[***************************************|           ] (79%) Total processed: 140000  Vertices inserted: 6809    Split ways inserted 12312
[*********************************************|     ] (90%) Total processed: 160000  Vertices inserted: 5026    Split ways inserted 9346
[**************************************************|] (100%) Total processed: 177210     Vertices inserted: 4094    Split ways inserted 9414

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: 177210
#########################