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

Vaihde

Vaihde

Tables

Column Descriptions

Rata vaihde, Avoinrata vaihde, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0547 and maximum string is 1135+0313.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
asvuos_vi int Data source did not contain a description for ASVUOS_VI. Column asvuos_vi has 7428 rows, out of which 14 are empty, making the null percent 0.19. Minimum value is 1900 and maximum value is 2019.
aukiajetta string Data source did not contain a description for AUKIAJETTA. Column aukiajetta has 7428 rows, out of which 4693 are empty, making the null percent 63.18. Minimum string is and maximum string is K.
id int Data source did not contain a description for ID. Column id has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 66525 and maximum value is 909547.
klaitepuol string Data source did not contain a description for KLAITEPUOL. Column klaitepuol has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EI MÄÄRITELTY and maximum string is Suoralla raiteella.
klaitetyyp string Data source did not contain a description for KLAITETYYP. Column klaitetyyp has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asetin and maximum string is Sähkö.
katisyys string Data source did not contain a description for KATISYYS. Column katisyys has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - and maximum string is V.
kaytotpvm date Data source did not contain a description for KAYTOTPVM. Column is empty.
kiinnitys string Data source did not contain a description for KIINNITYS. Column kiinnitys has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is SKL-kiinnitys.
kosketlkm int Data source did not contain a description for KOSKETLKM. Column kosketlkm has 7428 rows, out of which 3574 are empty, making the null percent 48.12. Minimum value is 0 and maximum value is 7.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 7428 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.
lam_kieli string Data source did not contain a description for LAM_KIELI. Column lam_kieli has 7428 rows, out of which 279 are empty, making the null percent 3.76. Minimum string is and maximum string is K.
lam_ristey string Data source did not contain a description for LAM_RISTEY. Column lam_ristey has 7428 rows, out of which 260 are empty, making the null percent 3.50. Minimum string is and maximum string is K.
lam_tankuo string Data source did not contain a description for LAM_TANKUO. Column lam_tankuo has 7428 rows, out of which 5465 are empty, making the null percent 73.57. Minimum string is and maximum string is K.
lam_tukiki string Data source did not contain a description for LAM_TUKIKI. Column lam_tukiki has 7428 rows, out of which 265 are empty, making the null percent 3.57. Minimum string is and maximum string is K.
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 7428 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 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0547 and maximum string is 1135+0313.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
lukitlaite string Data source did not contain a description for LUKITLAITE. Column lukitlaite has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei lukitusta and maximum string is Varmuus.
lukkomalli string Data source did not contain a description for LUKKOMALLI. Column lukkomalli has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EI MÄÄRITELTY ! and maximum string is Sähköinen sis.rak.
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 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1205602 and maximum value is 1214968.
omistaja string Data source did not contain a description for OMISTAJA. Column omistaja has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Liikennevirasto and maximum string is Yksityinen.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 547 and maximum value is 11350313.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 547 and maximum value is 11350313.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 547 and maximum value is 11350313.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0547 and maximum string is 1135+0313.
polkytys string Data source did not contain a description for POLKYTYS. Column polkytys has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Betoni and maximum string is Puu.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 7428 rows, out of which 48 are empty, making the null percent 0.65. Minimum value is 1 and maximum value is 751.
sijraidtun string Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 001 EKR HKI-LPV and maximum string is ÄS V004-P.
tila string Data source did not contain a description for TILA. Column tila has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EL and maximum string is P.
tukikerros string Data source did not contain a description for TUKIKERROS. Column tukikerros has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hieno sepeli and maximum string is Sora.
turvavaihd string Data source did not contain a description for TURVAVAIHD. Column turvavaihd has 7428 rows, out of which 4141 are empty, making the null percent 55.75. Minimum string is and maximum string is K.
uuskiesiir string Data source did not contain a description for UUSKIESIIR. Column uuskiesiir has 7428 rows, out of which 52 are empty, making the null percent 0.70. Minimum string is and maximum string is U.
vaihdopast string Data source did not contain a description for VAIHDOPAST. Column vaihdopast has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei määritelty and maximum string is Lyhty.
vaihdetun string Data source did not contain a description for VAIHDETUN. Column vaihdetun has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AHO V0461 and maximum string is ÄS V0008.
vaihdetyyp string Data source did not contain a description for VAIHDETYYP. Column vaihdetyyp has 7428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KRV43-233-1:9 and maximum string is YV60-900P-1:18.
valmvuosi int Data source did not contain a description for VALMVUOSI. Column valmvuosi has 7428 rows, out of which 7243 are empty, making the null percent 97.51. Minimum value is 2007 and maximum value is 2018.
yksityinen string Data source did not contain a description for YKSITYINEN. Column yksityinen has 7428 rows, out of which 4 are empty, making the null percent 0.05. Minimum string is and maximum string is Y.
yksraidlii string Data source did not contain a description for YKSRAIDLII. Column yksraidlii has 7428 rows, out of which 4232 are empty, making the null percent 56.97. Minimum string is and maximum string is K.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 7428 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:05:19 and maximum value is 2020-05-25 21:05:33.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 7428 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.222089745511525... and first 25 characters of maximum string: POINT (30.950848253964786...
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 7428 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