Import www.cultura.ro

From OpenStreetMap Wiki
Jump to: navigation, search

Importul a fost finalizat 1 Septembrie 2010 - 18:20 PM EEST.

Importate August 2010:

Nume Changeset
Arad deja importat
Cluj deja importat
Maramures deja importat
Teleorman http://www.openstreetmap.org/browse/changeset/5578846
Giurgiu http://www.openstreetmap.org/browse/changeset/5589673
Calarasi http://www.openstreetmap.org/browse/changeset/5596860
Dolj http://www.openstreetmap.org/browse/changeset/5597466
Constanta http://www.openstreetmap.org/browse/changeset/5598265
Ialomita http://www.openstreetmap.org/browse/changeset/5598542
Olt http://www.openstreetmap.org/browse/changeset/5599061
Mehedinti http://www.openstreetmap.org/browse/changeset/5599553
Gorj http://www.openstreetmap.org/browse/changeset/5604639
Dambovita http://www.openstreetmap.org/browse/changeset/5605006
Prahova http://www.openstreetmap.org/browse/changeset/5605280
Braila http://www.openstreetmap.org/browse/changeset/5606857
Tulcea http://www.openstreetmap.org/browse/changeset/5607324
Valcea http://www.openstreetmap.org/browse/changeset/5607698
Arges http://www.openstreetmap.org/browse/changeset/5608373 (multiple change sets due to upload network error)
Caras Severin http://www.openstreetmap.org/browse/changeset/5632800
Buzau http://www.openstreetmap.org/browse/changeset/5633016
Brasov http://www.openstreetmap.org/browse/changeset/5633325
Galati http://www.openstreetmap.org/browse/changeset/5633446
Vrancea http://www.openstreetmap.org/browse/changeset/5633543
Timis http://www.openstreetmap.org/browse/changeset/5633851
Sibiu http://www.openstreetmap.org/browse/changeset/5634302
Covasna http://www.openstreetmap.org/browse/changeset/5634584
Hunedoara http://www.openstreetmap.org/browse/changeset/5635040
Alba http://www.openstreetmap.org/browse/changeset/5635622
Bacau http://www.openstreetmap.org/browse/changeset/5636121
Vaslui http://www.openstreetmap.org/browse/changeset/5636562
Mures http://www.openstreetmap.org/browse/changeset/5642353
Harghita http://www.openstreetmap.org/browse/changeset/5642548
Neamt http://www.openstreetmap.org/browse/changeset/5642764
Salaj http://www.openstreetmap.org/browse/changeset/5643124
Iasi http://www.openstreetmap.org/browse/changeset/5644592
Bihor http://www.openstreetmap.org/browse/changeset/5651309
Suceava http://www.openstreetmap.org/browse/changeset/5652434
Satu Mare http://www.openstreetmap.org/browse/changeset/5652680
Botosani http://www.openstreetmap.org/browse/changeset/5654597


Localitati cu limite administrative deja existente (vor fi excluse din import pentru a evita poligoane duplicate):


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)

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)

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)

Dolj

  osm_id  | place  |   name   | place_name | boundary | admin_level 
----------+--------+----------+------------+----------+-------------
 35427700 | town   | Băilești |            |          | 
 28905141 | suburb | Făcăi    |            |          | 
(2 rows)

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)

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)


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)

Mehedinti

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)

Gorj

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)

Dambovita

  osm_id  |  place  |    name    | place_name | boundary | admin_level 
----------+---------+------------+------------+----------+-------------
 41809587 | city    | Târgoviște |            |          | 
 23605262 | town    | Buftea     |            |          | 
 25471785 | village | Ologeni    |            |          | 
(3 rows)

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)

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 |            |          | 

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)

Valcea

  osm_id  | place |      name      | place_name | boundary | admin_level 
----------+-------+----------------+------------+----------+-------------
 41750449 | city  | Râmnicu Vâlcea |            |          | 
(1 row)

Arges

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)

Caras Severin

  osm_id  |  place  |   name    | place_name | boundary | admin_level 
----------+---------+-----------+------------+----------+-------------
 27596405 | village | Gherteniș |            |          | 
 27596342 | village | Fizeș     |            |          | 
(2 rows)

Buzau

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)

Brasov

  osm_id  |  place  |  name   | place_name | boundary | admin_level 
----------+---------+---------+------------+----------+-------------
 25608871 | village | Ghimbav |            |          | 
 24242604 | city    | Brașov  |            |          | 
 37088623 | village | Bod     |            |          | 
(3 rows)

Galati

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)

Vrancea

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)


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)


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)


Covasna

  osm_id  |  place  |      name       | place_name | boundary | admin_level 
----------+---------+-----------------+------------+----------+-------------
 24269252 | city    | Sfântu-Gheorghe |            |          | 
 27533835 | village | Arcuș           |            |          | 
(2 rows)

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)


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)

Bacau

  osm_id  | place | name  | place_name | boundary | admin_level 
----------+-------+-------+------------+----------+-------------
 40410322 | city  | Bacau |            |          | 
(1 row)


Vaslui

  osm_id  | place |  name   | place_name |    boundary    | admin_level 
----------+-------+---------+------------+----------------+-------------
 40283666 |       | Văleni  |            | administrative | 8
 40283667 |       | Solești |            | administrative | 8
(2 rows)


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)

Harghita

  osm_id  | place |       name        | place_name | boundary | admin_level 
----------+-------+-------------------+------------+----------+-------------
 27542899 | city  | Odorheiu Secuiesc |            |          | 
 24239367 | town  | Miercurea Ciuc    |            |          | 
(2 rows)

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)

Salaj

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)

Bistrita-Nasaud

  osm_id  |  place  |   name   | place_name | boundary | admin_level 
----------+---------+----------+------------+----------+-------------
 24557379 | city    | Bistrița |            |          | 
 40433527 | village | Monor    |            |          | 
 40433467 | village | Gledin   |            |          | 
(3 rows)

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)


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)


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)

Satu Mare

  osm_id  | place |         name         | place_name | boundary | admin_level 
----------+-------+----------------------+------------+----------+-------------
 28996080 | city  | Municipiul Satu-Mare |            |          | 
(1 row)

Botosani

 osm_id | place | name | place_name | boundary | admin_level 
--------+-------+------+------------+----------+-------------
(0 rows)