To download the data set, please sign up or log in
Tekninen toimenpide
Tables
-
Tl133, Avointl133, Full historyTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tekninen toimenpide kertoo milloin tien rakenne on syntynyt ja minkä toimenpiteen seurauksena. Voimaantulopäivämäärän on tarkoitus kertoa minä vuonna ja missä kuussa liikenne on tielle päästetty. Mikäli virallinen yleiselle liikenteelle luovuttaminen on tapahtunut myöhemmin, ilmoitetaan se erikseen tätä tarkoitusta varten varatussa kentässä. Inventointi tapahtuu toimistotyönä suunnitelma yms. asiakirjojen perusteella oheisiin luokkiin.
-
Tl133, Avointl133, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tekninen toimenpide kertoo milloin tien rakenne on syntynyt ja minkä toimenpiteen seurauksena. Voimaantulopäivämäärän on tarkoitus kertoa minä vuonna ja missä kuussa liikenne on tielle päästetty. Mikäli virallinen yleiselle liikenteelle luovuttaminen on tapahtunut myöhemmin, ilmoitetaan se erikseen tätä tarkoitusta varten varatussa kentässä. Inventointi tapahtuu toimistotyönä suunnitelma yms. asiakirjojen perusteella oheisiin luokkiin.
Column Descriptions
Tl133, Avointl133, Full history
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 71277 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 605738 and maximum value is 678001. |
| ely | int | Data source did not contain a description for ELY. Column ely has 71277 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 71277 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 71277 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 71277 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 71277 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 26859. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 71277 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 71277 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 31584. |
| 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. |
| tp | int | Data source did not contain a description for TP. Column tp has 71277 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. |
| s_tp | string | Data source did not contain a description for S_TP. Column s_tp has 71277 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 suuntpar. |
| luovpvm | date | Data source did not contain a description for LUOVPVM. Column is empty. |
| 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 71277 rows, out of which 2 are empty, making the null percent 0.00. 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 71277 rows, out of which 2 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 71277 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 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 71277 rows, out of which 1 are empty, making the null percent 0.00. 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 71277 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.7506785444... and first 25 characters of maximum string: MULTILINESTRING ((30.0356... |
| 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 71277 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. |
Tl133, Avointl133, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 71277 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 605738 and maximum value is 678001. |
| ely | int | Data source did not contain a description for ELY. Column ely has 71277 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 71277 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 71277 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 71277 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 71277 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 26859. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 71277 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 71277 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 31584. |
| 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. |
| tp | int | Data source did not contain a description for TP. Column tp has 71277 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. |
| s_tp | string | Data source did not contain a description for S_TP. Column s_tp has 71277 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 suuntpar. |
| luovpvm | date | Data source did not contain a description for LUOVPVM. Column is empty. |
| 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 71277 rows, out of which 2 are empty, making the null percent 0.00. 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 71277 rows, out of which 2 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 71277 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 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 71277 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 71277 rows, out of which 1 are empty, making the null percent 0.00. 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 71277 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.7506785444... and first 25 characters of maximum string: MULTILINESTRING ((30.0356... |
| 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 71277 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 9, 2020 |