Import www.cultura.ro
Jump to navigation
Jump to search
Importul a fost finalizat 1 Septembrie 2010 - 18:20 PM EEST.
Importate August 2010:
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)