To download the data set, please sign up or log in
Pohjavesialue
Tables
-
Tl141, Avointl141, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin viedään keskitetysti SYKE:n aineiston perusteella kaikki tärkeiksi luokitellut sekä muut vedenhankintaan soveltuvat pohjavesialueet, joita tie leikkaa tai jotka muuten edellyttävät tieympäristön suojausta. ELYt täydentävät toimistotyönä suojaus- ja suolankäyttörajoitustiedot.
Column Descriptions
Tl141, Avointl141, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 37632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 379291 and maximum value is 417249. |
| ely | int | Data source did not contain a description for ELY. Column ely has 37632 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 37632 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 96516. |
| 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 37632 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 37632 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 997. |
| aet | int | Data source did not contain a description for AET. Column aet has 37632 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 26194. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 37632 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 997. |
| let | int | Data source did not contain a description for LET. Column let has 37632 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 26205. |
| 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. |
| pvty | int | Data source did not contain a description for PVTY. Column pvty has 37632 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 2. |
| s_pvty | string | Data source did not contain a description for S_PVTY. Column s_pvty has 37632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is pvalue and maximum string is pvalueM. |
| pvalue | int | Data source did not contain a description for PVALUE. Column pvalue has 37632 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 10. |
| s_pvalue | string | Data source did not contain a description for S_PVALUE. Column s_pvalue has 37632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Luokka 1 and maximum string is Tärkeä. |
| pvsuoja | float | Data source did not contain a description for PVSUOJA. Column is empty. |
| s_pvsuoja | string | Data source did not contain a description for S_PVSUOJA. Column is empty. |
| pvnro | int | Data source did not contain a description for PVNRO. Column pvnro has 37632 rows, out of which 5272 are empty, making the null percent 14.01. Minimum value is 101501 and maximum value is 12976500. |
| pvnimi | string | Data source did not contain a description for PVNIMI. Column pvnimi has 37632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakkulanharju and maximum string is Östermossbacken B. |
| pvsuola | float | Data source did not contain a description for PVSUOLA. Column is empty. |
| s_pvsuola | string | Data source did not contain a description for S_PVSUOLA. Column is empty. |
| pvtaso | float | Data source did not contain a description for PVTASO. Column is empty. |
| s_pvtaso | string | Data source did not contain a description for S_PVTASO. Column is empty. |
| pvteksti | string | Data source did not contain a description for PVTEKSTI. Column is empty. |
| 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 37632 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. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 37632 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 37632 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 37632 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. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 37632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 37632 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 37632 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 37632 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 37632 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 (20.7497973076... and first 25 characters of maximum string: MULTILINESTRING ((29.5343... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column is empty. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column is empty. |
| geom_type | string | Geometry type. Column geom_type has 37632 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 | July 9, 2018 |