[OSM-talk] planet-090916.osm.bz2 - inconsistent dump?

2009-09-21 Thread Marcin Cieslak
I tried to import planet-090916.osm.bz2 into the postgres database
using osmosis, using empty schema from:

URL: 
http://svn.openstreetmap.org/applications/utils/osmosis/trunk/script/contrib/apidb_0.6.sql
Revision: 17698

The dump process:

time bzip2 -dc $HOME/import/planet-090916.osm.bz2 | \
$HOME/osmosis/trunk/bin/osmosis \
--read-xml file=-\
--write-apidb-0.6 authFile=$HOME/import/planet-authfile.txt

failed after taking 26 hours and 415GB of space with:

org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load current 
way nodes.
(...)
Caused by: org.postgresql.util.PSQLException: 
ERROR: insert or update on table current_way_nodes violates 
foreign key constraint current_way_nodes_node_id_fkey   
Detail: Key (node_id)=(497587545) is not present in table 
current_nodes.

My current_nodes contains now 434807934 rows and current_ways 12050.
The highest numbered node is 497541099 and way is 1999800.

Is this inconsistency of the planet.osm file or am I doing something wrong?
Is there any way to recover from this or should I restart the whole process from
scratch?

Which dump would you recommend?

-- 
   Marcin Cieslak // sa...@saper.info 


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


Re: [OSM-talk] [Maps-l] using default country name

2009-08-23 Thread Marcin Cieslak
Peter Körner wrote:
 Maarten Deen schrieb:
 They tell you that the translation in the given language is identical to 
 the value of the name=* tag. If you see the name-Tag as a fallback for a 
 missing name:xx-tag (what you should), those pseudo-translations are 
 needless. I'm currently in a discussion with Marc Schütz (search through 
 the mails of the last days) if deleting them is a good or a bad thing.

I have read the above mentioned discussion[1] (unfortunately it  is
spread among two mailing lists) and I have two additional points to make:

(1) Default tags can be changed. We should remember that default tags
can be edited by somebody later and they will no longer be good for
other languages.

(2) There is some inconsistency in default tags. Sometimes it's the
English name, sometimes it's written in the Latin alphabet, local
alphabet (e.g. Arabic) or both. I think Iran is spelt in Arabic, Comoros
are spelt in both. Some people say Burma, some say Myanmar for various
reasons. I think having explicit name:xx tags even if *at the given
moment of time* it's the same as the default.

That's said, I have added name:pl to Polska even thought it is
the default name, too. Therefore having name:de == Deutschland is
perfectly fine. In this case it actually indicates that the local
official language is Hochdeutsch (de or de_DE).

Therefore I would propose to remove orange tags from the utility -
such name will be either italic or orange and never normal.
Both carry notion of something being wrong with the name.

I actually wonder if the default tag is the right thing to have
altogether. Probably better might be to use some fallback order (say,
en,de,ru to be very European-centric) and displaying the name in
italic in OSM (meaning fallback language applied).


Some more intelligent fallback mechanism could be applied in the future
(using user's browser preferences for example):

- Browser says Accept-Language: zh;q=1.0, ja;q=0.2, en;q=0.1 - this
means I understand Chinese (say Mandarin) and a bit of Japanese and
some tiny English. For more details on that see RFC2616[2].

- The webserver sees that there is no name:zh but there are name:en
and name:ja. This user indicates it prefers Japanese to English.
Actually in this case Japanese is much better option for the users since
there are chances that the kanji spelling will be the same as Chinese,
like, for example, 中国 (same in the Japan language and simplified
notation of Chinese).

But this would require on-demand application of the negotiated labels on
the map and this technically might not be easy to be done in a feasible
name (it would be difficult to create pre-generated tiles for different
sets of user preferences).

[1]http://thread.gmane.org/gmane.comp.gis.openstreetmap/39745/focus=39900
[2]http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html

-- 
   Marcin Cieslak // sa...@saper.info 

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


Re: [OSM-talk] [Maps-l] Announcemen: Multilingual Country-List

2009-08-18 Thread Marcin Cieslak
Peter Körner wrote:

 (Montenegro is still missing)
 
 It seems there is no node for it. Searching if with the Namefinder 
 doesn't bring up a node. I'd need a node id to add it to the list.

I think it's 445970763

-- 
   Marcin Cieslak // sa...@saper.info 




signature.asc
Description: OpenPGP digital signature
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk