On Wed 2008-08-27 01:00:38, Petr Nejedly wrote: zobrazit citaci Spechat se neda, pocitace jsou pomaly; ta konverze by mela trvat 10+ hodin... zobrazit citaci Na pochlapeni UIR_ADR bych moc nespolehal. zobrazit citaci Ten ADRESA_KOD by mel pro updaty stacit, ne? Anyway, tady je dalsi vzorek, mel by byt oznacen podle debaty na tady, takze pokud jsem neco udelal blbe, reknete... Pavel -- (english) http://www.livejournal.com/~pavelmachek (cesky, pictures) http://atrey.karlin.mff.cuni.cz/~pavel/picture/horses/blog.html ------------- další část --------------- cat > /tmp/delme.osm << EOF <?xml version='1.0' encoding='UTF-8'?> <osm version='0.5' generator='JOSM'> EOF ID=0 cat adresa.csv | grep -v ",,.$" | grep ,198.., | head -30 | ( while IFS=, read ADRESA_KOD OBJEKT_KOD ULICE_KOD CISOR_HOD CISOR_PIS PSC STAV VZNIK_DNE VZNIK_INFO ZANIK_DNE ZANIK_INFO PCD X Y; do ID=$[$ID-1] # echo $ULICE_KOD $CISOR_HOD $OBJEKT_KOD $PSC $X $Y if [ $STAV -eq 1 ]; then grep "^$ULICE_KOD" ulice.csv | ( IFS=, read I1 I2 NAME NAME2 grep "^$OBJEKT_KOD" objekt.csv | ( IFS=, read I1 I2 I3 CISDOM_HOD I4 echo "$X $Y" | ~/sf/timetab/cz/geo/jtsk2wgs | ( read LAT LON H echo $ID $NAME $CISDOM_HOD $CISOR_HOD $CISOR_PIS $PSC $LAT $LON echo "<node id='$ID' action='modify' visible='true' lat='$LAT' lon='$LON'>" >> /tmp/delme.osm echo " <tag k='addr:street' v=$NAME></tag>" >> /tmp/delme.osm echo " <tag k='addr:housenumber' v='$CISOR_HOD$CISOR_PIS'></tag>" >> /tmp/delme.osm echo " <tag k='addr:red' v='$CISDOM_HOD'></tag>" >> /tmp/delme.osm echo " <tag k='addr:postcode' v='$PSC'></tag>" >> /tmp/delme.osm echo " <tag k='uir_adr:ADRESA_KOD' v='$ADRESA_KOD'></tag>" >> /tmp/delme.osm echo " <tag k='source:addr' v='uir_adr'></tag>" >> /tmp/delme.osm echo "</node>" >> /tmp/delme.osm ) ) ) fi done ) cat >> /tmp/delme.osm << EOF </osm> EOF cat /tmp/delme.osm | cstocs 1250 utf8 > /tmp/delme2.osm ------------- další část --------------- <?xml version='1.0' encoding='UTF-8'?> <osm version='0.5' generator='JOSM'> <node id='-1' action='modify' visible='true' lat='50.1046381' lon='14.5605466'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='2'></tag> <tag k='addr:red' v='1062'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412883'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-2' action='modify' visible='true' lat='50.1047264' lon='14.5607255'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='4'></tag> <tag k='addr:red' v='1063'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412891'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-3' action='modify' visible='true' lat='50.1048502' lon='14.5608968'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='6'></tag> <tag k='addr:red' v='1064'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412905'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-4' action='modify' visible='true' lat='50.1049598' lon='14.5611135'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='8'></tag> <tag k='addr:red' v='1065'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412913'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-5' action='modify' visible='true' lat='50.1050557' lon='14.5612767'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='10'></tag> <tag k='addr:red' v='1066'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412921'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-6' action='modify' visible='true' lat='50.1054176' lon='14.5616800'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='12'></tag> <tag k='addr:red' v='1067'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412930'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-7' action='modify' visible='true' lat='50.1056088' lon='14.5615832'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='3'></tag> <tag k='addr:red' v='1068'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412948'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-8' action='modify' visible='true' lat='50.1054574' lon='14.5613048'> <tag k='addr:street' v='Vlčkova'></tag> <tag k='addr:housenumber' v='1'></tag> <tag k='addr:red' v='1069'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412956'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-9' action='modify' visible='true' lat='50.1053301' lon='14.5607815'> <tag k='addr:street' v='Bratří VenclĂ­kĹŻ'></tag> <tag k='addr:housenumber' v='2'></tag> <tag k='addr:red' v='1070'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412964'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-10' action='modify' visible='true' lat='50.1054861' lon='14.5605934'> <tag k='addr:street' v='Bratří VenclĂ­kĹŻ'></tag> <tag k='addr:housenumber' v='4'></tag> <tag k='addr:red' v='1071'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412972'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-11' action='modify' visible='true' lat='50.1056445' lon='14.5604330'> <tag k='addr:street' v='Bratří VenclĂ­kĹŻ'></tag> <tag k='addr:housenumber' v='6'></tag> <tag k='addr:red' v='1072'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412981'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-12' action='modify' visible='true' lat='50.1058118' lon='14.5602707'> <tag k='addr:street' v='Bratří VenclĂ­kĹŻ'></tag> <tag k='addr:housenumber' v='8'></tag> <tag k='addr:red' v='1073'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22412999'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-13' action='modify' visible='true' lat='50.1061687' lon='14.5597862'> <tag k='addr:street' v='Bratří VenclĂ­kĹŻ'></tag> <tag k='addr:housenumber' v='10'></tag> <tag k='addr:red' v='1074'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413006'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-14' action='modify' visible='true' lat='50.1062320' lon='14.5604077'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='2'></tag> <tag k='addr:red' v='1075'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413014'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-15' action='modify' visible='true' lat='50.1062680' lon='14.5606118'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='4'></tag> <tag k='addr:red' v='1076'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413022'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-16' action='modify' visible='true' lat='50.1063023' lon='14.5609008'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='6'></tag> <tag k='addr:red' v='1077'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413031'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-17' action='modify' visible='true' lat='50.1063621' lon='14.5611703'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='8'></tag> <tag k='addr:red' v='1078'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413049'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-18' action='modify' visible='true' lat='50.1065341' lon='14.5625167'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='10'></tag> <tag k='addr:red' v='1079'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413057'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-19' action='modify' visible='true' lat='50.1065599' lon='14.5627087'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='12'></tag> <tag k='addr:red' v='1080'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413065'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-20' action='modify' visible='true' lat='50.1066043' lon='14.5630097'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='14'></tag> <tag k='addr:red' v='1081'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413073'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-21' action='modify' visible='true' lat='50.1066641' lon='14.5632793'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='16'></tag> <tag k='addr:red' v='1082'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413081'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-22' action='modify' visible='true' lat='50.1068259' lon='14.5646136'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='18'></tag> <tag k='addr:red' v='1083'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413090'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-23' action='modify' visible='true' lat='50.1068542' lon='14.5648334'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='20'></tag> <tag k='addr:red' v='1084'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413103'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-24' action='modify' visible='true' lat='50.1069572' lon='14.5653901'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='24'></tag> <tag k='addr:red' v='1086'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413111'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-25' action='modify' visible='true' lat='50.1072822' lon='14.5674519'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='26'></tag> <tag k='addr:red' v='1087'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413120'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-26' action='modify' visible='true' lat='50.1073258' lon='14.5676402'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='28'></tag> <tag k='addr:red' v='1088'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413138'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-27' action='modify' visible='true' lat='50.1073869' lon='14.5679236'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='30'></tag> <tag k='addr:red' v='1089'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413146'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-28' action='modify' visible='true' lat='50.1074645' lon='14.5681894'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='32'></tag> <tag k='addr:red' v='1090'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413154'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-29' action='modify' visible='true' lat='50.1075521' lon='14.5687776'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='34'></tag> <tag k='addr:red' v='1091'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413162'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> <node id='-30' action='modify' visible='true' lat='50.1074264' lon='14.5690016'> <tag k='addr:street' v='CĂ­glerova'></tag> <tag k='addr:housenumber' v='36'></tag> <tag k='addr:red' v='1092'></tag> <tag k='addr:postcode' v='19800'></tag> <tag k='uir_adr:ADRESA_KOD' v='22413171'></tag> <tag k='source:addr' v='uir_adr'></tag> </node> </osm>

Pavel Machek napsal(a): zobrazit citaci O to nejde. Jeste jsme se nedomluvili jak to ma vypadat a ty si tu hazis outer joinama nad CSV v bashi ;-) Stejne to nakonec nejlepe provede Tomas Kolda (vid ;-)) protoze uz ma v databazi i ty 3+ roky updatu a u nej ten outer join pobezi asi tak 130ms. zobrazit citaci Hmm, pravda, vsechny updaty dohromady daji necelych 24 tisic nove dodanych souradnic existujicich adres a vseho vsudy 9 (devet) novych adres ktere maji i souradnice. Takze z hlediska souradnic jsou relevantni jen updaty 442, 497, 606, 607 a 6 zobrazit citaci Ano zobrazit citaci Udelal. Vychazis ze 4 roky starych dat. Viz prvni odstavec. (Tim nechci nijak krotit tvoji kreativitu, jen ji mirne nasmerovat. Pokud to mergovani updatu taky napises v Bashi, jsi borec ;-) Teda ne ze by to neslo...) -- Petr "Nenik" Nejedly, NetBeans/Sun Microsystems, http://www.netbeans.org 355/113 -- Not the famous irrational number PI, but an incredible simulation!

On Wed 2008-08-27 13:09:41, Petr Nejedly wrote: zobrazit citaci ;-). No, debata se zda-se omezila na 'jak se zapise cislo popisne', z cehoz usuzuju ze se v podstate shodujem.... zobrazit citaci No, ono se to stejne bude uploadovat rychlosti 3 zaznamy za sekundu... ;-). No... kdyby nekde byly updatovany data v CSV, tak nepohrdnu; asi se mi update opravdu psat nechce. Pavel -- (english) http://www.livejournal.com/~pavelmachek (cesky, pictures) http://atrey.karlin.mff.cuni.cz/~pavel/picture/horses/blog.html