Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- enter code hereUsing projection SRS 900913 (Spherical Mercator)
- Setting up table: planet_osm_point
- NOTICE: table "planet_osm_point_tmp" does not exist, skipping
- Setting up table: planet_osm_line
- NOTICE: table "planet_osm_line_tmp" does not exist, skipping
- Setting up table: planet_osm_polygon
- NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
- Setting up table: planet_osm_roads
- NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
- Using built-in tag processing pipeline
- Allocating memory for dense node cache
- Allocating dense node cache in one big chunk
- Allocating memory for sparse node cache
- Sharing dense sparse
- Node-cache: cache=800MB, maxblocks=102400*8192, allocation method=3
- Mid: Ram, scale=100
- Reading in file: /Users/hadoop/Desktop/osm/mtl.osm
- StartElement: Unknown element name: note
- Unknown node type 3
- EndElement: Unknown element name: note
- StartElement: Unknown element name: meta
- EndElement: Unknown element name: meta.
- Processing: Node(1234k 112.2k/s) Way(248k 15.56k/s) Relation(6805 3402.50/s) parse time: 29s
- Node stats: total(1234539), max(4764987639) in 11s
- Way stats: total(248884), max(483754469) in 16s
- Relation stats: total(6805), max(7120865) in 2s
- Committing transaction for planet_osm_point
- Committing transaction for planet_osm_line
- Committing transaction for planet_osm_polygon
- Committing transaction for planet_osm_roads
- Writing way (248k)
- Committing transaction for planet_osm_point
- Committing transaction for planet_osm_line
- Committing transaction for planet_osm_polygon
- Committing transaction for planet_osm_roads
- Writing relation (6798)
- Sorting data and creating indexes for planet_osm_point
- Sorting data and creating indexes for planet_osm_line
- Sorting data and creating indexes for planet_osm_polygon
- Sorting data and creating indexes for planet_osm_roads
- node cache: stored: 1234539(100.00%), storage efficiency: 52.39% (dense blocks: 276, sparse nodes: 1036935), hit rate: 98.58%
- Analyzing planet_osm_roads finished
- Copying planet_osm_roads to cluster by geometry finished
- Creating geometry index on planet_osm_roads
- Creating indexes on planet_osm_roads finished
- All indexes on planet_osm_roads created in 1s
- Completed planet_osm_roads
- Analyzing planet_osm_polygon finished
- Analyzing planet_osm_line finished
- Analyzing planet_osm_point finished
- Copying planet_osm_polygon to cluster by geometry finished
- Creating geometry index on planet_osm_polygon
- Copying planet_osm_line to cluster by geometry finished
- Creating geometry index on planet_osm_line
- Copying planet_osm_point to cluster by geometry finished
- Creating geometry index on planet_osm_point
- Creating indexes on planet_osm_polygon finished
- All indexes on planet_osm_polygon created in 5s
- Completed planet_osm_polygon
- Creating indexes on planet_osm_line finished
- All indexes on planet_osm_line created in 7s
- Completed planet_osm_line
- Creating indexes on planet_osm_point finished
- All indexes on planet_osm_point created in 8s
- Completed planet_osm_point
- Osm2pgsql took 54s overall
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement