To download the data set, please sign up or log in
Leveysrajoitus
Tables
-
Tl264, Avointl264, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin viedään suurten erikoiskuljetusten tavoiteverkkoon kuuluvilta maanteiltä, rampeilta katuosuuksilta sekä viereisistä silta-aukoista ne leveysrajoitukset, joiden kohdalla vapaa leveys on alle 10,5 metriä. Leveysrajoituksen osoitteena käytetään tietolajilla 262 ilmoitetun vastaavan alikulkupaikan osoitetta mikäli rajoitus liittyy ko. alikulkupaikkaan. Vapaa leveys määritellään ajoratakohtaisesti ja se voi olla erilainen 1-ajorataisen tien eri ajosuunnille (oikea / vasen) tien mittaussuunnassa (vrt.TL263).
Column Descriptions
Tl264, Avointl264, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 5257 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 69713 and maximum value is 74969. |
| ely | int | Data source did not contain a description for ELY. Column ely has 5257 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 5257 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 88857. |
| 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 5257 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 5257 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 933. |
| aet | int | Data source did not contain a description for AET. Column aet has 5257 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 24839. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 5257 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 9. |
| 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. |
| levrajty | int | Data source did not contain a description for LEVRAJTY. Column levrajty has 5257 rows, out of which 435 are empty, making the null percent 8.27. Minimum value is 1 and maximum value is 9. |
| s_levrajty | string | Data source did not contain a description for S_LEVRAJTY. Column s_levrajty has 5257 rows, out of which 435 are empty, making the null percent 8.27. Minimum string is and maximum string is valaisin. |
| maxlev | int | Data source did not contain a description for MAXLEV. Column maxlev has 5257 rows, out of which 1 are empty, making the null percent 0.02. Minimum value is 200 and maximum value is 2470. |
| kaidelev | int | Data source did not contain a description for KAIDELEV. Column kaidelev has 5257 rows, out of which 3852 are empty, making the null percent 73.27. Minimum value is 350 and maximum value is 1100. |
| levki | int | Data source did not contain a description for LEVKI. Column levki has 5257 rows, out of which 634 are empty, making the null percent 12.06. Minimum value is 0 and maximum value is 9. |
| s_levki | string | Data source did not contain a description for S_LEVKI. Column s_levki has 5257 rows, out of which 634 are empty, making the null percent 12.06. Minimum string is and maximum string is viersilt. |
| kilev | int | Data source did not contain a description for KILEV. Column kilev has 5257 rows, out of which 5117 are empty, making the null percent 97.34. Minimum value is 459 and maximum value is 1685. |
| kaidekork | int | Data source did not contain a description for KAIDEKORK. Column kaidekork has 5257 rows, out of which 3273 are empty, making the null percent 62.26. Minimum value is 35 and maximum value is 231. |
| levraj | string | Data source did not contain a description for LEVRAJ. Column levraj has 5257 rows, out of which 2363 are empty, making the null percent 44.95. Minimum string is and maximum string is Öljysataman portti. |
| 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 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum value is 132 and maximum value is 9000. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 5257 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 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum value is 1 and maximum value is 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 5257 rows, out of which 7 are empty, making the null percent 0.13. Minimum string is and maximum string is Oulun l??ni. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 5257 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 (20.764618450705466... and first 25 characters of maximum string: POINT (31.271571422944213... |
| 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 5257 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 10, 2020 |
|---|---|
| Created | August 1, 2018 |