To download the data set, please sign up or log in
Suojatiet
Tables
-
Tl310, Avointl310, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Liittymissä olevat suojatiet rekisteröidään liitymätietoina (kts. solmut, liittymät ja liittymätiedot). Sen lisäksi niistä ja muuallakin olevista suojateistä voi kerätä tarkempia tietoja tälle tietolajille.
Column Descriptions
Tl310, Avointl310, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 10917 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 135196 and maximum value is 147208. |
| ely | int | Data source did not contain a description for ELY. Column ely has 10917 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 10917 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 99507. |
| 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 10917 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 10917 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 993. |
| aet | int | Data source did not contain a description for AET. Column aet has 10917 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 24776. |
| 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. |
| mater310 | int | Data source did not contain a description for MATER310. Column mater310 has 10917 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 9. |
| s_mater310 | string | Data source did not contain a description for S_MATER310. Column s_mater310 has 10917 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ei tietoa and maximum string is upkesto. |
| varo310 | int | Data source did not contain a description for VARO310. Column varo310 has 10917 rows, out of which 3169 are empty, making the null percent 29.03. Minimum value is 0 and maximum value is 1. |
| s_varo310 | string | Data source did not contain a description for S_VARO310. Column s_varo310 has 10917 rows, out of which 3169 are empty, making the null percent 29.03. Minimum string is and maximum string is merkki. |
| keskikor | int | Data source did not contain a description for KESKIKOR. Column keskikor has 10917 rows, out of which 2379 are empty, making the null percent 21.79. Minimum value is 0 and maximum value is 1. |
| s_keskikor | string | Data source did not contain a description for S_KESKIKOR. Column s_keskikor has 10917 rows, out of which 2379 are empty, making the null percent 21.79. Minimum string is and maximum string is on. |
| stopviiv | int | Data source did not contain a description for STOPVIIV. Column stopviiv has 10917 rows, out of which 3195 are empty, making the null percent 29.27. Minimum value is 0 and maximum value is 1. |
| s_stopviiv | string | Data source did not contain a description for S_STOPVIIV. Column s_stopviiv has 10917 rows, out of which 3195 are empty, making the null percent 29.27. Minimum string is and maximum string is on. |
| korotus3 | int | Data source did not contain a description for KOROTUS3. Column korotus3 has 10917 rows, out of which 4392 are empty, making the null percent 40.23. Minimum value is 0 and maximum value is 1. |
| s_korotus3 | string | Data source did not contain a description for S_KOROTUS3. Column s_korotus3 has 10917 rows, out of which 4392 are empty, making the null percent 40.23. Minimum string is and maximum string is on. |
| kuvu310 | int | Data source did not contain a description for KUVU310. Column kuvu310 has 10917 rows, out of which 10052 are empty, making the null percent 92.08. Minimum value is 1985 and maximum value is 2019. |
| kukk310 | int | Data source did not contain a description for KUKK310. Column kukk310 has 10917 rows, out of which 10588 are empty, making the null percent 96.99. Minimum value is 1 and maximum value is 12. |
| 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 10917 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 10917 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 10917 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 10917 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 10917 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 10917 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 10917 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 10917 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 10917 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (21.12211741531399 ... and first 25 characters of maximum string: POINT (30.954859443049518... |
| 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 10917 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | July 9, 2018 |