To download the data set, please sign up or log in

PKS osoiteluettelo

PKS osoiteluettelo

Tables

Column Descriptions

Pks Osoiteluettelopoint, Avoindatapks Osoiteluettelo

Column Type Comment
id int Data source did not contain a description for id. Column id has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 135596.
katunimi string Data source did not contain a description for katunimi. Column katunimi has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A.I. Virtasen aukio and maximum string is Raatepolku.
gatan string Data source did not contain a description for gatan. Column gatan has 134252 rows, out of which 37 are empty, making the null percent 0.03. Minimum string is and maximum string is Vattenklöverstigen.
osoitenume int Data source did not contain a description for osoitenume. Column osoitenume has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 924.
osoitenum0 int Data source did not contain a description for osoitenum0. Column osoitenum0 has 134252 rows, out of which 133785 are empty, making the null percent 99.65. Minimum value is 2 and maximum value is 960.
osoitekirj string Data source did not contain a description for osoitekirj. Column osoitekirj has 134252 rows, out of which 113852 are empty, making the null percent 84.80. Minimum string is and maximum string is a.
n int Data source did not contain a description for n. Column n has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6659134 and maximum value is 6698505.
e int Data source did not contain a description for e. Column e has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25472568 and maximum value is 25513658.
kaupunki string Data source did not contain a description for kaupunki. Column kaupunki has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Vantaa.
staden string Data source did not contain a description for staden. Column staden has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Esbo and maximum string is Vanda.
tyyppi int Data source did not contain a description for tyyppi. Column tyyppi has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 22.
osoitenum1 string Data source did not contain a description for osoitenum1. Column osoitenum1 has 134252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is 10.
postinumer string Data source did not contain a description for postinumer. Column postinumer has 134252 rows, out of which 605 are empty, making the null percent 0.45. Minimum string is and maximum string is 02970.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 134252 rows, out of which 204 are empty, making the null percent 0.15. Minimum string is and maximum string is ESPOO.
datanomist string Data source did not contain a description for datanomist. Column is empty.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created June 12, 2018