[Talk-ro] Import automatizat pentru limita localitatilor (via cultura.ro)
Cristian Draghici
cristian.draghici at gmail.com
Fri Jul 30 06:22:02 BST 2010
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
>
>
-------------- partea urm�toare --------------
Un ata�ament HTML a fost eliminat
URL: <http://lists.openstreetmap.org/pipermail/talk-ro/attachments/20100730/164efd8b/attachment-0001.html>
More information about the Talk-ro
mailing list