Ro:EditareTagDrumuri

From OpenStreetMap Wiki
Jump to: navigation, search
openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential');
 count 
-------
 13990
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'Strada%';
 count 
-------
  2132
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'strada%';
 count 
-------
    11
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'Str.%';
 count 
-------
  1360
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'str.%';
 count 
-------
    87
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'Bulevar%';
 count 
-------
   434
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'bulevar%';
 count 
-------
     2
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'Ale%';
 count 
-------
   323
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'ale%';
 count 
-------
     0
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'B-dul%';
 count 
-------
    50
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'b-dul%';
 count 
-------
     0
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'Intrar%';
 count 
-------
   135
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like 'intrar%';
 count 
-------
     3
(1 row)

openmapdb=# select count(name) from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like '%;%';
 count 
-------
    46
(1 row)




Ciudatenii (merge in Potlatch?)

openmapdb=# select name from planet_osm_line where highway in ('primary', 'secondary', 'tertiary', 'residential') and name like '%;%';
                                            name                                             
---------------------------------------------------------------------------------------------
 DN6;E70
 DN6;E70
 DN11;E574
 DN11;E574
 tbd; Str. Kós Károly
 DN12;E578
 B-dul Mihai Viteazul; B-dul Mihai Viteazul; Bld. Mihai Viteazul
 Pasajul Baneasa; Bulevardul Aerogarii
 Pasajul Baneasa; Bulevardul Aerogarii
 Podul Hasdeu; Strada Bogdan Petriceicu-Hasdeu
 Bulevardul Octavian Goga; Calea Vitan
 Strada Lucian Blaga; Bulevardul Octavian Goga; Calea Vitan
 Soseaua Ghermanesti; 101B
 Soseaua Snagov; 101B
 DJ200;DJ100
 DJ412;DJ401
 DC27;DJ300
 Bulevardul Dorobanţilor; Strada Gratiei
 Strada Principala; DN 39
 Soseaua Portului; DN 39
 Strada Mihail Kogalniceanu; DN 39
 Bulevardul Regele ferdinand I; Bulevardul Regele Ferdinand I
 Str. Paris; Strada Coriolan Brediceanu
 Strada Episcop Augustin Pache; STRADA EPISCOP AUGUSTIN PACHE; STRADA EPISCOP AUGUSTIN PACHE
 Strada Salcamilor; Strada Feldioara
 Strada Mihail Kogălniceanu; Strada Dacilor
 Strada Mihail Kogălniceanu; Strada Dacilor
 STRADA BABA DOCHIA;
 STRADA BABA DOCHIA;
 Strada Ştefan Octavian Iosif; Strada Gloriei
 Strada Gheorghe Adam; Strada Demetriade
 Strada Gheorghe Adam; Strada Demetriade
 E671;E68
 Tsar Mihail III Shishman; Zhivko Puev
 Tsar Mihail III Shishman; Zhivko Puev
 Splaiul Independentei; Splaiul Independenţei
 E79; DN56
 E79; DN56
 E79; DN56
 Ion Codru Dragusanu; Luarea Bastiliei
 Lanii; Charles Darwin
 DN17;E58
 DN6;E70
 DN6;E70
 DN6;E70
 DN6;E70
(46 rows)


Nationale (DN)

OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/28523802 ">28523802 </a> primary DN 15B rezolvat (sters pentru ca era un duplicat)
<a href="http://openstreetmap.org/browse/way/26233548 ">26233548 </a> primary DN 10 rezolvat (sters pentru ca era un duplicat)
<a href="http://openstreetmap.org/browse/way/25639331 ">25639331 </a> primary DN 22B rezolvat


Europene (E)

OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/23556809 ">23556809 </a> trunk E 70 editor
<a href="http://openstreetmap.org/browse/way/20854655 ">20854655 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/21783513 ">21783513 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/21783528 ">21783528 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/21052622 ">21052622 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/15244260 ">15244260 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/15244597 ">15244597 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/28284567 ">28284567 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/28284568 ">28284568 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/28284569 ">28284569 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/23679936 ">23679936 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15493146 ">15493146 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15493378 ">15493378 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15512026 ">15512026 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511859 ">15511859 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15512003 ">15512003 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511929 ">15511929 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511916 ">15511916 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511729 ">15511729 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511251 ">15511251 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244359 ">15244359 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244366 ">15244366 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244362 ">15244362 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15242465 ">15242465 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244224 ">15244224 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876737 ">25876737 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243089 ">15243089 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243043 ">15243043 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243057 ">15243057 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876746 ">25876746 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876743 ">25876743 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243063 ">15243063 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876747 ">25876747 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243078 ">15243078 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/14447527 ">14447527 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243076 ">15243076 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876740 ">25876740 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876739 ">25876739 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/26528672 ">26528672 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243199 ">15243199 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243192 ">15243192 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15486393 ">15486393 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15486423 ">15486423 </a> trunk E 85 editor



Judetene (DJ)


OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/26159847 ">26159847 </a> secondary DJ 663 editor
<a href="http://openstreetmap.org/browse/way/25349587 ">25349587 </a> secondary DJ 663A editor
<a href="http://openstreetmap.org/browse/way/25349592 ">25349592 </a> secondary DJ 663A editor
<a href="http://openstreetmap.org/browse/way/25349731 ">25349731 </a> secondary DJ 674A editor
<a href="http://openstreetmap.org/browse/way/24416040 ">24416040 </a> secondary DJ 675 editor
<a href="http://openstreetmap.org/browse/way/24228358 ">24228358 </a> secondary DJ 655 editor
<a href="http://openstreetmap.org/browse/way/24011374 ">24011374 </a> secondary DJ 679 editor
<a href="http://openstreetmap.org/browse/way/24016448 ">24016448 </a> secondary DJ 679 editor
<a href="http://openstreetmap.org/browse/way/24241758 ">24241758 </a> secondary DJ 679C editor
<a href="http://openstreetmap.org/browse/way/24228767 ">24228767 </a> secondary DJ 506 editor
<a href="http://openstreetmap.org/browse/way/22906556 ">22906556 </a> secondary DJ 701B editor
<a href="http://openstreetmap.org/browse/way/22905315 ">22905315 </a> secondary DJ 602 editor
<a href="http://openstreetmap.org/browse/way/22905324 ">22905324 </a> secondary DJ 602 editor
<a href="http://openstreetmap.org/browse/way/16872548 ">16872548 </a> secondary DJ 701B editor
<a href="http://openstreetmap.org/browse/way/16872550 ">16872550 </a> secondary DJ 701B editor
<a href="http://openstreetmap.org/browse/way/22896710 ">22896710 </a> secondary DJ 100A editor
<a href="http://openstreetmap.org/browse/way/22905098 ">22905098 </a> secondary DJ 100A editor
<a href="http://openstreetmap.org/browse/way/22895298 ">22895298 </a> secondary DJ 101 editor
<a href="http://openstreetmap.org/browse/way/23584719 ">23584719 </a> primary_link DJ 601A editor
<a href="http://openstreetmap.org/browse/way/22895458 ">22895458 </a> secondary DJ 101 editor
<a href="http://openstreetmap.org/browse/way/17377749 ">17377749 </a> secondary DJ 101G editor
<a href="http://openstreetmap.org/browse/way/17377821 ">17377821 </a> secondary DJ 101G editor
<a href="http://openstreetmap.org/browse/way/17377812 ">17377812 </a> secondary DJ 101G editor
<a href="http://openstreetmap.org/browse/way/22598266 ">22598266 </a> secondary DJ 101 editor
<a href="http://openstreetmap.org/browse/way/21779262 ">21779262 </a> secondary DJ 200b editor
<a href="http://openstreetmap.org/browse/way/21778992 ">21778992 </a> secondary DJ 200b editor
<a href="http://openstreetmap.org/browse/way/15961810 ">15961810 </a> secondary DJ 101D editor
<a href="http://openstreetmap.org/browse/way/27633909 ">27633909 </a> secondary DJ 101 editor
<a href="http://openstreetmap.org/browse/way/15961802 ">15961802 </a> secondary DJ 101D editor
<a href="http://openstreetmap.org/browse/way/15961804 ">15961804 </a> secondary DJ 101D editor
<a href="http://openstreetmap.org/browse/way/21757754 ">21757754 </a> secondary DJ 100 editor
<a href="http://openstreetmap.org/browse/way/22598242 ">22598242 </a> secondary DJ 200 editor
<a href="http://openstreetmap.org/browse/way/21057482 ">21057482 </a> secondary DJ 300 editor
<a href="http://openstreetmap.org/browse/way/21057476 ">21057476 </a> secondary DJ 300 editor
<a href="http://openstreetmap.org/browse/way/21757677 ">21757677 </a> secondary DJ 100 editor
<a href="http://openstreetmap.org/browse/way/22598758 ">22598758 </a> secondary DJ 101C editor
<a href="http://openstreetmap.org/browse/way/22598754 ">22598754 </a> secondary DJ 101C editor
<a href="http://openstreetmap.org/browse/way/22598759 ">22598759 </a> secondary DJ 101C editor
<a href="http://openstreetmap.org/browse/way/22598737 ">22598737 </a> secondary DJ 101C editor
<a href="http://openstreetmap.org/browse/way/22598755 ">22598755 </a> secondary DJ 101C editor
<a href="http://openstreetmap.org/browse/way/21757701 ">21757701 </a> secondary DJ 100 editor
<a href="http://openstreetmap.org/browse/way/16134658 ">16134658 </a> secondary DJ 101E editor
<a href="http://openstreetmap.org/browse/way/24683848 ">24683848 </a> secondary DJ 101E editor
<a href="http://openstreetmap.org/browse/way/16134653 ">16134653 </a> secondary DJ 101F editor
<a href="http://openstreetmap.org/browse/way/26004584 ">26004584 </a> secondary DJ 403 editor
<a href="http://openstreetmap.org/browse/way/24450765 ">24450765 </a> secondary DJ 100H editor
<a href="http://openstreetmap.org/browse/way/28194418 ">28194418 </a> secondary DJ 203G editor
<a href="http://openstreetmap.org/browse/way/28194426 ">28194426 </a> secondary DJ 205 editor
<a href="http://openstreetmap.org/browse/way/28044716 ">28044716 </a> secondary DJ 102F editor
<a href="http://openstreetmap.org/browse/way/28044718 ">28044718 </a> secondary DJ 102F editor
<a href="http://openstreetmap.org/browse/way/28191079 ">28191079 </a> secondary DJ 205 editor
<a href="http://openstreetmap.org/browse/way/28044717 ">28044717 </a> secondary DJ 102F editor
<a href="http://openstreetmap.org/browse/way/28284220 ">28284220 </a> secondary DJ 102F editor
<a href="http://openstreetmap.org/browse/way/28284221 ">28284221 </a> secondary DJ 102F editor
<a href="http://openstreetmap.org/browse/way/23679228 ">23679228 </a> secondary DJ 204A editor
<a href="http://openstreetmap.org/browse/way/23691818 ">23691818 </a> secondary DJ 202C editor
<a href="http://openstreetmap.org/browse/way/23679671 ">23679671 </a> secondary DJ 202D editor
<a href="http://openstreetmap.org/browse/way/25847105 ">25847105 </a> secondary DJ 248 editor
<a href="http://openstreetmap.org/browse/way/25875470 ">25875470 </a> secondary DJ 204 editor
<a href="http://openstreetmap.org/browse/way/23026353 ">23026353 </a> secondary DJ 394 editor
<a href="http://openstreetmap.org/browse/way/23026054 ">23026054 </a> secondary DJ 394 editor


Judetene cu litera mica si spatiu (Dj)

OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/25990652 ">25990652 </a> secondary Dj 714 editor
<a href="http://openstreetmap.org/browse/way/25982935 ">25982935 </a> secondary Dj 713A editor
<a href="http://openstreetmap.org/browse/way/26030994 ">26030994 </a> secondary Dj 714 editor
<a href="http://openstreetmap.org/browse/way/26030995 ">26030995 </a> secondary Dj 714 editor
<a href="http://openstreetmap.org/browse/way/25982937 ">25982937 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757332 ">27757332 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757331 ">27757331 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757407 ">27757407 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757333 ">27757333 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757424 ">27757424 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/27757336 ">27757336 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/23340079 ">23340079 </a> secondary Dj 503 editor
<a href="http://openstreetmap.org/browse/way/27757341 ">27757341 </a> secondary Dj 713 editor
<a href="http://openstreetmap.org/browse/way/23340311 ">23340311 </a> secondary Dj 503 editor
<a href="http://openstreetmap.org/browse/way/23340326 ">23340326 </a> secondary Dj 601 editor
<a href="http://openstreetmap.org/browse/way/25879220 ">25879220 </a> secondary Dj 226A editor
<a href="http://openstreetmap.org/browse/way/25843895 ">25843895 </a> secondary Dj 222C editor


Nationale cu litera mica si spatiu (Dn )

OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/24489732 ">24489732 </a> primary Dn 52 editor


Segmente de drum national care au nume identic cu ref [select osm_id, highway, ref, name from planet_osm_roads where ref like 'DN%' and name = ref;]


OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/24047346 ">24047346 </a> primary DN58 editor
<a href="http://openstreetmap.org/browse/way/24066205 ">24066205 </a> primary DN58 editor
<a href="http://openstreetmap.org/browse/way/24047149 ">24047149 </a> primary DN58 editor
<a href="http://openstreetmap.org/browse/way/24073802 ">24073802 </a> primary DN57B editor
<a href="http://openstreetmap.org/browse/way/26279059 ">26279059 </a> primary DN1H editor
<a href="http://openstreetmap.org/browse/way/28210321 ">28210321 </a> primary DN1H editor
<a href="http://openstreetmap.org/browse/way/25257385 ">25257385 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/25257570 ">25257570 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/26517295 ">26517295 </a> primary DN56A editor
<a href="http://openstreetmap.org/browse/way/25718923 ">25718923 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/24423554 ">24423554 </a> primary DN19;E81 editor
<a href="http://openstreetmap.org/browse/way/27779253 ">27779253 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/25257572 ">25257572 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/27532823 ">27532823 </a> primary DN67A editor
<a href="http://openstreetmap.org/browse/way/26553539 ">26553539 </a> primary DN1C;E81 editor
<a href="http://openstreetmap.org/browse/way/27779252 ">27779252 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/25257519 ">25257519 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/27810501 ">27810501 </a> primary DN19;E81 editor
<a href="http://openstreetmap.org/browse/way/25257532 ">25257532 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/23561845 ">23561845 </a> primary DN67 editor
<a href="http://openstreetmap.org/browse/way/24245489 ">24245489 </a> primary DN74 editor
<a href="http://openstreetmap.org/browse/way/26564927 ">26564927 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/26564932 ">26564932 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/24227886 ">24227886 </a> trunk DN6 editor
<a href="http://openstreetmap.org/browse/way/24153641 ">24153641 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/24153696 ">24153696 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/24153774 ">24153774 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/24256785 ">24256785 </a> primary DN14B editor
<a href="http://openstreetmap.org/browse/way/24154071 ">24154071 </a> primary DN75 editor
<a href="http://openstreetmap.org/browse/way/27735230 ">27735230 </a> primary DN6;E70 editor
<a href="http://openstreetmap.org/browse/way/27153631 ">27153631 </a> primary DN7A editor
<a href="http://openstreetmap.org/browse/way/27712785 ">27712785 </a> primary DN54 editor
<a href="http://openstreetmap.org/browse/way/27712784 ">27712784 </a> primary DN54 editor
<a href="http://openstreetmap.org/browse/way/27712783 ">27712783 </a> primary DN54 editor
<a href="http://openstreetmap.org/browse/way/28362568 ">28362568 </a> primary DN64 editor
<a href="http://openstreetmap.org/browse/way/28362586 ">28362586 </a> primary DN64 editor
<a href="http://openstreetmap.org/browse/way/24240800 ">24240800 </a> primary DN14a editor
<a href="http://openstreetmap.org/browse/way/24356818 ">24356818 </a> primary DN17;E58 editor
<a href="http://openstreetmap.org/browse/way/24240928 ">24240928 </a> primary DN14a editor
<a href="http://openstreetmap.org/browse/way/24240924 ">24240924 </a> primary DN14a editor
<a href="http://openstreetmap.org/browse/way/24240805 ">24240805 </a> primary DN14a editor
<a href="http://openstreetmap.org/browse/way/24240806 ">24240806 </a> primary DN14A editor
<a href="http://openstreetmap.org/browse/way/27712771 ">27712771 </a> primary DN54 editor
<a href="http://openstreetmap.org/browse/way/28046493 ">28046493 </a> primary DN64 editor
<a href="http://openstreetmap.org/browse/way/28046486 ">28046486 </a> primary DN64 editor
<a href="http://openstreetmap.org/browse/way/24240735 ">24240735 </a> primary DN14A editor
<a href="http://openstreetmap.org/browse/way/27713974 ">27713974 </a> primary DN54 editor
<a href="http://openstreetmap.org/browse/way/26478891 ">26478891 </a> primary DN73C editor
<a href="http://openstreetmap.org/browse/way/4833220 ">4833220 </a> primary DN7C editor
<a href="http://openstreetmap.org/browse/way/24239215 ">24239215 </a> primary DN13A editor
<a href="http://openstreetmap.org/browse/way/28051630 ">28051630 </a> primary DN6;E70 editor
<a href="http://openstreetmap.org/browse/way/26947623 ">26947623 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/25652260 ">25652260 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/25652261 ">25652261 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/25652262 ">25652262 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/26351378 ">26351378 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/25652263 ">25652263 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/25651462 ">25651462 </a> primary DN73A editor
<a href="http://openstreetmap.org/browse/way/26351385 ">26351385 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/26351395 ">26351395 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/27751985 ">27751985 </a> trunk DN1 editor
<a href="http://openstreetmap.org/browse/way/26124971 ">26124971 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/27314362 ">27314362 </a> trunk DN1 editor
<a href="http://openstreetmap.org/browse/way/26168460 ">26168460 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/12128380 ">12128380 </a> primary DN17A editor
<a href="http://openstreetmap.org/browse/way/28507234 ">28507234 </a> primary DN10 editor
<a href="http://openstreetmap.org/browse/way/24271103 ">24271103 </a> primary DN10 editor
<a href="http://openstreetmap.org/browse/way/23754211 ">23754211 </a> primary DN12 editor
<a href="http://openstreetmap.org/browse/way/23753620 ">23753620 </a> primary DN12 editor
<a href="http://openstreetmap.org/browse/way/23218377 ">23218377 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379772 ">24379772 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379771 ">24379771 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379766 ">24379766 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379758 ">24379758 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/26125060 ">26125060 </a> secondary DN2K editor
<a href="http://openstreetmap.org/browse/way/24379755 ">24379755 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379764 ">24379764 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379752 ">24379752 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379751 ">24379751 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379744 ">24379744 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/24379743 ">24379743 </a> primary DN2E editor
<a href="http://openstreetmap.org/browse/way/13623479 ">13623479 </a> trunk DN7 editor
<a href="http://openstreetmap.org/browse/way/23584395 ">23584395 </a> trunk DN7 editor
<a href="http://openstreetmap.org/browse/way/28523802 ">28523802 </a> primary DN 15B editor
<a href="http://openstreetmap.org/browse/way/23727297 ">23727297 </a> trunk DN1 editor
<a href="http://openstreetmap.org/browse/way/23727041 ">23727041 </a> trunk DN1 editor
<a href="http://openstreetmap.org/browse/way/23576300 ">23576300 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/23576334 ">23576334 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/23576364 ">23576364 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/23576384 ">23576384 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/23576379 ">23576379 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/23576400 ">23576400 </a> primary DN3 editor
<a href="http://openstreetmap.org/browse/way/28524011 ">28524011 </a> primary DN10 editor
<a href="http://openstreetmap.org/browse/way/25197342 ">25197342 </a> primary DN31 editor
<a href="http://openstreetmap.org/browse/way/27664953 ">27664953 </a> primary DN2C editor
<a href="http://openstreetmap.org/browse/way/28404961 ">28404961 </a> primary DN2M editor
<a href="http://openstreetmap.org/browse/way/28404959 ">28404959 </a> primary DN2M editor
<a href="http://openstreetmap.org/browse/way/22820516 ">22820516 </a> primary DN2B editor
<a href="http://openstreetmap.org/browse/way/25908455 ">25908455 </a> primary DN24 editor
<a href="http://openstreetmap.org/browse/way/25908454 ">25908454 </a> primary DN24 editor
<a href="http://openstreetmap.org/browse/way/20866946 ">20866946 </a> primary DN24 editor
<a href="http://openstreetmap.org/browse/way/25908452 ">25908452 </a> primary DN24 editor
<a href="http://openstreetmap.org/browse/way/25908453 ">25908453 </a> primary DN24 editor
<a href="http://openstreetmap.org/browse/way/25875472 ">25875472 </a> primary DN25 editor
<a href="http://openstreetmap.org/browse/way/23002073 ">23002073 </a> primary DN25 editor
<a href="http://openstreetmap.org/browse/way/23002074 ">23002074 </a> primary DN25 editor
<a href="http://openstreetmap.org/browse/way/25639331 ">25639331 </a> primary DN 22B editor


Segmente de drum european cu name identic cu ref

OSM_IDtyperefstatus
<a href="http://openstreetmap.org/browse/way/13040954 ">13040954 </a> primary E671 editor
<a href="http://openstreetmap.org/browse/way/5031594 ">5031594 </a> primary E671 editor
<a href="http://openstreetmap.org/browse/way/13040460 ">13040460 </a> primary E671 editor
<a href="http://openstreetmap.org/browse/way/27015494 ">27015494 </a> trunk E79 editor
<a href="http://openstreetmap.org/browse/way/26252573 ">26252573 </a> trunk E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/26517172 ">26517172 </a> trunk E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/26506290 ">26506290 </a> trunk E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/26506434 ">26506434 </a> trunk E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/26506432 ">26506432 </a> trunk E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/28049608 ">28049608 </a> primary E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/28049736 ">28049736 </a> primary E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/28049978 ">28049978 </a> secondary E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/28049245 ">28049245 </a> secondary E79; DN56 editor
<a href="http://openstreetmap.org/browse/way/15244260 ">15244260 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/15244597 ">15244597 </a> trunk E 60 editor
<a href="http://openstreetmap.org/browse/way/28284567 ">28284567 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/28284568 ">28284568 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/28284569 ">28284569 </a> trunk_link E 85 editor
<a href="http://openstreetmap.org/browse/way/23679936 ">23679936 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15512026 ">15512026 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511859 ">15511859 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15512003 ">15512003 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511929 ">15511929 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511916 ">15511916 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511729 ">15511729 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15511251 ">15511251 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244359 ">15244359 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244366 ">15244366 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244362 ">15244362 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15242465 ">15242465 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15244224 ">15244224 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243089 ">15243089 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243057 ">15243057 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243063 ">15243063 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/25876747 ">25876747 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/26528672 ">26528672 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243199 ">15243199 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15243192 ">15243192 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15486393 ">15486393 </a> trunk E 85 editor
<a href="http://openstreetmap.org/browse/way/15486423 ">15486423 </a> trunk E 85 editor

Alte interogări utile

Cu această interogare putem găsi mai ușor drumurile care au nevoie de cuvântul "Strada" înainte de nume. Deoarece încă mai există elemente de inconsecvență și de risc, nu se poate adăuga pur și simplu 'Strada ' înainte de orice nume din lista generată (dar e un bun început).


select osm_id, ref, name from planet_osm_line where name !~ '^(Stradela|Intrarea|Pasajul|Strada|Calea|Splaiul|Bulevardul|Drumul|[SȘŞ]oseaua|Alee?a|Pia[țtţ][aă]|Podul|[Ss]tr.? )' and highway ~* '(trunk|primary|secondary|tertiary|residential|service|living_street|road)' and name !~* '^(DN|DJ|DC|E *[0-9]+)' and name !~* '[ЦарАлександърúőűđĐß]' and name ~* '[a-z]' and name !~* 'fixme' ;