To download the data set, please sign up or log in
Radan merkki - Radan merkit (RATKOn tietolaji)
Tables
-
Track sign, Avointrack sign, Full historyTSV
Radan merkeillä välitetään tietoa rautatieliikenteelle ja radanpidolle sekä annetaan informaatiota myös radan läheisyydessä liikkuville ihmisille. Radan merkeistä ilmoitetaan merkkirekisterin tunniste, paikka, lukusuunta, puoli, valmistusnumero, merkkityyppi, teksti, asennuskorkeus, -etäisyys ja -rakenne, kiinnitystapa, kiinnitin, kääntyvä (kyllä, ei, ei tiedossa), tulppa, asennuspäivä, valmistusvuosi, perustus, valmistaja, omistaja ja lisätiedot. Aineisto kattaa Väyläviraston omistamat rautatiet.
-
Track sign, Avointrack sign, LatestTSV
Radan merkeillä välitetään tietoa rautatieliikenteelle ja radanpidolle sekä annetaan informaatiota myös radan läheisyydessä liikkuville ihmisille. Radan merkeistä ilmoitetaan merkkirekisterin tunniste, paikka, lukusuunta, puoli, valmistusnumero, merkkityyppi, teksti, asennuskorkeus, -etäisyys ja -rakenne, kiinnitystapa, kiinnitin, kääntyvä (kyllä, ei, ei tiedossa), tulppa, asennuspäivä, valmistusvuosi, perustus, valmistaja, omistaja ja lisätiedot. Aineisto kattaa Väyläviraston omistamat rautatiet.
Column Descriptions
Track sign, Avointrack sign, Latest
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.3.118.328136 and maximum string is 1.2.246.578.3.118.330698. |
| type | string | Data source did not contain a description for type. Column type has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: track_sign. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-06-25T16:17Z and maximum string is 2019-06-25T16:20Z. |
| state | string | Data source did not contain a description for state. Column state has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN USE. |
| track_sign | int | Data source did not contain a description for track_sign. Column track_sign has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1387124 and maximum value is 1439997. |
| place | string | Data source did not contain a description for place. Column place has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Raideopastin O107. |
| facing_dir | string | Data source did not contain a description for facing_dir. Column facing_dir has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pik-Tur. |
| track_sig0 | string | Data source did not contain a description for track_sig0. Column track_sig0 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: O107. |
| track_sig1 | string | Data source did not contain a description for track_sig1. Column track_sig1 has 2 rows, out of which 1 are empty, making the null percent 50.00. The single string value is: Junakulkutien päätekohta ... |
| manufactur | string | Data source did not contain a description for manufactur. Column is empty. |
| installati | string | Data source did not contain a description for installati. Column is empty. |
| installat0 | string | Data source did not contain a description for installat0. Column is empty. |
| plug | string | Data source did not contain a description for plug. Column is empty. |
| production | int | Data source did not contain a description for production. Column production has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| installat1 | string | Data source did not contain a description for installat1. Column is empty. |
| warranty_e | string | Data source did not contain a description for warranty_e. Column is empty. |
| side | string | Data source did not contain a description for side. Column side has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oikea. |
| swiveling | string | Data source did not contain a description for swiveling. Column swiveling has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| track_sig2 | string | Data source did not contain a description for track_sig2. Column track_sig2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Junakulkutien päätekohta ... and first 25 characters of maximum string: Raideopastimen tunnus... |
| track_sig3 | string | Data source did not contain a description for track_sig3. Column track_sig3 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is T-253 and maximum string is T-259. |
| track_sig4 | string | Data source did not contain a description for track_sig4. Column track_sig4 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tiedossa and maximum string is Muu. |
| installat2 | string | Data source did not contain a description for installat2. Column installat2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Merkkipylväs and maximum string is Raideopastin. |
| foundation | string | Data source did not contain a description for foundation. Column foundation has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| notes | string | Data source did not contain a description for notes. Column notes has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ['Ei tiedossa']. |
| name | string | Data source did not contain a description for name. Column name has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: TKUT 107 0200+0745 Junaku... and first 25 characters of maximum string: TKUT 107 0200+0745 Raideo... |
| owner | string | Data source did not contain a description for owner. Column owner has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| maintenanc | string | Data source did not contain a description for maintenanc. Column is empty. |
| maintenan0 | string | Data source did not contain a description for maintenan0. Column is empty. |
| operating | string | Data source did not contain a description for operating. Column is empty. |
| accounting | string | Data source did not contain a description for accounting. Column is empty. |
| locationtr | string | Data source did not contain a description for locationtr. Column locationtr has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TKUT 107. |
| routenumbe | int | Data source did not contain a description for routenumbe. Column routenumbe has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 332. |
| kmm | string | Data source did not contain a description for kmm. Column kmm has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 0200+0745. |
| km | int | Data source did not contain a description for km. Column km has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 200. |
| m | int | Data source did not contain a description for m. Column m has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 745. |
| geom_geojson | string | Geometry in GeoJSON format. Column is empty. |
| geom_geotext | string | Geometry as GeoText. Column is empty. |
| 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 is empty. |
Track sign, Avointrack sign, Full history
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.3.118.328136 and maximum string is 1.2.246.578.3.118.330698. |
| type | string | Data source did not contain a description for type. Column type has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: track_sign. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-06-25T16:17Z and maximum string is 2019-06-25T16:20Z. |
| state | string | Data source did not contain a description for state. Column state has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN USE. |
| track_sign | int | Data source did not contain a description for track_sign. Column track_sign has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1387124 and maximum value is 1439997. |
| place | string | Data source did not contain a description for place. Column place has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Raideopastin O107. |
| facing_dir | string | Data source did not contain a description for facing_dir. Column facing_dir has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pik-Tur. |
| track_sig0 | string | Data source did not contain a description for track_sig0. Column track_sig0 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: O107. |
| track_sig1 | string | Data source did not contain a description for track_sig1. Column track_sig1 has 2 rows, out of which 1 are empty, making the null percent 50.00. The single string value is: Junakulkutien päätekohta ... |
| manufactur | string | Data source did not contain a description for manufactur. Column is empty. |
| installati | string | Data source did not contain a description for installati. Column is empty. |
| installat0 | string | Data source did not contain a description for installat0. Column is empty. |
| plug | string | Data source did not contain a description for plug. Column is empty. |
| production | int | Data source did not contain a description for production. Column production has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| installat1 | string | Data source did not contain a description for installat1. Column is empty. |
| warranty_e | string | Data source did not contain a description for warranty_e. Column is empty. |
| side | string | Data source did not contain a description for side. Column side has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oikea. |
| swiveling | string | Data source did not contain a description for swiveling. Column swiveling has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| track_sig2 | string | Data source did not contain a description for track_sig2. Column track_sig2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Junakulkutien päätekohta ... and first 25 characters of maximum string: Raideopastimen tunnus... |
| track_sig3 | string | Data source did not contain a description for track_sig3. Column track_sig3 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is T-253 and maximum string is T-259. |
| track_sig4 | string | Data source did not contain a description for track_sig4. Column track_sig4 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tiedossa and maximum string is Muu. |
| installat2 | string | Data source did not contain a description for installat2. Column installat2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Merkkipylväs and maximum string is Raideopastin. |
| foundation | string | Data source did not contain a description for foundation. Column foundation has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| notes | string | Data source did not contain a description for notes. Column notes has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ['Ei tiedossa']. |
| name | string | Data source did not contain a description for name. Column name has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: TKUT 107 0200+0745 Junaku... and first 25 characters of maximum string: TKUT 107 0200+0745 Raideo... |
| owner | string | Data source did not contain a description for owner. Column owner has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa. |
| maintenanc | string | Data source did not contain a description for maintenanc. Column is empty. |
| maintenan0 | string | Data source did not contain a description for maintenan0. Column is empty. |
| operating | string | Data source did not contain a description for operating. Column is empty. |
| accounting | string | Data source did not contain a description for accounting. Column is empty. |
| locationtr | string | Data source did not contain a description for locationtr. Column locationtr has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TKUT 107. |
| routenumbe | int | Data source did not contain a description for routenumbe. Column routenumbe has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 332. |
| kmm | string | Data source did not contain a description for kmm. Column kmm has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 0200+0745. |
| km | int | Data source did not contain a description for km. Column km has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 200. |
| m | int | Data source did not contain a description for m. Column m has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 745. |
| geom_geojson | string | Geometry in GeoJSON format. Column is empty. |
| geom_geotext | string | Geometry as GeoText. Column is empty. |
| 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 is empty. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 8, 2020 |