address
126,220 rows sorted by street_municipality
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41654 | 35 | 2018-08-07T16:13:09.782270+03:00 | Point | 24.5864106 | 60.1939105 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41655 | 37 | 2018-08-07T16:13:15.049140+03:00 | Point | 24.5861395 | 60.1939635 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41656 | 4 | 2018-08-07T16:12:37.643779+03:00 | Point | 24.5889773 | 60.1919169 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41657 | 5 | 2018-08-07T16:13:14.282865+03:00 | Point | 24.5894426 | 60.1921876 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41658 | 6 | 2020-08-24T15:49:29.789682+03:00 | Point | 24.5872733 | 60.1926835 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41659 | 7 | 2018-08-07T16:13:19.979996+03:00 | Point | 24.5890992 | 60.1922584 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41660 | 8 | 2018-08-07T16:13:15.050564+03:00 | Point | 24.5871218 | 60.1932575 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41661 | 9 | 2018-08-07T16:13:25.156351+03:00 | Point | 24.5888273 | 60.1923832 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
| 41991 | 1 | 2018-08-07T16:13:14.162258+03:00 | Point | 24.809072 | 60.2384961 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41992 | 2 | 2018-08-07T16:13:19.639232+03:00 | Point | 24.8092154 | 60.2386669 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41993 | 3 | 2018-08-07T16:13:24.340545+03:00 | Point | 24.8092888 | 60.2384516 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41994 | 4 | 2018-08-07T16:12:37.673785+03:00 | Point | 24.809468 | 60.2386762 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41995 | 5 | 2018-08-07T16:13:14.164246+03:00 | Point | 24.8098304 | 60.2384523 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41996 | 6 | 2018-08-07T16:13:25.200511+03:00 | Point | 24.8098472 | 60.2386678 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 41997 | 7 | 2018-08-07T16:13:15.189970+03:00 | Point | 24.810263 | 60.2385517 | 3751 | 2018-08-07T16:12:35.607264+03:00 | espoo | Siipi | Vingen | 02660 | ||
| 42168 | 1 | 2018-08-07T16:12:37.702733+03:00 | Point | 24.8263381 | 60.2401893 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42169 | 10 | 2018-08-07T16:13:24.657899+03:00 | Point | 24.8255053 | 60.240628 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42170 | 12 | 2020-08-24T15:49:40.132905+03:00 | Point | 24.8255216 | 60.2409601 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42171 | 3 | 2020-08-24T15:49:43.479052+03:00 | Point | 24.8259759 | 60.2404042 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42172 | 4 | 2018-08-07T16:13:24.312420+03:00 | Point | 24.8257071 | 60.2400269 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42173 | 5 | 2020-08-24T15:49:41.944522+03:00 | Point | 24.8260106 | 60.2406735 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42174 | 6 | 2018-08-07T16:13:19.841087+03:00 | Point | 24.8252552 | 60.240134 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42175 | 7 | 2020-08-24T15:49:45.450183+03:00 | Point | 24.8260279 | 60.2408082 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42176 | 8 | 2018-08-07T16:13:19.679028+03:00 | Point | 24.8254709 | 60.2403138 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 42177 | 9 | 2020-08-24T15:49:44.589415+03:00 | Point | 24.8260088 | 60.2409966 | 3779 | 2018-08-07T16:12:35.673772+03:00 | espoo | Piikivi | Flintan | 02680 | ||
| 82814 | 100 | 2018-08-07T16:13:15.268938+03:00 | Point | 24.80921 | 60.1277483 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82815 | 128 | 2018-08-07T16:13:09.577267+03:00 | Point | 24.8087494 | 60.1296235 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82816 | 134 | 2018-08-07T16:13:15.178195+03:00 | Point | 24.8092137 | 60.1302166 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82817 | 142 | 2018-08-07T16:13:15.178309+03:00 | Point | 24.8092468 | 60.1307282 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82818 | 150 | 2018-08-07T16:13:15.178080+03:00 | Point | 24.8099476 | 60.1308818 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82819 | 154 | 2018-08-07T16:13:24.653760+03:00 | Point | 24.8107547 | 60.1313228 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82820 | 164 | 2018-08-07T16:13:24.424525+03:00 | Point | 24.8117225 | 60.1319883 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82821 | 170 | 2018-08-07T16:13:24.926355+03:00 | Point | 24.8132328 | 60.1321879 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82822 | 20 | 2018-08-07T16:13:09.553097+03:00 | Point | 24.8155569 | 60.1316527 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82823 | 36 | 2018-08-07T16:13:20.124043+03:00 | Point | 24.8141762 | 60.130807 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82824 | 40 | 2018-08-07T16:13:09.582515+03:00 | Point | 24.8134773 | 60.1303124 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82825 | 46 | 2018-08-07T16:13:15.172997+03:00 | Point | 24.8152606 | 60.1299379 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82826 | 54 | 2018-08-07T16:13:19.598698+03:00 | Point | 24.8129754 | 60.1299796 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82827 | 66 | 2018-08-07T16:13:20.003598+03:00 | Point | 24.812818 | 60.1291806 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82828 | 72 | 2018-08-07T16:13:09.577388+03:00 | Point | 24.8109849 | 60.1288369 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82829 | 78 | 2018-08-07T16:13:19.043656+03:00 | Point | 24.8113819 | 60.1286131 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82830 | 8 | 2018-08-07T16:13:25.284321+03:00 | Point | 24.8145236 | 60.1330155 | 7241 | 2018-08-07T16:13:07.208295+03:00 | espoo | Stora Ådholmen | Stora Ådholmen | 02160 | ||
| 82831 | 10 | 2018-08-07T16:13:24.226325+03:00 | Point | 24.6632431 | 60.1374115 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82832 | 11 | 2018-08-07T16:13:24.351473+03:00 | Point | 24.663293 | 60.1325289 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82833 | 12 | 2018-08-07T16:13:20.122619+03:00 | Point | 24.6633349 | 60.1372322 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82834 | 13 | 2018-08-07T16:13:15.176411+03:00 | Point | 24.6633329 | 60.1321431 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82835 | 14 | 2018-08-07T16:13:15.276157+03:00 | Point | 24.6630353 | 60.1366121 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82836 | 15 | 2018-08-07T16:13:15.176184+03:00 | Point | 24.6635029 | 60.1313536 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82837 | 16 | 2018-08-07T16:13:24.457893+03:00 | Point | 24.6628424 | 60.136118 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82838 | 17 | a | 2018-08-07T16:13:24.698450+03:00 | Point | 24.6636346 | 60.1307975 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82839 | 17 | b | 2018-08-07T16:13:24.129269+03:00 | Point | 24.6638172 | 60.1305287 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82840 | 18 | 2018-08-07T16:13:19.047833+03:00 | Point | 24.6629718 | 60.1357862 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82841 | 19 | 2018-08-07T16:13:19.898756+03:00 | Point | 24.6647416 | 60.1298668 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82842 | 2 | 2018-08-07T16:13:19.012094+03:00 | Point | 24.6599888 | 60.1388662 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82843 | 20 | 2018-08-07T16:13:25.013432+03:00 | Point | 24.6626366 | 60.1351302 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82844 | 22 | 2018-08-07T16:13:25.286042+03:00 | Point | 24.662982 | 60.13479 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82845 | 23 | 2018-08-07T16:13:15.287738+03:00 | Point | 24.6658615 | 60.1294299 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82846 | 24 | 2018-08-07T16:13:14.356909+03:00 | Point | 24.663508 | 60.1343784 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82847 | 25 | 2018-08-07T16:13:15.266765+03:00 | Point | 24.6666578 | 60.1289651 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82848 | 26 | 2018-08-07T16:13:24.650544+03:00 | Point | 24.6639437 | 60.1340026 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82849 | 27 | 2018-08-07T16:13:09.795375+03:00 | Point | 24.6679119 | 60.1277027 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82850 | 28 | 2018-08-07T16:13:24.333515+03:00 | Point | 24.6640172 | 60.1338591 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82851 | 30 | 2018-08-07T16:13:14.744955+03:00 | Point | 24.6640766 | 60.1333208 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82852 | 31 | 2018-08-07T16:13:24.520443+03:00 | Point | 24.6686181 | 60.1272557 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82853 | 32 | 2018-08-07T16:13:14.982324+03:00 | Point | 24.6639366 | 60.1329345 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82854 | 33 | 2018-08-07T16:13:14.351514+03:00 | Point | 24.6690886 | 60.1269787 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82855 | 34 | 2018-08-07T16:13:14.344404+03:00 | Point | 24.6641345 | 60.1311757 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82856 | 35 | 2018-08-07T16:13:14.431863+03:00 | Point | 24.6694698 | 60.1266385 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82857 | 36 | 2018-08-07T16:13:19.561964+03:00 | Point | 24.6659303 | 60.1297442 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82858 | 37 | 2018-08-07T16:13:25.327636+03:00 | Point | 24.6699074 | 60.1260562 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82859 | 38 | 2020-08-24T15:49:41.268811+03:00 | Point | 24.6665072 | 60.129629 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82860 | 39 | 2020-08-24T15:49:37.427940+03:00 | Point | 24.670981 | 60.1248292 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82861 | 4 | 2018-08-07T16:13:14.293663+03:00 | Point | 24.6607307 | 60.1384732 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82862 | 40 | a | 2018-08-07T16:13:20.236340+03:00 | Point | 24.6666171 | 60.1294318 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82863 | 40 | b | 2018-08-07T16:13:09.573332+03:00 | Point | 24.6668885 | 60.1292799 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82864 | 41 | 2018-08-07T16:13:19.548611+03:00 | Point | 24.6731663 | 60.123964 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82865 | 43 | 2018-08-07T16:13:09.557005+03:00 | Point | 24.6737793 | 60.1238219 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82866 | 45 | 2018-08-07T16:13:24.747310+03:00 | Point | 24.6743371 | 60.1238054 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82867 | 48 | 2018-08-07T16:13:24.761054+03:00 | Point | 24.6683599 | 60.1278834 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82868 | 5 | 2018-08-07T16:13:09.558785+03:00 | Point | 24.6620728 | 60.1357121 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82869 | 5 | b | 2018-08-07T16:13:15.314027+03:00 | Point | 24.662062 | 60.135012 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82870 | 50 | 2018-08-07T16:13:19.421226+03:00 | Point | 24.6685231 | 60.1277581 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82871 | 6 | 2018-08-07T16:13:15.258614+03:00 | Point | 24.6617054 | 60.1381974 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82872 | 64 | 2018-08-07T16:13:24.875841+03:00 | Point | 24.6711376 | 60.1253682 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82873 | 66 | 2018-08-07T16:13:14.362535+03:00 | Point | 24.6717005 | 60.12484 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82874 | 68 | 2018-08-07T16:13:14.362665+03:00 | Point | 24.6721483 | 60.1250296 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82875 | 7 | a | 2018-08-07T16:13:14.357025+03:00 | Point | 24.6633318 | 60.134019 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82876 | 7 | b | 2018-08-07T16:13:09.553215+03:00 | Point | 24.6635322 | 60.1337771 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82877 | 74 | 2018-08-07T16:13:14.362784+03:00 | Point | 24.6722957 | 60.1246799 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82878 | 76 | 2018-08-07T16:13:24.377511+03:00 | Point | 24.6727479 | 60.1244387 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82879 | 78 | 2018-08-07T16:13:14.364263+03:00 | Point | 24.6747825 | 60.1242462 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82880 | 8 | 2018-08-07T16:13:15.258850+03:00 | Point | 24.6624816 | 60.137966 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82881 | 8 | b | 2018-08-07T16:13:24.663534+03:00 | Point | 24.6631688 | 60.1376357 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82882 | 9 | 2018-08-07T16:13:14.357140+03:00 | Point | 24.6635363 | 60.1333732 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | ||
| 82883 | 9 | b | 2018-08-07T16:13:09.599199+03:00 | Point | 24.6633424 | 60.1329778 | 7242 | 2018-08-07T16:13:07.210854+03:00 | espoo | Soukan rantatie | Sökö strandväg | 02360 | |
| 82884 | 1 | 2018-08-07T16:13:15.250678+03:00 | Point | 24.6680113 | 60.1285557 | 7243 | 2018-08-07T16:13:07.211729+03:00 | espoo | Soukansalmentie | Sökösundsvägen | 02360 | ||
| 82885 | 10 | 2018-08-07T16:13:27.258198+03:00 | Point | 24.6686056 | 60.1302894 | 7243 | 2018-08-07T16:13:07.211729+03:00 | espoo | Soukansalmentie | Sökösundsvägen | 02360 | ||
| 82886 | 11 | 2018-08-07T16:13:19.750164+03:00 | Point | 24.6690016 | 60.1302725 | 7243 | 2018-08-07T16:13:07.211729+03:00 | espoo | Soukansalmentie | Sökösundsvägen | 02360 | ||
| 82887 | 12 | a | 2018-08-07T16:13:19.024335+03:00 | Point | 24.6683482 | 60.1308363 | 7243 | 2018-08-07T16:13:07.211729+03:00 | espoo | Soukansalmentie | Sökösundsvägen | 02360 | |
| 82888 | 12 | b | 2018-08-07T16:13:24.527658+03:00 | Point | 24.6690333 | 60.1306944 | 7243 | 2018-08-07T16:13:07.211729+03:00 | espoo | Soukansalmentie | Sökösundsvägen | 02360 |
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 );