address
126,220 rows sorted by location_coordinates_1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117630 | 2 | 2018-08-07T16:13:24.243489+03:00 | Point | 24.6594229 | 60.0769421 | 10344 | 2018-08-07T16:13:21.717079+03:00 | espoo | Herrökobben | Herrökobben | 02380 | ||
111425 | 200 | 2018-08-07T16:13:14.329975+03:00 | Point | 24.6560664 | 60.0801467 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111424 | 182 | 2018-08-07T16:13:24.822206+03:00 | Point | 24.6571549 | 60.0808496 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111423 | 170 | 2018-08-07T16:13:24.890706+03:00 | Point | 24.6580441 | 60.0817315 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111421 | 142 | 2018-08-07T16:13:25.392883+03:00 | Point | 24.6608087 | 60.0819361 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
117385 | 40 | 2018-08-07T16:13:24.083981+03:00 | Point | 24.6665198 | 60.0821301 | 10301 | 2018-08-07T16:13:21.372788+03:00 | espoo | Herrön Träskholm | Herrö Träskholm | 02380 | ||
111420 | 112 | 2018-08-07T16:13:24.836877+03:00 | Point | 24.6631366 | 60.082687 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
117386 | 54 | 2018-08-07T16:13:27.254504+03:00 | Point | 24.6678779 | 60.0828605 | 10301 | 2018-08-07T16:13:21.372788+03:00 | espoo | Herrön Träskholm | Herrö Träskholm | 02380 | ||
111422 | 160 | 2018-08-07T16:13:14.870239+03:00 | Point | 24.6580322 | 60.0828803 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111436 | 94 | 2018-08-07T16:13:14.330206+03:00 | Point | 24.6645634 | 60.0837138 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111428 | 374 | 2018-08-07T16:13:24.925605+03:00 | Point | 24.6579855 | 60.0839214 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111426 | 366 | 2018-08-07T16:13:25.298170+03:00 | Point | 24.6572089 | 60.0843053 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111427 | 370 | 2018-08-07T16:13:25.245777+03:00 | Point | 24.6579426 | 60.0845945 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111429 | 380 | 2018-08-07T16:13:27.322405+03:00 | Point | 24.6587857 | 60.0847223 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111430 | 386 | 2018-08-07T16:13:24.984173+03:00 | Point | 24.65934 | 60.084984 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111570 | 66 | 2018-08-07T16:13:14.335339+03:00 | Point | 24.6514841 | 60.0853764 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111431 | 400 | 2018-08-07T16:13:25.103842+03:00 | Point | 24.6599254 | 60.0857126 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111569 | 58 | 2018-08-07T16:13:25.063896+03:00 | Point | 24.6528981 | 60.0858918 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111568 | 52 | 2018-08-07T16:13:25.043855+03:00 | Point | 24.6542074 | 60.0861196 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111435 | 56 | 2018-08-07T16:13:27.218027+03:00 | Point | 24.6685087 | 60.086237 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111567 | 44 | 2018-08-07T16:13:25.043493+03:00 | Point | 24.6552641 | 60.0864455 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111432 | 410 | 2018-08-07T16:13:24.821964+03:00 | Point | 24.6608697 | 60.0864869 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111559 | 102 | 2018-08-07T16:13:25.131379+03:00 | Point | 24.6500334 | 60.0866292 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111560 | 108 | 2018-08-07T16:13:27.315041+03:00 | Point | 24.6502965 | 60.0872313 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111566 | 30 | 2018-08-07T16:13:25.210897+03:00 | Point | 24.6556688 | 60.0872633 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111433 | 430 | 2018-08-07T16:13:25.150042+03:00 | Point | 24.6632684 | 60.0873816 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
111565 | 24 | 2018-08-07T16:13:27.215017+03:00 | Point | 24.6559314 | 60.0879282 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111561 | 116 | 2018-08-07T16:13:14.335456+03:00 | Point | 24.6508437 | 60.0881662 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111564 | 20 | 2018-08-07T16:13:25.030792+03:00 | Point | 24.6559823 | 60.0882155 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111562 | 130 | 2018-08-07T16:13:25.044477+03:00 | Point | 24.6520044 | 60.0888604 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111563 | 2 | 2018-08-07T16:13:25.095535+03:00 | Point | 24.6557388 | 60.0891663 | 9309 | 2018-08-07T16:13:11.595465+03:00 | espoo | Lilla Herrö | Lilla Herrö | 02380 | ||
111434 | 450 | 2018-08-07T16:13:24.200258+03:00 | Point | 24.6668249 | 60.0892845 | 9299 | 2018-08-07T16:13:11.577144+03:00 | espoo | Stora Herrö | Stora Herrö | 02380 | ||
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 | |||
118184 | 10 | 2018-08-07T16:13:24.941882+03:00 | Point | 24.6455052 | 60.0916704 | 10479 | 2018-08-07T16:13:23.164499+03:00 | espoo | Brudholmen | Brudholmen | 02380 | ||
109596 | 300 | 2018-08-07T16:13:25.089517+03:00 | Point | 24.6508395 | 60.0936593 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109594 | 280 | 2018-08-07T16:13:14.265138+03:00 | Point | 24.6536542 | 60.0943219 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109598 | 346 | 2018-08-07T16:13:20.153279+03:00 | Point | 24.6519158 | 60.0955559 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
115536 | 40 | 2018-08-07T16:13:15.296107+03:00 | Point | 24.7290895 | 60.0959159 | 9926 | 2018-08-07T16:13:13.987589+03:00 | espoo | Alskär | Alskär | 02380 | ||
109599 | 366 | 2018-08-07T16:13:20.153155+03:00 | Point | 24.6543184 | 60.0961098 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109600 | 370 | 2018-08-07T16:13:14.268473+03:00 | Point | 24.655251 | 60.0963007 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109593 | 240 | 2018-08-07T16:13:20.219163+03:00 | Point | 24.659978 | 60.0963039 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110462 | 100 | 2018-08-07T16:13:15.291692+03:00 | Point | 24.765049 | 60.0966219 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109592 | 218 | 2018-08-07T16:13:20.219286+03:00 | Point | 24.6650424 | 60.0967118 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110476 | 70 | 2018-08-07T16:13:14.501918+03:00 | Point | 24.7683006 | 60.096852 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109601 | 374 | 2018-08-07T16:13:14.268342+03:00 | Point | 24.6554599 | 60.0969564 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
115535 | 2 | 2018-08-07T16:13:24.104906+03:00 | Point | 24.7305904 | 60.0969961 | 9926 | 2018-08-07T16:13:13.987589+03:00 | espoo | Alskär | Alskär | 02380 | ||
110475 | 66 | 2018-08-07T16:13:14.295081+03:00 | Point | 24.7689801 | 60.0973558 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109602 | 382 | 2018-08-07T16:13:24.527111+03:00 | Point | 24.6552213 | 60.0974225 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110463 | 118 | 2018-08-07T16:13:24.636307+03:00 | Point | 24.7645931 | 60.0975456 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110464 | 120 | 2018-08-07T16:13:25.032007+03:00 | Point | 24.7652401 | 60.0975467 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110722 | 42 | 2018-08-07T16:13:25.376614+03:00 | Point | 24.6837263 | 60.0976373 | 9226 | 2018-08-07T16:13:11.477680+03:00 | espoo | Torraisarn | Torraisarn | 02380 | ||
110465 | 122 | 2018-08-07T16:13:15.292050+03:00 | Point | 24.7652388 | 60.0977352 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109603 | 388 | 2018-08-07T16:13:24.992273+03:00 | Point | 24.6556845 | 60.0978187 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110466 | 124 | 2018-08-07T16:13:19.104194+03:00 | Point | 24.7652736 | 60.0978968 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109604 | 392 | 2020-08-24T15:49:42.048326+03:00 | Point | 24.6567975 | 60.0979562 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109591 | 200 | 2018-08-07T16:13:14.905503+03:00 | Point | 24.6673845 | 60.0979563 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110721 | 16 | 2018-08-07T16:13:14.304811+03:00 | Point | 24.6852504 | 60.0980269 | 9226 | 2018-08-07T16:13:11.477680+03:00 | espoo | Torraisarn | Torraisarn | 02380 | ||
110467 | 128 | 2018-08-07T16:13:15.292394+03:00 | Point | 24.765146 | 60.0981479 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110474 | 46 | 2018-08-07T16:13:19.577526+03:00 | Point | 24.7698717 | 60.0983716 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110723 | 52 | 2018-08-07T16:13:24.339895+03:00 | Point | 24.6838447 | 60.0984095 | 9226 | 2018-08-07T16:13:11.477680+03:00 | espoo | Torraisarn | Torraisarn | 02380 | ||
110473 | 38 | 2018-08-07T16:13:19.588168+03:00 | Point | 24.7692767 | 60.0986309 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109607 | 400 | 2018-08-07T16:13:24.240482+03:00 | Point | 24.6554242 | 60.0986527 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
109589 | 180 | 2018-08-07T16:13:25.257134+03:00 | Point | 24.6705048 | 60.0986822 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110724 | 56 | 2018-08-07T16:13:15.315534+03:00 | Point | 24.6840033 | 60.098742 | 9226 | 2018-08-07T16:13:11.477680+03:00 | espoo | Torraisarn | Torraisarn | 02380 | ||
110472 | 30 | 2018-08-07T16:13:15.291451+03:00 | Point | 24.7685568 | 60.0987643 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110469 | 16 | 2018-08-07T16:13:27.100944+03:00 | Point | 24.7657525 | 60.0988042 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
109608 | 404 | 2018-08-07T16:13:14.447481+03:00 | Point | 24.6560874 | 60.098834 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110471 | 24 | 2018-08-07T16:13:15.291575+03:00 | Point | 24.7676393 | 60.0988793 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110468 | 142 | 2018-08-07T16:13:15.292166+03:00 | Point | 24.7642231 | 60.0990079 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
110579 | 72 | 2018-08-07T16:13:15.289303+03:00 | Point | 24.7096851 | 60.0992317 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
110470 | 2 | 2018-08-07T16:13:15.330216+03:00 | Point | 24.7652634 | 60.0993329 | 9198 | 2018-08-07T16:13:11.439576+03:00 | espoo | Sumparen | Sumparen | 02380 | ||
115190 | 16 | 2018-08-07T16:13:19.776333+03:00 | Point | 24.730068 | 60.0993376 | 9854 | 2018-08-07T16:13:13.623324+03:00 | espoo | Tvijälp | Tvijälp | 02380 | ||
109971 | 10 | 2018-08-07T16:13:24.708876+03:00 | Point | 24.756633 | 60.0996494 | 9156 | 2018-08-07T16:13:11.374889+03:00 | espoo | Meriniemenpolku | Havsuddsstigen | 02380 | ||
109704 | 15 | 2018-08-07T16:13:14.267632+03:00 | Point | 24.7591134 | 60.0996719 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
115193 | 8 | 2018-08-07T16:13:15.265943+03:00 | Point | 24.7302441 | 60.0997868 | 9854 | 2018-08-07T16:13:13.623324+03:00 | espoo | Tvijälp | Tvijälp | 02380 | ||
109712 | 23 | 2018-08-07T16:13:20.143406+03:00 | Point | 24.7629413 | 60.0997955 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
109609 | 408 | 2018-08-07T16:13:24.681870+03:00 | Point | 24.6555378 | 60.0998199 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
115192 | 40 | 2018-08-07T16:13:19.328679+03:00 | Point | 24.7266666 | 60.0998333 | 9854 | 2018-08-07T16:13:13.623324+03:00 | espoo | Tvijälp | Tvijälp | 02380 | ||
109711 | 22 | 2018-08-07T16:13:24.338184+03:00 | Point | 24.7635161 | 60.0998504 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
110581 | 78 | 2018-08-07T16:13:27.083526+03:00 | Point | 24.7090311 | 60.1000111 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
115191 | 2 | 2018-08-07T16:13:15.133911+03:00 | Point | 24.7304935 | 60.1000565 | 9854 | 2018-08-07T16:13:13.623324+03:00 | espoo | Tvijälp | Tvijälp | 02380 | ||
110578 | 70 | 2018-08-07T16:13:14.482824+03:00 | Point | 24.7105039 | 60.100149 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109978 | 9 | 2018-08-07T16:13:27.289251+03:00 | Point | 24.755353 | 60.1001497 | 9156 | 2018-08-07T16:13:11.374889+03:00 | espoo | Meriniemenpolku | Havsuddsstigen | 02380 | ||
110577 | 64 | 2018-08-07T16:13:15.301520+03:00 | Point | 24.7110965 | 60.1002131 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109710 | 21 | 2018-08-07T16:13:20.143644+03:00 | Point | 24.7618412 | 60.1002872 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
109977 | 8 | 2018-08-07T16:13:20.253525+03:00 | Point | 24.7556754 | 60.1003029 | 9156 | 2018-08-07T16:13:11.374889+03:00 | espoo | Meriniemenpolku | Havsuddsstigen | 02380 | ||
109709 | 20 | 2018-08-07T16:13:24.568595+03:00 | Point | 24.7638361 | 60.1003446 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
110576 | 58 | 2018-08-07T16:13:20.024703+03:00 | Point | 24.7117962 | 60.1003672 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109706 | 17 | 2018-08-07T16:13:24.472064+03:00 | Point | 24.7604025 | 60.1003833 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
109703 | 14 | 2018-08-07T16:13:14.681693+03:00 | Point | 24.7616066 | 60.1004214 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
110580 | 76 | 2018-08-07T16:13:15.301287+03:00 | Point | 24.7099441 | 60.1004439 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109588 | 134 | 2018-08-07T16:13:27.132465+03:00 | Point | 24.6737748 | 60.100638 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110574 | 24 | 2018-08-07T16:13:24.451288+03:00 | Point | 24.7106071 | 60.1006787 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109975 | 6 | 2018-08-07T16:13:20.254080+03:00 | Point | 24.754953 | 60.1007593 | 9156 | 2018-08-07T16:13:11.374889+03:00 | espoo | Meriniemenpolku | Havsuddsstigen | 02380 | ||
110573 | 22 | 2018-08-07T16:13:14.937655+03:00 | Point | 24.7113788 | 60.100824 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109976 | 7 | 2018-08-07T16:13:20.245692+03:00 | Point | 24.7541975 | 60.1008297 | 9156 | 2018-08-07T16:13:11.374889+03:00 | espoo | Meriniemenpolku | Havsuddsstigen | 02380 | ||
110572 | 20 | 2018-08-07T16:13:15.333788+03:00 | Point | 24.7108572 | 60.1008588 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 | ||
109705 | 16 | 2018-08-07T16:13:20.159626+03:00 | Point | 24.7627357 | 60.1008902 | 9135 | 2018-08-07T16:13:11.343011+03:00 | espoo | Ison Lehtisaaren polku | Storlövöstigen | 02380 | ||
109611 | 422 | 2018-08-07T16:13:25.276889+03:00 | Point | 24.6568029 | 60.1008912 | 9129 | 2018-08-07T16:13:11.333741+03:00 | espoo | Pentala | Pentala | 02380 | ||
110583 | 96 | 2018-08-07T16:13:20.114939+03:00 | Point | 24.7088974 | 60.1008994 | 9208 | 2018-08-07T16:13:11.451814+03:00 | espoo | Högkopplan | Högkopplan | 02380 |
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 );