To download the data set, please sign up or log in
Kaistat - Kaistat (Tierekisterin tietolaji 160)
Tables
-
Tl160, Avointl160, Full historyTSV
Aineisto kattaa Väylän ylläpitämän maantieverkon. Tätä tietolajia ei päivitetä, vaan sen sisältö tulee tierekisterin kaistataulusta. Kaistoja ylläpidetään Digiroadissa.
-
Tl160, Avointl160, LatestTSV
Aineisto kattaa Väylän ylläpitämän maantieverkon. Tätä tietolajia ei päivitetä, vaan sen sisältö tulee tierekisterin kaistataulusta. Kaistoja ylläpidetään Digiroadissa.
Column Descriptions
Tl160, Avointl160, Full history
| Column | Type | Comment |
|---|---|---|
| ely | int | Data source did not contain a description for ELY. Column ely has 94401 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 94401 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 94401 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 94401 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 94401 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 94401 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 26063. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 94401 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 94401 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 31584. |
| id_sama | int | Data source did not contain a description for ID_SAMA. Column id_sama has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 79492 and maximum value is 300640896. |
| 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. |
| katyyppi | int | Data source did not contain a description for KATYYPPI. Column katyyppi has 94401 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 20. |
| s_katyyppi | string | Data source did not contain a description for S_KATYYPPI. Column s_katyyppi has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is joukkoliik and maximum string is yhd.käpy. |
| 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. |
| poisto | int | Data source did not contain a description for POISTO. Column poisto has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| reittiavai | int | Data source did not contain a description for REITTIAVAI. Column reittiavai has 94401 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 995070. |
| etaisyysti | int | Data source did not contain a description for ETAISYYSTI. Column etaisyysti has 94401 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 1281319. |
| etaisyyst0 | int | Data source did not contain a description for ETAISYYST0. Column etaisyyst0 has 94401 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 1281937. |
| ualue | int | Data source did not contain a description for UALUE. Column ualue has 94401 rows, out of which 302 are empty, making the null percent 0.32. Minimum value is 129 and maximum value is 9999. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 94401 rows, out of which 302 are empty, making the null percent 0.32. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 94401 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 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum value is 1 and maximum value is 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Oulun l??ni. |
| status | int | Data source did not contain a description for STATUS. Column status has 94401 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 3. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 94401 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.7650111244... and first 25 characters of maximum string: MULTILINESTRING ((28.1705... |
| 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 94401 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. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Tl160, Avointl160, Latest
| Column | Type | Comment |
|---|---|---|
| ely | int | Data source did not contain a description for ELY. Column ely has 94401 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 94401 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 94401 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 94401 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 94401 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 94401 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 26063. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 94401 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 94401 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 31584. |
| id_sama | int | Data source did not contain a description for ID_SAMA. Column id_sama has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 79492 and maximum value is 300640896. |
| 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. |
| katyyppi | int | Data source did not contain a description for KATYYPPI. Column katyyppi has 94401 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 20. |
| s_katyyppi | string | Data source did not contain a description for S_KATYYPPI. Column s_katyyppi has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is joukkoliik and maximum string is yhd.käpy. |
| 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. |
| poisto | int | Data source did not contain a description for POISTO. Column poisto has 94401 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| reittiavai | int | Data source did not contain a description for REITTIAVAI. Column reittiavai has 94401 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 995070. |
| etaisyysti | int | Data source did not contain a description for ETAISYYSTI. Column etaisyysti has 94401 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 1281319. |
| etaisyyst0 | int | Data source did not contain a description for ETAISYYST0. Column etaisyyst0 has 94401 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 1281937. |
| ualue | int | Data source did not contain a description for UALUE. Column ualue has 94401 rows, out of which 302 are empty, making the null percent 0.32. Minimum value is 129 and maximum value is 9999. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 94401 rows, out of which 302 are empty, making the null percent 0.32. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 94401 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 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum value is 1 and maximum value is 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 94401 rows, out of which 301 are empty, making the null percent 0.32. Minimum string is and maximum string is Oulun l??ni. |
| status | int | Data source did not contain a description for STATUS. Column status has 94401 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 3. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 94401 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.7650111244... and first 25 characters of maximum string: MULTILINESTRING ((28.1705... |
| 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 94401 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 10, 2020 |
|---|---|
| Created | September 10, 2020 |