Runkoverkko (testi) - Runkoverkko (Tierekisterin tietolaji 340)

Tables

Tl340, Avointl340TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon.

Column Descriptions

Tl340, Avointl340

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 2283 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 17477 and maximum value is 20916.
ely	int	Data source did not contain a description for ELY. Column ely has 2283 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 2283 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 15701.
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 2283 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 2283 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 502.
aet	int	Data source did not contain a description for AET. Column aet has 2283 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 15755.
losa	int	Data source did not contain a description for LOSA. Column losa has 2283 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 502.
let	int	Data source did not contain a description for LET. Column let has 2283 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.
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.
linkki	int	Data source did not contain a description for LINKKI. Column linkki has 2283 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1001 and maximum value is 2260.
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 2283 rows, out of which 2 are empty, making the null percent 0.09. Minimum value is 127 and maximum value is 1435.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 2283 rows, out of which 2 are empty, making the null percent 0.09. Minimum string is Tampere 17-22 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 2283 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pirkanmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 2283 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 2283 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 2283 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 2283 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pirkanmaa and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 2283 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.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018