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

Viherkuviot

Viherkuviot

Tables

Column Descriptions

Tl524, Avointl524, Full history

Column Type Comment
s_vihertyy string Data source did not contain a description for S_VIHERTYY. Column s_vihertyy has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is köynnös and maximum string is vieraslaji.
vihertyy int Data source did not contain a description for VIHERTYY. Column vihertyy has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 11.
vihaluetun string Data source did not contain a description for VIHALUETUN. Column vihaluetun has 12390 rows, out of which 16 are empty, making the null percent 0.13. Minimum string is and maximum string is TMTMVI618174812.
z float Data source did not contain a description for Z. Column is empty.
y int Data source did not contain a description for Y. Column y has 12390 rows, out of which 8503 are empty, making the null percent 68.63. Minimum value is 261076 and maximum value is 7001911.
x int Data source did not contain a description for X. Column x has 12390 rows, out of which 8503 are empty, making the null percent 68.63. Minimum value is 360130 and maximum value is 7764578.
s_urakka string Data source did not contain a description for S_URAKKA. Column s_urakka has 12390 rows, out of which 11735 are empty, making the null percent 94.71. Minimum string is and maximum string is yrittäjä.
urakka int Data source did not contain a description for URAKKA. Column urakka has 12390 rows, out of which 11735 are empty, making the null percent 94.71. Minimum value is 100 and maximum value is 400.
vihkunto int Data source did not contain a description for VIHKUNTO. Column vihkunto has 12390 rows, out of which 1243 are empty, making the null percent 10.03. Minimum value is 0 and maximum value is 3.
s_vihkunto string Data source did not contain a description for S_VIHKUNTO. Column s_vihkunto has 12390 rows, out of which 1243 are empty, making the null percent 10.03. Minimum string is and maximum string is poisto.
kasvilaji string Data source did not contain a description for KASVILAJI. Column kasvilaji has 12390 rows, out of which 4340 are empty, making the null percent 35.03. Minimum string is and maximum string is Ympäristötaide.
kasvimaara int Data source did not contain a description for KASVIMAARA. Column kasvimaara has 12390 rows, out of which 9320 are empty, making the null percent 75.22. Minimum value is 0 and maximum value is 4800.
toimenpid1 string Data source did not contain a description for TOIMENPID1. Column toimenpid1 has 12390 rows, out of which 9234 are empty, making the null percent 74.53. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yksittäiset männyn taimet...
toimenpid2 string Data source did not contain a description for TOIMENPID2. Column toimenpid2 has 12390 rows, out of which 11574 are empty, making the null percent 93.41. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yksittäisen koivuntaimen ...
vhkortti int Data source did not contain a description for VHKORTTI. Column vhkortti has 12390 rows, out of which 3703 are empty, making the null percent 29.89. Minimum value is 0 and maximum value is 1.
s_vhkortti string Data source did not contain a description for S_VHKORTTI. Column s_vhkortti has 12390 rows, out of which 3703 are empty, making the null percent 29.89. Minimum string is and maximum string is on.
vhkartta int Data source did not contain a description for VHKARTTA. Column vhkartta has 12390 rows, out of which 4400 are empty, making the null percent 35.51. Minimum value is 0 and maximum value is 1.
s_vhkartta string Data source did not contain a description for S_VHKARTTA. Column s_vhkartta has 12390 rows, out of which 4400 are empty, making the null percent 35.51. Minimum string is and maximum string is on.
valokuv int Data source did not contain a description for VALOKUV. Column valokuv has 12390 rows, out of which 4410 are empty, making the null percent 35.59. Minimum value is 0 and maximum value is 1.
s_valokuv string Data source did not contain a description for S_VALOKUV. Column s_valokuv has 12390 rows, out of which 4410 are empty, making the null percent 35.59. Minimum string is and maximum string is on.
tunniste string Data source did not contain a description for TUNNISTE. Column tunniste has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1091007 and maximum string is TMTMVI618175763.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
puoli int Data source did not contain a description for PUOLI. Column puoli has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8.
aet int Data source did not contain a description for AET. Column aet has 12390 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 24760.
aosa int Data source did not contain a description for AOSA. Column aosa has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 915.
ajr int Data source did not contain a description for AJR. Column ajr has 12390 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 2.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
tie int Data source did not contain a description for TIE. Column tie has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 92065.
ely int Data source did not contain a description for ELY. Column ely has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 14.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61078 and maximum value is 74518.
laani string Data source did not contain a description for LAANI. Column laani has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 19.
kunta string Data source did not contain a description for KUNTA. Column kunta has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
liva string Data source did not contain a description for LIVA. Column liva has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Harjavalta 16-21 and maximum string is Äänekoski 19-24.
ualue int Data source did not contain a description for UALUE. Column ualue has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 132 and maximum value is 1437.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
id int Data source did not contain a description for ID. Column is empty.
vihernro int Data source did not contain a description for VIHERNRO. Column vihernro has 12390 rows, out of which 20 are empty, making the null percent 0.16. Minimum value is 1 and maximum value is 60.
viherala int Data source did not contain a description for VIHERALA. Column viherala has 12390 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 41000.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 12390 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 (21.273433365420257... and first 25 characters of maximum string: POINT (31.197016098995213...
geom_center_x float Longitude of center. Column geom_center_x has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.27 and maximum value is 31.20.
geom_center_y float Latitude of center. Column geom_center_y has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.87 and maximum value is 69.96.
geom_type string Geometry type. Column geom_type has 12390 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.

Tl524, Avointl524, Latest

Column Type Comment
s_vihertyy string Data source did not contain a description for S_VIHERTYY. Column s_vihertyy has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is köynnös and maximum string is vieraslaji.
vihertyy int Data source did not contain a description for VIHERTYY. Column vihertyy has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 11.
vihaluetun string Data source did not contain a description for VIHALUETUN. Column vihaluetun has 12390 rows, out of which 16 are empty, making the null percent 0.13. Minimum string is and maximum string is TMTMVI618174812.
z float Data source did not contain a description for Z. Column is empty.
y int Data source did not contain a description for Y. Column y has 12390 rows, out of which 8503 are empty, making the null percent 68.63. Minimum value is 261076 and maximum value is 7001911.
x int Data source did not contain a description for X. Column x has 12390 rows, out of which 8503 are empty, making the null percent 68.63. Minimum value is 360130 and maximum value is 7764578.
s_urakka string Data source did not contain a description for S_URAKKA. Column s_urakka has 12390 rows, out of which 11735 are empty, making the null percent 94.71. Minimum string is and maximum string is yrittäjä.
urakka int Data source did not contain a description for URAKKA. Column urakka has 12390 rows, out of which 11735 are empty, making the null percent 94.71. Minimum value is 100 and maximum value is 400.
vihkunto int Data source did not contain a description for VIHKUNTO. Column vihkunto has 12390 rows, out of which 1243 are empty, making the null percent 10.03. Minimum value is 0 and maximum value is 3.
s_vihkunto string Data source did not contain a description for S_VIHKUNTO. Column s_vihkunto has 12390 rows, out of which 1243 are empty, making the null percent 10.03. Minimum string is and maximum string is poisto.
kasvilaji string Data source did not contain a description for KASVILAJI. Column kasvilaji has 12390 rows, out of which 4340 are empty, making the null percent 35.03. Minimum string is and maximum string is Ympäristötaide.
kasvimaara int Data source did not contain a description for KASVIMAARA. Column kasvimaara has 12390 rows, out of which 9320 are empty, making the null percent 75.22. Minimum value is 0 and maximum value is 4800.
toimenpid1 string Data source did not contain a description for TOIMENPID1. Column toimenpid1 has 12390 rows, out of which 9234 are empty, making the null percent 74.53. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yksittäiset männyn taimet...
toimenpid2 string Data source did not contain a description for TOIMENPID2. Column toimenpid2 has 12390 rows, out of which 11574 are empty, making the null percent 93.41. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yksittäisen koivuntaimen ...
vhkortti int Data source did not contain a description for VHKORTTI. Column vhkortti has 12390 rows, out of which 3703 are empty, making the null percent 29.89. Minimum value is 0 and maximum value is 1.
s_vhkortti string Data source did not contain a description for S_VHKORTTI. Column s_vhkortti has 12390 rows, out of which 3703 are empty, making the null percent 29.89. Minimum string is and maximum string is on.
vhkartta int Data source did not contain a description for VHKARTTA. Column vhkartta has 12390 rows, out of which 4400 are empty, making the null percent 35.51. Minimum value is 0 and maximum value is 1.
s_vhkartta string Data source did not contain a description for S_VHKARTTA. Column s_vhkartta has 12390 rows, out of which 4400 are empty, making the null percent 35.51. Minimum string is and maximum string is on.
valokuv int Data source did not contain a description for VALOKUV. Column valokuv has 12390 rows, out of which 4410 are empty, making the null percent 35.59. Minimum value is 0 and maximum value is 1.
s_valokuv string Data source did not contain a description for S_VALOKUV. Column s_valokuv has 12390 rows, out of which 4410 are empty, making the null percent 35.59. Minimum string is and maximum string is on.
tunniste string Data source did not contain a description for TUNNISTE. Column tunniste has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1091007 and maximum string is TMTMVI618175763.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
puoli int Data source did not contain a description for PUOLI. Column puoli has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8.
aet int Data source did not contain a description for AET. Column aet has 12390 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 24760.
aosa int Data source did not contain a description for AOSA. Column aosa has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 915.
ajr int Data source did not contain a description for AJR. Column ajr has 12390 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 2.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
tie int Data source did not contain a description for TIE. Column tie has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 92065.
ely int Data source did not contain a description for ELY. Column ely has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 14.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61078 and maximum value is 74518.
laani string Data source did not contain a description for LAANI. Column laani has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 19.
kunta string Data source did not contain a description for KUNTA. Column kunta has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
liva string Data source did not contain a description for LIVA. Column liva has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Harjavalta 16-21 and maximum string is Äänekoski 19-24.
ualue int Data source did not contain a description for UALUE. Column ualue has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 132 and maximum value is 1437.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
id int Data source did not contain a description for ID. Column is empty.
vihernro int Data source did not contain a description for VIHERNRO. Column vihernro has 12390 rows, out of which 20 are empty, making the null percent 0.16. Minimum value is 1 and maximum value is 60.
viherala int Data source did not contain a description for VIHERALA. Column viherala has 12390 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 41000.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 12390 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 (21.273433365420257... and first 25 characters of maximum string: POINT (31.197016098995213...
geom_center_x float Longitude of center. Column geom_center_x has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.27 and maximum value is 31.20.
geom_center_y float Latitude of center. Column geom_center_y has 12390 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.87 and maximum value is 69.96.
geom_type string Geometry type. Column geom_type has 12390 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.

Additional Info

Last Updated September 11, 2020
Created September 10, 2020