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

Merkki

Merkki

Tables

Column Descriptions

Rata merkki, Avoinrata merkki, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1068+0000.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
asennuspvm date Data source did not contain a description for ASENNUSPVM. Column is empty.
asetaisyys int Data source did not contain a description for ASETAISYYS. Column asetaisyys has 14002 rows, out of which 12992 are empty, making the null percent 92.79. Minimum value is 1000 and maximum value is 7200.
askorkeus int Data source did not contain a description for ASKORKEUS. Column askorkeus has 14002 rows, out of which 12608 are empty, making the null percent 90.04. Minimum value is 800 and maximum value is 19000.
id int Data source did not contain a description for ID. Column id has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348588 and maximum value is 900184.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 14002 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:38 and maximum value is 2020-05-25 21:04:01.
kaantyva string Data source did not contain a description for KAANTYVA. Column kaantyva has 14002 rows, out of which 13759 are empty, making the null percent 98.26. Minimum string is and maximum string is K.
katselmpvm date Data source did not contain a description for KATSELMPVM. Column is empty.
kiinntapa string Data source did not contain a description for KIINNTAPA. Column kiinntapa has 14002 rows, out of which 11762 are empty, making the null percent 84.00. Minimum string is and maximum string is Viritelmä.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 14002 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.
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 14002 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 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1068+0000.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
lukusuunta string Data source did not contain a description for LUKUSUUNTA. Column lukusuunta has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahv-Kki and maximum string is Äs-Vma.
merkk_tyyp string Data source did not contain a description for MERKK_TYYP. Column merkk_tyyp has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: JKV-nopeusmerkki... and first 25 characters of maximum string: Raideopastimen vaakatunnu...
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 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1873921 and maximum value is 1888658.
paikka string Data source did not contain a description for PAIKKA. Column paikka has 14002 rows, out of which 873 are empty, making the null percent 6.23. Minimum string is and maximum string is Yhteinen.
perustus string Data source did not contain a description for PERUSTUS. Column perustus has 14002 rows, out of which 12051 are empty, making the null percent 86.07. Minimum string is and maximum string is Viritelmä.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1068+0000.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10680000.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10680000.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10680000.
puoli string Data source did not contain a description for PUOLI. Column puoli has 14002 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 Vasen.
pylvas int Data source did not contain a description for PYLVAS. Column pylvas has 14002 rows, out of which 13122 are empty, making the null percent 93.72. Minimum value is 3500 and maximum value is 4500.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 14002 rows, out of which 35 are empty, making the null percent 0.25. Minimum value is 1 and maximum value is 751.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 14002 rows, out of which 7061 are empty, making the null percent 50.43. Minimum value is 2 and maximum value is 751.
suun_aseta string Data source did not contain a description for SUUN_ASETA. Column suun_aseta has 14002 rows, out of which 3351 are empty, making the null percent 23.93. Minimum string is and maximum string is vähintään 2900 mm.
suun_askor int Data source did not contain a description for SUUN_ASKOR. Column suun_askor has 14002 rows, out of which 11335 are empty, making the null percent 80.95. Minimum value is 2200 and maximum value is 4000.
teksti int Data source did not contain a description for TEKSTI. Column teksti has 14002 rows, out of which 1426 are empty, making the null percent 10.18. Minimum value is 1 and maximum value is 1068.
valmistnro string Data source did not contain a description for VALMISTNRO. Column valmistnro has 14002 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is T-101A and maximum string is T-356D.
valmvuosi float Data source did not contain a description for VALMVUOSI. Column valmvuosi has 14002 rows, out of which 14001 are empty, making the null percent 99.99. Constant value is 2014.00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 14002 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.228065607848436... and first 25 characters of maximum string: POINT (30.951372063865506...
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 14002 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