To download the data set, please sign up or log in
Päällysteen alustankäsittely
Tables
-
Tl152, Avointl152, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tieto rekisteröidään aina, kun 1-ajorataiselle tielle on molempien kaistojen tai 2-ajorataisella tiellä on kaistan leveydelle tehty toimenpide vanhalle päällysteelle (+kantavalle kerrokselle) päällystysvuonna ennen varsinaista kulutuskerroksen levittämistä. Tierekisteriin viedään käytetyn käsittelymenetelmän sekä kerrospaksuuden suhteen yhtenäiset osuudet. Päällysteen alustankäsittelyllä tarkoitetaan toimenpiteitä, jotka tehdään vanhalle päällysteelle (+kantavalle kerrokselle) päällystysvuonna ennen varsinaista pinnaksi jäävän uuden päällysteen levittämistä. Tällaisia toimenpiteitä ovat yleensä kevyet, kantavuutta lisäävät parantamistoimenpiteet sekä erilaiset tasaus- ja jyrsintätoimenpiteet. Mikäli alustankäsittely (lähinnä...
Column Descriptions
Tl152, Avointl152, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 48596 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 314339 and maximum value is 363240. |
| ely | int | Data source did not contain a description for ELY. Column ely has 48596 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 48596 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 97128. |
| 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 48596 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. |
| kaista | int | Data source did not contain a description for KAISTA. Column kaista has 48596 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 31. |
| aosa | int | Data source did not contain a description for AOSA. Column aosa has 48596 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 999. |
| aet | int | Data source did not contain a description for AET. Column aet has 48596 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 24231. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 48596 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 999. |
| let | int | Data source did not contain a description for LET. Column let has 48596 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 24905. |
| 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. |
| alustaka | int | Data source did not contain a description for ALUSTAKA. Column alustaka has 48596 rows, out of which 6 are empty, making the null percent 0.01. Minimum value is 1 and maximum value is 99. |
| s_alustaka | string | Data source did not contain a description for S_ALUSTAKA. Column s_alustaka has 48596 rows, out of which 6 are empty, making the null percent 0.01. Minimum string is and maximum string is VBST. |
| alustapaks | int | Data source did not contain a description for ALUSTAPAKS. Column alustapaks has 48596 rows, out of which 16848 are empty, making the null percent 34.67. Minimum value is 1 and maximum value is 200. |
| alustaseli | string | Data source did not contain a description for ALUSTASELI. Column alustaseli has 48596 rows, out of which 38524 are empty, making the null percent 79.27. Minimum string is and maximum string is verkko TAS kerrokseen. |
| 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 48596 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 48596 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 48596 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 48596 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 48596 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 48596 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 48596 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 48596 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 48596 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.7518273625... and first 25 characters of maximum string: MULTILINESTRING ((27.5731... |
| 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 48596 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 9, 2020 |
|---|---|
| Created | July 9, 2018 |