To download the data set, please sign up or log in
Maankäyttö:Kantakartta:Silta
Tables
-
Silta, Kantasilta, Full historyTSV
No description available for layer kanta:Silta (Maankäyttö:Kantakartta:Silta)
-
Silta, Kantasilta, LatestTSV
No description available for layer kanta:Silta (Maankäyttö:Kantakartta:Silta)
Column Descriptions
Silta, Kantasilta, Latest
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 2842 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Silta.100398563 and maximum string is Silta.99954210. |
| kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 2842 rows, out of which 234 are empty, making the null percent 8.23. Minimum value is 807100 and maximum value is 8071001. |
| sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 2842 rows, out of which 234 are empty, making the null percent 8.23. Minimum value is 0 and maximum value is 5. |
| luontitapa | string | Data source did not contain a description for luontitapa. Column luontitapa has 2842 rows, out of which 234 are empty, making the null percent 8.23. The single string value is: . |
| alkupvm | timestamp | Data source did not contain a description for alkuPvm. Column alkupvm has 2842 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-07 09:02:19. |
| siltarakenteetsiltarakennekplkoodi | int | Data source did not contain a description for siltarakenteetSiltarakennekplkoodi. Column siltarakenteetsiltarakennekplkoodi has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Constant value is 808260. |
| siltarakenteetsiltarakennesijaintiepavarmuus | int | Data source did not contain a description for siltarakenteetSiltarakennesijaintiepavarmuus. Column siltarakenteetsiltarakennesijaintiepavarmuus has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Constant value is 0. |
| siltarakenteetsiltarakenneluontitapa | string | Data source did not contain a description for siltarakenteetSiltarakenneluontitapa. Column siltarakenteetsiltarakenneluontitapa has 2842 rows, out of which 2608 are empty, making the null percent 91.77. The single string value is: . |
| siltarakenteetsiltarakennealkupvm | string | Data source did not contain a description for siltarakenteetSiltarakennealkuPvm. Column siltarakenteetsiltarakennealkupvm has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Minimum string is and maximum string is 2020-05-27T07:49:51. |
| tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 2842 rows, out of which 2608 are empty, making the null percent 91.77. The single string value is: . |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 2842 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.5048026 60... and first 25 characters of maximum string: LINESTRING (24.8460717 60... |
| 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 2842 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
Silta, Kantasilta, Full history
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 2842 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Silta.100398563 and maximum string is Silta.99954210. |
| kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 2842 rows, out of which 234 are empty, making the null percent 8.23. Minimum value is 807100 and maximum value is 8071001. |
| sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 2842 rows, out of which 234 are empty, making the null percent 8.23. Minimum value is 0 and maximum value is 5. |
| luontitapa | string | Data source did not contain a description for luontitapa. Column luontitapa has 2842 rows, out of which 234 are empty, making the null percent 8.23. The single string value is: . |
| alkupvm | timestamp | Data source did not contain a description for alkuPvm. Column alkupvm has 2842 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-07 09:02:19. |
| siltarakenteetsiltarakennekplkoodi | int | Data source did not contain a description for siltarakenteetSiltarakennekplkoodi. Column siltarakenteetsiltarakennekplkoodi has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Constant value is 808260. |
| siltarakenteetsiltarakennesijaintiepavarmuus | int | Data source did not contain a description for siltarakenteetSiltarakennesijaintiepavarmuus. Column siltarakenteetsiltarakennesijaintiepavarmuus has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Constant value is 0. |
| siltarakenteetsiltarakenneluontitapa | string | Data source did not contain a description for siltarakenteetSiltarakenneluontitapa. Column siltarakenteetsiltarakenneluontitapa has 2842 rows, out of which 2608 are empty, making the null percent 91.77. The single string value is: . |
| siltarakenteetsiltarakennealkupvm | string | Data source did not contain a description for siltarakenteetSiltarakennealkuPvm. Column siltarakenteetsiltarakennealkupvm has 2842 rows, out of which 2608 are empty, making the null percent 91.77. Minimum string is and maximum string is 2020-05-27T07:49:51. |
| tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 2842 rows, out of which 2608 are empty, making the null percent 91.77. The single string value is: . |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 2842 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.5048026 60... and first 25 characters of maximum string: LINESTRING (24.8460717 60... |
| 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 2842 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 8, 2020 |