Maankäyttö:Kantakartta:Rakenne
Tables
-
Rakenne, Kantarakenne, Full historyTSV
No description available for layer kanta:Rakenne (Maankäyttö:Kantakartta:Rakenne)
-
Rakenne, Kantarakenne, LatestTSV
No description available for layer kanta:Rakenne (Maankäyttö:Kantakartta:Rakenne)
Column Descriptions
Rakenne, Kantarakenne, Full history
Column | Type | Comment |
---|---|---|
gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 200381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Rakenne.10002107 and maximum string is Rakenne.9997912. |
kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 200381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 701130 and maximum value is 751180090. |
sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 200381 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 200381 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 200381 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 13:44:34. |
tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 200381 rows, out of which 13116 are empty, making the null percent 6.55. Minimum string is and maximum string is valonheitinmasto. |
materiaali | string | Data source did not contain a description for materiaali. Column materiaali has 200381 rows, out of which 124777 are empty, making the null percent 62.27. Minimum string is and maximum string is tiili. |
suuntakulma | int | Data source did not contain a description for suuntakulma. Column suuntakulma has 200381 rows, out of which 199806 are empty, making the null percent 99.71. 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 200381 rows, out of which 199806 are empty, making the null percent 99.71. The single string value is: . |
nimi | string | Data source did not contain a description for nimi. Column nimi has 200381 rows, out of which 198671 are empty, making the null percent 99.15. Minimum string is and maximum string is tukipilari. |
geom_geojson | string | Geometry in GeoJSON format. |
geom_geotext | string | Geometry as GeoText. Column geom_geotext has 200381 rows, out of which 278 are empty, making the null percent 0.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: POINT (24.8492678 60.2245... |
geom_center_x | float | Longitude of center. Column geom_center_x has 200381 rows, out of which 192505 are empty, making the null percent 96.07. Minimum value is 24.50 and maximum value is 24.85. |
geom_center_y | float | Latitude of center. Column geom_center_y has 200381 rows, out of which 192505 are empty, making the null percent 96.07. Minimum value is 60.08 and maximum value is 60.36. |
geom_type | string | Geometry type. Column geom_type has 200381 rows, out of which 278 are empty, making the null percent 0.14. Minimum string is and maximum string is ST_POINT. |
orig_extractdate | string | The date when the data was originally fetched from the source. |
Rakenne, Kantarakenne, Latest
Column | Type | Comment |
---|---|---|
gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 200381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Rakenne.10002107 and maximum string is Rakenne.9997912. |
kplkoodi | int | Data source did not contain a description for kplkoodi. Column kplkoodi has 200381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 701130 and maximum value is 751180090. |
sijaintiepavarmuus | int | Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 200381 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 200381 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 200381 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 13:44:34. |
tyyppi | string | Data source did not contain a description for tyyppi. Column tyyppi has 200381 rows, out of which 13116 are empty, making the null percent 6.55. Minimum string is and maximum string is valonheitinmasto. |
materiaali | string | Data source did not contain a description for materiaali. Column materiaali has 200381 rows, out of which 124777 are empty, making the null percent 62.27. Minimum string is and maximum string is tiili. |
suuntakulma | int | Data source did not contain a description for suuntakulma. Column suuntakulma has 200381 rows, out of which 199806 are empty, making the null percent 99.71. 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 200381 rows, out of which 199806 are empty, making the null percent 99.71. The single string value is: . |
nimi | string | Data source did not contain a description for nimi. Column nimi has 200381 rows, out of which 198671 are empty, making the null percent 99.15. Minimum string is and maximum string is tukipilari. |
geom_geojson | string | Geometry in GeoJSON format. |
geom_geotext | string | Geometry as GeoText. Column geom_geotext has 200381 rows, out of which 278 are empty, making the null percent 0.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: POINT (24.8492678 60.2245... |
geom_center_x | float | Longitude of center. Column geom_center_x has 200381 rows, out of which 192505 are empty, making the null percent 96.07. Minimum value is 24.50 and maximum value is 24.85. |
geom_center_y | float | Latitude of center. Column geom_center_y has 200381 rows, out of which 192505 are empty, making the null percent 96.07. Minimum value is 60.08 and maximum value is 60.36. |
geom_type | string | Geometry type. Column geom_type has 200381 rows, out of which 278 are empty, making the null percent 0.14. Minimum string is and maximum string is ST_POINT. |
Additional Info
Last Updated | September 10, 2020 |
---|---|
Created | September 9, 2020 |