1. Home
  2. Datasets
  3. Silta
To download the data set, please sign up or log in

Silta

Silta

Tables

Column Descriptions

Rata silta, Avoinrata silta, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0322 and maximum string is 1141+0248.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
brutrakpak float Data source did not contain a description for BRUTRAKPAK. Column brutrakpak has 5497 rows, out of which 446 are empty, making the null percent 8.11. Minimum value is 0.00 and maximum value is 94.41.
huomautus1 string Data source did not contain a description for HUOMAUTUS1. Column huomautus1 has 5497 rows, out of which 3988 are empty, making the null percent 72.55. Minimum string is and maximum string is Äkäsjoen liikennepaikka.
huomautus2 string Data source did not contain a description for HUOMAUTUS2. Column huomautus2 has 5497 rows, out of which 4878 are empty, making the null percent 88.74. Minimum string is and maximum string is ylläpitämä tiesilta.
id int Data source did not contain a description for ID. Column id has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348488 and maximum value is 907134.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-25 21:03:27 and maximum value is 2020-05-25 21:03:38.
jannemitat float Data source did not contain a description for JANNEMITAT. Column jannemitat has 5497 rows, out of which 3921 are empty, making the null percent 71.33. Minimum value is 2.00 and maximum value is 84.00.
jannenro int Data source did not contain a description for JANNENRO. Column jannenro has 5497 rows, out of which 5379 are empty, making the null percent 97.85. Minimum value is 1 and maximum value is 8.
kaidevali float Data source did not contain a description for KAIDEVALI. Column kaidevali has 5497 rows, out of which 228 are empty, making the null percent 4.15. Minimum value is 0.00 and maximum value is 99.99.
kokpituus float Data source did not contain a description for KOKPITUUS. Column kokpituus has 5497 rows, out of which 215 are empty, making the null percent 3.91. Minimum value is 0.00 and maximum value is 716.00.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 5497 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 12.
kunnpitaja string Data source did not contain a description for KUNNPITAJA. Column kunnpitaja has 5497 rows, out of which 3453 are empty, making the null percent 62.82. Minimum string is and maximum string is YksityinenRautaruukki.
kuormkoodi string Data source did not contain a description for KUORMKOODI. Column kuormkoodi has 5497 rows, out of which 1336 are empty, making the null percent 24.30. Minimum string is and maximum string is VR-I48.
latauspvm date Data source did not contain a description for LATAUSPVM. Column is empty.
loc_error string Data source did not contain a description for LOC_ERROR. Column loc_error has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: NO ERROR.
loppukm_m string Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0322 and maximum string is 1141+0248.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
maatukrv int Data source did not contain a description for MAATUKRV. Column maatukrv has 5497 rows, out of which 358 are empty, making the null percent 6.51. Minimum value is 198 and maximum value is 2019.
muunimi string Data source did not contain a description for MUUNIMI. Column muunimi has 5497 rows, out of which 5129 are empty, making the null percent 93.31. Minimum string is and maximum string is Öljytien ylikulkusilta.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
nimi string Data source did not contain a description for NIMI. Column is empty.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 739969 and maximum value is 745740.
otsikko string Data source did not contain a description for OTSIKKO. Column otsikko has 5497 rows, out of which 4692 are empty, making the null percent 85.36. Minimum string is and maximum string is Yläratapiha.
peruskorjv int Data source did not contain a description for PERUSKORJV. Column peruskorjv has 5497 rows, out of which 4762 are empty, making the null percent 86.63. Minimum value is 1890 and maximum value is 2019.
perustsyv float Data source did not contain a description for PERUSTSYV. Column perustsyv has 5497 rows, out of which 650 are empty, making the null percent 11.82. Minimum value is 0.00 and maximum value is 66.00.
pisinjamit float Data source did not contain a description for PISINJAMIT. Column pisinjamit has 5497 rows, out of which 187 are empty, making the null percent 3.40. Minimum value is 0.00 and maximum value is 104.00.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0322 and maximum string is 1141+0248.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 322 and maximum value is 11410248.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 322 and maximum value is 11410248.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 322 and maximum value is 11410248.
raideluku int Data source did not contain a description for RAIDELUKU. Column raideluku has 5497 rows, out of which 297 are empty, making the null percent 5.40. Minimum value is 0 and maximum value is 17.
raktyyppi string Data source did not contain a description for RAKTYYPPI. Column raktyyppi has 5497 rows, out of which 88 are empty, making the null percent 1.60. First 25 characters of minimum string: ... and first 25 characters of maximum string: Teräspalkkibetoninen ulok...
rakvuosi int Data source did not contain a description for RAKVUOSI. Column rakvuosi has 5497 rows, out of which 61 are empty, making the null percent 1.11. Minimum value is 1862 and maximum value is 2019.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 5497 rows, out of which 10 are empty, making the null percent 0.18. Minimum value is 1 and maximum value is 751.
siirtlaat string Data source did not contain a description for SIIRTLAAT. Column siirtlaat has 5497 rows, out of which 4962 are empty, making the null percent 90.27. Minimum string is and maximum string is RATA2.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 5497 rows, out of which 3822 are empty, making the null percent 69.53. Minimum value is 2 and maximum value is 751.
sillantila string Data source did not contain a description for SILLANTILA. Column sillantila has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: EI LIIKENNETTÄ. SILTA OLE... and first 25 characters of maximum string: YHTEYS TAI RAIDE PURETTU...
siltakoodi int Data source did not contain a description for SILTAKOODI. Column siltakoodi has 5497 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 4873.
siltanimi string Data source did not contain a description for SILTANIMI. Column siltanimi has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aatolan alikulkusilta and maximum string is Överbyn alikulkusilta.
siltarakid int Data source did not contain a description for SILTARAKID. Column siltarakid has 5497 rows, out of which 56 are empty, making the null percent 1.02. Minimum value is 410560 and maximum value is 9000936.
siltatyyp string Data source did not contain a description for SILTATYYP. Column siltatyyp has 5497 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alikulkusilta and maximum string is Ylikäytäväsilta.
silttyypid int Data source did not contain a description for SILTTYYPID. Column silttyypid has 5497 rows, out of which 88 are empty, making the null percent 1.60. Minimum value is 413445 and maximum value is 9000937.
suunitnro int Data source did not contain a description for SUUNITNRO. Column suunitnro has 5497 rows, out of which 314 are empty, making the null percent 5.71. Minimum value is 12 and maximum value is 55555.
tienimi string Data source did not contain a description for TIENIMI. Column tienimi has 5497 rows, out of which 4334 are empty, making the null percent 78.84. Minimum string is and maximum string is Äänekoskentie.
tienumero int Data source did not contain a description for TIENUMERO. Column tienumero has 5497 rows, out of which 5081 are empty, making the null percent 92.43. Minimum value is 1 and maximum value is 49002.
trr_tunnus string Data source did not contain a description for TRR_TUNNUS. Column trr_tunnus has 5497 rows, out of which 86 are empty, making the null percent 1.56. Minimum string is and maximum string is V-607.
vapkorkeus float Data source did not contain a description for VAPKORKEUS. Column vapkorkeus has 5497 rows, out of which 291 are empty, making the null percent 5.29. Minimum value is 0.00 and maximum value is 26.86.
vapleveys float Data source did not contain a description for VAPLEVEYS. Column vapleveys has 5497 rows, out of which 191 are empty, making the null percent 3.47. Minimum value is 0.00 and maximum value is 99.99.
vinouskulm int Data source did not contain a description for VINOUSKULM. Column vinouskulm has 5497 rows, out of which 1592 are empty, making the null percent 28.96. Minimum value is 0 and maximum value is 153.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5497 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.23423601984046 ... and first 25 characters of maximum string: POINT (30.93531344921166 ...
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 5497 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 11, 2020
Created July 9, 2018