[Tile-serving] [osm2pgsql] osm2pgsql not adding the ways to the database (#165)

baditaflorin notifications at github.com
Thu Jul 3 15:43:26 UTC 2014


Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.


C:\osm2pgsql\x64>osm2pgsql.exe -c -d overpass -U postgres -H localhost -S c:\def
ault.style f:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (http://www.customdebug
.com/osm2pgsql/index.html)'
Using 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
Allocating memory for sparse node cache
Node-cache: cache=800MB, maxblocks=102401*zd, allocation method=8192
Mid: Ram, scale=100

Reading in file: f:\leisure.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(123k 41.1k/s) Way(1253k 37.98k/s) Relation(0 0.00/s)  parse tim
e: 36s

Node stats: total(123205), max(2944840119) in 3s
Way stats: total(1253181), max(291018582) in 33s
Relation stats: total(0), max(0) in 0s
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 (1253k)
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 (0)
node cache: stored: 123205(100.00%), storage efficiency: 50.00% (dense blocks: 0
, sparse nodes: 123205), hit rate: 0.01%
Sorting data and creating indexes for planet_osm_point
Analyzing planet_osm_point finished
Copying planet_osm_point to cluster by geometry finished
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_point created  in 8s
Completed planet_osm_point
Sorting data and creating indexes for planet_osm_line
Analyzing planet_osm_line finished
Copying planet_osm_line to cluster by geometry finished
Creating indexes on  planet_osm_line finished
All indexes on  planet_osm_line created  in 0s
Completed planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
Analyzing planet_osm_polygon finished
Copying planet_osm_polygon to cluster by geometry finished
Creating indexes on  planet_osm_polygon finished
All indexes on  planet_osm_polygon created  in 1s
Completed planet_osm_polygon
Sorting data and creating indexes for planet_osm_roads
Analyzing planet_osm_roads finished
Copying planet_osm_roads to cluster by geometry finished
Creating indexes on  planet_osm_roads finished
All indexes on  planet_osm_roads created  in 0s
Completed planet_osm_roads

Osm2pgsql took 64s overall

C:\osm2pgsql\x64>osm2pgsql.exe -c -d osm -U postgres -H localhost -S c:\default.
style f:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (http://www.customdebug
.com/osm2pgsql/index.html)'
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE:  table "planet_osm_line" does not exist, skipping
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE:  table "planet_osm_polygon" does not exist, skipping
NOTICE:  table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE:  table "planet_osm_roads" does not exist, skipping
NOTICE:  table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for sparse node cache
Node-cache: cache=800MB, maxblocks=102401*zd, allocation method=8192
Mid: Ram, scale=100

Reading in file: f:\leisure.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(123k 41.1k/s) Way(1253k 29.84k/s) Relation(0 0.00/s)  parse tim
e: 45s

Node stats: total(123205), max(2944840119) in 3s
Way stats: total(1253181), max(291018582) in 42s
Relation stats: total(0), max(0) in 0s
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 (1253k)
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 (0)
node cache: stored: 123205(100.00%), storage efficiency: 50.00% (dense blocks: 0
, sparse nodes: 123205), hit rate: 0.01%
Sorting data and creating indexes for planet_osm_point
Analyzing planet_osm_point finished
Copying planet_osm_point to cluster by geometry finished
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_point created  in 8s
Completed planet_osm_point
Sorting data and creating indexes for planet_osm_line
Analyzing planet_osm_line finished
Copying planet_osm_line to cluster by geometry finished
Creating indexes on  planet_osm_line finished
All indexes on  planet_osm_line created  in 0s
Completed planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
Analyzing planet_osm_polygon finished
Copying planet_osm_polygon to cluster by geometry finished
Creating indexes on  planet_osm_polygon finished
All indexes on  planet_osm_polygon created  in 0s
Completed planet_osm_polygon
Sorting data and creating indexes for planet_osm_roads
Analyzing planet_osm_roads finished
Copying planet_osm_roads to cluster by geometry finished
Creating indexes on  planet_osm_roads finished
All indexes on  planet_osm_roads created  in 0s
Completed planet_osm_roads

Osm2pgsql took 73s overall

C:\osm2pgsql\x64>

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/165
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140703/28ccafa9/attachment.html>


More information about the Tile-serving mailing list