[OSM-dev] load database

Mohamad Ali Mohamad.ali at intellitrac.com.au
Fri May 8 06:14:13 BST 2009


Hi Guys,
1.I export Melbourne area from www.openstreetmap.org , it's about 5 MB

I would like to ask If what I did is ok:

time ./osm2pgsql --slim -d gis map.osm.bz2

osm2pgsql SVN version 0.65-14928

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Mid: pgsql, scale=100, cache=800MB, maxblocks=102401*8192
Setting up table: planet_osm_nodes
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: map.osm.bz2
Processing: Node(10k) Way(0k) Relation(0k)WARNING: Found Out of order node
379776895 (2468027,895) - this will impact the cache efficiency
Processing: Node(22k) Way(4k) Relation(0k)
Node stats: total(22105), max(391893729)
Way stats: total(4366), max(34161566)
Relation stats: total(45), max(101792)

Going over pending ways
processing way (0k)

Going over pending relations

node cache: stored: 19319(87.40%), storage efficiency: 0.85%, hit rate:
87.87%


real    0m7.182s
user    0m2.200s
sys    0m0.230s

 

and one more question:

2.when rendering the maps, what that mean:

World [ 0 - 16 ]:  4 11 7 p: (67.5, 0.0) (90.0, 21.94304553343818) 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090508/d6c3990a/attachment.html>


More information about the dev mailing list