address
126,220 rows sorted by location_coordinates_0
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108016 | 45 | 2018-08-07T16:13:24.131320+03:00 | Point | 24.5038823 | 60.3216807 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 105256 | 7 | 2018-08-07T16:13:19.327218+03:00 | Point | 24.5045261 | 60.2576613 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105223 | 7 | 2018-08-07T16:13:19.899345+03:00 | Point | 24.5045462 | 60.2611169 | 8854 | 2018-08-07T16:13:11.012007+03:00 | espoo | Kivilammentie | Kivilampivägen | 02820 | ||
| 105257 | 9 | 2018-08-07T16:13:24.793038+03:00 | Point | 24.5045543 | 60.2581909 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105226 | 11 | 2018-08-07T16:13:25.335595+03:00 | Point | 24.5045677 | 60.2584961 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105255 | 5 | 2018-08-07T16:13:19.665775+03:00 | Point | 24.504658 | 60.2573027 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 104205 | 1 | 2018-08-07T16:13:19.367871+03:00 | Point | 24.5047243 | 60.2576979 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 105225 | 10 | 2018-08-07T16:13:19.322785+03:00 | Point | 24.5047785 | 60.2588918 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105245 | 3 | 2018-08-07T16:13:14.191897+03:00 | Point | 24.5048421 | 60.2570701 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105222 | 5 | 2018-08-07T16:13:14.180815+03:00 | Point | 24.5049999 | 60.260975 | 8854 | 2018-08-07T16:13:11.012007+03:00 | espoo | Kivilammentie | Kivilampivägen | 02820 | ||
| 106809 | 21 | 2018-08-07T16:13:24.102980+03:00 | Point | 24.5050876 | 60.2695289 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 105220 | 2 | 2018-08-07T16:13:24.899371+03:00 | Point | 24.5050969 | 60.2605355 | 8854 | 2018-08-07T16:13:11.012007+03:00 | espoo | Kivilammentie | Kivilampivägen | 02820 | ||
| 106811 | 23 | 2018-08-07T16:13:14.221503+03:00 | Point | 24.5051461 | 60.2692419 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107966 | 26 | 2018-08-07T16:13:19.462250+03:00 | Point | 24.5053365 | 60.3128813 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 106813 | 25 | 2018-08-07T16:13:20.086641+03:00 | Point | 24.5053512 | 60.2688209 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104221 | 2 | 2018-08-07T16:13:25.288537+03:00 | Point | 24.5053712 | 60.2579157 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 108020 | 56 | 2020-08-24T15:49:44.089478+03:00 | Point | 24.5054061 | 60.3214441 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 107961 | 19 | 2018-08-07T16:13:20.124391+03:00 | Point | 24.5054425 | 60.3130522 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107299 | 18 | 2018-08-07T16:13:24.182440+03:00 | Point | 24.505479 | 60.2878942 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 106821 | 34 | 2018-08-07T16:13:19.938734+03:00 | Point | 24.5054929 | 60.2690099 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107958 | 16 | 2018-08-07T16:13:24.350160+03:00 | Point | 24.5054939 | 60.3120471 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107960 | 18 | 2018-08-07T16:13:19.460913+03:00 | Point | 24.505528 | 60.3121819 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 106819 | 32 | 2018-08-07T16:13:24.536888+03:00 | Point | 24.5056066 | 60.269854 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104231 | 3 | 2018-08-07T16:13:14.201814+03:00 | Point | 24.5056093 | 60.2577012 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 105221 | 3 | 2018-08-07T16:13:24.411627+03:00 | Point | 24.5058719 | 60.2606461 | 8854 | 2018-08-07T16:13:11.012007+03:00 | espoo | Kivilammentie | Kivilampivägen | 02820 | ||
| 107959 | 17 | 2018-08-07T16:13:25.274382+03:00 | Point | 24.5058771 | 60.3130269 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 105224 | 1 | 2020-08-24T15:49:43.540297+03:00 | Point | 24.5059174 | 60.2552341 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02860 | ||
| 107296 | 14 | b | 2018-08-07T16:13:19.963994+03:00 | Point | 24.5059256 | 60.2870522 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | |
| 107965 | 24 | 2018-08-07T16:13:24.210355+03:00 | Point | 24.5059703 | 60.3128477 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107298 | 16 | 2018-08-07T16:13:27.341932+03:00 | Point | 24.5060052 | 60.2877615 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 105232 | 16 | 2018-08-07T16:13:24.098117+03:00 | Point | 24.5060952 | 60.2602161 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105229 | 14 | 2018-08-07T16:13:20.245937+03:00 | Point | 24.5061015 | 60.2597943 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105227 | 12 | 2018-08-07T16:13:19.552051+03:00 | Point | 24.5061072 | 60.2594174 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 109820 | 12 | 2018-08-07T16:13:19.943606+03:00 | Point | 24.5061183 | 60.2742718 | 9144 | 2018-08-07T16:13:11.358956+03:00 | espoo | Naruportti | Snörporten | 02860 | ||
| 109822 | 16 | 2018-08-07T16:13:27.319736+03:00 | Point | 24.5061243 | 60.2750707 | 9144 | 2018-08-07T16:13:11.358956+03:00 | espoo | Naruportti | Snörporten | 02860 | ||
| 105219 | 1 | 2018-08-07T16:13:19.552528+03:00 | Point | 24.5062366 | 60.2604231 | 8854 | 2018-08-07T16:13:11.012007+03:00 | espoo | Kivilammentie | Kivilampivägen | 02820 | ||
| 107963 | 20 | 2018-08-07T16:13:19.461151+03:00 | Point | 24.506253 | 60.3120948 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107956 | 14 | 2018-08-07T16:13:19.461502+03:00 | Point | 24.50631 | 60.3119155 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 108015 | 43 | 2018-08-07T16:13:19.901184+03:00 | Point | 24.506351 | 60.32239 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 108021 | 58 | 2018-08-07T16:13:19.907509+03:00 | Point | 24.5063612 | 60.3205142 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 105228 | 13 | 2018-08-07T16:13:24.389687+03:00 | Point | 24.5064085 | 60.2586017 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 106818 | 30 | 2018-08-07T16:13:19.445001+03:00 | Point | 24.5064146 | 60.2701981 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104237 | 4 | 2018-08-07T16:13:25.065258+03:00 | Point | 24.5064911 | 60.2579109 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 104244 | 5 | 2018-08-07T16:13:14.170382+03:00 | Point | 24.5064943 | 60.2577045 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 105230 | 15 | a | 2018-08-07T16:13:19.232692+03:00 | Point | 24.506513 | 60.2588624 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | |
| 106822 | 36 | 2018-08-07T16:13:19.970803+03:00 | Point | 24.5065384 | 60.2691753 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 105233 | 17 | 19 | 2018-08-07T16:13:20.181238+03:00 | Point | 24.5065548 | 60.2596793 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | |
| 106815 | 27 | 2018-08-07T16:13:24.141144+03:00 | Point | 24.5065599 | 60.268942 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107294 | 13 | 2018-08-07T16:13:19.392117+03:00 | Point | 24.5066187 | 60.2878446 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 107297 | 15 | 2018-08-07T16:13:19.444379+03:00 | Point | 24.5066852 | 60.2882308 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 106816 | 28 | 2018-08-07T16:13:14.231216+03:00 | Point | 24.5067911 | 60.2703879 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 105234 | 18 | 2018-08-07T16:13:19.024452+03:00 | Point | 24.5068159 | 60.2603355 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 107295 | 14 | 2018-08-07T16:13:24.156685+03:00 | Point | 24.5069302 | 60.2875675 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 107957 | 15 | 2018-08-07T16:13:19.461904+03:00 | Point | 24.5069652 | 60.3128604 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 106823 | 38 | 2018-08-07T16:13:19.971035+03:00 | Point | 24.5069864 | 60.2694193 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107954 | 12 | 2018-08-07T16:13:19.465980+03:00 | Point | 24.5070534 | 60.3118106 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 97804 | 46 | 2018-08-07T16:13:24.605983+03:00 | Point | 24.5071512 | 60.2163926 | 8377 | 2018-08-07T16:13:08.357134+03:00 | espoo | Loojärventie | Låjärvsvägen | 02780 | ||
| 109821 | 14 | 2018-08-07T16:13:14.304436+03:00 | Point | 24.5072106 | 60.2749401 | 9144 | 2018-08-07T16:13:11.358956+03:00 | espoo | Naruportti | Snörporten | 02860 | ||
| 105236 | 21 | 2018-08-07T16:13:14.181166+03:00 | Point | 24.5072537 | 60.2600499 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 106814 | 26 | 2018-08-07T16:13:14.978801+03:00 | Point | 24.5072581 | 60.2705782 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 108014 | 41 | 2018-08-07T16:13:24.513062+03:00 | Point | 24.5073956 | 60.3227259 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 97802 | 44 | 2018-08-07T16:13:24.777965+03:00 | Point | 24.5074257 | 60.2161334 | 8377 | 2018-08-07T16:13:08.357134+03:00 | espoo | Loojärventie | Låjärvsvägen | 02780 | ||
| 105231 | 15 | b | 2018-08-07T16:13:24.933334+03:00 | Point | 24.507469 | 60.2589467 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | |
| 108019 | 54 | 2018-08-07T16:13:14.247988+03:00 | Point | 24.5074993 | 60.3218467 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 107955 | 13 | 2018-08-07T16:13:19.465863+03:00 | Point | 24.5075294 | 60.3126381 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107964 | 22 | 2018-08-07T16:13:19.466618+03:00 | Point | 24.5075765 | 60.3119113 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 105235 | 20 | 2018-08-07T16:13:14.180931+03:00 | Point | 24.507594 | 60.2602486 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 106804 | 15 | 19 | 2018-08-07T16:13:19.450378+03:00 | Point | 24.5075959 | 60.2709474 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | |
| 106825 | 40 | 2018-08-07T16:13:19.971294+03:00 | Point | 24.5076506 | 60.269709 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104245 | 6 | 2018-08-07T16:13:24.407567+03:00 | Point | 24.5076647 | 60.2579422 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 106812 | 24 | 2018-08-07T16:13:24.221284+03:00 | Point | 24.5077608 | 60.2707954 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107292 | 11 | 2018-08-07T16:13:19.964225+03:00 | Point | 24.5077608 | 60.2876334 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 106826 | 42 | 2018-08-07T16:13:19.971539+03:00 | Point | 24.5078658 | 60.2698175 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104246 | 7 | 2018-08-07T16:13:19.227868+03:00 | Point | 24.5078672 | 60.2576916 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 107736 | 14 | 2018-08-07T16:13:19.463942+03:00 | Point | 24.5078907 | 60.2898149 | 9018 | 2018-08-07T16:13:11.198642+03:00 | espoo | Soidinkorpi | Orrspelskärret | 02860 | ||
| 109830 | 9 | 2018-08-07T16:13:27.343452+03:00 | Point | 24.5079845 | 60.2751494 | 9144 | 2018-08-07T16:13:11.358956+03:00 | espoo | Naruportti | Snörporten | 02860 | ||
| 107953 | 11 | 2018-08-07T16:13:14.234946+03:00 | Point | 24.5080192 | 60.3125501 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107973 | 9 | 2018-08-07T16:13:19.922291+03:00 | Point | 24.5080586 | 60.3123349 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107971 | 7 | 2018-08-07T16:13:27.170069+03:00 | Point | 24.5080994 | 60.3120299 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 104248 | 9 | 2018-08-07T16:13:24.419299+03:00 | Point | 24.5081563 | 60.2576837 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 107952 | 10 | 2018-08-07T16:13:24.834306+03:00 | Point | 24.508177 | 60.3116801 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107293 | 12 | 2018-08-07T16:13:24.826513+03:00 | Point | 24.5082544 | 60.2872672 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 106827 | 44 | 2018-08-07T16:13:20.063535+03:00 | Point | 24.5082588 | 60.2701151 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 104247 | 8 | 2018-08-07T16:13:19.227634+03:00 | Point | 24.5082609 | 60.2579354 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | ||
| 107734 | 12 | 2018-08-07T16:13:24.632303+03:00 | Point | 24.5083438 | 60.2897448 | 9018 | 2018-08-07T16:13:11.198642+03:00 | espoo | Soidinkorpi | Orrspelskärret | 02860 | ||
| 106810 | 22 | 2018-08-07T16:13:14.236595+03:00 | Point | 24.5084789 | 60.2711033 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107737 | 15 | 2018-08-07T16:13:19.463826+03:00 | Point | 24.508486 | 60.2899069 | 9018 | 2018-08-07T16:13:11.198642+03:00 | espoo | Soidinkorpi | Orrspelskärret | 02860 | ||
| 107307 | 9 | 2018-08-07T16:13:25.178374+03:00 | Point | 24.5084869 | 60.2874386 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 97800 | 42 | 2018-08-07T16:13:19.118488+03:00 | Point | 24.5085303 | 60.2158502 | 8377 | 2018-08-07T16:13:08.357134+03:00 | espoo | Loojärventie | Låjärvsvägen | 02780 | ||
| 105238 | 23 | 2018-08-07T16:13:19.690048+03:00 | Point | 24.5085736 | 60.2599651 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 105237 | 22 | 2018-08-07T16:13:24.860325+03:00 | Point | 24.5086061 | 60.2602075 | 8855 | 2018-08-07T16:13:11.012732+03:00 | espoo | Kolmirannantie | Kolmirantavägen | 02820 | ||
| 107972 | 8 | 2018-08-07T16:13:19.467084+03:00 | Point | 24.5086852 | 60.3115743 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 104208 | 10 | b | 2018-11-21T15:06:45.523430+02:00 | Point | 24.5088623 | 60.2587814 | 8809 | 2018-08-07T16:13:10.967623+03:00 | espoo | Vuohilammentie | Vuohilampivägen | 02820 | |
| 106820 | 33 | 2018-08-07T16:13:19.449916+03:00 | Point | 24.5088679 | 60.2704674 | 8949 | 2018-08-07T16:13:11.119339+03:00 | espoo | Kauristie | Stenbocksvägen | 02860 | ||
| 107735 | 13 | 2018-08-07T16:13:24.883898+03:00 | Point | 24.5089566 | 60.2898727 | 9018 | 2018-08-07T16:13:11.198642+03:00 | espoo | Soidinkorpi | Orrspelskärret | 02860 | ||
| 108018 | 52 | 2018-08-07T16:13:14.251931+03:00 | Point | 24.5089695 | 60.3227677 | 9033 | 2018-08-07T16:13:11.213413+03:00 | espoo | Kattilantie | Kattilavägen | 02820 | ||
| 107291 | 10 | 2018-08-07T16:13:25.144356+03:00 | Point | 24.5090164 | 60.2870905 | 8979 | 2018-08-07T16:13:11.151946+03:00 | espoo | Soittilantie | Soittilavägen | 02860 | ||
| 116565 | 2 | 2018-08-07T16:13:27.127899+03:00 | Point | 24.5090616 | 60.2876921 | 10124 | 2018-08-07T16:13:17.255246+03:00 | espoo | Soittilanrinne | Soittilabranten | 02860 | ||
| 107970 | 6 | 2018-08-07T16:13:20.146768+03:00 | Point | 24.5091753 | 60.3114684 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 | ||
| 107969 | 5 | 2018-08-07T16:13:24.907068+03:00 | Point | 24.509226 | 60.3117019 | 9031 | 2018-08-07T16:13:11.211196+03:00 | espoo | Haukkaranta | Haukkastranden | 02820 |
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 );