Kevyen liikenteen väylävaurio - Kevyen liikenteen väylävaurio (Tierekisterin tietolaji 751)

Tables

Tl751, Avointl751TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon.

Column Descriptions

Tl751, Avointl751

Column	Type	Comment
tie	int	Data source did not contain a description for TIE. Column tie has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 70002 and maximum value is 99507.
lakkautpvm	string	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 55566 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 0.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 999.
aet	int	Data source did not contain a description for AET. Column aet has 55566 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 16700.
losa	int	Data source did not contain a description for LOSA. Column losa has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 999.
let	int	Data source did not contain a description for LET. Column let has 55566 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 16722.
alkupvm	string	Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm	string	Data source did not contain a description for LOPPUPVM. Column is empty.
mittaust	int	Data source did not contain a description for MITTAUST. Column mittaust has 55566 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 2.
s_mittaust	string	Data source did not contain a description for S_MITTAUST. Column s_mittaust has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kontrolli and maximum string is normaali.
verkkohalk	int	Data source did not contain a description for VERKKOHALK. Column verkkohalk has 55566 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 300.
pituushalk	int	Data source did not contain a description for PITUUSHALK. Column pituushalk has 55566 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 554.
paikattuha	int	Data source did not contain a description for PAIKATTUHA. Column paikattuha has 55566 rows, out of which 5758 are empty, making the null percent 10.36. Minimum value is 0 and maximum value is 409.
poikkihalk	int	Data source did not contain a description for POIKKIHALK. Column poikkihalk has 55566 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 55.
epatasaisu	int	Data source did not contain a description for EPATASAISU. Column epatasaisu has 55566 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 120.
reika	int	Data source did not contain a description for REIKA. Column reika has 55566 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 43.
reunapainu	int	Data source did not contain a description for REUNAPAINU. Column reunapainu has 55566 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 214.
este	int	Data source did not contain a description for ESTE. Column este has 55566 rows, out of which 5758 are empty, making the null percent 10.36. Minimum value is 0 and maximum value is 8.
turvapuute	int	Data source did not contain a description for TURVAPUUTE. Column turvapuute has 55566 rows, out of which 5758 are empty, making the null percent 10.36. Minimum value is 0 and maximum value is 11.
vauriosumm	int	Data source did not contain a description for VAURIOSUMM. Column vauriosumm has 55566 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 999.
vanha_75	int	Data source did not contain a description for VANHA_75. Column vanha_75 has 55566 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 0.
s_vanha_75	string	Data source did not contain a description for S_VANHA_75. Column s_vanha_75 has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. This column is filled with a constant value. The single string value is: ei_vanhent.
kohdeid_75	int	Data source did not contain a description for KOHDEID_75. Column kohdeid_75 has 55566 rows, out of which 14646 are empty, making the null percent 26.36. Minimum value is 95064 and maximum value is 174691.
id	int	Data source did not contain a description for ID. Column is empty.
muutospvm	string	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 55566 rows, out of which 18 are empty, making the null percent 0.03. Minimum value is 127 and maximum value is 9000.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 55566 rows, out of which 18 are empty, making the null percent 0.03. Minimum string is Alavus 17-22 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 55566 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 55566 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 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ähtäri and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 55566 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 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaa and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Länsi-Suomen lääni and maximum string is Oulun l??ni.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 55566 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 184770 and maximum value is 243915.
ely	int	Data source did not contain a description for ELY. Column ely has 55566 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.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018