To download the data set, please sign up or log in
Varoituslaitos (tasoristeys) - Varoituslaitos (RATKOn tietolaji)
Tables
-
Warning device, Avoinwarning device, Full historyTSV
Varoituslaitoksella tarkoitetaan tasoristeyksen turvalaitteita. Aineisto kattaa Väyläviraston omistamat rautatiet.
-
Warning device, Avoinwarning device, LatestTSV
Varoituslaitoksella tarkoitetaan tasoristeyksen turvalaitteita. Aineisto kattaa Väyläviraston omistamat rautatiet.
Column Descriptions
Warning device, Avoinwarning device, Full history
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 1.2.246.578.3.116.263892. |
| type | string | Data source did not contain a description for type. Column type has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: warning_device. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2020-04-20T12:20Z. |
| state | string | Data source did not contain a description for state. Column state has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: DELETED. |
| warning_de | string | Data source did not contain a description for warning_de. Column warning_de has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Puolipuomilaitos. |
| warning_d0 | string | Data source did not contain a description for warning_d0. Column warning_d0 has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Mussalo vanha junatoimist... |
| date_of_in | string | Data source did not contain a description for date_of_in. Column is empty. |
| date_of_re | string | Data source did not contain a description for date_of_re. Column is empty. |
| date_of_de | string | Data source did not contain a description for date_of_de. Column is empty. |
| instructio | int | Data source did not contain a description for instructio. Column instructio has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 20467. |
| instructi0 | string | Data source did not contain a description for instructi0. Column instructi0 has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: B. |
| name | string | Data source did not contain a description for name. Column name has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Mussalo vanha junatoimist... |
| owner | string | Data source did not contain a description for owner. Column owner has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Väylävirasto. |
| 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 is empty. |
| routenumbe | string | Data source did not contain a description for routenumbe. Column is empty. |
| kmm | string | Data source did not contain a description for kmm. Column is empty. |
| km | string | Data source did not contain a description for km. Column is empty. |
| m | string | Data source did not contain a description for m. Column is empty. |
| 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. |
Warning device, Avoinwarning device, Latest
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 1.2.246.578.3.116.263892. |
| type | string | Data source did not contain a description for type. Column type has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: warning_device. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2020-04-20T12:20Z. |
| state | string | Data source did not contain a description for state. Column state has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: DELETED. |
| warning_de | string | Data source did not contain a description for warning_de. Column warning_de has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Puolipuomilaitos. |
| warning_d0 | string | Data source did not contain a description for warning_d0. Column warning_d0 has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Mussalo vanha junatoimist... |
| date_of_in | string | Data source did not contain a description for date_of_in. Column is empty. |
| date_of_re | string | Data source did not contain a description for date_of_re. Column is empty. |
| date_of_de | string | Data source did not contain a description for date_of_de. Column is empty. |
| instructio | int | Data source did not contain a description for instructio. Column instructio has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 20467. |
| instructi0 | string | Data source did not contain a description for instructi0. Column instructi0 has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: B. |
| name | string | Data source did not contain a description for name. Column name has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Mussalo vanha junatoimist... |
| owner | string | Data source did not contain a description for owner. Column owner has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Väylävirasto. |
| 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 is empty. |
| routenumbe | string | Data source did not contain a description for routenumbe. Column is empty. |
| kmm | string | Data source did not contain a description for kmm. Column is empty. |
| km | string | Data source did not contain a description for km. Column is empty. |
| m | string | Data source did not contain a description for m. Column is empty. |
| 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. |
Additional Info
| Last Updated | September 10, 2020 |
|---|---|
| Created | September 10, 2020 |