address
126,220 rows sorted by postal_code
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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47602 | 356 | a | 2020-08-24T15:48:03.269561+03:00 | Point | 25.1499225 | 60.33874 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | ||
| 47605 | 356 | d | 2020-08-24T15:48:03.261432+03:00 | Point | 25.1502312 | 60.3389371 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | ||
| 47606 | 356 | e | 2020-08-24T15:48:03.258498+03:00 | Point | 25.1505401 | 60.3391701 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | ||
| 47609 | 356 | h | 2020-08-24T15:48:03.247763+03:00 | Point | 25.1508308 | 60.3393941 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | ||
| 47877 | 1 | 2020-08-24T15:48:04.139554+03:00 | Point | 24.8027938 | 60.3729636 | 4418 | 2018-08-07T16:12:49.974780+03:00 | vantaa | Vallesmanninkuja | Befallningsmansgränden | |||
| 47878 | 2 | 2020-08-24T15:48:04.135682+03:00 | Point | 24.8032472 | 60.3729194 | 4418 | 2018-08-07T16:12:49.974780+03:00 | vantaa | Vallesmanninkuja | Befallningsmansgränden | |||
| 47879 | 3 | 2020-08-24T15:48:04.133201+03:00 | Point | 24.8022154 | 60.3727024 | 4418 | 2018-08-07T16:12:49.974780+03:00 | vantaa | Vallesmanninkuja | Befallningsmansgränden | |||
| 47880 | 4 | 2020-08-24T15:48:04.130691+03:00 | Point | 24.803031 | 60.3727037 | 4418 | 2018-08-07T16:12:49.974780+03:00 | vantaa | Vallesmanninkuja | Befallningsmansgränden | |||
| 49791 | 1 | 2020-08-24T15:48:08.959717+03:00 | Point | 24.7979398 | 60.3723819 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49792 | 2 | 2020-08-24T15:48:08.957152+03:00 | Point | 24.7984107 | 60.3724365 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49793 | 3 | 2020-08-24T15:48:08.954435+03:00 | Point | 24.7984672 | 60.3720865 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49794 | 4 | 2020-08-24T15:48:08.951896+03:00 | Point | 24.7990109 | 60.3720963 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49795 | 5 | 2020-08-24T15:48:08.949279+03:00 | Point | 24.7988308 | 60.3719076 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49796 | 6 | 2020-08-24T15:48:08.946694+03:00 | Point | 24.8000838 | 60.3715235 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49797 | 7 | 2020-08-24T15:48:08.943998+03:00 | Point | 24.7994673 | 60.3715585 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 49798 | 9 | 2020-08-24T15:48:08.941313+03:00 | Point | 24.80005 | 60.3711196 | 4565 | 2018-08-07T16:12:50.504412+03:00 | vantaa | Toukolantie | Toukolavägen | |||
| 50918 | 1 | 2020-08-24T15:48:11.804217+03:00 | Point | 24.8006468 | 60.3743067 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50919 | 10 | 2020-08-24T15:48:11.779670+03:00 | Point | 24.803081 | 60.3734307 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50920 | 12 | 2020-08-24T15:48:11.776995+03:00 | Point | 24.8038081 | 60.3730907 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50921 | 2 | 2020-08-24T15:48:11.801474+03:00 | Point | 24.8007903 | 60.3745582 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50922 | 3 | 2020-08-24T15:48:11.798784+03:00 | Point | 24.801374 | 60.3739487 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50923 | 4 | 2020-08-24T15:48:11.796162+03:00 | Point | 24.8013173 | 60.3743346 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50924 | 5 | 2020-08-24T15:48:11.793435+03:00 | Point | 24.8021377 | 60.3735639 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50925 | 6 | 2020-08-24T15:48:11.790786+03:00 | Point | 24.8017172 | 60.3741467 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50926 | 7 | 2020-08-24T15:48:11.788133+03:00 | Point | 24.8027193 | 60.3732956 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50927 | 8 | 2020-08-24T15:48:11.785284+03:00 | Point | 24.8022449 | 60.3738154 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 50928 | 9 | 2020-08-24T15:48:11.782437+03:00 | Point | 24.8037734 | 60.3728304 | 4657 | 2018-08-07T16:12:50.829463+03:00 | vantaa | Taula-Matin tie | Taula-Mattis väg | |||
| 52744 | 1 | 2020-08-24T15:48:15.992656+03:00 | Point | 24.8047424 | 60.3744653 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52745 | 1 | b | 2020-08-24T15:48:15.990015+03:00 | Point | 24.8049567 | 60.3749952 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | ||
| 52746 | 1 | c | 2020-08-24T15:48:15.987409+03:00 | Point | 24.805135 | 60.375498 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | ||
| 52747 | 10 | 2020-08-24T15:48:15.956856+03:00 | Point | 24.8019318 | 60.3746317 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52748 | 11 | 2020-08-24T15:48:15.954383+03:00 | Point | 24.8019298 | 60.3749548 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52749 | 12 | 2020-08-24T15:48:15.951865+03:00 | Point | 24.8012227 | 60.3749807 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52750 | 13 | 2020-08-24T15:48:15.949335+03:00 | Point | 24.8014752 | 60.3751875 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52751 | 2 | 2020-08-24T15:48:15.984783+03:00 | Point | 24.8035652 | 60.374302 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52752 | 2 | a | 2020-08-24T15:48:15.981630+03:00 | Point | 24.8047985 | 60.3741782 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | ||
| 52753 | 3 | 2020-08-24T15:48:15.979109+03:00 | Point | 24.8047197 | 60.3752282 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52754 | 4 | 2020-08-24T15:48:15.976442+03:00 | Point | 24.8034045 | 60.3738889 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52755 | 5 | 2020-08-24T15:48:15.973820+03:00 | Point | 24.8039788 | 60.3748411 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52756 | 6 | 2020-08-24T15:48:15.971202+03:00 | Point | 24.8029863 | 60.3741037 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52757 | 7 | 2020-08-24T15:48:15.964603+03:00 | Point | 24.8029296 | 60.3744985 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52758 | 8 | 2020-08-24T15:48:15.961935+03:00 | Point | 24.8024046 | 60.3743811 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 52759 | 9 | 2020-08-24T15:48:15.959404+03:00 | Point | 24.8026204 | 60.3746596 | 4812 | 2018-08-07T16:12:51.372607+03:00 | vantaa | Sompiontie | Sompiovägen | |||
| 68477 | 1 | 2018-08-07T16:13:03.003837+03:00 | Point | 24.8082245 | 60.3710777 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 68478 | 1 | a | 2018-08-07T16:13:03.003713+03:00 | Point | 24.8090523 | 60.3720752 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | ||
| 68481 | 2 | 2020-08-24T15:48:53.686559+03:00 | Point | 24.8070747 | 60.3724134 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 68482 | 3 | 2018-08-07T16:13:03.003207+03:00 | Point | 24.8137962 | 60.3729345 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 68483 | 4 | 2020-08-24T15:48:53.682645+03:00 | Point | 24.8102609 | 60.3730732 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 68484 | 5 | 2020-08-24T15:48:53.679113+03:00 | Point | 24.8161963 | 60.3748227 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 68485 | 8 | 2020-08-24T15:48:53.675579+03:00 | Point | 24.8157946 | 60.3753427 | 6119 | 2018-08-07T16:13:00.516309+03:00 | vantaa | Lamminsuontie | Lamminsuovägen | |||
| 71053 | 10 | 2020-08-24T15:48:59.452405+03:00 | Point | 24.7879978 | 60.3654465 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71054 | 2 | 2020-08-24T15:48:59.469208+03:00 | Point | 24.7857716 | 60.3650211 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71055 | 3 | 2020-08-24T15:48:59.466805+03:00 | Point | 24.78532 | 60.364814 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71056 | 3 | b | 2020-08-24T15:48:59.464378+03:00 | Point | 24.7858302 | 60.364375 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | ||
| 71057 | 4 | 2020-08-24T15:48:59.461983+03:00 | Point | 24.7876121 | 60.3662268 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71058 | 5 | 2020-08-24T15:48:59.459547+03:00 | Point | 24.7870506 | 60.3634166 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71059 | 6 | 2020-08-24T15:48:59.457195+03:00 | Point | 24.788118 | 60.3664699 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 71060 | 8 | 2020-08-24T15:48:59.454788+03:00 | Point | 24.7867921 | 60.3641522 | 6322 | 2018-08-07T16:13:01.269969+03:00 | vantaa | Kotihaantie | Hemhagsvägen | |||
| 72424 | 26 | 2020-08-24T15:49:02.683426+03:00 | Point | 24.7869001 | 60.3614867 | 6418 | 2018-08-07T16:13:01.653258+03:00 | vantaa | Klaukkalantie | Klövskogsvägen | |||
| 72425 | 27 | 2020-08-24T15:49:02.679651+03:00 | Point | 24.7894554 | 60.361401 | 6418 | 2018-08-07T16:13:01.653258+03:00 | vantaa | Klaukkalantie | Klövskogsvägen | |||
| 72427 | 29 | 2018-08-07T16:13:03.501336+03:00 | Point | 24.7883819 | 60.3620904 | 6418 | 2018-08-07T16:13:01.653258+03:00 | vantaa | Klaukkalantie | Klövskogsvägen | |||
| 72429 | 31 | 2020-08-24T15:49:02.671711+03:00 | Point | 24.785752 | 60.3624901 | 6418 | 2018-08-07T16:13:01.653258+03:00 | vantaa | Klaukkalantie | Klövskogsvägen | |||
| 75294 | 1 | 2020-08-24T15:49:09.029498+03:00 | Point | 24.8028328 | 60.3755126 | 6630 | 2018-08-07T16:13:02.473607+03:00 | vantaa | Karrintie | Karrivägen | |||
| 75295 | 2 | 2020-08-24T15:49:09.027104+03:00 | Point | 24.8018548 | 60.3753765 | 6630 | 2018-08-07T16:13:02.473607+03:00 | vantaa | Karrintie | Karrivägen | |||
| 75296 | 3 | 2020-08-24T15:49:09.024486+03:00 | Point | 24.8033024 | 60.3757915 | 6630 | 2018-08-07T16:13:02.473607+03:00 | vantaa | Karrintie | Karrivägen | |||
| 75297 | 4 | 2020-08-24T15:49:09.022130+03:00 | Point | 24.8024875 | 60.3756647 | 6630 | 2018-08-07T16:13:02.473607+03:00 | vantaa | Karrintie | Karrivägen | |||
| 75298 | 6 | 2020-08-24T15:49:09.019653+03:00 | Point | 24.803084 | 60.3759438 | 6630 | 2018-08-07T16:13:02.473607+03:00 | vantaa | Karrintie | Karrivägen | |||
| 76648 | 1 | 2020-08-24T15:49:13.052971+03:00 | Point | 24.7998163 | 60.3737669 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76649 | 10 | 2020-08-24T15:49:13.031167+03:00 | Point | 24.8002419 | 60.3723405 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76650 | 12 | 2020-08-24T15:49:13.028647+03:00 | Point | 24.8000445 | 60.3720171 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76651 | 14 | 2020-08-24T15:49:13.026103+03:00 | Point | 24.7998277 | 60.3719091 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76652 | 16 | 2020-08-24T15:49:13.023710+03:00 | Point | 24.7990864 | 60.3716028 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76653 | 18 | 2020-08-24T15:49:13.019382+03:00 | Point | 24.7986886 | 60.3714496 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76654 | 2 | 2020-08-24T15:49:13.050553+03:00 | Point | 24.7998323 | 60.374117 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76655 | 20 | 2020-08-24T15:49:13.016914+03:00 | Point | 24.7981282 | 60.3712154 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76656 | 3 | 2020-08-24T15:49:13.048097+03:00 | Point | 24.7997298 | 60.3730847 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76657 | 4 | 2020-08-24T15:49:13.045706+03:00 | Point | 24.8002526 | 60.3735522 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76658 | 5 | 2020-08-24T15:49:13.043378+03:00 | Point | 24.7997863 | 60.3727437 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76659 | 6 | 2020-08-24T15:49:13.040933+03:00 | Point | 24.8001469 | 60.3730584 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76660 | 7 | 2020-08-24T15:49:13.038483+03:00 | Point | 24.799627 | 60.3721242 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76661 | 8 | 2020-08-24T15:49:13.036068+03:00 | Point | 24.8002033 | 60.3727264 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76662 | 9 | 2020-08-24T15:49:13.033613+03:00 | Point | 24.7983437 | 60.3715478 | 6753 | 2018-08-07T16:13:05.040235+03:00 | vantaa | Jukolantie | Jukolavägen | |||
| 76663 | 1 | 2020-08-24T15:49:13.065274+03:00 | Point | 24.8005651 | 60.3728436 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 76664 | 2 | 2020-08-24T15:49:13.062783+03:00 | Point | 24.8010161 | 60.3731943 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 76665 | 3 | 2020-08-24T15:49:13.060415+03:00 | Point | 24.8013618 | 60.3729794 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 76666 | 4 | 2020-08-24T15:49:13.058026+03:00 | Point | 24.8016315 | 60.3733298 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 76667 | 5 | 2020-08-24T15:49:13.055667+03:00 | Point | 24.8018323 | 60.3730968 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 76668 | 7 | 2018-08-07T16:13:08.813642+03:00 | Point | 24.8023569 | 60.3732771 | 6754 | 2018-08-07T16:13:05.045437+03:00 | vantaa | Jukolankuja | Jukolagränden | |||
| 77446 | 1 | 2020-08-24T15:49:14.866419+03:00 | Point | 24.799492 | 60.3734433 | 6814 | 2018-08-07T16:13:05.267408+03:00 | vantaa | Impivaarantie | Impivaaravägen | |||
| 77447 | 2 | 2020-08-24T15:49:14.863933+03:00 | Point | 24.7990227 | 60.3731195 | 6814 | 2018-08-07T16:13:05.267408+03:00 | vantaa | Impivaarantie | Impivaaravägen | |||
| 77448 | 3 | 2020-08-24T15:49:14.861039+03:00 | Point | 24.7984969 | 60.3731456 | 6814 | 2018-08-07T16:13:05.267408+03:00 | vantaa | Impivaarantie | Impivaaravägen | |||
| 77449 | 4 | 2020-08-24T15:49:14.858657+03:00 | Point | 24.7983545 | 60.3727236 | 6814 | 2018-08-07T16:13:05.267408+03:00 | vantaa | Impivaarantie | Impivaaravägen | |||
| 77450 | 5 | 2020-08-24T15:49:14.856263+03:00 | Point | 24.7978833 | 60.3727229 | 6814 | 2018-08-07T16:13:05.267408+03:00 | vantaa | Impivaarantie | Impivaaravägen | |||
| 125853 | 3 | 2019-04-25T11:36:55.867680+03:00 | Point | 24.9351625 | 60.0909266 | 11531 | 2019-04-25T11:36:31.285371+03:00 | helsinki | Ulkokari | Ytterskär | |||
| 296 | 1 | 2018-08-07T16:12:37.385056+03:00 | Point | 24.9327139 | 60.1725306 | 30 | 2018-08-07T16:12:22.671619+03:00 | helsinki | Ainonkatu | Ainogatan | 00100 | ||
| 297 | 2 | 2018-08-07T16:12:26.161512+03:00 | Point | 24.9324634 | 60.1716868 | 30 | 2018-08-07T16:12:22.671619+03:00 | helsinki | Ainonkatu | Ainogatan | 00100 | ||
| 298 | 3 | 2018-08-07T16:12:37.385179+03:00 | Point | 24.9312736 | 60.172099 | 30 | 2018-08-07T16:12:22.671619+03:00 | helsinki | Ainonkatu | Ainogatan | 00100 | ||
| 299 | 4 | 2018-08-07T16:12:26.161676+03:00 | Point | 24.9319771 | 60.1716147 | 30 | 2018-08-07T16:12:22.671619+03:00 | helsinki | Ainonkatu | Ainogatan | 00100 | ||
| 712 | 1 | 2018-08-07T16:12:37.475611+03:00 | Point | 24.9389245 | 60.1749928 | 59 | 2018-08-07T16:12:22.738586+03:00 | helsinki | Alvar Aallon katu | Alvar Aaltos gata | 00100 | ||
| 713 | 3 | 2018-08-07T16:12:26.184107+03:00 | Point | 24.9384725 | 60.1758094 | 59 | 2018-08-07T16:12:22.738586+03:00 | helsinki | Alvar Aallon katu | Alvar Aaltos gata | 00100 |
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 );