To download the data set, please sign up or log in
Maankäyttö:Kantakartta:Vesikohde
Tables
-
Vesikohde, Kantavesikohde, Full historyTSV
No description available for layer kanta:Vesikohde (Maankäyttö:Kantakartta:Vesikohde)
-
Vesikohde, Kantavesikohde, LatestTSV
No description available for layer kanta:Vesikohde (Maankäyttö:Kantakartta:Vesikohde)
Column Descriptions
Vesikohde, Kantavesikohde, Latest
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Vesikohde.10000884 and maximum string is Vesikohde.9999276. |
| kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 301000 and maximum value is 30100003. |
| sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 70126 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 5. |
| luontitapa | string | Data source did not contain a description for luontitapa. Column luontitapa has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus. |
| alkupvm | timestamp | Data source did not contain a description for alkuPvm. Column alkupvm has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-04-21 08:28:35 and maximum value is 2020-09-03 12:53:41. |
| tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 70126 rows, out of which 582 are empty, making the null percent 0.83. Minimum string is and maximum string is virtaussuuntanuoli. |
| suuntakulma | int | Data source did not contain a description for suuntakulma. Column suuntakulma has 70126 rows, out of which 47490 are empty, making the null percent 67.72. Minimum value is 0 and maximum value is 6. |
| suuntakulma_uom | string | Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 70126 rows, out of which 47490 are empty, making the null percent 67.72. The single string value is: . |
| virtaavavesi | int | Data source did not contain a description for virtaavavesi. Column virtaavavesi has 70126 rows, out of which 68348 are empty, making the null percent 97.46. Constant value is 1. |
| ilmentymaelementinnimi | string | Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: . |
| suunta | int | Data source did not contain a description for suunta. Column suunta has 70126 rows, out of which 69544 are empty, making the null percent 99.17. Constant value is 1. |
| suunta_uom | string | Data source did not contain a description for suunta_uom. Column suunta_uom has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: . |
| nimi | string | Data source did not contain a description for nimi. Column nimi has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: UNKNOWN FIELD 'Text' TABL... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 70126 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 (24.4998239 60... and first 25 characters of maximum string: POINT (24.8496794 60.2235... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 70126 rows, out of which 42655 are empty, making the null percent 60.83. Minimum value is 24.50 and maximum value is 24.85. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 70126 rows, out of which 42655 are empty, making the null percent 60.83. Minimum value is 60.06 and maximum value is 60.36. |
| geom_type | string | Geometry type. Column geom_type has 70126 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_POINT. |
Vesikohde, Kantavesikohde, Full history
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Vesikohde.10000884 and maximum string is Vesikohde.9999276. |
| kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 301000 and maximum value is 30100003. |
| sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 70126 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 5. |
| luontitapa | string | Data source did not contain a description for luontitapa. Column luontitapa has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus. |
| alkupvm | timestamp | Data source did not contain a description for alkuPvm. Column alkupvm has 70126 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-04-21 08:28:35 and maximum value is 2020-09-03 12:53:41. |
| tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 70126 rows, out of which 582 are empty, making the null percent 0.83. Minimum string is and maximum string is virtaussuuntanuoli. |
| suuntakulma | int | Data source did not contain a description for suuntakulma. Column suuntakulma has 70126 rows, out of which 47490 are empty, making the null percent 67.72. Minimum value is 0 and maximum value is 6. |
| suuntakulma_uom | string | Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 70126 rows, out of which 47490 are empty, making the null percent 67.72. The single string value is: . |
| virtaavavesi | int | Data source did not contain a description for virtaavavesi. Column virtaavavesi has 70126 rows, out of which 68348 are empty, making the null percent 97.46. Constant value is 1. |
| ilmentymaelementinnimi | string | Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: . |
| suunta | int | Data source did not contain a description for suunta. Column suunta has 70126 rows, out of which 69544 are empty, making the null percent 99.17. Constant value is 1. |
| suunta_uom | string | Data source did not contain a description for suunta_uom. Column suunta_uom has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: . |
| nimi | string | Data source did not contain a description for nimi. Column nimi has 70126 rows, out of which 69544 are empty, making the null percent 99.17. The single string value is: UNKNOWN FIELD 'Text' TABL... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 70126 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 (24.4998239 60... and first 25 characters of maximum string: POINT (24.8496794 60.2235... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 70126 rows, out of which 42655 are empty, making the null percent 60.83. Minimum value is 24.50 and maximum value is 24.85. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 70126 rows, out of which 42655 are empty, making the null percent 60.83. Minimum value is 60.06 and maximum value is 60.36. |
| geom_type | string | Geometry type. Column geom_type has 70126 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_POINT. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 10, 2020 |
|---|---|
| Created | September 8, 2020 |