[Talk-ro] Import automatizat pentru limita localitatilor (via cultura.ro)
Ioan Indreias
indreias at gmail.com
Fri Jul 30 07:28:46 BST 2010
Salut Janos,
Si eu sunt pentru continuare - daca ai timp sa te apuci de acest import cred
ca ar fi un lucru excelent.
Toate bune,
Nini
2010/7/30 Cristian Draghici <cristian.draghici la gmail.com>
> Janos,
>
> Eu zic sa-i dai drumul.
>
> Referitor la duplicate, Arad, Cluj, Maramures par deja importate (au multe
> localitati).
> Unde nu s-a facut deja import e liniste (daca vrei si iti pare fezabil poti
> filtra dupa field-ul name/place_name de mai jos ca sa elimini duplicatele
> inainte de import):
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Teleorman'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+------+------------------+----------+-------------
> 45980211 | village | | Beuca | | 6
> 45980213 | suburb | | Beuca | | 6
> 45947824 | town | | Roșiorii de Vede | | 6
> 45980214 | village | | Zâmbreasca | | 6
> 45980201 | village | | Plopi | | 6
> 45964896 | village | | Buzescu | | 6
> 45964942 | village | | Peretu | | 6
> 45949100 | city | | Alexandria | | 6
> (8 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Giurgiu'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+-------------------+------------+----------+-------------
> 24678054 | village | Ciorogarla | | |
> 51909836 | village | Daia | | |
> 23594094 | village | Branistari | | |
> 23594320 | village | Adunații Copăceni | | |
> 23594339 | village | Varlaam | | |
> 23594343 | village | Mogoșești | | |
> 23594170 | village | Budeni | | |
> 23593899 | village | Grădiștea | | |
> 23593780 | village | Fălăștoaca | | |
> 23593654 | village | Câmpurelu | | |
> 23593662 | village | Colibași | | |
> 23593693 | village | Gostinari | | |
> 23589723 | village | Dobreni | | |
> 36328390 | village | Prundu | | |
> 23593172 | village | Vărăști | | |
> 23593168 | village | Valea Dragului | | |
> (16 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Calarasi'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+------------+------------+----------+-------------
> 23594556 | village | Pasarea | | |
> 26027668 | village | Chirnogi | | |
> 26003491 | town | Oltenița | | |
> 26027832 | village | Mânăstirea | | |
> 26028080 | village | Dorobanțu | | |
> 26028120 | village | Ciocănești | | |
> (6 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Dolj'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+--------+----------+------------+----------+-------------
> 35427700 | town | Băilești | | |
> 28905141 | suburb | Făcăi | | |
> (2 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Constanta'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+---------------------+------------+----------+-------------
> 26453305 | town | Hârsova | | |
> 26453386 | village | Nicolae Bălcescu | | |
> 26453345 | village | Mihail Kogălniceanu | | |
> 27800159 | village | Movilita | | |
> 13836140 | island | Insula Ovidiu | | |
> 14383932 | village | | | |
> (6 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Ialomita'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+---------------+------------+----------+-------------
> 25745894 | city | Urziceni | | |
> 25746345 | village | Manasia | | |
> 25746314 | village | Gârbovi | | |
> 26452898 | village | Stejaru | | |
> 26452840 | village | Păltinișu | | |
> 25744563 | town | Amara | | |
> 25744430 | city | Slobozia | | |
> 26036877 | village | Slobozia Nouă | | |
> 26453711 | town | Țăndărei | | |
> 26463441 | town | Giurgeni | | |
> (10 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Olt'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+-------------+------------+----------+-------------
> 28782758 | town | Caracal | | |
> 27672382 | village | Vlădila | | |
> 31027213 | village | Vișina Nouă | | |
> 27713743 | village | Studinița | | |
> 27713790 | village | Vișina | | |
> 27532504 | village | Traian | | |
> (6 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Mehedinti'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Gorj'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Dambovita'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+------------+------------+----------+-------------
> 41809587 | city | Târgoviște | | |
> 23605262 | town | Buftea | | |
> 25471785 | village | Ologeni | | |
> (3 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Prahova'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+----------------+----------------+----------------+-------------
> 28919414 | town | Bușteni | Bușteni | administrative | 6
> 28919879 | town | Sinaia | Sinaia | administrative | 6
> 28919544 | suburb | Poiana Tapului | Poiana Tapului | administrative | 6
> 28919367 | town | Azuga | Azuga | administrative | 6
> 13631221 | city | Ploiești | | |
> 35070782 | village | Valea Cucului | | administrative | 6
> 25745682 | city | Mizil | | |
> (7 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Braila'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+------------------+------------+----------+-------------
> 25743236 | village | Dudescu | | |
> 25743718 | village | Ianca | | |
> 25742969 | village | Zăvoaia | | |
> 26036660 | town | Bărăganu | | |
> 25743538 | village | Bordei Verde | | |
> 25742929 | town | Însurăței | | |
> 25743432 | village | Viziru | | |
> 28406123 | village | Mihai Bravu | | |
> 28406369 | village | Spiru Haret | | |
> 28406262 | village | Berteștii de Jos | | |
> 28406215 | village | Berteștii de Sus | | |
> 23839602 | island | | | |
> 23839541 | island | | | |
> 23837469 | island | | | |
> 23839521 | island | | | |
> (15 rows)
>
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Tulcea'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+----------------+------------+----------+-------------
> 33189627 | village | Ceatalchioi | | |
> 27701225 | village | Ceatalchioi | | |
> 27701368 | village | Nufăru | | |
> 27701353 | village | Ilganii de Jos | | |
> 27701382 | village | Partizani | | |
> 27701366 | village | Ilganii de Sus | | |
> 26667165 | island | | | |
> 33189448 | village | Beștepe | | |
> 26789313 | village | Gorgova | | |
> 26667174 | island | | | |
> 33189561 | village | Chilia Veche | | |
> 26955237 | village | Crișan | | |
> 26955228 | village | Crișan | | |
> 26955227 | village | Crișan | | |
> 26955226 | village | Crișan | | |
> 27093275 | village | Letea | | |
> 27093255 | village | Periprava | | |
> (17 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Valcea'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+-------+----------------+------------+----------+-------------
> 41750449 | city | Râmnicu Vâlcea | | |
> (1 row)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Arges'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Caras-Severin'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+-----------+------------+----------+-------------
> 27596405 | village | Gherteniș | | |
> 27596342 | village | Fizeș | | |
> (2 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Buzau'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+---------------+------------+----------+-------------
> 25745267 | village | Pogoanele | | |
> 41667190 | city | Râmnicu Sărat | | |
> 25745244 | village | Padina | | |
> (3 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Brasov'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+---------+------------+----------+-------------
> 25608871 | village | Ghimbav | | |
> 24242604 | city | Brașov | | |
> 37088623 | village | Bod | | |
> (3 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Galati'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Vrancea'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Timis'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+--------------+------------+----------+-------------
> 22723496 | village | Gelu | | |
> 25761202 | village | Dudeștii Noi | | |
> 22723401 | village | | | |
> 25761251 | village | Orțișoara | | |
> 14324496 | town | Deta | | |
> 24607708 | suburb | Q.Plopi | | |
> 25486017 | village | Ianova | | |
> 24621614 | village | | | |
> 39627087 | village | Remetea Mică | | |
> 47717705 | village | Alioș | | |
> 14325375 | village | Recaș | | |
> 14325108 | village | Buziaș | | |
> 25710106 | village | | | |
> (13 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Sibiu'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+-------------+------------+----------+-------------
> 13777540 | city | Sibiu | | |
> 27150333 | village | Cisnadioara | | |
> 40122100 | town | | | |
> 28580741 | village | Veseud | | |
> 24283388 | town | Mediaș | | |
> 28555446 | village | Motiș | | |
> (6 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Covasna'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+-----------------+------------+----------+-------------
> 24269252 | city | Sfântu-Gheorghe | | |
> 27533835 | village | Arcuș | | |
> (2 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Hunedoara'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+------------------+---------------+----------+-------------
> 35559642 | village | Zeicani | | |
> 35559629 | village | Răchitova | | |
> 35432697 | town | | Brad | |
> 35559621 | village | Densuș | | |
> 35559636 | village | Sarmizegetusa | | |
> 35559620 | village | Clopotiva | | |
> 35559628 | village | Peșteana | | |
> 35559625 | village | Ostrov | | |
> 35559631 | village | Râu de Mori | | |
> 35559641 | village | Suseni | | |
> 35559626 | village | Păclișa | | |
> 35559637 | village | Silvașu de Sus | | |
> 53197617 | city | | Deva | |
> 35417927 | town | | Hunedoara | |
> 35559634 | village | Sânpetru | | |
> 35559624 | village | Nucșoara | | |
> 35559632 | village | Săcel | | |
> 35559623 | village | Nălațvad | | |
> 35432703 | town | | Hațeg | |
> 35559622 | village | Mălăiești | | |
> 35559633 | village | Sălașu de Sus | | |
> 35559635 | village | Sântămăria Orlea | | |
> 35559627 | village | Paroș | | |
> 35559618 | village | Ciopeia | | |
> 35417931 | town | | Călan | |
> 35559630 | village | Râu Alb | | |
> 35417929 | town | | Simeria | |
> 35417930 | village | | Simeria Veche | |
> 35432698 | town | | Lupeni | |
> 35432702 | town | | Geoagiu | |
> 35432701 | town | | Petroșani | |
> 35432704 | town | | Petrila | |
> (32 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Alba'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+-------+------------+------------+----------+-------------
> 25739309 | city | Abrud | | |
> 13692569 | city | Alba Iulia | | |
> 24256713 | town | Teiuș | | |
> 24256566 | town | Aiud | | |
> (4 rows)
>
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Bacau'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+-------+-------+------------+----------+-------------
> 40410322 | city | Bacau | | |
> (1 row)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Vaslui'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+-------+---------+------------+----------------+-------------
> 40283666 | | Văleni | | administrative | 8
> 40283667 | | Solești | | administrative | 8
> (2 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Mures'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+-------------+------------+----------------+-------------
> 45425110 | village | | Gligorești | | 6
> 31526661 | city | Târgu Mureș | | administrative | 6
> 35583196 | village | Stejereni | | |
> (3 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Harghita'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+-------+-------------------+------------+----------+-------------
> 27542899 | city | Odorheiu Secuiesc | | |
> 24239367 | town | Miercurea Ciuc | | |
> (2 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Neamt'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+--------------+------------+----------+-------------
> 40117457 | city | Piatra-Neamt | | |
> 35301755 | town | Târgu Neamț | | |
> 48272021 | village | Pildești | | |
> 15493509 | village | Săbăoani | | |
> (4 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Salaj'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Bistrita-Nasaud'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+----------+------------+----------+-------------
> 24557379 | city | Bistrița | | |
> 40433527 | village | Monor | | |
> 40433467 | village | Gledin | | |
> (3 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Iasi'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+----------+------------+----------------+-------------
> 28809798 | village | Focuri | | |
> 53789553 | village | | Lețcani | |
> 53790654 | village | | Bogonos | |
> 44021832 | island | | | |
> 27159863 | islet | | | |
> 40283677 | | Poieni | | administrative | 8
> 40283675 | | Poiana | | administrative | 8
> 40283671 | | Satu Nou | | administrative | 8
> (8 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Bihor'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+---------+------------------+------------+----------+-------------
> 28270886 | village | | Ciumeghiu | |
> 59861002 | village | Boiu | | |
> 59860123 | village | Ghiorac | | |
> 54546113 | village | | Tulca | |
> 59470729 | village | Batar - Satu Nou | | |
> 59470393 | village | Talpos | | |
> 59470728 | village | Batar | | |
> 58575660 | village | | Căuașd | |
> 59470797 | village | Taut | | |
> 58576047 | village | | Gurbediu | |
> 41311896 | suburb | Episcopia Bihor | | |
> 41396501 | city | Oradea | | |
> 59856579 | village | Girisul Negru | | |
> 59470846 | city | Tinca | | |
> 59857119 | village | Belfir | | |
> 25726151 | village | Săcueni | | |
> (16 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Suceava'));
> osm_id | place | name | place_name | boundary | admin_level
> ----------+---------+--------------+------------+----------+-------------
> 27048541 | village | Cârlibaba | | |
> 40020073 | city | Vatra Dornei | | |
> 44420849 | town | Rădăuți | | |
> 35003113 | city | Fălticeni | | |
> (4 rows)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Satu Mare'));
> osm_id | place | name | place_name | boundary |
> admin_level
>
> ----------+-------+----------------------+------------+----------+-------------
> 28996080 | city | Municipiul Satu-Mare | | |
> (1 row)
>
> openmapdb=# select osm_id, place, name, place_name, boundary, admin_level
> from planet_osm_polygon where (admin_level is not null or place is not null
> or boundary is not null) and st_intersects(way, (select boundary from
> mdl_judete where name = 'Botosani'));
> osm_id | place | name | place_name | boundary | admin_level
> --------+-------+------+------------+----------+-------------
> (0 rows)
>
>
>
>
> 2010/7/30 Manuel R Ciosici <manuelrciosici la gmail.com>
>
> Eu de Crăciun parcă am curățat județul Arad în ceea ce privește limitele
>> administrative. Ce venise din importul de la cultura.ro mi se părea
>> foarte calitativ. +1 să continui că doar în timp se curăță duplicatele la
>> limite.
>>
>> Manuel R. Ciosici
>> http://manuelciosici.com
>>
>> Sent from my iPhone
>>
>> On Jul 29, 2010, at 22:52, Janos Rusiczki <janos.rusiczki la gmail.com>
>> wrote:
>>
>> Chiar acu vreo saptamana sau doua am deshumat codul care l-am folosit
>> pentru import.
>> Oare ar trebui sa continui? Macar, asa cum a fost, dar a fost un progres.
>> :)
>>
>> 2010/7/29 Stefan UNGUREANU < <stefan.ungureanu la mytrek.ro>
>> stefan.ungureanu la mytrek.ro>
>>
>>> Salut,
>>>
>>> Pai nici nu cred ca e vreo legatura. In CLC nu exista limite
>>> administrative, numai o suma de poligoane cu diferite caracteristici.
>>>
>>> Tocmai din cauza asta sugerasem mai demult ca datele de la cultura.ro sa
>>> fie folosite ca limite administrative, iar cele de la CLC doar ca poligoane
>>> de land cover.
>>>
>>> Stefan.
>>>
>>>
>>> On 29/07/2010 21:28, Cristian Draghici wrote:
>>>
>>>> Salut
>>>>
>>>> Speram sa inteleg cum anume se va realiza treaba, pentru ca, dupa cum am
>>>> spus mai jos, eu unul nu vad legatura intre CLC land cover si limite
>>>> administrative.
>>>>
>>>> Mai mult, limitele din cultura.ro < <http://cultura.ro>
>>>> http://cultura.ro> sunt destul de
>>>>
>>>> incorecte (m-am uitat la Targu Jiu de exemplu) -> ele par sa reprezinta
>>>> limitele "de interes cultural" mai degraba decat limitele administrative
>>>> (pe satelitar sa vad zone locuite excluse din poligonul orasului).
>>>>
>>>>
>>>> Multumesc,
>>>> Cristi
>>>>
>>>> On Thu, Jul 29, 2010 at 7:16 PM, Stefan UNGUREANU
>>>> < <stefan.ungureanu la mytrek.ro>stefan.ungureanu la mytrek.ro <mailto:<stefan.ungureanu la mytrek.ro>
>>>> stefan.ungureanu la mytrek.ro>> wrote:
>>>>
>>>> Salut,
>>>>
>>>> Asa cum spune si numele mesajului (Import automatizat pentru limita
>>>> localitatilor (via cultura.ro < <http://cultura.ro>http://cultura.ro>)),
>>>> cred ca era
>>>>
>>>> vorba de a crea limitele localitatilor din datele de la 'cultura.ro
>>>> < <http://cultura.ro>http://cultura.ro>' si poligoanele de landcover
>>>> de la CLC.
>>>>
>>>>
>>>> Stefan.
>>>>
>>>>
>>>> On 28/07/2010 10:00, Cristian Draghici wrote:
>>>>
>>>> Salut
>>>>
>>>>
>>>> M-am uitat un pic peste datele CLC si ori nu gasesc ce ati gasit
>>>> voi,
>>>> ori nu inteleg cum pot fi folosite pentru definirea limitelor
>>>> oraselor
>>>> de exemplu (de aici a plecat thread-ul initial).
>>>>
>>>> Spre exemplu, daca ma uit la Giurgiu in Urban Atlas:
>>>> ( <http://www.eea.europa.eu/data-and-maps/data/urban-atlas>
>>>> http://www.eea.europa.eu/data-and-maps/data/urban-atlas) CLC nu
>>>> defineste un poligon care sa constituie limita orasului, ci un
>>>> SET de
>>>> poligoane (impartite functie de land use, etc). In acest set de
>>>> poligoane e cuprins si un sat alaturat orasului (Slobozia) pentru
>>>> simplul fapt ca si in acest sat exista o zona locuita.
>>>>
>>>> Ca atare, eu nu vad nici o legatura intre limitele
>>>> administrative ale
>>>> orasului asa cum sunt ele definite la primaria Giurgiu si datele
>>>> din
>>>> CLC, si atunci scopul initial al thread-ului (definire limite
>>>> administrative pentru localitati) nu va fi atins.
>>>>
>>>> Va rog corectati-ma daca gresesc.
>>>>
>>>> Multumiri,
>>>> Cristi
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Jun 2, 2010 at 7:21 PM, Stefan UNGUREANU
>>>> < <stefan.ungureanu la mytrek.ro>stefan.ungureanu la mytrek.ro<mailto:<stefan.ungureanu la mytrek.ro>
>>>> stefan.ungureanu la mytrek.ro>
>>>> <mailto: <stefan.ungureanu la mytrek.ro>stefan.ungureanu la mytrek.ro
>>>> <mailto: <stefan.ungureanu la mytrek.ro>stefan.ungureanu la mytrek.ro>>>
>>>> wrote:
>>>>
>>>> Salut tuturor.
>>>>
>>>> Pentru moment am luat datele si le-am prelucrat. N-am avut
>>>> timp sa caut
>>>> diferente, insa ceea ce pot sa spun e ca fisierul a crescut.
>>>>
>>>> Inainte aveam date in valoare de approx 173 Mb, acum avem
>>>> approx 176 Mb;
>>>> fisierul este comprimat (tar.gz); e drept ca datele reale
>>>> sunt probabil
>>>> cu vreo 10Mb mai mici pentru ca eu folosesc un contur al
>>>> tarii extins cu
>>>> 10 km (daca imi aduc bine aminte) pentru harta Garmin.
>>>>
>>>> Stefan.
>>>>
>>>> On 30/05/2010 19:18, Ciprian Talaba wrote:
>>>> > Salutare,
>>>> >
>>>> > Incepand cu data de 27 mai datele CLC 2006 sunt disponibile
>>>> in format
>>>> > vectorial:
>>>> >
>>>> <http://www.eea.europa.eu/data-and-maps/data/clc-2006-vector-data-version>
>>>> http://www.eea.europa.eu/data-and-maps/data/clc-2006-vector-data-version
>>>> .
>>>> >
>>>> > Avem pagina de wiki
>>>> > <http://wiki.openstreetmap.org/wiki/Romania_CLC_Import>
>>>> http://wiki.openstreetmap.org/wiki/Romania_CLC_Import unde se
>>>> discuta
>>>> > despre solutii legate de importul acestor date iar Stefan a
>>>> pus acest
>>>> > import in lista globala
>>>> > <http://wiki.openstreetmap.org/wiki/Import/Catalogue>
>>>> http://wiki.openstreetmap.org/wiki/Import/Catalogue si a
>>>> inceput sa
>>>> > prezinte modul in care realizeaza in acest moment o harta
>>>> compusa din
>>>> > datele OSM + CLC:
>>>> >
>>>> <http://wiki.openstreetmap.org/wiki/Corine_Land_Cover_Romania_2006>
>>>> http://wiki.openstreetmap.org/wiki/Corine_Land_Cover_Romania_2006.
>>>> >
>>>> > Haideti sa tragem o concluzie in ceea ce priveste cea mai buna
>>>> > modalitate de import si sa ne apucam de treaba. Binenteles o
>>>> comparatie
>>>> > cu datele OSM si eventual cu cele din CLC 2000 ar fi
>>>> binevenita,
>>>> dar din
>>>> > ce am inteles calitatea datelor este foarte buna.
>>>> >
>>>> > Numai bine,
>>>> > Ciprian
>>>> >
>>>> > On Wed, Mar 31, 2010 at 8:08 PM, Ciprian Talaba
>>>> < <cipriantalaba la gmail.com>cipriantalaba la gmail.com <mailto:<cipriantalaba la gmail.com>
>>>> cipriantalaba la gmail.com>
>>>> <mailto: <cipriantalaba la gmail.com>cipriantalaba la gmail.com<mailto:<cipriantalaba la gmail.com>
>>>> cipriantalaba la gmail.com>>
>>>> > <mailto: <cipriantalaba la gmail.com>cipriantalaba la gmail.com<mailto:<cipriantalaba la gmail.com>
>>>> cipriantalaba la gmail.com>
>>>>
>>>> <mailto: <cipriantalaba la gmail.com>cipriantalaba la gmail.com
>>>> <mailto: <cipriantalaba la gmail.com>cipriantalaba la gmail.com>>>>
>>>> wrote:
>>>> >
>>>> > Sa readucem un pin subiectul in actualitate. Asa cum cred
>>>> ca am
>>>> > mentionat pe unul din subiectele legate de CLC, am trimis
>>>> o
>>>> > intrebare catre EEA pentru a afla cand vor fi disponibile
>>>> datele
>>>> > CLC2006 in format vectorial (Stefan a utilizat ultimele
>>>> date
>>>> > vectoriale, CLC2000). Daca CLC2006 va fi publicat pana la
>>>> sfarsitul
>>>> > lui aprilie atunci merita sa mai asteptam cateva saptamani
>>>> pentru ca
>>>> > din ce stiu noile date sunt mult mai precise. Am sa incerc
>>>> sa
>>>> fac si
>>>> > o comparatie, sa vad ce pot face cu raster-ul.
>>>> >
>>>> > Binenteles intre timp putem sa discutam variantele deja
>>>> propuse
>>>> > pentru import sau sa ne gandim la unelte care ne pot ajuta
>>>> sa
>>>> > automatizam acest import :)
>>>> >
>>>> > O zi buna,
>>>> > Ciprian
>>>> >
>>>> > ==============================================
>>>> >
>>>> > Dear Ciprian Talaba,
>>>> > Thank you for your enquiry and your interest in CORINE
>>>> data.
>>>> > The EEA is the EU agency responsible for producing
>>>> aggregated
>>>> > information on the state and trends of the environment in
>>>> Europe.
>>>> > For more information on the activities of the EEA, please
>>>> see the
>>>> > following websites:
>>>> > _www.eea.europa.eu_ < <http://www.eea.europa.eu/>
>>>> http://www.eea.europa.eu/>
>>>> > _ <http://www.eea.europa.eu/help/eea-help-centre/faqs_>
>>>> http://www.eea.europa.eu/help/eea-help-centre/faqs_
>>>> > New CLC 2006 is expected to be finalised during April.
>>>> Version 13 of
>>>> > CLC2006 will include vector data of the countries that
>>>> have been
>>>> > finalised. This will be published and made available on
>>>> the EEA
>>>> > website by the end of April. For more see:
>>>> > _ <http://etc-lusi.eionet.europa.eu/CLC2006/_>
>>>> http://etc-lusi.eionet.europa.eu/CLC2006/_
>>>> > You can download the raster data for CLC2006 as well as
>>>> new
>>>> versions
>>>> > of CLC1990 and CLC2000 version 12 at:
>>>> > _ <http://www.eea.europa.eu/themes/landuse/datasets_>
>>>> http://www.eea.europa.eu/themes/landuse/datasets_
>>>> > For further information about the CLC2006 data from the
>>>> missing
>>>> > countries, you may find it relevant to contact the
>>>> responsible
>>>> > national authorities. For this purpose, I suggest that you
>>>> utilise
>>>> > the contact information for the NRC for landcover for the
>>>> countries
>>>> > of your interest. This information is available at:
>>>> >
>>>>
>>>> _<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_<<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_
>>>> >
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1_
>>>> >>
>>>>
>>>>
>>>> >
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1
>>>> >
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1
>>>> <<http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1>
>>>> http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-landcover-mc&rd=1&af=0&ud=1&od=1
>>>> >>>
>>>> > General information
>>>> > From the EEA website, we have CORINE landcover data which
>>>> is
>>>> > available free of charge. The current data we have
>>>> available for
>>>> > landcover can be found at the following website:
>>>> > _ <http://www.eea.europa.eu/themes/landuse/datasets_>
>>>> http://www.eea.europa.eu/themes/landuse/datasets_
>>>> > To be provided with an overview of EEA land use data and
>>>> reports,
>>>> > you can consult the EEA theme section at:
>>>> > _ <http://www.eea.europa.eu/themes/landuse_>
>>>> http://www.eea.europa.eu/themes/landuse_
>>>> > The CLC viewer may also be interesting for you at (here
>>>> you
>>>> can also
>>>> > download tiles specific for the area you are interested
>>>> in):
>>>> > _ <http://dataservice.eea.europa.eu/clc/eeaclc.asp_>
>>>> http://dataservice.eea.europa.eu/clc/eeaclc.asp_
>>>> > The EEA EIONET GIS website includes guides on geographic
>>>> information
>>>> > from the EEA and also a link to free open source GIS
>>>> software.
>>>> > Please have a look at this information here:
>>>> > _ <http://www.eionet.europa.eu/gis_>
>>>> http://www.eionet.europa.eu/gis_
>>>> > Hopefully, this information may be helpful to you.
>>>> > Kind regards,
>>>> > Jesse Goodman | Communications | *European Environment
>>>> Agency
>>>> > *Kongens Nytorv 6 - 1050 Copenhagen K – Denmark
>>>> > Tel.: +45 33 36 71 85 +45 33 36 71 85 | E-mail:
>>>> > _jesse.goodman la eea.europa.eu_
>>>> <mailto: <jesse.goodman la eea.europa.eu>
>>>> jesse.goodman la eea.europa.eu
>>>> <mailto: <jesse.goodman la eea.europa.eu>
>>>> jesse.goodman la eea.europa.eu>
>>>> <mailto: <jesse.goodman la eea.europa.eu>
>>>> jesse.goodman la eea.europa.eu
>>>> <mailto: <jesse.goodman la eea.europa.eu>
>>>> jesse.goodman la eea.europa.eu>>> |
>>>> > Enquiries: _<http://www.europa.eu/help/infocentre/enquiries_>
>>>> www.europa.eu/help/infocentre/enquiries_
>>>> < <http://www.europa.eu/help/infocentre/enquiries_>
>>>> http://www.europa.eu/help/infocentre/enquiries_>
>>>> < <http://www.europa.eu/help/infocentre/enquiries_>
>>>> http://www.europa.eu/help/infocentre/enquiries_>
>>>> > < <http://www.europa.eu/help/infocentre/enquiries>
>>>> http://www.europa.eu/help/infocentre/enquiries> |
>>>> > _www.eea.europa.eu_ < <http://www.eea.europa.eu/>
>>>> http://www.eea.europa.eu/>
>>>> > /*Do something for our planet, print this email only if
>>>> needed. Even
>>>> > a small action can make an enormous difference, when
>>>> millions of
>>>> > people do it! */
>>>> >
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > _______________________________________________
>>>> > Talk-ro mailing list
>>>> > <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org <mailto:<Talk-ro la openstreetmap.org>
>>>> Talk-ro la openstreetmap.org>
>>>> <mailto: <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org
>>>> <mailto: <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org>>
>>>>
>>>> > <http://lists.openstreetmap.org/listinfo/talk-ro>
>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>
>>>> _______________________________________________
>>>> Talk-ro mailing list
>>>> <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org <mailto:<Talk-ro la openstreetmap.org>
>>>> Talk-ro la openstreetmap.org>
>>>> <mailto: <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org
>>>> <mailto: <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org>>
>>>>
>>>> <http://lists.openstreetmap.org/listinfo/talk-ro>
>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Talk-ro mailing list
>>>> <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org <mailto:<Talk-ro la openstreetmap.org>
>>>> Talk-ro la openstreetmap.org>
>>>> <http://lists.openstreetmap.org/listinfo/talk-ro>
>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>
>>>>
>>>> _______________________________________________
>>>> Talk-ro mailing list
>>>> <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org <mailto:<Talk-ro la openstreetmap.org>
>>>> Talk-ro la openstreetmap.org>
>>>> <http://lists.openstreetmap.org/listinfo/talk-ro>
>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Talk-ro mailing list
>>>> <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org
>>>> <http://lists.openstreetmap.org/listinfo/talk-ro>
>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>
>>>
>>> _______________________________________________
>>> Talk-ro mailing list
>>> <Talk-ro la openstreetmap.org>Talk-ro la openstreetmap.org
>>> <http://lists.openstreetmap.org/listinfo/talk-ro>
>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>
>>
>> _______________________________________________
>> Talk-ro mailing list
>> Talk-ro la openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ro
>>
>>
>> _______________________________________________
>> Talk-ro mailing list
>> Talk-ro la openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ro
>>
>>
>
>
>
> _______________________________________________
> Talk-ro mailing list
> Talk-ro la openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-ro
>
>
-------------- partea urm�toare --------------
Un ata�ament HTML a fost eliminat
URL: <http://lists.openstreetmap.org/pipermail/talk-ro/attachments/20100730/ce52a653/attachment-0001.html>
More information about the Talk-ro
mailing list