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

Osoitteet

Osoitteet

Tables

Column Descriptions

Osoitteet, Gisosoitteet

Column Type Comment
katunimi string Data source did not contain a description for katunimi. Column katunimi has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Virtapuistonkenttä and maximum string is Övre-Thors.
katunimi_r string Data source did not contain a description for katunimi_r. Column katunimi_r has 40825 rows, out of which 37 are empty, making the null percent 0.09. Minimum string is Oljevägen and maximum string is Övre-Thors.
osoitenume int Data source did not contain a description for osoitenume. Column osoitenume has 40825 rows, out of which 45 are empty, making the null percent 0.11. Minimum value is 0 and maximum value is 900.
osoitenum0 string Data source did not contain a description for osoitenum0. Column osoitenum0 has 40825 rows, out of which 40754 are empty, making the null percent 99.83. Minimum string is and maximum string is 9.
kirjain string Data source did not contain a description for kirjain. Column kirjain has 40825 rows, out of which 32014 are empty, making the null percent 78.42. Minimum string is and maximum string is p.
osoiteteks string Data source did not contain a description for osoiteteks. Column osoiteteks has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Öljytie 10 and maximum string is Övre-Thors 0.
osoitetek0 string Data source did not contain a description for osoitetek0. Column osoitetek0 has 40825 rows, out of which 6 are empty, making the null percent 0.01. Minimum string is Oljevägen 10 and maximum string is Övre-Thors 0.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (24.891917645209983... and first 25 characters of maximum string: POINT (25.191978895992094...
geom_center_x double Longitude of the centroid of the geometry. Column is empty.
geom_center_y double Latitude of the centroid of the geometry. Column is empty.
geom_type string Geometry type. Column geom_type has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created October 22, 2018