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

Ratajohto

Ratajohto

Tables

Column Descriptions

Rata ratajohto, Avoinrata ratajohto, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0034 and maximum string is 0973+0012.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
huomautus string Data source did not contain a description for HUOMAUTUS. Column huomautus has 61472 rows, out of which 61465 are empty, making the null percent 99.99. Minimum string is and maximum string is portaali.
id int Data source did not contain a description for ID. Column id has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348745 and maximum value is 904654.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 61472 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:00:39 and maximum value is 2020-05-25 21:02:18.
kohde string Data source did not contain a description for KOHDE. Column is empty.
kohde_tyyp string Data source did not contain a description for KOHDE_TYYP. Column kohde_tyyp has 61472 rows, out of which 4588 are empty, making the null percent 7.46. Minimum string is and maximum string is vko.
korkeus int Data source did not contain a description for KORKEUS. Column korkeus has 61472 rows, out of which 4541 are empty, making the null percent 7.39. Minimum value is 567 and maximum value is 665.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 61472 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 61472 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 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0034 and maximum string is 0973+0012.
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 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7769217 and maximum value is 7831177.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0034 and maximum string is 0973+0012.
pituuskall int Data source did not contain a description for PITUUSKALL. Column pituuskall has 61472 rows, out of which 4590 are empty, making the null percent 7.47. Minimum value is 0 and maximum value is 164.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30034 and maximum value is 9730012.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30034 and maximum value is 9730012.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30034 and maximum value is 9730012.
pylvas_v_o string Data source did not contain a description for PYLVAS_V_O. Column pylvas_v_o has 61472 rows, out of which 12 are empty, making the null percent 0.02. Minimum string is and maximum string is v.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 61472 rows, out of which 33 are empty, making the null percent 0.05. Minimum value is 1 and maximum value is 554.
sahkratpyl string Data source did not contain a description for SAHKRATPYL. Column sahkratpyl has 61472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 100-1 and maximum string is Tja-9.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 61472 rows, out of which 40693 are empty, making the null percent 66.20. Minimum value is 2 and maximum value is 554.
siksak int Data source did not contain a description for SIKSAK. Column siksak has 61472 rows, out of which 4541 are empty, making the null percent 7.39. Minimum value is -360 and maximum value is 65.
synkrkood int Data source did not contain a description for SYNKRKOOD. Column synkrkood has 61472 rows, out of which 4244 are empty, making the null percent 6.90. Minimum value is 0 and maximum value is 2.
teksti string Data source did not contain a description for TEKSTI. Column is empty.
toler_tunn string Data source did not contain a description for TOLER_TUNN. Column toler_tunn has 61472 rows, out of which 4588 are empty, making the null percent 7.46. Minimum string is and maximum string is z.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 61472 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.47533255862212 ... and first 25 characters of maximum string: POINT (30.129337945285997...
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 61472 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