Essen, North Rhine-Westphalia
101,339 rows
This data as json, CSV (advanced)
Link | rowid ▼ | House number | Street name | Postal code | Latitude | Longitude |
---|---|---|---|---|---|---|
1 | 1 | 281 | Steeler Straße | 45138 | 51.4472216 | 7.0458433 |
2 | 2 | 371 | Steeler Straße | 45138 | 51.4459132 | 7.0531808 |
3 | 3 | 487-489 | Steeler Straße | 45276 | 51.4464253 | 7.0619890 |
4 | 4 | 55 | Grenoblestraße | 45276 | 51.4464371 | 7.0829241 |
5 | 5 | 166 | Dahlhauser Straße | 45279 | 51.4369036 | 7.1035385 |
6 | 6 | 1 | Von-Ossietzky-Ring | 45279 | 51.4369868 | 7.1078578 |
7 | 7 | 150 | Ruhrallee | 45136 | 51.4370971 | 7.0430603 |
8 | 8 | 288 | Altenessener Straße | 45326 | 51.4923178 | 7.0100591 |
9 | 9 | 87 | Berliner Straße | 45145 | 51.4480640 | 6.9733752 |
10 | 10 | 91 | Berliner Straße | 45145 | 51.4481572 | 6.9733843 |
11 | 11 | 91 | Berliner Straße | 45145 | 51.4481349 | 6.9733859 |
12 | 12 | 94 | Mülheimer Straße | 45145 | 51.4446781 | 6.9717058 |
13 | 13 | 91 | Mülheimer Straße | 45145 | 51.4446064 | 6.9720954 |
14 | 14 | 87 | Mülheimer Straße | 45145 | 51.4447013 | 6.9723625 |
15 | 15 | 39 | Weg am Berge | 45279 | 51.4395383 | 7.1197669 |
16 | 16 | 8 | Schederhofstraße | 45145 | 51.4493369 | 6.9996006 |
17 | 17 | 36 | Kämpenstraße | 45147 | 51.4422920 | 6.9760859 |
18 | 18 | 60 | Wickenburgstraße | 45147 | 51.4387229 | 6.9653479 |
19 | 19 | 120 | Mülheimer Straße | 45145 | 51.4439537 | 6.9701986 |
20 | 20 | 2 | Dresdener Straße | 45145 | 51.4448012 | 6.9721440 |
21 | 21 | 13-19 | Moltkestraße | 45128 | 51.4433563 | 7.0194415 |
22 | 22 | 104a | Alte Hauptstraße | 45289 | 51.4150817 | 7.1082964 |
23 | 23 | 385 | Überruhrstraße | 45277 | 51.4206972 | 7.0916185 |
24 | 24 | 335 | Überruhrstraße | 45277 | 51.4216176 | 7.0891259 |
25 | 25 | 14A | Lehnsgrund | 45149 | 51.4324055 | 6.9710605 |
26 | 26 | 74 | Am Mühlenbach | 45147 | 51.4364419 | 6.9771480 |
27 | 27 | 15 | Heisinger Straße | 45134 | 51.4188524 | 7.0250905 |
28 | 28 | 81 | Schwarzensteinweg | 45289 | 51.4172741 | 7.1264208 |
29 | 29 | 1 | Hügel | 45133 | 51.4069043 | 7.0089364 |
30 | 30 | 67 | Kirchstraße | 45289 | 51.4109347 | 7.1100560 |
31 | 31 | 69a | Kirchstraße | 45289 | 51.4101484 | 7.1096885 |
32 | 32 | 1 | Prinz-Friedrich-Platz | 45257 | 51.3933769 | 7.0787609 |
33 | 33 | 1 | Langenberger Straße | 45277 | 51.4425665 | 7.0781844 |
34 | 34 | 8 | Weigelwerkstraße | 45326 | 51.4844294 | 6.9962221 |
35 | 35 | 40 | Frankenstraße | 45134 | 51.4285084 | 7.0529139 |
36 | 36 | 36 | Kettwiger Straße | 45127 | 51.4548502 | 7.0130103 |
37 | 37 | 242 | Bochumer Landstraße | 45276 | 51.4501245 | 7.0972498 |
38 | 38 | 23 | Hufergasse | 45239 | 51.3890107 | 7.0014109 |
39 | 39 | 36-38 | Grafenstraße | 45239 | 51.3889244 | 7.0010742 |
40 | 40 | 5 | Körholzstraße | 45239 | 51.3891608 | 7.0008184 |
41 | 41 | 184 | Schmachtenbergstraße | 45219 | 51.3803155 | 6.9521270 |
42 | 42 | 54 | Hauptstraße | 45219 | 51.3626487 | 6.9405755 |
43 | 43 | 14 | Kringsgat | 45219 | 51.3633446 | 6.9400065 |
44 | 44 | 69 | Ruhrstraße | 45219 | 51.3624345 | 6.9371259 |
45 | 45 | 7 | Kirchtreppe | 45219 | 51.3627389 | 6.9370893 |
46 | 46 | 142 | Heidhauser Straße | 45239 | 51.3819137 | 7.0217942 |
47 | 47 | 4 | Werdener Straße | 45219 | 51.3581182 | 6.9327379 |
48 | 48 | 2 | Zur Alten Fähre | 45219 | 51.3587950 | 6.9346010 |
49 | 49 | 263 | Frankenstraße | 45134 | 51.4207742 | 7.0257641 |
50 | 50 | 10 | Lerchenstraße | 45134 | 51.4183659 | 7.0241471 |
51 | 51 | 90 | Wilhelm-Bernsau-Weg | 45239 | 51.3914816 | 6.9937989 |
52 | 52 | 38 | Schwarze-Lenen-Weg | 45134 | 51.4094471 | 7.0334691 |
53 | 53 | 26 | Werdener Straße | 45219 | 51.3585189 | 6.9343817 |
54 | 54 | 345 | Ruhrtalstraße | 45219 | 51.3635800 | 6.9537152 |
55 | 55 | 41 | Kruppstraße | 45128 | 51.4474601 | 7.0040381 |
56 | 56 | 44 | Schultenweg | 45279 | 51.4433016 | 7.1058014 |
57 | 57 | 201 | Westfalenstraße | 45276 | 51.4428755 | 7.0671356 |
58 | 58 | 103 | Dahlhauser Straße | 45279 | 51.4401167 | 7.0941645 |
59 | 59 | 33 | Philosophenweg | 45279 | 51.4462652 | 7.1080215 |
60 | 60 | 183 | Rüttenscheider Straße | 45131 | 51.4322878 | 7.0041608 |
61 | 61 | 179 | Dahlhauser Straße | 45279 | 51.4373801 | 7.1064671 |
62 | 62 | 1 | Museumsplatz | 45128 | 51.4425294 | 7.0047432 |
63 | 63 | 32 | Heiligenhauser Straße | 45219 | 51.3533790 | 6.9315586 |
64 | 64 | 117 | Mendener Straße | 45219 | 51.3780723 | 6.9151213 |
65 | 65 | 230 | Laupendahler Landstraße | 45239 | 51.3763400 | 6.9784322 |
66 | 66 | 274 | Frohnhauser Straße | 45144 | 51.4496763 | 6.9720861 |
67 | 67 | 1 | Krefelder Straße | 45145 | 51.4491792 | 6.9733137 |
68 | 68 | 12 | Tangabucht | 45357 | 51.4804360 | 6.9394765 |
69 | 69 | 36 | Veronikastraße | 45131 | 51.4310585 | 7.0126821 |
70 | 70 | 218 | Krayer Straße | 45307 | 51.4653542 | 7.0805932 |
71 | 71 | 11 | Korumhöhe | 45307 | 51.4650961 | 7.0962242 |
72 | 72 | 170 | Krayer Straße | 45307 | 51.4612578 | 7.0791828 |
73 | 73 | 57-59 | Korthover Weg | 45307 | 51.4671888 | 7.0881700 |
74 | 74 | 45 | Zur Alten Fähre | 45219 | 51.3613100 | 6.9342487 |
75 | 75 | 56 | Hauptstraße | 45219 | 51.3626912 | 6.9402460 |
76 | 76 | 34 | Rotthauser Straße | 45309 | 51.4730831 | 7.0839528 |
77 | 77 | 44 | Rotthauser Straße | 45309 | 51.4735532 | 7.0832158 |
78 | 78 | 40 | Rotthauser Straße | 45309 | 51.4736912 | 7.0838033 |
79 | 79 | 97 | Rüttenscheider Straße | 45130 | 51.4372345 | 7.0055931 |
80 | 80 | 17 | Munscheidstraße | 45307 | 51.4678150 | 7.0929592 |
81 | 81 | 77 | Klarastraße | 45130 | 51.4396793 | 7.0127933 |
82 | 82 | 74 | Klarastraße | 45130 | 51.4393694 | 7.0127973 |
83 | 83 | 3 | Rechtstraße | 45355 | 51.4740261 | 6.9513806 |
84 | 84 | 23 | Marktstraße | 45355 | 51.4741042 | 6.9506810 |
85 | 85 | 38 - 52 | Viehofer Straße | 45127 | 51.4596253 | 7.0142666 |
86 | 86 | 27 | III. Hagen | 45127 | 51.4552164 | 7.0093541 |
87 | 87 | 10 | Opernplatz | 45128 | 51.4468571 | 7.0126652 |
88 | 88 | 53 | Huyssenallee | 45128 | 51.4458378 | 7.0105753 |
89 | 89 | 101 | Schloßstraße | 45355 | 51.4683469 | 6.9420920 |
90 | 90 | 419 | Frohnhauser Straße | 45144 | 51.4480006 | 6.9583960 |
91 | 91 | 362 | Frohnhauser Straße | 45144 | 51.4485418 | 6.9635302 |
92 | 92 | 384 | Frohnhauser Straße | 45144 | 51.4483910 | 6.9618195 |
93 | 93 | 12 | Steinstraße | 45128 | 51.4462078 | 7.0158468 |
94 | 94 | 67 | Flurstraße | 45355 | 51.4746692 | 6.9414682 |
95 | 95 | 462 | Frintroper Straße | 45359 | 51.4765880 | 6.9110402 |
96 | 96 | 253 | Germaniastraße | 45355 | 51.4738961 | 6.9529614 |
97 | 97 | 6 | Germaniaplatz | 45355 | 51.4744287 | 6.9522065 |
98 | 98 | 6 | Rudolf-Heinrich-Straße | 45355 | 51.4742050 | 6.9524445 |
99 | 99 | 7 | Germaniaplatz | 45355 | 51.4745578 | 6.9518002 |
100 | 100 | 8 | Germaniaplatz | 45355 | 51.4745757 | 6.9513901 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Essen, North Rhine-Westphalia] ( [House number] TEXT, [Street name] TEXT, [Postal code] TEXT, [Latitude] TEXT, [Longitude] TEXT );