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

Routavaurio

Routavaurio

Tables

Column Descriptions

Rata routavaurio, Avoinrata routavaurio, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0004+0800 and maximum string is 1062+0500.
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 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348679 and maximum value is 875048.
ilmoitpvm date Data source did not contain a description for ILMOITPVM. Column is empty.
kiilalkpvm date Data source did not contain a description for KIILALKPVM. Column is empty.
kiilloppvm date Data source did not contain a description for KIILLOPPVM. Column is empty.
kiilpaksmm int Data source did not contain a description for KIILPAKSMM. Column kiilpaksmm has 1605 rows, out of which 1211 are empty, making the null percent 75.45. Minimum value is -5 and maximum value is 50.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 1605 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 1605 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 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0005+0000 and maximum string is 1064+0030.
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.
noprajoit int Data source did not contain a description for NOPRAJOIT. Column noprajoit has 1605 rows, out of which 622 are empty, making the null percent 38.75. Minimum value is 0 and maximum value is 160.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 232865 and maximum value is 234555.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40800 and maximum value is 10620500.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 50000 and maximum value is 10640030.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40800 and maximum value is 10620500.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0004+0800 and maximum string is 1062+0500.
rajalkpvm date Data source did not contain a description for RAJALKPVM. Column is empty.
rajloppvm date Data source did not contain a description for RAJLOPPVM. Column is empty.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 1605 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 731.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 1605 rows, out of which 649 are empty, making the null percent 40.44. Minimum value is 2 and maximum value is 731.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 1605 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:18 and maximum value is 2020-05-25 21:03:23.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.6462265340... and first 25 characters of maximum string: MULTILINESTRING ((30.2087...
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 1605 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated September 11, 2020
Created July 9, 2018