Barcelona, Catalonia
Data license: © OpenStreetMap contributors — ODbL 1.0
41,457 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | House number | Street name | Postal code | Latitude | Longitude |
|---|---|---|---|---|---|---|
| 1 | 1 | 159-169 | Passeig de la Vall d'Hebron | 8035 | 41.4351531 | 2.1467316 |
| 2 | 2 | 24 | Carrer de Ramón y Cajal | 8012 | 41.4025115 | 2.1585725 |
| 3 | 3 | 7 | Carrer de Verdi | 8012 | 41.4031147 | 2.157597 |
| 4 | 4 | 54 | Carrer d'Astúries | 8012 | 41.4039465 | 2.1553363 |
| 5 | 5 | 32 | Carrer de Verdi | 8012 | 41.4040146 | 2.1568811 |
| 6 | 6 | 49 | Carrer de Torrijos | 8012 | 41.4043891 | 2.1576461 |
| 7 | 7 | 75 | carrer Nou de Les Rambles | 8001 | 41.3764247 | 2.1715874 |
| 8 | 8 | 28 | carrer Nou de Les Rambles | 8001 | 41.3782412 | 2.1732928 |
| 9 | 9 | 98 | La Rambla | 8002 | 41.3822988 | 2.1725153 |
| 10 | 10 | 3 | ronda Sant Pau | 8015 | 41.3753821 | 2.1671991 |
| 11 | 11 | 35 | carrer Carretes | 8001 | 41.3774283 | 2.1674957 |
| 12 | 12 | 5-7 | Carrer del Poeta Cabanyes | 8004 | 41.3747759 | 2.1661966 |
| 13 | 13 | 26 | La Rambla | 8002 | 41.3782716 | 2.1761732 |
| 14 | 14 | 5 | Plaça dels Traginers | 8002 | 41.3822765 | 2.1798415 |
| 15 | 15 | 190-198 | Carretera de Sant Cugat | 8035 | 41.430306 | 2.128889 |
| 16 | 16 | 272 | Carrer d'Aragó | 8007 | 41.3915276 | 2.1643195 |
| 17 | 17 | 223 | Carrer de Muntaner | 8036 | 41.3937636 | 2.1497797 |
| 18 | 18 | 3 | Plaça de Francesc Macià | 8021 | 41.3933021 | 2.1445936 |
| 19 | 19 | 5 | Carrer de Ganduxer | 8021 | 41.3919314 | 2.1379764 |
| 20 | 20 | 51 | Carrer de l'Argenteria | 8003 | 41.3836716 | 2.1806392 |
| 21 | 21 | 25 | Carrer del Capità Arenas | 8034 | 41.3910021 | 2.1256514 |
| 22 | 22 | 56 | Passeig de Manuel Girona | 8034 | 41.3912953 | 2.1253205 |
| 23 | 23 | 28 | Passeig de Manuel Girona | 8034 | 41.3906341 | 2.1226099 |
| 24 | 24 | 4 | carrer dels Paletes | 8034 | 41.3990752 | 2.1216692 |
| 25 | 25 | 686 | Avinguda Diagonal | 8034 | 41.3865043 | 2.1183962 |
| 26 | 26 | 252 | Avinguda de Vallcarca | 8023 | 41.4197988 | 2.1408569 |
| 27 | 27 | 188 | Avinguda de Vallcarca | 8023 | 41.4154874 | 2.142485 |
| 28 | 28 | 2 | Carrer del Paradís | 8002 | 41.3830692 | 2.1770246 |
| 29 | 29 | 14 | Carrer del Paradís | 8002 | 41.3835193 | 2.1770013 |
| 30 | 30 | 428 | Avinguda Meridiana | 8030 | 41.4330796 | 2.1836133 |
| 31 | 31 | 1-15 | Carrer de Dublín | 8027 | 41.4285321 | 2.1871298 |
| 32 | 32 | 58 | carrer Les Torres | 8042 | 41.4469028 | 2.1751995 |
| 33 | 33 | 7 | Carrer de Craywinckel | 8022 | 41.4120106 | 2.1395126 |
| 34 | 34 | 102 | Carrer de l'Atlàntic | 8040 | 41.3260955 | 2.1420204 |
| 35 | 35 | 8 | Carrer de Sant Francesc Xavier | 8016 | 41.4416041 | 2.1780626 |
| 36 | 36 | 9 | Passeig Andreu Nin | 8016 | 41.4354066 | 2.181653 |
| 37 | 37 | 266 | Passeig de Fabra i Puig | 8031 | 41.4304493 | 2.1743213 |
| 38 | 38 | 760 | Gran Via de les Corts Catalanes | 8013 | 41.3979941 | 2.1800431 |
| 39 | 39 | 87 | carrer Roger De Flor | 8013 | 41.3942532 | 2.1784533 |
| 40 | 40 | 69 | carrer de la Marina | 8005 | 41.3923144 | 2.189737 |
| 41 | 41 | 5 | Carrer de Cervantes | 8002 | 41.381257 | 2.1773769 |
| 42 | 42 | 20 | Carrer de Tirso de Molina | 8028 | 41.376111 | 2.1314448 |
| 43 | 43 | 18 | Carrer del Roser | 8004 | 41.373761 | 2.1668348 |
| 44 | 44 | 71-73 | Avinguda del Paral·lel | 8004 | 41.3747586 | 2.1683146 |
| 45 | 45 | 54 | Carrer de Tordera | 8012 | 41.4019328 | 2.162054 |
| 46 | 46 | 529 | Carrer de Muntaner | 8022 | 41.4041568 | 2.1362017 |
| 47 | 47 | 32 | Rambla de Fabra i Puig | 8030 | 41.4303043 | 2.188017 |
| 48 | 48 | 468 | Carrer de Mallorca | 8013 | 41.4057761 | 2.1786434 |
| 49 | 49 | 111 | Carrer de París | 8029 | 41.3895915 | 2.1476885 |
| 50 | 50 | 8 | Avenida Gaudí | 8025 | 41.4051547 | 2.1745971 |
| 51 | 51 | 27,29 | Avinguda Gaudí | 8025 | 41.406511 | 2.1742446 |
| 52 | 52 | 2 | Avinguda de Gaudí | 8025 | 41.4047602 | 2.1746628 |
| 53 | 53 | 3 | Avenida Gaudí | 8025 | 41.4050316 | 2.1742781 |
| 54 | 54 | 178 | Carrer de Bac de Roda | 8020 | 41.4127914 | 2.1974089 |
| 55 | 55 | 58 | Carrer d'Andrade | 8018 | 41.4124433 | 2.1967739 |
| 56 | 56 | 168 | carrer Bac de Roda | 8020 | 41.4114535 | 2.1990606 |
| 57 | 57 | 1-4 | Plaça de la Clota | 8035 | 41.4260483 | 2.1494277 |
| 58 | 58 | 59 | Carrer de Ferran | 8002 | 41.3823086 | 2.1765833 |
| 59 | 59 | 20 | Carrer de la Dagueria | 8002 | 41.3830486 | 2.178292 |
| 60 | 60 | 1 | carrer Alcantara | 8042 | 41.4451469 | 2.1719165 |
| 61 | 61 | 14-16 | Carrer d'Alcántara | 8042 | 41.4457676 | 2.1725927 |
| 62 | 62 | 142-144 | Carrer de la Llacuna | 8018 | 41.40537 | 2.1934837 |
| 63 | 63 | 117 | Rambla del Poblenou | 8018 | 41.4035018 | 2.1977649 |
| 64 | 64 | 95 | la Rambla | 8002 | 41.3822966 | 2.1719827 |
| 65 | 65 | 546 | Gran Via de les Corts Catalanes | 8011 | 41.3815258 | 2.1726713 |
| 66 | 66 | 67 | La Rambla | 8002 | 41.3809714 | 2.173182 |
| 67 | 67 | 69 | La Rambla | 8002 | 41.381036 | 2.1731293 |
| 68 | 68 | 69 | La Rambla | 8002 | 41.3810752 | 2.1730901 |
| 69 | 69 | 4 | Carrer dels Banys Nous | 8002 | 41.3820651 | 2.1753232 |
| 70 | 70 | 1 | Carrer d'Avinyó | 8002 | 41.3818432 | 2.1755817 |
| 71 | 71 | 119 | La Rambla | 8002 | 41.3843881 | 2.170482 |
| 72 | 72 | 15 | Carrer d'en Xuclà | 8001 | 41.3833679 | 2.1700135 |
| 73 | 73 | 25 | Carrer d'en Xuclà | 8001 | 41.3836497 | 2.1694288 |
| 74 | 74 | 21 | carrer Xucla | 8001 | 41.3835968 | 2.1696695 |
| 75 | 75 | 731 | Gran Via de les Corts Catalanes | 8013 | 41.398628 | 2.1800918 |
| 76 | 76 | 189 | Carrer Mariners | 8013 | 41.4000479 | 2.1793749 |
| 77 | 77 | 173 | Carrer de Padilla | 8013 | 41.4011223 | 2.1829564 |
| 78 | 78 | 240 4t | Avinguda Diagonal | 8018 | 41.4045469 | 2.1908792 |
| 79 | 79 | 208 | Avinguda Diagonal | 8018 | 41.4053714 | 2.1928801 |
| 80 | 80 | 150 | Carrer de Lepant | 8013 | 41.3988917 | 2.1855755 |
| 81 | 81 | 166 | calle Sicília | 8013 | 41.3959308 | 2.1813837 |
| 82 | 82 | 103 | Carrer de Casp | 8013 | 41.3960634 | 2.1794666 |
| 83 | 83 | 75 | C Alí Bei | 8013 | 41.3950111 | 2.1824289 |
| 84 | 84 | 3 | Carrer de Santa Teresa | 8012 | 41.3978819 | 2.1598488 |
| 85 | 85 | 114 | Passeig de Gràcia | 8008 | 41.3970814 | 2.1592969 |
| 86 | 86 | 265 | Carrer del Rosselló | 8008 | 41.3962081 | 2.1609608 |
| 87 | 87 | 83 | Passeig de Gràcia | 8008 | 41.3942863 | 2.16178 |
| 88 | 88 | 1 | Moll de Barcelona | 8039 | 41.3717119 | 2.1808851 |
| 89 | 89 | 4 | Pl Mar | 8003 | 41.3752504 | 2.1895807 |
| 90 | 90 | 1 | Plaça del Mar | 8003 | 41.3753402 | 2.1894951 |
| 91 | 91 | 1-4 | Plaça del Mar | 8003 | 41.3753694 | 2.1896344 |
| 92 | 92 | 72 | Passeig de Joan de Borbó | 8003 | 41.3756728 | 2.1893469 |
| 93 | 93 | 10 | Carrer de Provençals | 8019 | 41.4051323 | 2.2118586 |
| 94 | 94 | 41 | Carrer de la Canuda | 8002 | 41.3849468 | 2.1730368 |
| 95 | 95 | 6 | Carrer de la Canuda | 8002 | 41.3846579 | 2.1716453 |
| 96 | 96 | 121 | La Rambla | 8002 | 41.3845322 | 2.170421 |
| 97 | 97 | 125 | La Rambla | 8002 | 41.384831 | 2.1701595 |
| 98 | 98 | 29 | Pol. Ind. Zona Franca Sector C, Calle D | 8040 | 41.3283461 | 2.1275365 |
| 99 | 99 | 21-22 | Plaça Catalunya | 8002 | 41.3859551 | 2.1707466 |
| 100 | 100 | 17 | Plaça Catalunya | 8002 | 41.3865873 | 2.1714197 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Barcelona, Catalonia" ( "House number" TEXT, "Street name" TEXT, "Postal code" INTEGER, "Latitude" REAL, "Longitude" REAL );