1. Home
  2. Datasets
  3. Yleisten alueiden rekisteri, ...
To download the data set, please sign up or log in

Yleisten alueiden rekisteri, viherosat

Yleisten alueiden rekisteri, viherosat

Tables

Column Descriptions

Ylre Viherosatline, Hkrylre Viherosat

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 128052 and maximum value is 558872.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kalusteet ja leikkiväline... and first 25 characters of maximum string: Varusteet...
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aidat and maximum string is Rummut.
materiaali string Data source did not contain a description for materiaali. Column materiaali has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ajojohde... and first 25 characters of maximum string: HKR - A5, suoja-aita, ter...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HELEN and maximum string is Kaupunkiympäristö Länsi.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is HKL.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 5899 rows, out of which 5894 are empty, making the null percent 99.92. Minimum string is and maximum string is C - hoitotapa.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1 and maximum string is A2.
hoitoluoka string Data source did not contain a description for hoitoluoka. Column hoitoluoka has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvometsä and maximum string is Käyttöviheralue.
pituus float Data source did not contain a description for pituus. Column pituus has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 1728.00.
leveys float Data source did not contain a description for leveys. Column leveys has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 1000.00.
pinta_ala float Data source did not contain a description for pinta_ala. Column pinta_ala has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 234.00.
puiston_ni string Data source did not contain a description for puiston_ni. Column puiston_ni has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A501 and maximum string is HESPERIANPUISTO.
viheraluee int Data source did not contain a description for viheraluee. Column viheraluee has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 236381.
viheralue0 float Data source did not contain a description for viheralue0. Column viheralue0 has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.00 and maximum value is 10341.00.
osan_nro float Data source did not contain a description for osan_nro. Column osan_nro has 5899 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 1197.00.
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.

Ylre viherosatpoint, Hkrylre viherosat, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 127102 and maximum value is 569140.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali string Data source did not contain a description for materiaali. Column materiaali has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Viburnum opulus ´Roseum´...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HELEN and maximum string is YTV.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Liikunta.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 80851 rows, out of which 80805 are empty, making the null percent 99.94. Minimum string is and maximum string is C - hoitotapa.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1 and maximum string is III.
hoitoluoka string Data source did not contain a description for hoitoluoka. Column hoitoluoka has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arvometsä... and first 25 characters of maximum string: Ulkoilu- ja virkistysmets...
pituus int Data source did not contain a description for pituus. Column pituus has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
leveys int Data source did not contain a description for leveys. Column leveys has 80851 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 1000.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
puiston_ni string Data source did not contain a description for puiston_ni. Column puiston_ni has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A501 and maximum string is ÖRSKINPUISTO.
viheraluee int Data source did not contain a description for viheraluee. Column viheraluee has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 241581.
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 10581.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 80851 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 1812.
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 80851 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.82714089523927 ... and first 25 characters of maximum string: POINT (25.21492403965094 ...
geom_center_x float Longitude of center. Column geom_center_x has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.83 and maximum value is 25.21.
geom_center_y float Latitude of center. Column geom_center_y has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.11 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 80851 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.

Ylre viherosatpoint, Hkrylre viherosat, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 127102 and maximum value is 569140.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali string Data source did not contain a description for materiaali. Column materiaali has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Viburnum opulus ´Roseum´...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HELEN and maximum string is YTV.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Liikunta.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 80851 rows, out of which 80805 are empty, making the null percent 99.94. Minimum string is and maximum string is C - hoitotapa.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1 and maximum string is III.
hoitoluoka string Data source did not contain a description for hoitoluoka. Column hoitoluoka has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arvometsä... and first 25 characters of maximum string: Ulkoilu- ja virkistysmets...
pituus int Data source did not contain a description for pituus. Column pituus has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
leveys int Data source did not contain a description for leveys. Column leveys has 80851 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 1000.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
puiston_ni string Data source did not contain a description for puiston_ni. Column puiston_ni has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A501 and maximum string is ÖRSKINPUISTO.
viheraluee int Data source did not contain a description for viheraluee. Column viheraluee has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 241581.
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 10581.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 80851 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 1812.
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 80851 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.82714089523927 ... and first 25 characters of maximum string: POINT (25.21492403965094 ...
geom_center_x float Longitude of center. Column geom_center_x has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.83 and maximum value is 25.21.
geom_center_y float Latitude of center. Column geom_center_y has 80851 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.11 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 80851 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 September 8, 2020
Created August 6, 2018