To download the data set, please sign up or log in
Pohjanvahvistukset ja pohjarakenteet
Tables
-
Tl171, Avointl171, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tietolaji on tarkoitettu teiden pohjarakenteiden ja pohjanvahvistuskohteiden rekisteröintiin. Inventointi tehdään aluksi toimistotyönä vanhojen suunnitelmien ja piirustusten perusteella. Uusien teiden ja peruskorjausten tiedot rekisteröidään aina. Tietolajille viedään tiedot aina, jos kohde sisältää pohjanvahvistuksia tai -rakenteita, penkereessä tai sen alla on käytetty arinoita tai lujitteita, on käytetty pengerkeventeitä tai tien stabiliteettia on parannettu. Tiedot saadaan suunnitelmista tai urakoitsijoilta.
Column Descriptions
Tl171, Avointl171, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3809 and maximum value is 4088. |
| ely | int | Data source did not contain a description for ELY. Column ely has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 12. |
| tie | int | Data source did not contain a description for TIE. Column tie has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6 and maximum value is 77252. |
| 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 280 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 280 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 280 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 13254. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 280 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 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40 and maximum value is 13536. |
| 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. |
| pohjvahv | int | Data source did not contain a description for POHJVAHV. Column pohjvahv has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 99. |
| s_pohjvahv | string | Data source did not contain a description for S_POHJVAHV. Column s_pohjvahv has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is maanvar and maximum string is syvstbpil. |
| rakvuosi | int | Data source did not contain a description for RAKVUOSI. Column rakvuosi has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2018. |
| lujiarin | int | Data source did not contain a description for LUJIARIN. Column lujiarin has 280 rows, out of which 222 are empty, making the null percent 79.29. Minimum value is 1 and maximum value is 3. |
| s_lujiarin | string | Data source did not contain a description for S_LUJIARIN. Column s_lujiarin has 280 rows, out of which 222 are empty, making the null percent 79.29. Minimum string is and maximum string is teräsv. |
| kevennys | int | Data source did not contain a description for KEVENNYS. Column kevennys has 280 rows, out of which 268 are empty, making the null percent 95.71. Minimum value is 1 and maximum value is 7. |
| s_kevennys | string | Data source did not contain a description for S_KEVENNYS. Column s_kevennys has 280 rows, out of which 268 are empty, making the null percent 95.71. Minimum string is and maximum string is vaahtolas. |
| stabpar | int | Data source did not contain a description for STABPAR. Column stabpar has 280 rows, out of which 278 are empty, making the null percent 99.29. Minimum value is 7 and maximum value is 8. |
| s_stabpar | string | Data source did not contain a description for S_STABPAR. Column s_stabpar has 280 rows, out of which 278 are empty, making the null percent 99.29. Minimum string is and maximum string is tuksei-ul. |
| pohjamaa | int | Data source did not contain a description for POHJAMAA. Column pohjamaa has 280 rows, out of which 246 are empty, making the null percent 87.86. Minimum value is 1 and maximum value is 6. |
| s_pohjamaa | string | Data source did not contain a description for S_POHJAMAA. Column s_pohjamaa has 280 rows, out of which 246 are empty, making the null percent 87.86. Minimum string is and maximum string is Tv. |
| koerak | int | Data source did not contain a description for KOERAK. Column koerak has 280 rows, out of which 279 are empty, making the null percent 99.64. Constant value is 2. |
| s_koerak | string | Data source did not contain a description for S_KOERAK. Column s_koerak has 280 rows, out of which 279 are empty, making the null percent 99.64. The single string value is: . |
| uusiomat | float | Data source did not contain a description for UUSIOMAT. Column is empty. |
| s_uusiomat | string | Data source did not contain a description for S_UUSIOMAT. Column is empty. |
| levenrak | float | Data source did not contain a description for LEVENRAK. Column is empty. |
| s_levenrak | string | Data source did not contain a description for S_LEVENRAK. Column is empty. |
| lahde | int | Data source did not contain a description for LAHDE. Column lahde has 280 rows, out of which 176 are empty, making the null percent 62.86. Minimum value is 1 and maximum value is 5. |
| s_lahde | string | Data source did not contain a description for S_LAHDE. Column s_lahde has 280 rows, out of which 176 are empty, making the null percent 62.86. Minimum string is and maximum string is totpiir. |
| arktunnus | string | Data source did not contain a description for ARKTUNNUS. Column arktunnus has 280 rows, out of which 271 are empty, making the null percent 96.79. Minimum string is and maximum string is SJYR. |
| lisainfo | string | Data source did not contain a description for LISAINFO. Column lisainfo has 280 rows, out of which 210 are empty, making the null percent 75.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vaunusuonsiltojen tulopen... |
| apkoord | float | Data source did not contain a description for APKOORD. Column is empty. |
| aikoord | float | Data source did not contain a description for AIKOORD. Column is empty. |
| lpkoord | float | Data source did not contain a description for LPKOORD. Column is empty. |
| likoord | float | Data source did not contain a description for LIKOORD. Column is empty. |
| koordin | int | Data source did not contain a description for KOORDIN. Column koordin has 280 rows, out of which 273 are empty, making the null percent 97.50. Minimum value is 1 and maximum value is 4. |
| s_koordin | string | Data source did not contain a description for S_KOORDIN. Column s_koordin has 280 rows, out of which 273 are empty, making the null percent 97.50. Minimum string is and maximum string is KKJ. |
| 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 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 235 and maximum value is 1247. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hamina-Vaalimaa 17- and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 280 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 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavieska and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 17. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 280 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 280 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 280 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 (21.8372927567... and first 25 characters of maximum string: LINESTRING (27.8516949409... |
| 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 280 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. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | July 9, 2018 |