Re: [Keepright-talk] Dump file

[Harald K. <kee...@gm...>]

Hi Aleš,

you can download individual schemas too: the naming convention is

http://keepright.at/error_view_82.0.txt.bz2

where 82 is the schema number and 0 is a running number that is used to 
split the files (circumventing the 30 second execution time limit for 
the update script). Currently all three schemas are small enough so that 
no splitting is needed so there is no ".1" - file.

about the duplicates: I didn't know that. Thank you very much for the 
hint, I'll fix that!

Greetings from Vienna,
Harald

> Hi,
> I started to use keepright_errors.txt.bz2 
> <http://keepright.ipax.at/keepright_errors.txt.bz2> dump file to 
> correct all slovenian errors.
>
> Is it possible to get only some schema's. For Slovenia I need only 82, 
> 98 and 99.
>
> I noticed, you have duplicate entries in dump file. Duplication occurs 
> on fields schema and error_id which should be unique. Maybe you need 
> to export only distinct records. In Slovenia that is 20%.
>
> Here are 2 examples
>
> 823110650almost-junctionsnode43090783newThis node is very close but 
> not connected to way #43918302008-11-27 00:00:002012-06-15 
> 21:00:002007-09-06 12:49:58482295194172897051\N\NThis node is very 
> close but not connected to way #$14391830
> 823110650almost-junctionsnode43090783newThis node is very close but 
> not connected to way #43918302008-11-27 00:00:002012-06-15 
> 21:00:002007-09-06 12:49:58482295194172897051\N\NThis node is very 
> close but not connected to way #$14391830
>
> or
>
> 82497316100places of worship without religionnode313106025newThis node 
> is tagged as place of worship and therefore needs a religion 
> tag2008-11-21 22:00:002012-06-15 21:00:002008-11-19 
> 05:11:27466424985184144875\N\NThis $1 is tagged as place of worship 
> and therefore needs a religion tagnode
> 82497316100places of worship without religionnode313106025newThis node 
> is tagged as place of worship and therefore needs a religion 
> tag2008-11-21 22:00:002012-06-15 21:00:002008-11-19 
> 05:11:27466424985184144875\N\NThis $1 is tagged as place of worship 
> and therefore needs a religion tagnode
>
> I also noticed, there are duplicate errors of the same error. So 
> different schema,error_id, but same error_type, object_type 
> and object_id, which should also be unique. In Slovenia that is 15%.
>
> Example
>
> 82 23437256 060 24896973
> 82 4179376   060 24896973
> 82 264966     060 24896973
>
> Both this duplication are not visible on web site, but are present in 
> dump file. If corrected it would reduce dump file a lot.
>
> -- 
>
> Regards,
>
> *Aleš Trtnik*,
>
> Softdata d.o.o., Preradovic(eva 14, 1000 Ljubljana.
> tel: 01 4384164
> mob: 041 698793
> www: www.softdata.si <http://www.softdata.si>
> email: al...@so... <mailto:al...@so...>
>
>
>
>