To download the data set, please sign up or log in
Silta
Tables
-
Tl261, Avointl261, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin otetaan kaikki sillat, joiden ylitse yleiset tiet kulkevat. Myös ns. putkisillat rekisteröidään ellei kyseessä ole vesistöön liittyvä, halkaisijaltaan alle 2-metrinen rumpu. Mikäli silta ylittää tien, huomioidaan se ko. tien kannalta ainoastaan tietolajilla alikulkupaikka (262). Maantien suuntaisen kevyen liikenteen väylän sillat rekisteröidään ko. väylälle. Sillan tieosoite määrätään kullakin ajoradalla inventointisuunnassa ensimmäisen ja tien leveyssuunnassa uloimmaisen ukkopilarin kohdalta. Mikäli ukkopilaria ei ole, kuvitellaan sellainen kannen alkuun (liikuntasauma tms.). Risteyssilloilla osoite määräytyy risteävien teiden keskilinjojen mukaan. Sillan ollessa ELYjen rajalla, silta merkitään vain sillasta...
Column Descriptions
Tl261, Avointl261, Latest
| Column | Type | Comment |
|---|---|---|
| siltapit | int | Data source did not contain a description for SILTAPIT. Column siltapit has 18083 rows, out of which 634 are empty, making the null percent 3.51. Minimum value is 2 and maximum value is 1045. |
| kayttota | int | Data source did not contain a description for KAYTTOTA. Column kayttota has 18083 rows, out of which 8 are empty, making the null percent 0.04. Minimum value is 11 and maximum value is 30. |
| s_kayttota | string | Data source did not contain a description for S_KAYTTOTA. Column s_kayttota has 18083 rows, out of which 8 are empty, making the null percent 0.04. Minimum string is and maximum string is yks. |
| siltaura | int | Data source did not contain a description for SILTAURA. Column siltaura has 18083 rows, out of which 16721 are empty, making the null percent 92.47. Minimum value is 400 and maximum value is 5002. |
| s_siltaura | string | Data source did not contain a description for S_SILTAURA. Column s_siltaura has 18083 rows, out of which 16721 are empty, making the null percent 92.47. Minimum string is and maximum string is OSiltopa2. |
| tu_silta | int | Data source did not contain a description for TU_SILTA. Column tu_silta has 18083 rows, out of which 18077 are empty, making the null percent 99.97. Minimum value is 5001 and maximum value is 5002. |
| s_tu_silta | string | Data source did not contain a description for S_TU_SILTA. Column s_tu_silta has 18083 rows, out of which 18077 are empty, making the null percent 99.97. Minimum string is and maximum string is OSiltopa2. |
| siltaval | float | Data source did not contain a description for SILTAVAL. Column is empty. |
| s_siltaval | string | Data source did not contain a description for S_SILTAVAL. 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 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. 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 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 18083 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 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 18083 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 19. |
| maakunta | string | Data source did not contain a description for MAAKUNTA. Column maakunta has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni. |
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1118631 and maximum value is 1166754. |
| ely | int | Data source did not contain a description for ELY. Column ely has 18083 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 18083 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 96515. |
| 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 18083 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 18083 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 18083 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 24465. |
| 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. |
| siltavo | int | Data source did not contain a description for SILTAVO. Column siltavo has 18083 rows, out of which 18041 are empty, making the null percent 99.77. Minimum value is 1 and maximum value is 2. |
| siltanimi | string | Data source did not contain a description for SILTANIMI. Column siltanimi has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakenusjoen silta and maximum string is Överbyn uusi silta. |
| silta_id | int | Data source did not contain a description for SILTA_ID. Column silta_id has 18083 rows, out of which 2510 are empty, making the null percent 13.88. Minimum value is 6 and maximum value is 672652. |
| trex_oid | string | Data source did not contain a description for TREX_OID. Column trex_oid has 18083 rows, out of which 1 are empty, making the null percent 0.01. Minimum string is and maximum string is 1.2.246.578.1.15.905636. |
| akspaino | int | Data source did not contain a description for AKSPAINO. Column akspaino has 18083 rows, out of which 18022 are empty, making the null percent 99.66. Minimum value is 6 and maximum value is 12. |
| telipaino | int | Data source did not contain a description for TELIPAINO. Column telipaino has 18083 rows, out of which 17726 are empty, making the null percent 98.03. Minimum value is 8 and maximum value is 21. |
| telipaino3 | int | Data source did not contain a description for TELIPAINO3. Column telipaino3 has 18083 rows, out of which 17822 are empty, making the null percent 98.56. Minimum value is 12 and maximum value is 24. |
| ajonpaino | int | Data source did not contain a description for AJONPAINO. Column ajonpaino has 18083 rows, out of which 17876 are empty, making the null percent 98.86. Minimum value is 3 and maximum value is 42. |
| yhdpaino | int | Data source did not contain a description for YHDPAINO. Column yhdpaino has 18083 rows, out of which 17891 are empty, making the null percent 98.94. Minimum value is 12 and maximum value is 76. |
| siltanro | int | Data source did not contain a description for SILTANRO. Column siltanro has 18083 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 9111. |
| rakennety | string | Data source did not contain a description for RAKENNETY. Column rakennety has 18083 rows, out of which 32 are empty, making the null percent 0.18. First 25 characters of minimum string: ... and first 25 characters of maximum string: Teräsbetoninen voimalaito... |
| x | int | Data source did not contain a description for X. Column x has 18083 rows, out of which 4 are empty, making the null percent 0.02. Minimum value is 183993 and maximum value is 720316. |
| y | int | Data source did not contain a description for Y. Column y has 18083 rows, out of which 4 are empty, making the null percent 0.02. Minimum value is 6639768 and maximum value is 7773872. |
| ely_lyhenn | string | Data source did not contain a description for ELY_LYHENN. Column ely_lyhenn has 18083 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Epo and maximum string is Var. |
| geom_geojson | string | Geometry in GeoJSON format. |
| trex_id_os | int | Data source did not contain a description for TREX_ID_OS. Column trex_id_os has 18083 rows, out of which 1 are empty, making the null percent 0.01. Minimum value is 1 and maximum value is 74431. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 18083 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 (20.761221230035442... and first 25 characters of maximum string: POINT (31.327828964081608... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column is empty. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column is empty. |
| geom_type | string | Geometry type. Column geom_type has 18083 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. |
Additional Info
| Last Updated | September 10, 2020 |
|---|---|
| Created | July 9, 2018 |