To download the data set, please sign up or log in
Vallu-järjestelmän linja-autoreitit
Tables
-
Vallu Linjaukset, Avoinvallu LinjauksetTSV
Aineisto sisältää kaikki VALLU-tietojärjestelmän sisältämät voimassa olevat ja tulevaisuudessa voimaan tulevat linja-autovuorot. Vuorot kuvataan niiden kulkeman reitin mukaisina viivageometrioina.
Column Descriptions
Vallu Linjaukset, Avoinvallu Linjaukset
| Column | Type | Comment |
|---|---|---|
| vuorolisa2 | int | Data source did not contain a description for VUOROLISA2. Column vuorolisa2 has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| tyyppi | string | Data source did not contain a description for TYYPPI. Column tyyppi has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| vira_myon | int | Data source did not contain a description for VIRA_MYON. Column vira_myon has 6170 rows, out of which 4326 are empty, making the null percent 70.11. Minimum value is 106 and maximum value is 740. |
| vira_myo_1 | string | Data source did not contain a description for VIRA_MYO_1. Column is empty. |
| myon_viran | string | Data source did not contain a description for MYON_VIRAN. Column myon_viran has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| vira_valv | int | Data source did not contain a description for VIRA_VALV. Column vira_valv has 6170 rows, out of which 4325 are empty, making the null percent 70.10. Minimum value is 106 and maximum value is 837. |
| valv_viran | string | Data source did not contain a description for VALV_VIRAN. Column valv_viran has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| lu_voim_pv | timestamp | Data source did not contain a description for LU_VOIM_PV. Column lu_voim_pv has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009-12-03 00:00:00 and maximum value is 2018-09-10 00:00:00. |
| lu_lop_pvm | timestamp | Data source did not contain a description for LU_LOP_PVM. |
| lu_tod_lop | timestamp | Data source did not contain a description for LU_TOD_LOP. |
| lupsopmuok | timestamp | Data source did not contain a description for LUPSOPMUOK. Column lupsopmuok has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013-10-04 08:04:04 and maximum value is 2018-09-17 13:20:10. |
| lupasoptun | string | Data source did not contain a description for LUPASOPTUN. Column lupasoptun has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| liikharnro | int | Data source did not contain a description for LIIKHARNRO. Column liikharnro has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6660 and maximum value is 77007. |
| liikhar | string | Data source did not contain a description for LIIKHAR. Column liikhar has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| reittinrop | int | Data source did not contain a description for REITTINROP. Column reittinrop has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 70071 and maximum value is 261604. |
| ajosuunta | string | Data source did not contain a description for AJOSUUNTA. Column ajosuunta has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| reittinimi | string | Data source did not contain a description for REITTINIMI. Column reittinimi has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| otsatunnus | int | Data source did not contain a description for OTSATUNNUS. Column otsatunnus has 6170 rows, out of which 5704 are empty, making the null percent 92.45. Minimum value is 1 and maximum value is 989. |
| reittivoim | timestamp | Data source did not contain a description for REITTIVOIM. Column reittivoim has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009-12-03 00:00:00 and maximum value is 2019-01-01 00:00:00. |
| reittipaat | timestamp | Data source did not contain a description for REITTIPAAT. Column reittipaat has 6170 rows, out of which 4755 are empty, making the null percent 77.07. Minimum value is 2018-09-18 23:59:59 and maximum value is 2023-06-03 23:59:59. |
| reittimuok | timestamp | Data source did not contain a description for REITTIMUOK. Column reittimuok has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-03-03 12:55:28 and maximum value is 2018-09-13 12:57:50. |
| vuoro_pys | int | Data source did not contain a description for VUORO_PYS. Column vuoro_pys has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 300474 and maximum value is 1065808. |
| vuoromerk | string | Data source did not contain a description for VUOROMERK. Column vuoromerk has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| lahto | int | Data source did not contain a description for LAHTO. Column lahto has 6170 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 2350. |
| perilla | int | Data source did not contain a description for PERILLA. Column perilla has 6170 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 2359. |
| kausi | string | Data source did not contain a description for KAUSI. Column kausi has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| vuorotyyp | string | Data source did not contain a description for VUOROTYYP. Column vuorotyyp has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| vuoro_lisa | int | Data source did not contain a description for VUORO_LISA. Column vuoro_lisa has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 304303 and maximum value is 1065951. |
| vuoro_voim | timestamp | Data source did not contain a description for VUORO_VOIM. Column vuoro_voim has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009-12-03 00:00:00 and maximum value is 2019-02-05 00:00:00. |
| vuoro_paat | timestamp | Data source did not contain a description for VUORO_PAAT. |
| vuoro_muo | timestamp | Data source did not contain a description for VUORO_MUO. Column vuoro_muo has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-03-03 12:51:53 and maximum value is 2018-09-13 12:39:55. |
| koontikart | int | Data source did not contain a description for KOONTIKART. Column koontikart has 6170 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 1. |
| siir_matka | int | Data source did not contain a description for SIIR_MATKA. Column siir_matka has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1. |
| katsel_url | string | Data source did not contain a description for KATSEL_URL. Column katsel_url has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| lupsoptyyp | string | Data source did not contain a description for LUPSOPTYYP. Column lupsoptyyp has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N. |
| lupsopnum | int | Data source did not contain a description for LUPSOPNUM. Column lupsopnum has 6170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500019 and maximum value is 649327. |
| arkipaiva | int | Data source did not contain a description for ARKIPAIVA. Column arkipaiva has 6170 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 1. |
| lauantai | int | Data source did not contain a description for LAUANTAI. Column lauantai has 6170 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 1. |
| sunnuntai | int | Data source did not contain a description for SUNNUNTAI. Column sunnuntai has 6170 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 1. |
| geom_geojson | string | Geometry in GeoJSON format. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 12, 2019 |
|---|---|
| Created | July 9, 2018 |