Helsinki osoiteluettelo

Tables

• Helsinki Osoiteluettelopoint, Avoindatahelsinki OsoiteluetteloTSV

  No description available for layer avoindata:Helsinki_osoiteluettelo (Helsinki_osoiteluettelo)

Column Descriptions

Helsinki Osoiteluettelopoint, Avoindatahelsinki Osoiteluettelo

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 53941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6719 and maximum value is 293527.
katunimi	string	Data source did not contain a description for katunimi. Column katunimi has 53941 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 Naulakalliontie.
gatan	string	Data source did not contain a description for gatan. Column gatan has 53941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A.I. Virtanens plats and maximum string is Spikbergsvägen.
osoitenume	int	Data source did not contain a description for osoitenume. Column osoitenume has 53941 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	string	Data source did not contain a description for osoitenum0. Column osoitenum0 has 53941 rows, out of which 53600 are empty, making the null percent 99.37. Minimum string is and maximum string is 9.
osoitekirj	string	Data source did not contain a description for osoitekirj. Column osoitekirj has 53941 rows, out of which 47374 are empty, making the null percent 87.83. Minimum string is and maximum string is e.
n	int	Data source did not contain a description for n. Column n has 53941 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 6687221.
e	int	Data source did not contain a description for e. Column e has 53941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25490382 and maximum value is 25513658.
kaupunki	string	Data source did not contain a description for kaupunki. Column kaupunki has 53941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki.
staden	string	Data source did not contain a description for staden. Column staden has 53941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsingfors.
tyyppi	int	Data source did not contain a description for tyyppi. Column tyyppi has 53941 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.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 53941 rows, out of which 599 are empty, making the null percent 1.11. Minimum value is 100 and maximum value is 990.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 53941 rows, out of which 199 are empty, making the null percent 0.37. The single string value is: .
osoitenum1	int	Data source did not contain a description for osoitenum1. Column osoitenum1 has 53941 rows, out of which 6901 are empty, making the null percent 12.79. Minimum value is 0 and maximum value is 924.
datanomist	string	Data source did not contain a description for datanomist. Column is empty.
paivitetty	string	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	August 7, 2018