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

Erikoiskuljetusreitit

Erikoiskuljetusreitit

Tables

Column Descriptions

Tl144, Avointl144, Latest

Column Type Comment
aet int Data source did not contain a description for AET. Column aet has 11505 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 19809.
ajr int Data source did not contain a description for AJR. Column ajr has 11505 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 2.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
aosa int Data source did not contain a description for AOSA. Column aosa has 11505 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 915.
ely int Data source did not contain a description for ELY. Column ely has 11505 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 14.
eriku int Data source did not contain a description for ERIKU. Column eriku has 11505 rows, out of which 8619 are empty, making the null percent 74.92. Minimum value is 1 and maximum value is 3.
erikusop int Data source did not contain a description for ERIKUSOP. Column erikusop has 11505 rows, out of which 9414 are empty, making the null percent 81.83. Minimum value is 20100400 and maximum value is 20200112.
id int Data source did not contain a description for ID. Column is empty.
kunta string Data source did not contain a description for KUNTA. Column kunta has 11505 rows, out of which 3 are empty, making the null percent 0.03. Minimum string is and maximum string is Äänekoski.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 11505 rows, out of which 3 are empty, making the null percent 0.03. Minimum value is 5 and maximum value is 992.
laani string Data source did not contain a description for LAANI. Column laani has 11505 rows, out of which 3 are empty, making the null percent 0.03. Minimum string is and maximum string is Oulun l??ni.
lahde144 int Data source did not contain a description for LAHDE144. Column lahde144 has 11505 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 8.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
let int Data source did not contain a description for LET. Column let has 11505 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 26205.
liva string Data source did not contain a description for LIVA. Column liva has 11505 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
losa int Data source did not contain a description for LOSA. Column losa has 11505 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 915.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 11505 rows, out of which 3 are empty, making the null percent 0.03. Minimum string is and maximum string is Varsinais-Suomi.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 11505 rows, out of which 3 are empty, making the null percent 0.03. Minimum value is 1 and maximum value is 19.
mitkork int Data source did not contain a description for MITKORK. Column mitkork has 11505 rows, out of which 570 are empty, making the null percent 4.95. Minimum value is 4 and maximum value is 99.
mitlev int Data source did not contain a description for MITLEV. Column mitlev has 11505 rows, out of which 553 are empty, making the null percent 4.81. Minimum value is 4 and maximum value is 99.
mitpit int Data source did not contain a description for MITPIT. Column mitpit has 11505 rows, out of which 571 are empty, making the null percent 4.96. Minimum value is 8 and maximum value is 99.
muuntaja int Data source did not contain a description for MUUNTAJA. Column muuntaja has 11505 rows, out of which 11344 are empty, making the null percent 98.60. Minimum value is 1 and maximum value is 3.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 11505 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 58472 and maximum value is 70495.
pvm_144 int Data source did not contain a description for PVM_144. Column pvm_144 has 11505 rows, out of which 2721 are empty, making the null percent 23.65. Minimum value is 20111216 and maximum value is 20200112.
rajoitus int Data source did not contain a description for RAJOITUS. Column rajoitus has 11505 rows, out of which 7938 are empty, making the null percent 69.00. Minimum value is 0 and maximum value is 1.
sekv2 int Data source did not contain a description for SEKV2. Column sekv2 has 11505 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 3.
s_eriku string Data source did not contain a description for S_ERIKU. Column s_eriku has 11505 rows, out of which 8619 are empty, making the null percent 74.92. Minimum string is and maximum string is tuleva-ek.
s_lahde144 string Data source did not contain a description for S_LAHDE144. Column s_lahde144 has 11505 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ELY and maximum string is verkselv.
s_muuntaja string Data source did not contain a description for S_MUUNTAJA. Column s_muuntaja has 11505 rows, out of which 11344 are empty, making the null percent 98.60. Minimum string is and maximum string is tuleva-ekm.
s_rajoitus string Data source did not contain a description for S_RAJOITUS. Column s_rajoitus has 11505 rows, out of which 7938 are empty, making the null percent 69.00. Minimum string is and maximum string is rajoitettu.
s_sekv2 string Data source did not contain a description for S_SEKV2. Column s_sekv2 has 11505 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ei sekv and maximum string is varaus.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 11505 rows, out of which 2 are empty, making the null percent 0.02. Minimum string is and maximum string is Äänekoski 19-24.
tie int Data source did not contain a description for TIE. Column tie has 11505 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 81556.
ualue int Data source did not contain a description for UALUE. Column ualue has 11505 rows, out of which 2 are empty, making the null percent 0.02. Minimum value is 129 and maximum value is 9000.
viite_144 timestamp Data source did not contain a description for VIITE_144. Column viite_144 has 11505 rows, out of which 9581 are empty, making the null percent 83.28. Minimum value is 2013-03-04 00:00:00 and maximum value is 2019-09-03 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 11505 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 (20.7650111244... and first 25 characters of maximum string: MULTILINESTRING ((30.0321...
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 11505 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 10, 2020
Created July 9, 2018