1. Home
  2. Datasets
  3. Puurekisteri piste
To download the data set, please sign up or log in

Puurekisteri piste

No description available for layer avoindata:Puurekisteri_piste (Puurekisteri_piste)

Tables

Column Descriptions

Puurekisteri pistepoint, Avoindatapuurekisteri piste, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2 and maximum value is 89855.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is K-1 and maximum string is P-99276-99.
kadunnimi string Data source did not contain a description for kadunnimi. Column kadunnimi has 53186 rows, out of which 27228 are empty, making the null percent 51.19. Minimum string is and maximum string is YRTTIMAANTIE.
puistonnim string Data source did not contain a description for puistonnim. Column puistonnim has 53186 rows, out of which 26402 are empty, making the null percent 49.64. Minimum string is and maximum string is YRTTIPUISTO.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Katu and maximum string is Puisto.
suomenknim string Data source did not contain a description for suomenknim. Column suomenknim has 53186 rows, out of which 6 are empty, making the null percent 0.01. Minimum string is and maximum string is VUORIVAAHTERALAJIKE.
suku string Data source did not contain a description for suku. Column suku has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Abelia and maximum string is Zelkova.
laji string Data source did not contain a description for laji. Column laji has 53186 rows, out of which 1 are empty, making the null percent 0. Minimum string is and maximum string is x yedoensis.
kokoluokka string Data source did not contain a description for kokoluokka. Column kokoluokka has 53186 rows, out of which 3807 are empty, making the null percent 7.16. Minimum string is and maximum string is 70 cm -.
istutusvuo int Data source did not contain a description for istutusvuo. Column istutusvuo has 53186 rows, out of which 40599 are empty, making the null percent 76.33. Minimum value is 0 and maximum value is 20100.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/MAKA.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.83361235298313 ... and first 25 characters of maximum string: POINT (25.183705645228745...
geom_center_x float Longitude of center. Column geom_center_x has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.83 and maximum value is 25.18.
geom_center_y float Latitude of center. Column geom_center_y has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Puurekisteri pistepoint, Avoindatapuurekisteri piste, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2 and maximum value is 89855.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is K-1 and maximum string is P-99276-99.
kadunnimi string Data source did not contain a description for kadunnimi. Column kadunnimi has 53186 rows, out of which 27228 are empty, making the null percent 51.19. Minimum string is and maximum string is YRTTIMAANTIE.
puistonnim string Data source did not contain a description for puistonnim. Column puistonnim has 53186 rows, out of which 26402 are empty, making the null percent 49.64. Minimum string is and maximum string is YRTTIPUISTO.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Katu and maximum string is Puisto.
suomenknim string Data source did not contain a description for suomenknim. Column suomenknim has 53186 rows, out of which 6 are empty, making the null percent 0.01. Minimum string is and maximum string is VUORIVAAHTERALAJIKE.
suku string Data source did not contain a description for suku. Column suku has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Abelia and maximum string is Zelkova.
laji string Data source did not contain a description for laji. Column laji has 53186 rows, out of which 1 are empty, making the null percent 0. Minimum string is and maximum string is x yedoensis.
kokoluokka string Data source did not contain a description for kokoluokka. Column kokoluokka has 53186 rows, out of which 3807 are empty, making the null percent 7.16. Minimum string is and maximum string is 70 cm -.
istutusvuo int Data source did not contain a description for istutusvuo. Column istutusvuo has 53186 rows, out of which 40599 are empty, making the null percent 76.33. Minimum value is 0 and maximum value is 20100.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/MAKA.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.83361235298313 ... and first 25 characters of maximum string: POINT (25.183705645228745...
geom_center_x float Longitude of center. Column geom_center_x has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.83 and maximum value is 25.18.
geom_center_y float Latitude of center. Column geom_center_y has 53186 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 53186 rows, out of which 0 are empty, making the null percent 0. 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 February 28, 2023
Created July 6, 2022