To download the data set, please sign up or log in
Kivetyt alueet
Tables
-
Tl518, Avointl518, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan tiealueella olevat kivetyt alueet. Kivetyistä alueista inventoidaan tyyppi ja materiaali. Lisäksi kirjataan pinta-ala ja kuntopuutteet. Ajoratojen välissä sijaitsevat kiveykset inventoidaan ajoradalle yksi. Siltojen keilat ja etuluiskat rekisteröidään sillan ylittävälle tielle. Mikäli ylittävä väylä ei ole tieosoitejärjestelmässä, kirjataan siltaan liittyvä kiveys alimenevän tien ao. puolelle. Kivetyt alueet kuvataan.
Column Descriptions
Tl518, Avointl518, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 19473 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 190814 and maximum value is 212587. |
| ely | int | Data source did not contain a description for ELY. Column ely has 19473 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 19473 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 91811. |
| 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 19473 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 19473 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 995. |
| aet | int | Data source did not contain a description for AET. Column aet has 19473 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 24809. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 19473 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 995. |
| let | int | Data source did not contain a description for LET. Column let has 19473 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 24839. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 19473 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 8. |
| 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. |
| tunniste | string | Data source did not contain a description for TUNNISTE. Column tunniste has 19473 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1003501 and maximum string is TMTMVL815953683. |
| kuntoluo | int | Data source did not contain a description for KUNTOLUO. Column kuntoluo has 19473 rows, out of which 1482 are empty, making the null percent 7.61. Minimum value is 1 and maximum value is 5. |
| s_kuntoluo | string | Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 19473 rows, out of which 1482 are empty, making the null percent 7.61. Minimum string is and maximum string is tyydyttävä. |
| urakka | int | Data source did not contain a description for URAKKA. Column urakka has 19473 rows, out of which 19433 are empty, making the null percent 99.79. Minimum value is 200 and maximum value is 3007. |
| s_urakka | string | Data source did not contain a description for S_URAKKA. Column s_urakka has 19473 rows, out of which 19433 are empty, making the null percent 99.79. Minimum string is and maximum string is Vt 12 RaTu. |
| x | float | Data source did not contain a description for X. Column x has 19473 rows, out of which 19469 are empty, making the null percent 99.98. Minimum value is 477357.00 and maximum value is 477602.00. |
| y | float | Data source did not contain a description for Y. Column y has 19473 rows, out of which 19469 are empty, making the null percent 99.98. Minimum value is 7312336.00 and maximum value is 7312500.00. |
| z | float | Data source did not contain a description for Z. Column is empty. |
| kivaltyy | int | Data source did not contain a description for KIVALTYY. Column kivaltyy has 19473 rows, out of which 23 are empty, making the null percent 0.12. Minimum value is 1 and maximum value is 9. |
| s_kivaltyy | string | Data source did not contain a description for S_KIVALTYY. Column s_kivaltyy has 19473 rows, out of which 23 are empty, making the null percent 0.12. Minimum string is and maximum string is Viheralue. |
| kivetmat | int | Data source did not contain a description for KIVETMAT. Column kivetmat has 19473 rows, out of which 882 are empty, making the null percent 4.53. Minimum value is 1 and maximum value is 14. |
| s_kivetmat | string | Data source did not contain a description for S_KIVETMAT. Column s_kivetmat has 19473 rows, out of which 882 are empty, making the null percent 4.53. Minimum string is and maximum string is muu. |
| kivetala | int | Data source did not contain a description for KIVETALA. Column kivetala has 19473 rows, out of which 806 are empty, making the null percent 4.14. Minimum value is 0 and maximum value is 4000. |
| kivetpuut | string | Data source did not contain a description for KIVETPUUT. Column kivetpuut has 19473 rows, out of which 18334 are empty, making the null percent 94.15. Minimum string is and maximum string is ympyrän reunassa. |
| 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 19473 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 19473 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 19473 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 19473 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 19473 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 19473 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 19473 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 19473 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 19473 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.7638096935... and first 25 characters of maximum string: MULTILINESTRING ((30.9389... |
| 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 19473 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 |