[OSGeoLive] #2511: Auckland Data on disk does not match data on Download

[OSGeoLive]

#2511: Auckland Data on disk does not match data on Download
-----------------------+---------------------------
 Reporter:  cvvergara  |      Owner:  osgeolive@…
     Type:  task       |     Status:  new
 Priority:  normal     |  Milestone:  OSGeoLive17.0
Component:  OSGeoLive  |   Keywords:
-----------------------+---------------------------
 Data on Download
 https://download8.osgeo.org/livedvd/17/osm/

 Also the filename is different
 `auckland_NZ.osm.bz2` While in the disk is `AUCKLAND_NZ.osm.bz2`


 The pgRouting workshop is created using the data on download.
 {{{
 **************************************************
            COMMAND LINE CONFIGURATION             *
 ***************************************************
 Filename = auckland_NZ.osm
 Configuration file = /usr/share/osm2pgrouting/mapconfig.xml
 host = localhost
 port = 5432
 dbname = city_routing
 username = user
 schema=
 prefix =
 suffix =
 Drop tables
 Don't create indexes
 Don't add OSM nodes
 ***************************************************
 Testing database connection: city_routing
 database connection successful: city_routing
 Connecting to the database
 connection success

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

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

 Exporting configuration ...
   - Done
 Counting lines ...
   - Done
 Opening data file: auckland_NZ.osm      total lines: 1020947
     Parsing data


 End Of file


     Finish Parsing data

 Adding auxiliary tables to database...

 Export Ways ...
     Processing 41095 ways:

 [************************|                          ] (48%) Total
 processed: 20000       Vertices inserted: 14868       Split ways inserted
 15536

 [************************************************|  ] (97%) Total
 processed: 40000       Vertices inserted: 10228       Split ways inserted
 17643

 [**************************************************|] (100%) Total
 processed: 41095      Vertices inserted: 596 Split ways inserted 1099

 Creating indexes ...

 Processing Points of Interest ...
 #########################
 size of streets: 41095
 Execution started at: Fri Oct 17 21:13:30 2025
 Execution ended at:   Fri Oct 17 21:13:50 2025
 Elapsed time: 20.805 Seconds.
 User CPU time: -> 2.03785 seconds
 }}}

 while in the disk:
 {{{
 Execution starts at: Wed Nov 26 14:39:42 2025

 ***************************************************
            COMMAND LINE CONFIGURATION             *
 ***************************************************
 Filename = auckland_NZ.osm
 Configuration file = /usr/share/osm2pgrouting/mapconfig.xml
 host = localhost
 port = 5432
 dbname = city_routing
 username = user
 schema=
 prefix =
 suffix =
 Drop tables
 Don't create indexes
 Don't add OSM nodes
 ***************************************************
 Testing database connection: city_routing
 database connection successful: city_routing
 Connecting to the database
 connection success

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

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

 Exporting configuration ...
   - Done
 Counting lines ...
   - Done
 Opening data file: auckland_NZ.osm      total lines: 641229
     Parsing data


 End Of file


     Finish Parsing data

 Adding auxiliary tables to database...

 Export Ways ...
     Processing 26639 ways:
 [*************************************|             ] (75%) Total
 processed: 20000   Vertices inserted: 16737       Split ways inserted
 19244
 [**************************************************|] (100%) Total
 processed: 26639  Vertices inserted: 3622        Split ways inserted 7291

 Creating indexes ...

 Processing Points of Interest ...
 #########################
 size of streets: 26639
 Execution started at: Wed Nov 26 14:39:42 2025
 Execution ended at:   Wed Nov 26 14:40:01 2025
 Elapsed time: 19.035 Seconds.
 User CPU time: -> 6.59944 seconds
 #########################

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2511>
OSGeoLive <https://live.osgeo.org/>
self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything.