address
126,220 rows sorted by street_name_fi descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42084 | 1 | 2018-08-07T16:12:47.913293+03:00 | Point | 25.0074217 | 60.250364 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42085 | 10 | 2018-08-07T16:12:37.692728+03:00 | Point | 25.0044243 | 60.2517284 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42086 | 11 | 2018-08-07T16:12:37.692851+03:00 | Point | 25.0052371 | 60.2522848 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42087 | 2 | 2018-08-07T16:12:47.913412+03:00 | Point | 25.0063382 | 60.2497627 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42088 | 3 | 2018-08-07T16:12:47.936403+03:00 | Point | 25.0070066 | 60.2510192 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42089 | 4 | 2018-08-07T16:12:37.706335+03:00 | Point | 25.0058687 | 60.2500589 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42090 | 6 | 2018-08-07T16:12:47.936520+03:00 | Point | 25.005598 | 60.2510103 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42091 | 7 | 2018-08-07T16:12:37.706458+03:00 | Point | 25.0062663 | 60.2518809 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
42092 | 9 | 2018-08-07T16:12:47.936665+03:00 | Point | 25.005544 | 60.2521143 | 3771 | 2018-08-07T16:12:35.653468+03:00 | helsinki | Örskintie | Örskisvägen | 00700 | ||
125310 | 1 | 2018-11-14T12:13:01.662911+02:00 | Point | 25.0052371 | 60.2522848 | 11321 | 2018-11-14T12:12:39.149940+02:00 | helsinki | Örskinpolku | Örskisstigen | 00700 | ||
125311 | 2 | 2018-11-14T12:13:01.923153+02:00 | Point | 25.0041535 | 60.2523118 | 11321 | 2018-11-14T12:12:39.149940+02:00 | helsinki | Örskinpolku | Örskisstigen | 00700 | ||
125307 | 2 | 2018-11-14T12:13:01.922886+02:00 | Point | 25.0062663 | 60.2518809 | 11320 | 2018-11-14T12:12:39.149124+02:00 | helsinki | Örskinkuja | Örskisgränden | 00700 | ||
125308 | 3 | 2018-11-14T12:13:01.662745+02:00 | Point | 25.0074762 | 60.2514231 | 11320 | 2018-11-14T12:12:39.149124+02:00 | helsinki | Örskinkuja | Örskisgränden | 00700 | ||
125309 | 5 | 2018-11-14T12:13:01.923022+02:00 | Point | 25.0070609 | 60.2516116 | 11320 | 2018-11-14T12:12:39.149124+02:00 | helsinki | Örskinkuja | Örskisgränden | 00700 | ||
107746 | 1 | 2020-08-24T15:49:35.198019+03:00 | Point | 24.7520568 | 60.3018037 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
107747 | 2 | 2020-08-24T15:49:45.829515+03:00 | Point | 24.7520951 | 60.3015255 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
107748 | 3 | 2020-08-24T15:49:35.709644+03:00 | Point | 24.7514771 | 60.3019373 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
107749 | 4 | 2020-08-24T15:49:46.055477+03:00 | Point | 24.7515521 | 60.3015874 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
107750 | 5 | 2020-08-24T15:49:44.795831+03:00 | Point | 24.7509695 | 60.3020889 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
107751 | 6 | 2020-08-24T15:49:35.201242+03:00 | Point | 24.751099 | 60.3017122 | 9019 | 2018-08-07T16:13:11.199384+03:00 | espoo | Örkkirinne | Örkibrinken | 02970 | ||
108943 | 1 | 2018-08-07T16:13:24.911995+03:00 | Point | 24.7505256 | 60.301002 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108944 | 11 | 2018-08-07T16:13:24.620657+03:00 | Point | 24.7511838 | 60.3000698 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108945 | 13 | 2018-08-07T16:13:24.461385+03:00 | Point | 24.7517105 | 60.2997746 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108946 | 15 | 2018-08-07T16:13:27.290443+03:00 | Point | 24.7515139 | 60.2994691 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108947 | 16 | 2018-08-07T16:13:24.905780+03:00 | Point | 24.7523745 | 60.300449 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108948 | 17 | 2018-08-07T16:13:24.462050+03:00 | Point | 24.7514612 | 60.2992626 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108949 | 18 | 2018-08-07T16:13:19.928291+03:00 | Point | 24.7522864 | 60.3001527 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108950 | 19 | 2018-08-07T16:13:24.461803+03:00 | Point | 24.7513732 | 60.2989393 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108951 | 2 | 2018-08-07T16:13:25.114358+03:00 | Point | 24.7510145 | 60.3009222 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108952 | 20 | 2018-08-07T16:13:14.256889+03:00 | Point | 24.7522152 | 60.299991 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108953 | 22 | 2018-08-07T16:13:24.558201+03:00 | Point | 24.7521274 | 60.2996498 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108954 | 23 | 2018-08-07T16:13:24.474193+03:00 | Point | 24.7513586 | 60.2984815 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108955 | 24 | a | 2018-08-07T16:13:27.168077+03:00 | Point | 24.752057 | 60.2993894 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108956 | 24 | b | 2018-08-07T16:13:14.257006+03:00 | Point | 24.7527261 | 60.2993996 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108957 | 25 | 2018-08-07T16:13:24.473169+03:00 | Point | 24.7512702 | 60.2982211 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108958 | 26 | a | 2020-08-24T15:49:35.838433+03:00 | Point | 24.7519506 | 60.2991109 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108959 | 26 | b | 2020-08-24T15:49:44.715118+03:00 | Point | 24.7526375 | 60.2991571 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108960 | 27 | 2018-08-07T16:13:24.472302+03:00 | Point | 24.7511816 | 60.2979786 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108961 | 28 | 2020-08-24T15:49:35.833150+03:00 | Point | 24.7519156 | 60.2989583 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108962 | 29 | 2018-08-07T16:13:24.954930+03:00 | Point | 24.7511114 | 60.2976913 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108963 | 3 | 2018-09-18T18:27:10.873210+03:00 | Point | 24.7502198 | 60.3007861 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108964 | 3 | b | 2018-08-07T16:13:24.461650+03:00 | Point | 24.7495866 | 60.3008118 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108965 | 30 | 2018-08-07T16:13:25.221511+03:00 | Point | 24.7517932 | 60.2984016 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108966 | 32 | 2018-08-07T16:13:19.839740+03:00 | Point | 24.75174 | 60.2982669 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108967 | 34 | 2018-08-07T16:13:20.303530+03:00 | Point | 24.7516164 | 60.2978807 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108968 | 36 | 2018-08-07T16:13:19.839858+03:00 | Point | 24.7515634 | 60.2977101 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108969 | 37 | 2018-08-07T16:13:25.333019+03:00 | Point | 24.7546813 | 60.2918909 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108970 | 38 | 2018-08-07T16:13:19.347173+03:00 | Point | 24.7550847 | 60.2959754 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108971 | 39 | 2018-08-07T16:13:24.927211+03:00 | Point | 24.7549175 | 60.2917387 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108972 | 4 | 2018-08-07T16:13:24.462801+03:00 | Point | 24.7506184 | 60.3006881 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108973 | 40 | 2018-08-07T16:13:19.437976+03:00 | Point | 24.7551841 | 60.2947639 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108974 | 41 | 2018-08-07T16:13:24.478371+03:00 | Point | 24.7552829 | 60.2912278 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108975 | 42 | 2018-08-07T16:13:19.438481+03:00 | Point | 24.7551499 | 60.2945035 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108976 | 43 | 2018-08-07T16:13:24.416867+03:00 | Point | 24.7552481 | 60.2910482 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108977 | 44 | 2018-08-07T16:13:19.438760+03:00 | Point | 24.7550455 | 60.2939559 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108978 | 45 | 2018-08-07T16:13:19.858637+03:00 | Point | 24.7551775 | 60.2908147 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108979 | 46 | 2018-08-07T16:13:19.458425+03:00 | Point | 24.7549582 | 60.2935428 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108980 | 47 | 2018-08-07T16:13:24.694784+03:00 | Point | 24.7551427 | 60.2906352 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108981 | 48 | 2018-08-07T16:13:24.874854+03:00 | Point | 24.7550324 | 60.2932917 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108982 | 49 | 2018-08-07T16:13:19.858135+03:00 | Point | 24.7544749 | 60.2904724 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108983 | 5 | 2018-08-07T16:13:27.325396+03:00 | Point | 24.7499316 | 60.3006329 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108984 | 50 | 2018-08-07T16:13:25.328642+03:00 | Point | 24.7547494 | 60.2924564 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108985 | 51 | 2018-08-07T16:13:19.872424+03:00 | Point | 24.7548021 | 60.2902486 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108986 | 52 | 2018-08-07T16:13:19.429107+03:00 | Point | 24.7546967 | 60.2922409 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108987 | 53 | 2018-08-07T16:13:14.250843+03:00 | Point | 24.7550202 | 60.2900964 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108988 | 54 | 2018-08-07T16:13:19.561464+03:00 | Point | 24.7551875 | 60.2919008 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108989 | 55 | 2018-08-07T16:13:24.896965+03:00 | Point | 24.7550072 | 60.2894143 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108990 | 56 | 2018-08-07T16:13:19.858284+03:00 | Point | 24.7555331 | 60.2916232 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108991 | 57 | 2018-08-07T16:13:20.050237+03:00 | Point | 24.7547742 | 60.2891446 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108992 | 58 | a | 2018-08-07T16:13:24.117128+03:00 | Point | 24.7564585 | 60.2911761 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108993 | 58 | b | 2018-08-07T16:13:27.300892+03:00 | Point | 24.7556462 | 60.2910041 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108994 | 6 | 2018-08-07T16:13:24.462537+03:00 | Point | 24.7514532 | 60.3003127 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108995 | 60 | 2018-08-07T16:13:19.858431+03:00 | Point | 24.755558 | 60.2906988 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108996 | 62 | a | 2018-08-07T16:13:19.872802+03:00 | Point | 24.7554704 | 60.2903306 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | |
108997 | 64 | 2018-08-07T16:13:19.872936+03:00 | Point | 24.7554903 | 60.2900883 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108998 | 66 | 2018-08-07T16:13:14.251145+03:00 | Point | 24.7554938 | 60.2896126 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
108999 | 68 | 2018-08-07T16:13:24.845637+03:00 | Point | 24.7552086 | 60.2890736 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109000 | 7 | 2018-08-07T16:13:27.339050+03:00 | Point | 24.7504395 | 60.3004364 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
109001 | 70 | 2018-08-07T16:13:19.199690+03:00 | Point | 24.7549027 | 60.2888845 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109002 | 72 | 2020-08-24T15:49:35.912307+03:00 | Point | 24.7546875 | 60.2886418 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109003 | 74 | 2018-08-07T16:13:20.119158+03:00 | Point | 24.7544685 | 60.2889196 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109004 | 76 | 2020-08-24T15:49:35.906498+03:00 | Point | 24.7541972 | 60.2889371 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109005 | 78 | 2018-08-07T16:13:24.236228+03:00 | Point | 24.7534374 | 60.2889985 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02920 | ||
109006 | 8 | 2018-08-07T16:13:25.310125+03:00 | Point | 24.7518493 | 60.3005468 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
109007 | 9 | 2018-08-07T16:13:27.156805+03:00 | Point | 24.750857 | 60.3002398 | 9087 | 2018-08-07T16:13:11.273973+03:00 | espoo | Örkkiniityntie | Örkiängsvägen | 02970 | ||
117732 | 1 | 2018-08-07T16:13:24.442124+03:00 | Point | 24.7525505 | 60.3010956 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117733 | 11 | 2018-08-07T16:13:24.574789+03:00 | Point | 24.7528494 | 60.302227 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117734 | 15 | 2018-08-07T16:13:24.720822+03:00 | Point | 24.7529381 | 60.3024606 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117735 | 17 | 2020-08-24T15:49:42.483038+03:00 | Point | 24.7534819 | 60.3023 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117736 | 2 | 2020-08-24T15:49:41.904348+03:00 | Point | 24.7521518 | 60.3012025 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117737 | 3 | 2018-08-07T16:13:27.196067+03:00 | Point | 24.7526217 | 60.3012483 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117738 | 4 | 2020-08-24T15:49:40.002042+03:00 | Point | 24.7523814 | 60.3019389 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117739 | 5 | 2018-08-07T16:13:24.575744+03:00 | Point | 24.753056 | 60.3012222 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117740 | 6 | 2020-08-24T15:49:41.498781+03:00 | Point | 24.7524496 | 60.3024866 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117741 | 7 | 2018-08-07T16:13:24.575458+03:00 | Point | 24.7526909 | 60.3016613 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
117742 | 9 | 2018-08-07T16:13:27.204278+03:00 | Point | 24.7527612 | 60.3019397 | 10362 | 2018-08-07T16:13:21.867355+03:00 | espoo | Örkkilaakso | Örkidalen | 02970 | ||
108810 | 1 | 2020-08-24T15:49:35.884094+03:00 | Point | 24.7519183 | 60.2986082 | 9077 | 2018-08-07T16:13:11.263512+03:00 | espoo | Örkkikuja | Örkigränden | 02970 | ||
108811 | 10 | 2018-08-07T16:13:14.248451+03:00 | Point | 24.7547561 | 60.298802 | 9077 | 2018-08-07T16:13:11.263512+03:00 | espoo | Örkkikuja | Örkigränden | 02970 | ||
108812 | 11 | 2018-08-07T16:13:14.248579+03:00 | Point | 24.7546338 | 60.2982273 | 9077 | 2018-08-07T16:13:11.263512+03:00 | espoo | Örkkikuja | Örkigränden | 02970 | ||
108813 | 12 | 2018-08-07T16:13:24.373205+03:00 | Point | 24.755118 | 60.2987668 | 9077 | 2018-08-07T16:13:11.263512+03:00 | espoo | Örkkikuja | Örkigränden | 02970 |
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 );