Kantavuuskeskiarvo

Tables

Tl210, Avointl210, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Kantavuusmittauksen suorittamisesta tierekisteriä varten on oma erillinen ohjeensa. Tarkasteltavalta osuudelta tutkitaan tasavälein yleensä 10 mittauspistettä, joiden perusteella lasketaan ko. osuuden keskimääräiset tunnusluvut.

Column Descriptions

Tl210, Avointl210, Latest

Column	Type	Comment
laani	string	Data source did not contain a description for LAANI. Column laani has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 115161 and maximum value is 140339.
ely	int	Data source did not contain a description for ELY. Column ely has 24796 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.
tie	int	Data source did not contain a description for TIE. Column tie has 24796 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 70363.
lakkautpvm	date	Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr	int	Data source did not contain a description for AJR. Column ajr has 24796 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.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 24796 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 996.
aet	int	Data source did not contain a description for AET. Column aet has 24796 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 26379.
losa	int	Data source did not contain a description for LOSA. Column losa has 24796 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 996.
let	int	Data source did not contain a description for LET. Column let has 24796 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 31584.
alkupvm	date	Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm	date	Data source did not contain a description for LOPPUPVM. Column is empty.
kklaite	int	Data source did not contain a description for KKLAITE. Column kklaite has 24796 rows, out of which 1 are empty, making the null percent 0.00. Constant value is 2.
s_kklaite	string	Data source did not contain a description for S_KKLAITE. Column s_kklaite has 24796 rows, out of which 1 are empty, making the null percent 0.00. The single string value is: .
k2	int	Data source did not contain a description for K2. Column k2 has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40 and maximum value is 999.
s_k2	string	Data source did not contain a description for S_K2. Column s_k2 has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 40 pros and maximum string is ei tietoa.
kevkant	int	Data source did not contain a description for KEVKANT. Column kevkant has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 15 and maximum value is 2036.
taiphajo	int	Data source did not contain a description for TAIPHAJO. Column taiphajo has 24796 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 172.
tmitkant	int	Data source did not contain a description for TMITKANT. Column tmitkant has 24796 rows, out of which 115 are empty, making the null percent 0.46. Minimum value is 6 and maximum value is 1820.
amitkant	int	Data source did not contain a description for AMITKANT. Column amitkant has 24796 rows, out of which 115 are empty, making the null percent 0.46. Minimum value is 3 and maximum value is 1421.
sci	float	Data source did not contain a description for SCI. Column sci has 24796 rows, out of which 117 are empty, making the null percent 0.47. Minimum value is 0.01 and maximum value is 4.01.
bci	float	Data source did not contain a description for BCI. Column bci has 24796 rows, out of which 115 are empty, making the null percent 0.46. Minimum value is 0.01 and maximum value is 0.98.
tmitsp	int	Data source did not contain a description for TMITSP. Column tmitsp has 24796 rows, out of which 495 are empty, making the null percent 2.00. Minimum value is 23 and maximum value is 74.
id	int	Data source did not contain a description for ID. Column is empty.
muutospvm	date	Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue	int	Data source did not contain a description for UALUE. Column ualue has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 9000.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 24796 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.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 24796 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 19.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 24796 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 24796 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.0356...
geom_center_x	float	Longitude of center. Column is empty.
geom_center_y	float	Latitude of center. Column is empty.
geom_type	string	Geometry type. Column geom_type has 24796 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