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

Kiskovika

Kiskovika

Tables

Column Descriptions

Rata kiskovika, Avoinrata kiskovika, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0875 and maximum string is 1132+0755.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
elementpit float Data source did not contain a description for ELEMENTPIT. Column is empty.
havainpvm date Data source did not contain a description for HAVAINPVM. Column is empty.
id int Data source did not contain a description for ID. Column id has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348567 and maximum value is 904597.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 44604 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:04:11 and maximum value is 2020-05-25 21:05:19.
kisko string Data source did not contain a description for KISKO. Column kisko has 44604 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 Vasen.
kisko_laat string Data source did not contain a description for KISKO_LAAT. Column kisko_laat has 44604 rows, out of which 17047 are empty, making the null percent 38.22. Minimum string is and maximum string is R350LH.
kisko_pitu string Data source did not contain a description for KISKO_PITU. Column kisko_pitu has 44604 rows, out of which 18033 are empty, making the null percent 40.43. Minimum string is and maximum string is PK.
kisko_valm string Data source did not contain a description for KISKO_VALM. Column kisko_valm has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ANGLEUR and maximum string is VÖEST ALPINE.
kiskoprofi int Data source did not contain a description for KISKOPROFI. Column is empty.
kiskovaiht int Data source did not contain a description for KISKOVAIHT. Column kiskovaiht has 44604 rows, out of which 28231 are empty, making the null percent 63.29. Minimum value is 0 and maximum value is 6920.
korjausehd string Data source did not contain a description for KORJAUSEHD. Column korjausehd has 44604 rows, out of which 11098 are empty, making the null percent 24.88. Minimum string is and maximum string is tjh pala.
korjauspvm date Data source did not contain a description for KORJAUSPVM. Column is empty.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 44604 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.
kuityritys string Data source did not contain a description for KUITYRITYS. Column kuityritys has 44604 rows, out of which 38236 are empty, making the null percent 85.72. Minimum string is and maximum string is VRR.
latauspvm date Data source did not contain a description for LATAUSPVM. Column is empty.
liikenpaik string Data source did not contain a description for LIIKENPAIK. Column liikenpaik has 44604 rows, out of which 44603 are empty, making the null percent 100.00. The single string value is: .
loc_error string Data source did not contain a description for LOC_ERROR. Column loc_error has 44604 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 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0875 and maximum string is 1132+0755.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
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 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5286449 and maximum value is 5331450.
pala int Data source did not contain a description for PALA. Column pala has 44604 rows, out of which 28380 are empty, making the null percent 63.63. Minimum value is 0 and maximum value is 230.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0875 and maximum string is 1132+0755.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 875 and maximum value is 11320755.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 875 and maximum value is 11320755.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 44604 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 875 and maximum value is 11320755.
pystykulun int Data source did not contain a description for PYSTYKULUN. Column pystykulun has 44604 rows, out of which 42999 are empty, making the null percent 96.40. Minimum value is 1 and maximum value is 70.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 44604 rows, out of which 5 are empty, making the null percent 0.01. Minimum value is 1 and maximum value is 751.
ratjohpylv string Data source did not contain a description for RATJOHPYLV. Column ratjohpylv has 44604 rows, out of which 23148 are empty, making the null percent 51.90. Minimum string is and maximum string is X5B-20.
sijraide int Data source did not contain a description for SIJRAIDE. Column sijraide has 44604 rows, out of which 17576 are empty, making the null percent 39.40. Minimum value is 2 and maximum value is 751.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 44604 rows, out of which 16454 are empty, making the null percent 36.89. Minimum value is 2 and maximum value is 751.
sivukulun int Data source did not contain a description for SIVUKULUN. Column sivukulun has 44604 rows, out of which 41356 are empty, making the null percent 92.72. Minimum value is 1 and maximum value is 800.
tarkyritys string Data source did not contain a description for TARKYRITYS. Column tarkyritys has 44604 rows, out of which 32167 are empty, making the null percent 72.12. Minimum string is and maximum string is VRR.
uic_vikalk int Data source did not contain a description for UIC_VIKALK. Column uic_vikalk has 44604 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 4222.
valssausv int Data source did not contain a description for VALSSAUSV. Column valssausv has 44604 rows, out of which 1148 are empty, making the null percent 2.57. Minimum value is 0 and maximum value is 2017.
vian_kuvau string Data source did not contain a description for VIAN_KUVAU. Column vian_kuvau has 44604 rows, out of which 5408 are empty, making the null percent 12.12. Minimum string is and maximum string is ympärilyönnit.
vikalkm int Data source did not contain a description for VIKALKM. Column vikalkm has 44604 rows, out of which 55 are empty, making the null percent 0.12. Minimum value is 0 and maximum value is 2251.
vikaluokka int Data source did not contain a description for VIKALUOKKA. Column vikaluokka has 44604 rows, out of which 3133 are empty, making the null percent 7.02. Minimum value is 1 and maximum value is 3.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 44604 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.220881798771718... and first 25 characters of maximum string: POINT (30.946292957123894...
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 44604 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