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

Osoiteluettelo piste rekisteritiedot

Osoiteluettelo piste rekisteritiedot

Tables

Column Descriptions

Osoiteluettelo Piste Rekisteritiedotpoint, Avoindataosoiteluettelo Piste Rekisteritiedot

Column Type Comment
id int Data source did not contain a description for id. Column id has 51252 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 61167.
nimisto_id float Data source did not contain a description for nimisto_id. Column nimisto_id has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5.00 and maximum value is 6026641.00.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 51252 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 Katontekijänaukio.
adress string Data source did not contain a description for adress. Column adress has 51252 rows, out of which 3 are empty, making the null percent 0.01. Minimum string is and maximum string is Takläggarplatsen.
katunimi string Data source did not contain a description for katunimi. Column katunimi has 51252 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 Katontekijänaukio.
gatan string Data source did not contain a description for gatan. Column gatan has 51252 rows, out of which 3 are empty, making the null percent 0.01. Minimum string is and maximum string is Takläggarplatsen.
osoitenume string Data source did not contain a description for osoitenume. Column osoitenume has 51252 rows, out of which 4976 are empty, making the null percent 9.71. Minimum string is and maximum string is 2-4.
nimistokoh int Data source did not contain a description for nimistokoh. Column nimistokoh has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 81.
nimistoko0 string Data source did not contain a description for nimistoko0. Column nimistoko0 has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asuntoalue, huvila-alue, ... and first 25 characters of maximum string: Tori, katuaukio, aukio...
olotila string Data source did not contain a description for olotila. Column olotila has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Luonnosteltu and maximum string is Voimassa.
kunta string Data source did not contain a description for kunta. Column kunta has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 091.
kaupungino int Data source did not contain a description for kaupungino. Column kaupungino has 51252 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 59.
kaupungin0 string Data source did not contain a description for kaupungin0. Column kaupungin0 has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALPPIHARJU and maximum string is MALMI.
kaupungin1 string Data source did not contain a description for kaupungin1. Column kaupungin1 has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is BAGGBÖLE and maximum string is MALM.
postinumer string Data source did not contain a description for postinumer. Column postinumer has 51252 rows, out of which 5 are empty, making the null percent 0.01. Minimum string is and maximum string is 00700.
n int Data source did not contain a description for n. Column n has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6664205 and maximum value is 6687039.
e int Data source did not contain a description for e. Column e has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25490549 and maximum value is 25513654.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 51252 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki/FACTA.
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 August 7, 2018