address
126,220 rows sorted by street_name_fi
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125564 | 1 | 2018-11-14T12:13:01.815504+02:00 | Point | 24.9631943 | 60.2056169 | 11421 | 2018-11-14T12:12:42.276898+02:00 | helsinki | A.I. Virtasen aukio | A.I. Virtanens plats | 00560 | ||
| 508 | 1 | a | 2018-08-07T16:12:26.173000+03:00 | Point | 24.9593226 | 60.1867046 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | |
| 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 | |
| 510 | 10 | 2018-08-07T16:12:26.172409+03:00 | Point | 24.95561 | 60.1866137 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 511 | 11 | 2018-08-07T16:12:26.172524+03:00 | Point | 24.9549968 | 60.1869007 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 512 | 13 | 2018-08-07T16:12:26.172672+03:00 | Point | 24.9543301 | 60.1868287 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 513 | 15 | 2018-08-07T16:12:26.172835+03:00 | Point | 24.95388 | 60.1864336 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 514 | 17 | 2018-08-07T16:12:37.444053+03:00 | Point | 24.9539164 | 60.1862002 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 515 | 2 | 2018-08-07T16:12:26.173164+03:00 | Point | 24.9589985 | 60.1864263 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 516 | 3 | 2018-08-07T16:12:37.444352+03:00 | Point | 24.958115 | 60.1867043 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 517 | 4 | 2018-08-07T16:12:26.173325+03:00 | Point | 24.9583137 | 60.1864081 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 518 | 5 | a | 2018-08-07T16:12:37.444472+03:00 | Point | 24.9573037 | 60.1869284 | 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 | |
| 520 | 6 | 2018-08-07T16:12:37.444615+03:00 | Point | 24.9575748 | 60.186381 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 521 | 7 | 2018-08-07T16:12:26.173706+03:00 | Point | 24.9565286 | 60.1870089 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 522 | 9 | 2018-08-07T16:12:37.444741+03:00 | Point | 24.9559699 | 60.1870087 | 50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan | 00500 | ||
| 84414 | 1 | 2018-08-07T16:13:14.544833+03:00 | Point | 24.6340711 | 60.1520361 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84415 | 10 | 2018-08-07T16:13:15.138403+03:00 | Point | 24.6357108 | 60.1502904 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84416 | 12 | 2018-08-07T16:13:15.138518+03:00 | Point | 24.6354617 | 60.1500294 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84417 | 14 | 2020-08-24T15:49:31.154917+03:00 | Point | 24.6350446 | 60.1502975 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84418 | 16 | 2018-08-07T16:13:19.518406+03:00 | Point | 24.6354184 | 60.1506845 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84419 | 2 | 2018-08-07T16:13:19.815855+03:00 | Point | 24.6345019 | 60.152154 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84420 | 3 | 2018-08-07T16:13:09.605042+03:00 | Point | 24.6345279 | 60.151436 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84421 | 4 | 2018-08-07T16:13:14.545068+03:00 | Point | 24.6347563 | 60.1519482 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84422 | 6 | 2018-08-07T16:13:09.653776+03:00 | Point | 24.6358664 | 60.1508742 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 84423 | 8 | 2018-08-07T16:13:09.584995+03:00 | Point | 24.6356705 | 60.1506762 | 7366 | 2018-08-07T16:13:07.334952+03:00 | espoo | Aallokko | Vågsvallet | 02320 | ||
| 42529 | 1 | 2018-08-07T16:12:47.830405+03:00 | Point | 24.9791684 | 60.1823203 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 42530 | 11 | 2020-03-03T09:11:31.996296+02:00 | Point | 24.9781608 | 60.1801032 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 42531 | 3 | 2018-08-07T16:12:47.830278+03:00 | Point | 24.9790605 | 60.1820599 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 42532 | 5 | 2018-08-07T16:12:42.459785+03:00 | Point | 24.9788805 | 60.1817009 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 42533 | 7 | 2018-08-07T16:12:42.459902+03:00 | Point | 24.9787185 | 60.1813508 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 42534 | 9 | 2018-08-07T16:12:43.274235+03:00 | Point | 24.9784666 | 60.1807764 | 3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren | 00540 | ||
| 85567 | 10 | 2018-08-07T16:13:14.547907+03:00 | Point | 24.6391655 | 60.1521039 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85568 | 11 | 2018-08-07T16:13:24.909628+03:00 | Point | 24.6405665 | 60.1524129 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85569 | 12 | 2018-08-07T16:13:27.313381+03:00 | Point | 24.6393972 | 60.15232 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85570 | 14 | 2018-08-07T16:13:14.548745+03:00 | Point | 24.6403661 | 60.1526278 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85571 | 2 | 2018-08-07T16:13:15.143402+03:00 | Point | 24.6385165 | 60.1505494 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85572 | 3 | 2018-08-07T16:13:14.734622+03:00 | Point | 24.6380054 | 60.1511852 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85573 | 4 | 2018-08-07T16:13:25.093028+03:00 | Point | 24.6378822 | 60.1509246 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85574 | 5 | 2018-08-07T16:13:09.605160+03:00 | Point | 24.6387747 | 60.1516272 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85575 | 6 | 2018-08-07T16:13:25.238874+03:00 | Point | 24.6376249 | 60.1513996 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85576 | 7 | 2018-08-07T16:13:15.223306+03:00 | Point | 24.6394015 | 60.1519251 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85577 | 8 | 2018-08-07T16:13:14.547792+03:00 | Point | 24.638413 | 60.1517698 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85578 | 9 | 2018-08-07T16:13:14.548029+03:00 | Point | 24.6400286 | 60.152205 | 7457 | 2018-08-07T16:13:07.420796+03:00 | espoo | Aallonhuippu | Vågtoppen | 02320 | ||
| 85470 | 1 | 2018-08-07T16:13:14.519182+03:00 | Point | 24.6404876 | 60.1480954 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 85471 | 2 | 2018-08-07T16:13:25.201678+03:00 | Point | 24.6393022 | 60.1478409 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 85472 | 3 | 2018-08-07T16:13:24.356800+03:00 | Point | 24.6409714 | 60.1483032 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 85473 | 4 | 2018-08-07T16:13:14.554632+03:00 | Point | 24.639947 | 60.1481478 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 85474 | 6 | 2018-08-07T16:13:19.887945+03:00 | Point | 24.6406995 | 60.148473 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 85475 | 8 | 2018-08-07T16:13:09.601821+03:00 | Point | 24.6411459 | 60.1488063 | 7447 | 2018-08-07T16:13:07.410042+03:00 | espoo | Aallonkohina | Vågbruset | 02320 | ||
| 115204 | 1 | 2018-08-07T16:13:15.139115+03:00 | Point | 24.6375048 | 60.1492272 | 9859 | 2018-08-07T16:13:13.637737+03:00 | espoo | Aallonmerkki | Vågmärket | 02320 | ||
| 115205 | 2 | 2018-08-07T16:13:19.677356+03:00 | Point | 24.6373754 | 60.149532 | 9859 | 2018-08-07T16:13:13.637737+03:00 | espoo | Aallonmerkki | Vågmärket | 02320 | ||
| 115206 | 4 | 2018-08-07T16:13:25.205465+03:00 | Point | 24.6379483 | 60.1498298 | 9859 | 2018-08-07T16:13:13.637737+03:00 | espoo | Aallonmerkki | Vågmärket | 02320 | ||
| 84708 | 1 | 2018-08-07T16:13:25.169847+03:00 | Point | 24.6402516 | 60.1532198 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 84709 | 2 | 2018-08-07T16:13:24.156807+03:00 | Point | 24.6397117 | 60.1532004 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 84710 | 3 | 2018-08-07T16:13:19.466135+03:00 | Point | 24.6391681 | 60.1535131 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 84711 | 4 | 2018-08-07T16:13:09.588301+03:00 | Point | 24.6390617 | 60.1533602 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 84712 | 5 | 2018-08-07T16:13:09.591070+03:00 | Point | 24.6383062 | 60.1533043 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 84713 | 6 | 2018-08-07T16:13:20.051075+03:00 | Point | 24.6382367 | 60.1530707 | 7386 | 2018-08-07T16:13:07.351185+03:00 | espoo | Aallontaite | Vågbrottet | 02320 | ||
| 82799 | 1 | 2020-08-24T15:49:27.358811+03:00 | Point | 25.1040259 | 60.3171265 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82800 | 10 | 2020-08-24T15:49:27.332404+03:00 | Point | 25.10497 | 60.3181131 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82801 | 11 | 2018-08-07T16:13:09.551802+03:00 | Point | 25.1056397 | 60.3181844 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82802 | 12 | 2020-08-24T15:49:27.327336+03:00 | Point | 25.1053324 | 60.3182654 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82803 | 13 | 2020-08-24T15:49:27.322941+03:00 | Point | 25.1058935 | 60.3183278 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82804 | 14 | 2018-08-07T16:13:09.551445+03:00 | Point | 25.1056409 | 60.3185344 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82805 | 15 | 2018-08-07T16:13:09.551332+03:00 | Point | 25.1060752 | 60.318534 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82806 | 2 | 2020-08-24T15:49:27.356330+03:00 | Point | 25.1037733 | 60.3173421 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82807 | 3 | 2020-08-24T15:49:27.353908+03:00 | Point | 25.1042257 | 60.3173508 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82808 | 4 | 2020-08-24T15:49:27.351317+03:00 | Point | 25.103991 | 60.3175394 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82809 | 5 | 2018-08-07T16:13:09.552501+03:00 | Point | 25.1045518 | 60.3174851 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82810 | 6 | 2020-08-24T15:49:27.347547+03:00 | Point | 25.1042088 | 60.3177547 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82811 | 7 | 2020-08-24T15:49:27.341786+03:00 | Point | 25.1048967 | 60.317817 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82812 | 8 | 2020-08-24T15:49:27.337556+03:00 | Point | 25.10468 | 60.3179787 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 82813 | 9 | 2018-08-07T16:13:09.552030+03:00 | Point | 25.1052953 | 60.3179961 | 7240 | 2018-08-07T16:13:06.929283+03:00 | vantaa | Aallottarentie | Aallotarvägen | 01420 | ||
| 110553 | 1 | 2018-08-07T16:13:14.297543+03:00 | Point | 24.6401566 | 60.1503833 | 9206 | 2018-08-07T16:13:11.449465+03:00 | espoo | Aalto | Vågen | 02320 | ||
| 110554 | 3 | 2018-08-07T16:13:24.755473+03:00 | Point | 24.6393309 | 60.1501567 | 9206 | 2018-08-07T16:13:11.449465+03:00 | espoo | Aalto | Vågen | 02320 | ||
| 110555 | 4 | 2018-08-07T16:13:15.139465+03:00 | Point | 24.639425 | 60.14978 | 9206 | 2018-08-07T16:13:11.449465+03:00 | espoo | Aalto | Vågen | 02320 | ||
| 110556 | 6 | 2018-08-07T16:13:15.323885+03:00 | Point | 24.6390299 | 60.1496981 | 9206 | 2018-08-07T16:13:11.449465+03:00 | espoo | Aalto | Vågen | 02320 | ||
| 523 | 1 | 2018-08-07T16:12:26.174034+03:00 | Point | 25.0103581 | 60.285188 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 524 | 10 | 2018-08-07T16:12:26.173871+03:00 | Point | 25.0094361 | 60.2850714 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 525 | 12 | 2018-08-07T16:12:37.444868+03:00 | Point | 25.0091469 | 60.2850714 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 526 | 14 | 2018-08-07T16:12:26.174194+03:00 | Point | 25.00893 | 60.2850714 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 527 | 18 | 2018-08-07T16:12:37.445049+03:00 | Point | 25.0088939 | 60.2851701 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 528 | 2 | 2018-08-07T16:12:37.445192+03:00 | Point | 25.010575 | 60.2850264 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 529 | 20 | 2018-08-07T16:12:26.174355+03:00 | Point | 25.0089481 | 60.285233 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 530 | 22 | 2018-08-07T16:12:26.174515+03:00 | Point | 25.0090928 | 60.2854125 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 531 | 24 | 2018-08-07T16:12:37.445339+03:00 | Point | 25.009382 | 60.2854394 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 532 | 26 | 2018-08-07T16:12:26.174732+03:00 | Point | 25.0095809 | 60.2855471 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 533 | 3 | 2018-08-07T16:12:37.445513+03:00 | Point | 25.010105 | 60.285206 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 534 | 4 | 2018-08-07T16:12:26.174857+03:00 | Point | 25.0103581 | 60.2850444 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 535 | 6 | 2018-08-07T16:12:37.445661+03:00 | Point | 25.0099965 | 60.2850713 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 536 | 7 | 2018-08-07T16:12:26.174974+03:00 | Point | 25.0097616 | 60.2853945 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 537 | 8 | 2018-08-07T16:12:37.445782+03:00 | Point | 25.0097073 | 60.2850714 | 51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden | 00740 | ||
| 110092 | 1 | 2018-08-07T16:13:14.499227+03:00 | Point | 24.7444174 | 60.1705869 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | ||
| 110093 | 2 | 2018-08-07T16:13:14.278440+03:00 | Point | 24.7444518 | 60.1707934 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | ||
| 110094 | 3 | 2018-08-07T16:13:24.852142+03:00 | Point | 24.7453901 | 60.1705978 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | ||
| 110095 | 4 | 2018-08-07T16:13:14.478802+03:00 | Point | 24.7459468 | 60.1708232 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | ||
| 110096 | 5 | a | 2018-08-07T16:13:19.331145+03:00 | Point | 24.7458787 | 60.1703115 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | |
| 110097 | 5 | b | 2018-08-07T16:13:14.498758+03:00 | Point | 24.7459859 | 60.1704284 | 9164 | 2018-08-07T16:13:11.382319+03:00 | espoo | Aamukuja | Morgongränden | 02200 | |
| 90175 | 1 | 2018-08-07T16:13:25.132111+03:00 | Point | 24.7423074 | 60.1685903 | 7780 | 2018-08-07T16:13:07.757386+03:00 | espoo | Aamupäivänkuja | Förmiddagsgränden | 02210 |
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 );