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

Viheralueet

Viheralueet

Tables

Column Descriptions

Tl323, Avointl323, Latest

Column Type Comment
laani string Data source did not contain a description for LAANI. Column laani has 5476 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 5476 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 5476 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 5476 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 5476 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 5476 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 5476 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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 9000.
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.
vhaluenimi string Data source did not contain a description for VHALUENIMI. Column vhaluenimi has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 19053/1/1680-1825, välika... and first 25 characters of maximum string: Östensön palvelualue...
vhakartt int Data source did not contain a description for VHAKARTT. Column vhakartt has 5476 rows, out of which 1080 are empty, making the null percent 19.72. Minimum value is 0 and maximum value is 1.
s_vhakartt string Data source did not contain a description for S_VHAKARTT. Column s_vhakartt has 5476 rows, out of which 1080 are empty, making the null percent 19.72. Minimum string is and maximum string is on.
vhaluelk int Data source did not contain a description for VHALUELK. Column vhaluelk has 5476 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.
s_vhaluelk string Data source did not contain a description for S_VHALUELK. Column s_vhaluelk has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is E1 and maximum string is Y.
vhatyyp int Data source did not contain a description for VHATYYP. Column vhatyyp has 5476 rows, out of which 94 are empty, making the null percent 1.72. Minimum value is 0 and maximum value is 8.
vhalueala int Data source did not contain a description for VHALUEALA. Column vhalueala has 5476 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 188739.
vhakortt int Data source did not contain a description for VHAKORTT. Column vhakortt has 5476 rows, out of which 1117 are empty, making the null percent 20.40. Minimum value is 0 and maximum value is 1.
s_vhakortt string Data source did not contain a description for S_VHAKORTT. Column s_vhakortt has 5476 rows, out of which 1117 are empty, making the null percent 20.40. Minimum string is and maximum string is on.
s_vhatyyp string Data source did not contain a description for S_VHATYYP. Column s_vhatyyp has 5476 rows, out of which 94 are empty, making the null percent 1.72. Minimum string is and maximum string is taajama.
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.
let int Data source did not contain a description for LET. Column let has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 24790.
losa int Data source did not contain a description for LOSA. Column losa has 5476 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 995.
aet int Data source did not contain a description for AET. Column aet has 5476 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 24520.
aosa int Data source did not contain a description for AOSA. Column aosa has 5476 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 995.
ajr int Data source did not contain a description for AJR. Column ajr has 5476 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 5476 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 86595.
ely int Data source did not contain a description for ELY. Column ely has 5476 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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 35881 and maximum value is 42761.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.2738107319... and first 25 characters of maximum string: MULTILINESTRING ((29.1676...
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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Tl323, Avointl323, Full history

Column Type Comment
laani string Data source did not contain a description for LAANI. Column laani has 5476 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 5476 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 5476 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 5476 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 5476 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 5476 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 5476 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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 9000.
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.
vhaluenimi string Data source did not contain a description for VHALUENIMI. Column vhaluenimi has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 19053/1/1680-1825, välika... and first 25 characters of maximum string: Östensön palvelualue...
vhakartt int Data source did not contain a description for VHAKARTT. Column vhakartt has 5476 rows, out of which 1080 are empty, making the null percent 19.72. Minimum value is 0 and maximum value is 1.
s_vhakartt string Data source did not contain a description for S_VHAKARTT. Column s_vhakartt has 5476 rows, out of which 1080 are empty, making the null percent 19.72. Minimum string is and maximum string is on.
vhaluelk int Data source did not contain a description for VHALUELK. Column vhaluelk has 5476 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.
s_vhaluelk string Data source did not contain a description for S_VHALUELK. Column s_vhaluelk has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is E1 and maximum string is Y.
vhatyyp int Data source did not contain a description for VHATYYP. Column vhatyyp has 5476 rows, out of which 94 are empty, making the null percent 1.72. Minimum value is 0 and maximum value is 8.
vhalueala int Data source did not contain a description for VHALUEALA. Column vhalueala has 5476 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 188739.
vhakortt int Data source did not contain a description for VHAKORTT. Column vhakortt has 5476 rows, out of which 1117 are empty, making the null percent 20.40. Minimum value is 0 and maximum value is 1.
s_vhakortt string Data source did not contain a description for S_VHAKORTT. Column s_vhakortt has 5476 rows, out of which 1117 are empty, making the null percent 20.40. Minimum string is and maximum string is on.
s_vhatyyp string Data source did not contain a description for S_VHATYYP. Column s_vhatyyp has 5476 rows, out of which 94 are empty, making the null percent 1.72. Minimum string is and maximum string is taajama.
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.
let int Data source did not contain a description for LET. Column let has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 24790.
losa int Data source did not contain a description for LOSA. Column losa has 5476 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 995.
aet int Data source did not contain a description for AET. Column aet has 5476 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 24520.
aosa int Data source did not contain a description for AOSA. Column aosa has 5476 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 995.
ajr int Data source did not contain a description for AJR. Column ajr has 5476 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 5476 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 86595.
ely int Data source did not contain a description for ELY. Column ely has 5476 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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 35881 and maximum value is 42761.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.2738107319... and first 25 characters of maximum string: MULTILINESTRING ((29.1676...
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 5476 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 11, 2020
Created September 9, 2020