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

YLRE Viherosat piste

No description available for layer avoindata:YLRE_Viherosat_piste (YLRE_Viherosat_piste)

Tables

Column Descriptions

Ylre viherosat pistepoint, Avoindataylre viherosat piste, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 127102 and maximum value is 606079.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60 and maximum value is 515.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 82 and maximum value is 8536.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Victor Stanley...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 83741 are empty, making the null percent 99.9. Minimum string is and maximum string is C - hoitotapa.
viher_hoit int Data source did not contain a description for viher_hoit. Column viher_hoit has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 2401.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Arvometsä... and first 25 characters of maximum string: Ulkoilu- ja virkistysmets...
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Sosiaalivirasto.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 83821 rows, out of which 1423 are empty, making the null percent 1.7. Minimum value is 1 and maximum value is 5.
osan_pituu int Data source did not contain a description for osan_pituu. Column osan_pituu has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 1000.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A501 and maximum string is ÖRSKINPUISTO.
viheraluee string Data source did not contain a description for viheraluee. Column viheraluee has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 401 and maximum value is 255761.
viheralue1 int Data source did not contain a description for viheralue1. Column viheralue1 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 21 and maximum value is 11232.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 83821 rows, out of which 0 are empty, making the null percent 0. 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.
paivitett0 date Data source did not contain a description for paivitett0. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 83821 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.82714089547534 ... and first 25 characters of maximum string: POINT (25.521828259732487...
geom_center_x float Longitude of center. Column geom_center_x has 83821 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.52.
geom_center_y float Latitude of center. Column geom_center_y has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.11 and maximum value is 64.58.
geom_type string Geometry type. Column geom_type has 83821 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.

Ylre viherosat pistepoint, Avoindataylre viherosat piste, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 127102 and maximum value is 606079.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60 and maximum value is 515.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 82 and maximum value is 8536.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Victor Stanley...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 83741 are empty, making the null percent 99.9. Minimum string is and maximum string is C - hoitotapa.
viher_hoit int Data source did not contain a description for viher_hoit. Column viher_hoit has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 2401.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Arvometsä... and first 25 characters of maximum string: Ulkoilu- ja virkistysmets...
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Sosiaalivirasto.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 83821 rows, out of which 1423 are empty, making the null percent 1.7. Minimum value is 1 and maximum value is 5.
osan_pituu int Data source did not contain a description for osan_pituu. Column osan_pituu has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 1000.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 83821 rows, out of which 0 are empty, making the null percent 0. 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 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A501 and maximum string is ÖRSKINPUISTO.
viheraluee string Data source did not contain a description for viheraluee. Column viheraluee has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 401 and maximum value is 255761.
viheralue1 int Data source did not contain a description for viheralue1. Column viheralue1 has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 21 and maximum value is 11232.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 83821 rows, out of which 0 are empty, making the null percent 0. 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.
paivitett0 date Data source did not contain a description for paivitett0. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 83821 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.82714089547534 ... and first 25 characters of maximum string: POINT (25.521828259732487...
geom_center_x float Longitude of center. Column geom_center_x has 83821 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.52.
geom_center_y float Latitude of center. Column geom_center_y has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.11 and maximum value is 64.58.
geom_type string Geometry type. Column geom_type has 83821 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated July 7, 2022
Created July 5, 2022