To download the data set, please sign up or log in

Erotusjakso

Erotusjakso

Tables

Column Descriptions

Rata erotusjakso, Avoinrata erotusjakso, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 236 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 1008+0337.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
id int Data source did not contain a description for ID. Column id has 236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 351495 and maximum value is 901917.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 236 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:15 and maximum value is 2020-05-25 21:03:18.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 236 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 236 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 236 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 1008+0337.
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 236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40241 and maximum value is 40481.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 236 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 1008+0337.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 236 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 10080337.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 236 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 10080337.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 236 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 10080337.
pylvas_nro string Data source did not contain a description for PYLVAS_NRO. Column pylvas_nro has 236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1008-6 and maximum string is R/5B.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 236 rows, out of which 1 are empty, making the null percent 0.42. Minimum value is 1 and maximum value is 554.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 236 rows, out of which 167 are empty, making the null percent 70.76. Minimum value is 2 and maximum value is 554.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 236 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.520345713328307... and first 25 characters of maximum string: POINT (30.114434451737665...
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 236 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