Re: [OSM-dev] load database

[Iván Sánchez Ortega]

El Viernes, 8 de Mayo de 2009, Mohamad Ali escribió:
 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:
[...]
 Node stats: total(22105), max(391893729)
 Way stats: total(4366), max(34161566)
 Relation stats: total(45), max(101792)

Yes, everything looks OK.

 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)

It means that it's working. One line = One rendered tile.

-- 
--
Iván Sánchez Ortega i...@sanchezortega.es

http://ivan.sanchezortega.es
MSN:i_eat_s_p_a_m_for_breakf...@hotmail.com
Jabber:ivansanc...@jabber.org ; ivansanc...@kdetalk.net
IRC: ivansanchez @ OFTC  freenode


signature.asc
Description: This is a digitally signed message part.
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev

[OSM-dev] load database

[Mohamad Ali]

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%


real0m7.182s
user0m2.200s
sys0m0.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) 

 

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev