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

YLRE Viherosat viiva

No description available for layer avoindata:YLRE_Viherosat_viiva (YLRE_Viherosat_viiva)

Tables

Column Descriptions

Ylre viherosat viivaline, Avoindataylre viherosat viiva, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 128052 and maximum value is 605942.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 26 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 6584 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 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 238 and maximum value is 554.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aidat and maximum string is Vesijohdot.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 6584 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 8003.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ajojohde and maximum string is Välppä.
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 6584 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 Valtio, Ely-keskus.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 6584 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 Kiinteistö / Yksityinen.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 6584 rows, out of which 6566 are empty, making the null percent 99.73. 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 6584 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 2021.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 6584 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 H1.
hoitoluoka string Data source did not contain a description for hoitoluoka. Column hoitoluoka has 6584 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 6584 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 6584 rows, out of which 436 are empty, making the null percent 6.62. Minimum value is 1 and maximum value is 5.
osan_pituu float Data source did not contain a description for osan_pituu. Column osan_pituu has 6584 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 1728.5.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 6584 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 6584 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 234.
puiston_ni string Data source did not contain a description for puiston_ni. Column puiston_ni has 6584 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 Ystävyyden puisto.
viheraluee string Data source did not contain a description for viheraluee. Column viheraluee has 6584 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 6584 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 251321.
viheralue1 int Data source did not contain a description for viheralue1. Column viheralue1 has 6584 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 11030.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 6584 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 1197.
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 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8341978554... and first 25 characters of maximum string: LINESTRING (25.2470836120...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_LINESTRING.

Ylre viherosat viivaline, Avoindataylre viherosat viiva, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 128052 and maximum value is 605942.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 26 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 6584 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 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 238 and maximum value is 554.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aidat and maximum string is Vesijohdot.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 6584 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 8003.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ajojohde and maximum string is Välppä.
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 6584 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 Valtio, Ely-keskus.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 6584 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 Kiinteistö / Yksityinen.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 6584 rows, out of which 6566 are empty, making the null percent 99.73. 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 6584 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 2021.
hoitoluokk string Data source did not contain a description for hoitoluokk. Column hoitoluokk has 6584 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 H1.
hoitoluoka string Data source did not contain a description for hoitoluoka. Column hoitoluoka has 6584 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 6584 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 6584 rows, out of which 436 are empty, making the null percent 6.62. Minimum value is 1 and maximum value is 5.
osan_pituu float Data source did not contain a description for osan_pituu. Column osan_pituu has 6584 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 1728.5.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 6584 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 6584 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 234.
puiston_ni string Data source did not contain a description for puiston_ni. Column puiston_ni has 6584 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 Ystävyyden puisto.
viheraluee string Data source did not contain a description for viheraluee. Column viheraluee has 6584 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 6584 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 251321.
viheralue1 int Data source did not contain a description for viheralue1. Column viheralue1 has 6584 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 11030.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 6584 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 1197.
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 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8341978554... and first 25 characters of maximum string: LINESTRING (25.2470836120...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 6584 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 7, 2022
Created July 7, 2022