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 53894 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 285584.
katunimi	string	Data source did not contain a description for katunimi. Column katunimi has 53894 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 Pertunpellonraitti.
gatan	string	Data source did not contain a description for gatan. Column gatan has 53894 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 Bertåkerstået.
osoitenume	int	Data source did not contain a description for osoitenume. Column osoitenume has 53894 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 53894 rows, out of which 53557 are empty, making the null percent 99.37. Minimum value is 2 and maximum value is 960.
osoitekirj	string	Data source did not contain a description for osoitekirj. Column osoitekirj has 53894 rows, out of which 47358 are empty, making the null percent 87.87. Minimum string is and maximum string is b.
n	int	Data source did not contain a description for n. Column n has 53894 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 53894 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 53894 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 53894 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 53894 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	string	Data source did not contain a description for postinumer. Column postinumer has 53894 rows, out of which 602 are empty, making the null percent 1.12. Minimum string is and maximum string is 00740.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 53894 rows, out of which 201 are empty, making the null percent 0.37. The single string value is: .
osoitenum1	string	Data source did not contain a description for osoitenum1. Column osoitenum1 has 53894 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.
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
tablename	avoindatahelsinki_osoiteluettelo__helsinki_osoiteluettelopoint_all_piped