address
9,324 rows where letter = "b"
This data as json, CSV (advanced)
Suggested facets: modified_at (date), street_modified_at (date)
| id ▼ | number | number_end | letter | modified_at | location_type | location_coordinates_0 | location_coordinates_1 | street_id | street_modified_at | street_municipality | street_name_fi | street_name_sv | postal_code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37 | 11 | b | 2018-08-07T16:12:37.282041+03:00 | Point | 24.9843234 | 60.2554433 | 6 | 2018-08-07T16:12:22.625591+03:00 | helsinki | Ahomäentie | Svedjebackavägen | 00780 | |
| 42 | 2 | b | 2018-08-07T16:12:26.142766+03:00 | Point | 24.9864727 | 60.2553628 | 6 | 2018-08-07T16:12:22.625591+03:00 | helsinki | Ahomäentie | Svedjebackavägen | 00780 | |
| 57 | 1 | b | 2018-08-07T16:12:26.143992+03:00 | Point | 25.1074058 | 60.216717 | 8 | 2018-08-07T16:12:22.628900+03:00 | helsinki | Ahvenkoskenpolku | Abborforsstigen | 00950 | |
| 66 | 3 | b | 2018-08-07T16:12:37.295587+03:00 | Point | 25.1068291 | 60.216879 | 8 | 2018-08-07T16:12:22.628900+03:00 | helsinki | Ahvenkoskenpolku | Abborforsstigen | 00950 | |
| 69 | 5 | b | 2018-08-07T16:12:26.144371+03:00 | Point | 25.1063786 | 60.217041 | 8 | 2018-08-07T16:12:22.628900+03:00 | helsinki | Ahvenkoskenpolku | Abborforsstigen | 00950 | |
| 107 | 7 | b | 2018-08-07T16:12:26.147161+03:00 | Point | 24.9746649 | 60.2270708 | 9 | 2018-08-07T16:12:22.631252+03:00 | helsinki | Aidasmäentie | Gärdobackavägen | 00650 | |
| 161 | 17 | b | 2018-08-07T16:12:37.458480+03:00 | Point | 25.0220537 | 60.2848455 | 17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen | 00750 | |
| 168 | 22 | b | 2018-08-07T16:12:26.152665+03:00 | Point | 25.0200291 | 60.2848997 | 17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen | 00750 | |
| 172 | 25 | b | 2018-08-07T16:12:26.152906+03:00 | Point | 25.0196679 | 60.2854023 | 17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen | 00750 | |
| 175 | 27 | b | 2018-08-07T16:12:26.153137+03:00 | Point | 25.0195595 | 60.2856267 | 17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen | 00750 | |
| 178 | 29 | b | 2018-08-07T16:12:37.326462+03:00 | Point | 25.018981 | 60.2854742 | 17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen | 00750 | |
| 204 | 5 | b | 2018-08-07T16:12:26.155217+03:00 | Point | 25.0215712 | 60.2659616 | 19 | 2018-08-07T16:12:22.652174+03:00 | helsinki | Aapontie | Aapovägen | 00730 | |
| 264 | 15 | b | 2018-08-07T16:12:37.342130+03:00 | Point | 24.9283522 | 60.1651594 | 26 | 2018-08-07T16:12:22.663577+03:00 | helsinki | Abrahaminkatu | Abrahamsgatan | 00180 | |
| 303 | 3 | b | 2018-08-07T16:12:37.885390+03:00 | Point | 25.1278918 | 60.2103892 | 31 | 2018-08-07T16:12:22.672512+03:00 | helsinki | Airoparinkuja | Årparsgränden | 00980 | |
| 312 | 12 | b | 2018-08-07T16:12:26.162506+03:00 | Point | 25.1303995 | 60.2105752 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 317 | 14 | b | 2018-08-07T16:12:47.162021+03:00 | Point | 25.1293003 | 60.2108096 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 319 | 16 | b | 2018-08-07T16:12:37.399191+03:00 | Point | 25.1288123 | 60.2105588 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 325 | 2 | b | 2018-08-07T16:12:26.163425+03:00 | Point | 25.1345125 | 60.2107775 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 329 | 3 | b | 2018-08-07T16:12:26.163555+03:00 | Point | 25.1322962 | 60.2113003 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 334 | 6 | b | 2018-08-07T16:12:47.162145+03:00 | Point | 25.1326732 | 60.2108512 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 337 | 8 | b | 2018-08-07T16:12:37.400733+03:00 | Point | 25.1304357 | 60.2106111 | 32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen | 00980 | |
| 360 | 5 | b | 2018-08-07T16:12:43.278499+03:00 | Point | 24.8457013 | 60.2339484 | 34 | 2018-08-07T16:12:22.678240+03:00 | helsinki | Aittatie | Bodvägen | 00390 | |
| 362 | 6 | b | 2018-08-07T16:12:26.164581+03:00 | Point | 24.8450874 | 60.2340105 | 34 | 2018-08-07T16:12:22.678240+03:00 | helsinki | Aittatie | Bodvägen | 00390 | |
| 389 | 2 | b | 2018-08-07T16:12:37.414628+03:00 | Point | 25.0542229 | 60.2148287 | 38 | 2018-08-07T16:12:22.682660+03:00 | helsinki | Ajopolku | Skallgången | 00800 | |
| 392 | 4 | b | 2018-08-07T16:12:37.414803+03:00 | Point | 25.0538087 | 60.2152686 | 38 | 2018-08-07T16:12:22.682660+03:00 | helsinki | Ajopolku | Skallgången | 00800 | |
| 395 | 6 | b | 2018-08-07T16:12:47.496579+03:00 | Point | 25.0532314 | 60.2151791 | 38 | 2018-08-07T16:12:22.682660+03:00 | helsinki | Ajopolku | Skallgången | 00800 | |
| 411 | 2 | b | 2018-08-07T16:12:37.415709+03:00 | Point | 25.0583415 | 60.2587613 | 40 | 2018-08-07T16:12:22.689326+03:00 | helsinki | Akkutie | Ackumulatorvägen | 00770 | |
| 467 | 14 | b | 2018-08-07T16:12:26.171931+03:00 | Point | 25.035831 | 60.2709128 | 49 | 2018-08-07T16:12:22.702217+03:00 | helsinki | Alankotie | Låglandsvägen | 00730 | |
| 477 | 22 | b | 2018-08-07T16:12:37.256331+03:00 | Point | 25.0385243 | 60.2717827 | 49 | 2018-08-07T16:12:22.702217+03:00 | helsinki | Alankotie | Låglandsvägen | 00750 | |
| 489 | 33 | b | 2018-08-07T16:12:26.187595+03:00 | Point | 25.0416316 | 60.2712253 | 49 | 2018-08-07T16:12:22.702217+03:00 | helsinki | Alankotie | Låglandsvägen | 00750 | |
| 505 | 8 | b | 2018-08-07T16:12:47.163800+03:00 | Point | 25.0352156 | 60.2699527 | 49 | 2018-08-07T16:12:22.702217+03:00 | helsinki | Alankotie | Låglandsvägen | 00730 | |
| 509 | 1 | b | 2018-08-07T16:12:37.444199+03:00 | Point | 24.9588178 | 60.1867673 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | |
| 519 | 5 | b | 2018-08-07T16:12:26.173504+03:00 | Point | 24.9570692 | 60.1870899 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | |
| 547 | 15 | b | 2018-08-07T16:12:37.261278+03:00 | Point | 24.9439685 | 60.2387742 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 564 | 3 | b | 2018-08-07T16:12:26.212430+03:00 | Point | 24.9467299 | 60.2390715 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 588 | 51 | b | 2018-08-07T16:12:37.269977+03:00 | Point | 24.9330314 | 60.2377729 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 595 | 56 | b | 2018-08-07T16:12:26.190983+03:00 | Point | 24.9273485 | 60.2363877 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 620 | 78 | b | 2018-08-07T16:12:26.177695+03:00 | Point | 24.9202918 | 60.2359887 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 628 | 85 | b | 2018-08-07T16:12:26.178278+03:00 | Point | 24.9213377 | 60.2364291 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 634 | 88 | b | 2018-08-07T16:12:37.460419+03:00 | Point | 24.9166111 | 60.23543 | 54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen | 00660 | |
| 687 | 31 | b | 2018-08-07T16:12:37.474272+03:00 | Point | 25.0673514 | 60.2571773 | 57 | 2018-08-07T16:12:22.724600+03:00 | helsinki | Alppikylänkatu | Alpbygatan | 00770 | |
| 690 | 33 | b | 2018-08-07T16:12:26.182327+03:00 | Point | 25.0671703 | 60.2569441 | 57 | 2018-08-07T16:12:22.724600+03:00 | helsinki | Alppikylänkatu | Alpbygatan | 00770 | |
| 733 | 8 | b | 2018-08-07T16:12:26.185627+03:00 | Point | 25.0414085 | 60.2805776 | 61 | 2018-08-07T16:12:22.741664+03:00 | helsinki | Alviontie | Alviovägen | 00750 | |
| 756 | 27 | b | 2018-08-07T16:12:37.269501+03:00 | Point | 24.933667 | 60.1643993 | 64 | 2018-08-07T16:12:22.756176+03:00 | helsinki | Albertinkatu | Albertsgatan | 00180 | |
| 761 | 30 | b | 2018-08-07T16:12:26.205238+03:00 | Point | 24.9345341 | 60.1630893 | 64 | 2018-08-07T16:12:22.756176+03:00 | helsinki | Albertinkatu | Albertsgatan | 00120 | |
| 825 | 1 | b | 2018-08-07T16:12:37.284680+03:00 | Point | 24.8875523 | 60.2087965 | 70 | 2018-08-07T16:12:22.770008+03:00 | helsinki | Ansaritie | Orangerivägen | 00350 | |
| 839 | 2 | b | 2018-08-07T16:12:26.196817+03:00 | Point | 24.980176 | 60.1849412 | 71 | 2018-08-07T16:12:22.771298+03:00 | helsinki | Antareksenkatu | Antaresgatan | 00540 | |
| 866 | 11 | b | 2018-08-07T16:12:37.299225+03:00 | Point | 24.925787 | 60.1765748 | 76 | 2018-08-07T16:12:22.777557+03:00 | helsinki | Apollonkatu | Apollogatan | 00100 | |
| 896 | 2 | b | 2018-08-07T16:12:37.362498+03:00 | Point | 25.036364 | 60.2790174 | 77 | 2018-08-07T16:12:22.779240+03:00 | helsinki | Arttolantie | Arttolavägen | 00750 | |
| 902 | 24 | b | 2018-08-07T16:12:26.264852+03:00 | Point | 25.031395 | 60.2803201 | 77 | 2018-08-07T16:12:22.779240+03:00 | helsinki | Arttolantie | Arttolavägen | 00750 | |
| 906 | 3 | b | 2018-08-07T16:12:37.299722+03:00 | Point | 25.0366356 | 60.2794392 | 77 | 2018-08-07T16:12:22.779240+03:00 | helsinki | Arttolantie | Arttolavägen | 00750 | |
| 911 | 5 | b | 2018-08-07T16:12:26.199563+03:00 | Point | 25.036871 | 60.279834 | 77 | 2018-08-07T16:12:22.779240+03:00 | helsinki | Arttolantie | Arttolavägen | 00750 | |
| 921 | 3 | b | 2018-08-07T16:12:37.300544+03:00 | Point | 24.8977296 | 60.218588 | 78 | 2018-08-07T16:12:22.780950+03:00 | helsinki | Artturi Kanniston tie | Artturi Kannistos väg | 00320 | |
| 1017 | 10 | b | 2018-08-07T16:12:37.288909+03:00 | Point | 24.9591574 | 60.1890831 | 89 | 2018-08-07T16:12:22.800683+03:00 | helsinki | Aleksis Kiven katu | Aleksis Kivis gata | 00500 | |
| 1019 | 11 | b | 2018-08-07T16:12:26.248166+03:00 | Point | 24.9514956 | 60.1901306 | 89 | 2018-08-07T16:12:22.800683+03:00 | helsinki | Aleksis Kiven katu | Aleksis Kivis gata | 00510 | |
| 1028 | 19 | b | 2018-08-07T16:12:47.886015+03:00 | Point | 24.9469145 | 60.191888 | 89 | 2018-08-07T16:12:22.800683+03:00 | helsinki | Aleksis Kiven katu | Aleksis Kivis gata | 00510 | |
| 1085 | 3 | b | 2018-08-07T16:12:26.209089+03:00 | Point | 24.9870837 | 60.2630188 | 91 | 2018-08-07T16:12:22.806323+03:00 | helsinki | Alhokuja | Lakaängsgränd | 00780 | |
| 1089 | 6 | b | 2018-08-07T16:12:37.343295+03:00 | Point | 24.9852954 | 60.2627763 | 91 | 2018-08-07T16:12:22.806323+03:00 | helsinki | Alhokuja | Lakaängsgränd | 00780 | |
| 1166 | 2 | b | 2020-01-30T13:00:10.046616+02:00 | Point | 25.1501121 | 60.2064795 | 102 | 2018-08-07T16:12:22.827758+03:00 | helsinki | Bertha Pauligin katu | Bertha Pauligs gata | 00990 | |
| 1285 | 1 | b | 2018-08-07T16:12:47.536397+03:00 | Point | 24.9446936 | 60.1834054 | 111 | 2018-08-07T16:12:22.842376+03:00 | helsinki | Castréninkatu | Castrénsgatan | 00530 | |
| 1311 | 10 | b | 2018-08-07T16:12:37.319562+03:00 | Point | 25.0362796 | 60.2680765 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1313 | 11 | b | 2018-08-07T16:12:26.255847+03:00 | Point | 25.0351777 | 60.2683102 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1316 | 13 | b | 2018-08-07T16:12:26.255964+03:00 | Point | 25.0347981 | 60.2681128 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1322 | 2 | b | 2018-08-07T16:12:37.320315+03:00 | Point | 25.0389895 | 60.2679411 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1327 | 6 | b | 2018-08-07T16:12:26.256689+03:00 | Point | 25.0380683 | 60.2681119 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1331 | 9 | b | 2018-08-07T16:12:37.418501+03:00 | Point | 25.0360992 | 60.2683279 | 112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen | 00730 | |
| 1386 | 10 | b | 2018-08-07T16:12:26.226312+03:00 | Point | 24.8834725 | 60.2505554 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1388 | 11 | b | 2018-08-07T16:12:47.514901+03:00 | Point | 24.8842308 | 60.2506009 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1391 | 13 | b | 2018-08-07T16:12:37.432813+03:00 | Point | 24.8844103 | 60.2509063 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1394 | 16 | b | 2018-08-07T16:12:37.271692+03:00 | Point | 24.8824942 | 60.2514431 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1399 | 2 | b | 2018-08-07T16:12:26.242221+03:00 | Point | 24.8824832 | 60.2494954 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1403 | 23 | b | 2018-08-07T16:12:47.831786+03:00 | Point | 24.8820057 | 60.2517119 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1407 | 4 | b | 2018-08-07T16:12:37.272819+03:00 | Point | 24.8821748 | 60.2498721 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1410 | 6 | b | 2018-08-07T16:12:37.273219+03:00 | Point | 24.8828601 | 60.250142 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1413 | 8 | b | 2018-08-07T16:12:26.242984+03:00 | Point | 24.8825884 | 60.2503751 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1415 | 9 | b | 2018-08-07T16:12:26.243098+03:00 | Point | 24.8845209 | 60.2502781 | 117 | 2018-08-07T16:12:22.851632+03:00 | helsinki | Arhipanpolku | Arhippastigen | 00420 | |
| 1469 | 36 | b | 2018-08-07T16:12:26.231975+03:00 | Point | 24.948537 | 60.16875 | 126 | 2018-08-07T16:12:22.863083+03:00 | helsinki | Aleksanterinkatu | Alexandersgatan | 00100 | |
| 1509 | 6 | b | 2018-08-07T16:12:47.515253+03:00 | Point | 24.9775654 | 60.2076127 | 129 | 2018-08-07T16:12:22.872723+03:00 | helsinki | Arabiankatu | Arabiagatan | 00560 | |
| 1541 | 1 | b | 2018-08-07T16:12:37.259044+03:00 | Point | 24.9541034 | 60.258811 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1546 | 13 | b | 2018-08-07T16:12:37.258312+03:00 | Point | 24.9569558 | 60.259898 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1553 | 19 | b | 2018-08-07T16:12:37.258926+03:00 | Point | 24.9579305 | 60.2604997 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1557 | 21 | b | 2019-03-12T16:53:17.364783+02:00 | Point | 24.9582554 | 60.2606882 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1560 | 23 | b | 2018-08-07T16:12:37.259274+03:00 | Point | 24.9587612 | 60.2606166 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1563 | 25 | b | 2018-08-07T16:12:26.239778+03:00 | Point | 24.9590859 | 60.2609757 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1574 | 7 | b | 2018-08-07T16:12:26.240564+03:00 | Point | 24.9547711 | 60.2592869 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1576 | 8 | b | 2018-08-07T16:12:26.240692+03:00 | Point | 24.9572074 | 60.2609213 | 135 | 2018-08-07T16:12:22.882867+03:00 | helsinki | Asessorintie | Assessorsvägen | 00690 | |
| 1593 | 15 | b | 2018-08-07T16:12:38.434494+03:00 | Point | 25.0888479 | 60.2183732 | 137 | 2018-08-07T16:12:22.892811+03:00 | helsinki | Arhotie | Sandarvsvägen | 00900 | |
| 1598 | 18 | b | 2018-08-07T16:12:37.274328+03:00 | Point | 25.0878917 | 60.2183828 | 137 | 2018-08-07T16:12:22.892811+03:00 | helsinki | Arhotie | Sandarvsvägen | 00900 | |
| 1611 | 9 | b | 2018-08-07T16:12:26.244653+03:00 | Point | 25.0895852 | 60.2175201 | 137 | 2018-08-07T16:12:22.892811+03:00 | helsinki | Arhotie | Sandarvsvägen | 00900 | |
| 1650 | 4 | b | 2018-08-07T16:12:26.246349+03:00 | Point | 25.0420721 | 60.2766014 | 141 | 2018-08-07T16:12:22.899814+03:00 | helsinki | Aurapolku | Plogstigen | 00750 | |
| 1668 | 10 | b | 2018-08-07T16:12:26.247502+03:00 | Point | 25.1501465 | 60.2021623 | 143 | 2018-08-07T16:12:22.903235+03:00 | helsinki | Aurinkolahden puistotie | Solviksallén | 00990 | |
| 1686 | 13 | b | 2019-03-12T16:53:17.365694+02:00 | Point | 25.0124331 | 60.1798441 | 147 | 2018-08-07T16:12:22.914322+03:00 | helsinki | Armas Lindgrenin tie | Armas Lindgrens väg | 00570 | |
| 1723 | 3 | b | 2018-08-07T16:12:37.319131+03:00 | Point | 25.0384847 | 60.2688388 | 150 | 2018-08-07T16:12:22.921304+03:00 | helsinki | Aurinkomäenkuja | Solbackagränden | 00730 | |
| 1726 | 5 | b | 2018-08-07T16:12:37.319251+03:00 | Point | 25.0383767 | 60.269153 | 150 | 2018-08-07T16:12:22.921304+03:00 | helsinki | Aurinkomäenkuja | Solbackagränden | 00730 | |
| 1863 | 2 | b | 2018-08-07T16:12:37.363438+03:00 | Point | 24.8645526 | 60.2231806 | 166 | 2018-08-07T16:12:22.949374+03:00 | helsinki | Atomitie | Atomvägen | 00370 | |
| 1873 | 1 | b | 2018-08-07T16:12:26.266989+03:00 | Point | 25.0333757 | 60.2551977 | 167 | 2018-08-07T16:12:22.950858+03:00 | helsinki | Auertie | Solröksvägen | 00700 | |
| 1878 | 2 | b | 2018-08-07T16:12:37.364398+03:00 | Point | 25.03408 | 60.2552245 | 167 | 2018-08-07T16:12:22.950858+03:00 | helsinki | Auertie | Solröksvägen | 00700 | |
| 1883 | 6 | b | 2018-08-07T16:12:26.267487+03:00 | Point | 25.0338263 | 60.2543898 | 167 | 2018-08-07T16:12:22.950858+03:00 | helsinki | Auertie | Solröksvägen | 00700 | |
| 1967 | 11 | b | 2018-08-07T16:12:43.314837+03:00 | Point | 24.8444656 | 60.2242894 | 175 | 2018-08-07T16:12:22.959826+03:00 | helsinki | Eljaksentie | Eliasvägen | 00370 | |
| 1970 | 12 | b | 2018-08-07T16:12:26.269468+03:00 | Point | 24.8451926 | 60.2231863 | 175 | 2018-08-07T16:12:22.959826+03:00 | helsinki | Eljaksentie | Eliasvägen | 00370 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [address] ( [id] INTEGER PRIMARY KEY, [number] TEXT, [number_end] TEXT, [letter] TEXT, [modified_at] TEXT, [location_type] TEXT, [location_coordinates_0] FLOAT, [location_coordinates_1] FLOAT, [street_id] INTEGER, [street_modified_at] TEXT, [street_municipality] TEXT, [street_name_fi] TEXT, [street_name_sv] TEXT, [postal_code] TEXT );