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

Pohjaveden suojaus - Pohjaveden suojaus (Tierekisterin tietolaji 142)

Pohjaveden suojaus - Pohjaveden suojaus (Tierekisterin tietolaji 142)

Tables

Column Descriptions

Tl142, Avointl142, Full history

Column Type Comment
objectid int Data source did not contain a description for OBJECTID. Column objectid has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3521 and maximum value is 6292.
ely int Data source did not contain a description for ELY. Column ely has 2772 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.
tie int Data source did not contain a description for TIE. Column tie has 2772 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 29654.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr int Data source did not contain a description for AJR. Column ajr has 2772 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.
aosa int Data source did not contain a description for AOSA. Column aosa has 2772 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 431.
aet int Data source did not contain a description for AET. Column aet has 2772 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 16335.
losa int Data source did not contain a description for LOSA. Column losa has 2772 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 431.
let int Data source did not contain a description for LET. Column let has 2772 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 16535.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
pvsuoja int Data source did not contain a description for PVSUOJA. Column pvsuoja has 2772 rows, out of which 220 are empty, making the null percent 7.94. Minimum value is 1 and maximum value is 8.
s_pvsuoja string Data source did not contain a description for S_PVSUOJA. Column s_pvsuoja has 2772 rows, out of which 220 are empty, making the null percent 7.94. Minimum string is and maximum string is muu.
pvsuola int Data source did not contain a description for PVSUOLA. Column pvsuola has 2772 rows, out of which 2351 are empty, making the null percent 84.81. Constant value is 1.
s_pvsuola string Data source did not contain a description for S_PVSUOLA. Column s_pvsuola has 2772 rows, out of which 2351 are empty, making the null percent 84.81. The single string value is: .
pvtaso int Data source did not contain a description for PVTASO. Column pvtaso has 2772 rows, out of which 2438 are empty, making the null percent 87.95. Constant value is 1.
pvteksti string Data source did not contain a description for PVTEKSTI. Column pvteksti has 2772 rows, out of which 1147 are empty, making the null percent 41.38. Minimum string is and maximum string is Ämmäntöyräs.
id int Data source did not contain a description for ID. Column is empty.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue int Data source did not contain a description for UALUE. Column ualue has 2772 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 1436.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva string Data source did not contain a description for LIVA. Column liva has 2772 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.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 2772 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.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 2772 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.
laani string Data source did not contain a description for LAANI. Column laani has 2772 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.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 2772 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.4193429460... and first 25 characters of maximum string: MULTILINESTRING ((27.1333...
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 2772 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.

Tl142, Avointl142, Latest

Column Type Comment
objectid int Data source did not contain a description for OBJECTID. Column objectid has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3521 and maximum value is 6292.
ely int Data source did not contain a description for ELY. Column ely has 2772 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.
tie int Data source did not contain a description for TIE. Column tie has 2772 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 29654.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr int Data source did not contain a description for AJR. Column ajr has 2772 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.
aosa int Data source did not contain a description for AOSA. Column aosa has 2772 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 431.
aet int Data source did not contain a description for AET. Column aet has 2772 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 16335.
losa int Data source did not contain a description for LOSA. Column losa has 2772 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 431.
let int Data source did not contain a description for LET. Column let has 2772 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 16535.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
pvsuoja int Data source did not contain a description for PVSUOJA. Column pvsuoja has 2772 rows, out of which 220 are empty, making the null percent 7.94. Minimum value is 1 and maximum value is 8.
s_pvsuoja string Data source did not contain a description for S_PVSUOJA. Column s_pvsuoja has 2772 rows, out of which 220 are empty, making the null percent 7.94. Minimum string is and maximum string is muu.
pvsuola int Data source did not contain a description for PVSUOLA. Column pvsuola has 2772 rows, out of which 2351 are empty, making the null percent 84.81. Constant value is 1.
s_pvsuola string Data source did not contain a description for S_PVSUOLA. Column s_pvsuola has 2772 rows, out of which 2351 are empty, making the null percent 84.81. The single string value is: .
pvtaso int Data source did not contain a description for PVTASO. Column pvtaso has 2772 rows, out of which 2438 are empty, making the null percent 87.95. Constant value is 1.
pvteksti string Data source did not contain a description for PVTEKSTI. Column pvteksti has 2772 rows, out of which 1147 are empty, making the null percent 41.38. Minimum string is and maximum string is Ämmäntöyräs.
id int Data source did not contain a description for ID. Column is empty.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue int Data source did not contain a description for UALUE. Column ualue has 2772 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 1436.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva string Data source did not contain a description for LIVA. Column liva has 2772 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.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 2772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 2772 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.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 2772 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.
laani string Data source did not contain a description for LAANI. Column laani has 2772 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.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 2772 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.4193429460... and first 25 characters of maximum string: MULTILINESTRING ((27.1333...
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 2772 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.

Additional Info

Last Updated September 11, 2020
Created September 10, 2020