To download the data set, please sign up or log in
Tasoristeys - Tasoristeys (RATKOn tietolaji)
Tables
-
Level crossing, Avoinlevel crossing, Full historyTSV
Tasoristeyksellä tarkoitetaan kaikkia samalla tasolla olevia risteymäkohtia rautatien ja infrastruktuurin haltijan tunnustamien ja julkisille tai yksityisille käyttäjille avoimien kulkuväylien välillä. Tasoristeykseen kuuluvat myös kaikki siihen tarvittavat laitteet mukaan lukien päällyskansi tai -kannet. Aineisto kattaa Väyläviraston omistamat rautatiet.
-
Level crossing, Avoinlevel crossing, LatestTSV
Tasoristeyksellä tarkoitetaan kaikkia samalla tasolla olevia risteymäkohtia rautatien ja infrastruktuurin haltijan tunnustamien ja julkisille tai yksityisille käyttäjille avoimien kulkuväylien välillä. Tasoristeykseen kuuluvat myös kaikki siihen tarvittavat laitteet mukaan lukien päällyskansi tai -kannet. Aineisto kattaa Väyläviraston omistamat rautatiet.
Column Descriptions
Level crossing, Avoinlevel crossing, Latest
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 3318 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.113.257089 and maximum string is 1.2.246.578.3.113.400661. |
| type | string | Data source did not contain a description for type. Column type has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: level_crossing. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-05-09T10:17Z and maximum string is 2020-07-10T05:19Z. |
| state | string | Data source did not contain a description for state. Column state has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DELETED and maximum string is NOT IN USE. |
| id | string | Data source did not contain a description for id. Column id has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AHL1/04 and maximum string is ÄS /05. |
| class_of_r | string | Data source did not contain a description for class_of_r. Column class_of_r has 3318 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 Yksityistie. |
| amount_of | int | Data source did not contain a description for amount_of. Column amount_of has 3318 rows, out of which 44 are empty, making the null percent 1.33. Minimum value is 1 and maximum value is 12. |
| amount_of0 | int | Data source did not contain a description for amount_of0. Column amount_of0 has 3318 rows, out of which 615 are empty, making the null percent 18.54. Minimum value is 1 and maximum value is 8. |
| daily_pass | int | Data source did not contain a description for daily_pass. Column daily_pass has 3318 rows, out of which 2086 are empty, making the null percent 62.87. Minimum value is 1 and maximum value is 215. |
| daily_frei | int | Data source did not contain a description for daily_frei. Column daily_frei has 3318 rows, out of which 1053 are empty, making the null percent 31.74. Minimum value is 1 and maximum value is 40. |
| daily_road | int | Data source did not contain a description for daily_road. Column daily_road has 3318 rows, out of which 1456 are empty, making the null percent 43.88. Minimum value is 1 and maximum value is 12244. |
| date_of_in | string | Data source did not contain a description for date_of_in. Column date_of_in has 3318 rows, out of which 740 are empty, making the null percent 22.30. Minimum string is and maximum string is 2020-06-11T08:22Z. |
| restricted | string | Data source did not contain a description for restricted. Column restricted has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Kyllä. |
| road_numbe | int | Data source did not contain a description for road_numbe. Column road_numbe has 3318 rows, out of which 2812 are empty, making the null percent 84.75. Minimum value is 1 and maximum value is 49505. |
| road_name | string | Data source did not contain a description for road_name. Column road_name has 3318 rows, out of which 1572 are empty, making the null percent 47.38. Minimum string is and maximum string is Östermarksvägen. |
| road_speed | int | Data source did not contain a description for road_speed. Column road_speed has 3318 rows, out of which 780 are empty, making the null percent 23.51. Minimum value is 10 and maximum value is 80. |
| max_crossi | int | Data source did not contain a description for max_crossi. Column max_crossi has 3318 rows, out of which 1720 are empty, making the null percent 51.84. Minimum value is 10 and maximum value is 80. |
| road_surfa | string | Data source did not contain a description for road_surfa. Column road_surfa has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asfaltti and maximum string is Öljysora. |
| grit_box | string | Data source did not contain a description for grit_box. Column grit_box has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Ei tiedossa. |
| liftable_o | string | Data source did not contain a description for liftable_o. Column liftable_o has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Ei tiedossa. |
| liftable_0 | string | Data source did not contain a description for liftable_0. Column is empty. |
| road_appro | string | Data source did not contain a description for road_appro. Column road_appro has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei kunnossa and maximum string is Lähes kunnossa. |
| length_of | string | Data source did not contain a description for length_of. Column length_of has 3318 rows, out of which 3313 are empty, making the null percent 99.85. Minimum string is and maximum string is 6.0. |
| rail_cant | string | Data source did not contain a description for rail_cant. Column is empty. |
| nearby_roa | string | Data source did not contain a description for nearby_roa. Column nearby_roa has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Kyllä. |
| sight_dist | int | Data source did not contain a description for sight_dist. Column sight_dist has 3318 rows, out of which 640 are empty, making the null percent 19.29. Minimum value is -99 and maximum value is 1449. |
| sight_dis0 | int | Data source did not contain a description for sight_dis0. Column sight_dis0 has 3318 rows, out of which 732 are empty, making the null percent 22.06. Minimum value is 5 and maximum value is 1449. |
| sight_dis1 | int | Data source did not contain a description for sight_dis1. Column sight_dis1 has 3318 rows, out of which 731 are empty, making the null percent 22.03. Minimum value is 10 and maximum value is 1449. |
| sight_dis2 | int | Data source did not contain a description for sight_dis2. Column sight_dis2 has 3318 rows, out of which 733 are empty, making the null percent 22.09. Minimum value is 10 and maximum value is 1449. |
| sight_dis3 | int | Data source did not contain a description for sight_dis3. Column sight_dis3 has 3318 rows, out of which 732 are empty, making the null percent 22.06. Minimum value is 15 and maximum value is 1449. |
| accident_c | int | Data source did not contain a description for accident_c. Column accident_c has 3318 rows, out of which 846 are empty, making the null percent 25.50. Minimum value is 1 and maximum value is 7. |
| accident_p | float | Data source did not contain a description for accident_p. Column accident_p has 3318 rows, out of which 912 are empty, making the null percent 27.49. Minimum value is 0.01 and maximum value is 2.74. |
| accident_0 | float | Data source did not contain a description for accident_0. Column accident_0 has 3318 rows, out of which 1583 are empty, making the null percent 47.71. Minimum value is 0.01 and maximum value is 0.53. |
| date_of_de | string | Data source did not contain a description for date_of_de. Column date_of_de has 3318 rows, out of which 3316 are empty, making the null percent 99.94. Minimum string is and maximum string is 2020-09-29T23:00Z. |
| level_cros | int | Data source did not contain a description for level_cros. Column level_cros has 3318 rows, out of which 735 are empty, making the null percent 22.15. Minimum value is 15 and maximum value is 161. |
| level_cro0 | int | Data source did not contain a description for level_cro0. Column level_cro0 has 3318 rows, out of which 736 are empty, making the null percent 22.18. Minimum value is 15 and maximum value is 159. |
| name | string | Data source did not contain a description for name. Column name has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakeenkatu TUS /02 and maximum string is Österskogas NÄR /03. |
| owner | string | Data source did not contain a description for owner. Column owner has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Väylävirasto. |
| level_cro1 | string | Data source did not contain a description for level_cro1. Column level_cro1 has 3318 rows, out of which 297 are empty, making the null percent 8.95. Minimum string is and maximum string is 1.2.246.578.3.115.405532. |
| warning_de | string | Data source did not contain a description for warning_de. Column warning_de has 3318 rows, out of which 2548 are empty, making the null percent 76.79. Minimum string is and maximum string is 1.2.246.578.3.116.405674. |
| level_cro2 | string | Data source did not contain a description for level_cro2. Column level_cro2 has 3318 rows, out of which 102 are empty, making the null percent 3.07. Minimum string is and maximum string is 1.2.246.578.3.114.400468. |
| maintenanc | string | Data source did not contain a description for maintenanc. Column maintenanc has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum string is and maximum string is Pohjois-Suomi. |
| maintenan0 | int | Data source did not contain a description for maintenan0. Column maintenan0 has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 1 and maximum value is 12. |
| operating | string | Data source did not contain a description for operating. Column operating has 3318 rows, out of which 382 are empty, making the null percent 11.51. Minimum string is and maximum string is Tampere. |
| accounting | string | Data source did not contain a description for accounting. Column accounting has 3318 rows, out of which 2 are empty, making the null percent 0.06. First 25 characters of minimum string: ... and first 25 characters of maximum string: 2214 Muut alue 12, (Tuira... |
| locationtr | int | Data source did not contain a description for locationtr. Column locationtr has 3318 rows, out of which 882 are empty, making the null percent 26.58. Minimum value is 2 and maximum value is 751. |
| routenumbe | int | Data source did not contain a description for routenumbe. Column routenumbe has 3318 rows, out of which 209 are empty, making the null percent 6.30. Minimum value is 1 and maximum value is 751. |
| kmm | string | Data source did not contain a description for kmm. Column kmm has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum string is and maximum string is 1133+0523. |
| km | int | Data source did not contain a description for km. Column km has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 0 and maximum value is 1133. |
| m | int | Data source did not contain a description for m. Column m has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 0 and maximum value is 1208. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (21.220906643595868... and first 25 characters of maximum string: POINT (30.952454927535058... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 30.95. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.82 and maximum value is 67.46. |
| geom_type | string | Geometry type. Column geom_type has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
Level crossing, Avoinlevel crossing, Full history
| Column | Type | Comment |
|---|---|---|
| oid | string | Data source did not contain a description for oid. Column oid has 3318 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.113.257089 and maximum string is 1.2.246.578.3.113.400661. |
| type | string | Data source did not contain a description for type. Column type has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: level_crossing. |
| temporalst | string | Data source did not contain a description for temporalst. Column temporalst has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-05-09T10:17Z and maximum string is 2020-07-10T05:19Z. |
| state | string | Data source did not contain a description for state. Column state has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DELETED and maximum string is NOT IN USE. |
| id | string | Data source did not contain a description for id. Column id has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AHL1/04 and maximum string is ÄS /05. |
| class_of_r | string | Data source did not contain a description for class_of_r. Column class_of_r has 3318 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 Yksityistie. |
| amount_of | int | Data source did not contain a description for amount_of. Column amount_of has 3318 rows, out of which 44 are empty, making the null percent 1.33. Minimum value is 1 and maximum value is 12. |
| amount_of0 | int | Data source did not contain a description for amount_of0. Column amount_of0 has 3318 rows, out of which 615 are empty, making the null percent 18.54. Minimum value is 1 and maximum value is 8. |
| daily_pass | int | Data source did not contain a description for daily_pass. Column daily_pass has 3318 rows, out of which 2086 are empty, making the null percent 62.87. Minimum value is 1 and maximum value is 215. |
| daily_frei | int | Data source did not contain a description for daily_frei. Column daily_frei has 3318 rows, out of which 1053 are empty, making the null percent 31.74. Minimum value is 1 and maximum value is 40. |
| daily_road | int | Data source did not contain a description for daily_road. Column daily_road has 3318 rows, out of which 1456 are empty, making the null percent 43.88. Minimum value is 1 and maximum value is 12244. |
| date_of_in | string | Data source did not contain a description for date_of_in. Column date_of_in has 3318 rows, out of which 740 are empty, making the null percent 22.30. Minimum string is and maximum string is 2020-06-11T08:22Z. |
| restricted | string | Data source did not contain a description for restricted. Column restricted has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Kyllä. |
| road_numbe | int | Data source did not contain a description for road_numbe. Column road_numbe has 3318 rows, out of which 2812 are empty, making the null percent 84.75. Minimum value is 1 and maximum value is 49505. |
| road_name | string | Data source did not contain a description for road_name. Column road_name has 3318 rows, out of which 1572 are empty, making the null percent 47.38. Minimum string is and maximum string is Östermarksvägen. |
| road_speed | int | Data source did not contain a description for road_speed. Column road_speed has 3318 rows, out of which 780 are empty, making the null percent 23.51. Minimum value is 10 and maximum value is 80. |
| max_crossi | int | Data source did not contain a description for max_crossi. Column max_crossi has 3318 rows, out of which 1720 are empty, making the null percent 51.84. Minimum value is 10 and maximum value is 80. |
| road_surfa | string | Data source did not contain a description for road_surfa. Column road_surfa has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asfaltti and maximum string is Öljysora. |
| grit_box | string | Data source did not contain a description for grit_box. Column grit_box has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Ei tiedossa. |
| liftable_o | string | Data source did not contain a description for liftable_o. Column liftable_o has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Ei tiedossa. |
| liftable_0 | string | Data source did not contain a description for liftable_0. Column is empty. |
| road_appro | string | Data source did not contain a description for road_appro. Column road_appro has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei kunnossa and maximum string is Lähes kunnossa. |
| length_of | string | Data source did not contain a description for length_of. Column length_of has 3318 rows, out of which 3313 are empty, making the null percent 99.85. Minimum string is and maximum string is 6.0. |
| rail_cant | string | Data source did not contain a description for rail_cant. Column is empty. |
| nearby_roa | string | Data source did not contain a description for nearby_roa. Column nearby_roa has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei and maximum string is Kyllä. |
| sight_dist | int | Data source did not contain a description for sight_dist. Column sight_dist has 3318 rows, out of which 640 are empty, making the null percent 19.29. Minimum value is -99 and maximum value is 1449. |
| sight_dis0 | int | Data source did not contain a description for sight_dis0. Column sight_dis0 has 3318 rows, out of which 732 are empty, making the null percent 22.06. Minimum value is 5 and maximum value is 1449. |
| sight_dis1 | int | Data source did not contain a description for sight_dis1. Column sight_dis1 has 3318 rows, out of which 731 are empty, making the null percent 22.03. Minimum value is 10 and maximum value is 1449. |
| sight_dis2 | int | Data source did not contain a description for sight_dis2. Column sight_dis2 has 3318 rows, out of which 733 are empty, making the null percent 22.09. Minimum value is 10 and maximum value is 1449. |
| sight_dis3 | int | Data source did not contain a description for sight_dis3. Column sight_dis3 has 3318 rows, out of which 732 are empty, making the null percent 22.06. Minimum value is 15 and maximum value is 1449. |
| accident_c | int | Data source did not contain a description for accident_c. Column accident_c has 3318 rows, out of which 846 are empty, making the null percent 25.50. Minimum value is 1 and maximum value is 7. |
| accident_p | float | Data source did not contain a description for accident_p. Column accident_p has 3318 rows, out of which 912 are empty, making the null percent 27.49. Minimum value is 0.01 and maximum value is 2.74. |
| accident_0 | float | Data source did not contain a description for accident_0. Column accident_0 has 3318 rows, out of which 1583 are empty, making the null percent 47.71. Minimum value is 0.01 and maximum value is 0.53. |
| date_of_de | string | Data source did not contain a description for date_of_de. Column date_of_de has 3318 rows, out of which 3316 are empty, making the null percent 99.94. Minimum string is and maximum string is 2020-09-29T23:00Z. |
| level_cros | int | Data source did not contain a description for level_cros. Column level_cros has 3318 rows, out of which 735 are empty, making the null percent 22.15. Minimum value is 15 and maximum value is 161. |
| level_cro0 | int | Data source did not contain a description for level_cro0. Column level_cro0 has 3318 rows, out of which 736 are empty, making the null percent 22.18. Minimum value is 15 and maximum value is 159. |
| name | string | Data source did not contain a description for name. Column name has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakeenkatu TUS /02 and maximum string is Österskogas NÄR /03. |
| owner | string | Data source did not contain a description for owner. Column owner has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Väylävirasto. |
| level_cro1 | string | Data source did not contain a description for level_cro1. Column level_cro1 has 3318 rows, out of which 297 are empty, making the null percent 8.95. Minimum string is and maximum string is 1.2.246.578.3.115.405532. |
| warning_de | string | Data source did not contain a description for warning_de. Column warning_de has 3318 rows, out of which 2548 are empty, making the null percent 76.79. Minimum string is and maximum string is 1.2.246.578.3.116.405674. |
| level_cro2 | string | Data source did not contain a description for level_cro2. Column level_cro2 has 3318 rows, out of which 102 are empty, making the null percent 3.07. Minimum string is and maximum string is 1.2.246.578.3.114.400468. |
| maintenanc | string | Data source did not contain a description for maintenanc. Column maintenanc has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum string is and maximum string is Pohjois-Suomi. |
| maintenan0 | int | Data source did not contain a description for maintenan0. Column maintenan0 has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 1 and maximum value is 12. |
| operating | string | Data source did not contain a description for operating. Column operating has 3318 rows, out of which 382 are empty, making the null percent 11.51. Minimum string is and maximum string is Tampere. |
| accounting | string | Data source did not contain a description for accounting. Column accounting has 3318 rows, out of which 2 are empty, making the null percent 0.06. First 25 characters of minimum string: ... and first 25 characters of maximum string: 2214 Muut alue 12, (Tuira... |
| locationtr | int | Data source did not contain a description for locationtr. Column locationtr has 3318 rows, out of which 882 are empty, making the null percent 26.58. Minimum value is 2 and maximum value is 751. |
| routenumbe | int | Data source did not contain a description for routenumbe. Column routenumbe has 3318 rows, out of which 209 are empty, making the null percent 6.30. Minimum value is 1 and maximum value is 751. |
| kmm | string | Data source did not contain a description for kmm. Column kmm has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum string is and maximum string is 1133+0523. |
| km | int | Data source did not contain a description for km. Column km has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 0 and maximum value is 1133. |
| m | int | Data source did not contain a description for m. Column m has 3318 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 0 and maximum value is 1208. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (21.220906643595868... and first 25 characters of maximum string: POINT (30.952454927535058... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 30.95. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.82 and maximum value is 67.46. |
| geom_type | string | Geometry type. Column geom_type has 3318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 11, 2020 |