Toiminnallinen luokka

Tables

Tl130, Avointl130, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin viedään sekä vallitsevan tilanteen että kulloinkin voimassaolevan tieverkon runkosuunnitelman mukainen toiminnallinen tieluokitus. Tierekisterissä olevaa ns. nykyistä tieluokkaa muutetaan sekä uusia teitä luokitellaan sitä mukaan kuin runkosuunnitelma toteutuu. Kadun tieluokka on sama kuin sen jatkeena olevan tielinkin. Tierekisteriin erikseen otetut ns. Yleisten teiden verkkoa täydentävät kadut luokitellaan seututeiksi, koska niiden avulla saadaan valta-, kanta- ja seututeiden muodostama verkko aukottomaksi. Kuvaustekniikka perustuu: TOIML Nykyinen tieluokka, EURONRO Eurooppatien numero

Column Descriptions

Tl130, Avointl130, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 353645 and maximum value is 388159.
ely	int	Data source did not contain a description for ELY. Column ely has 32786 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 32786 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 92043.
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 32786 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 32786 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 999.
aet	int	Data source did not contain a description for AET. Column aet has 32786 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 24507.
losa	int	Data source did not contain a description for LOSA. Column losa has 32786 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 999.
let	int	Data source did not contain a description for LET. Column let has 32786 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.
toiml	int	Data source did not contain a description for TOIML. Column toiml has 32786 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 5.
s_toiml	string	Data source did not contain a description for S_TOIML. Column s_toiml has 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N.
toimlpts	int	Data source did not contain a description for TOIMLPTS. Column toimlpts has 32786 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 9.
s_toimlpts	string	Data source did not contain a description for S_TOIMLPTS. Column s_toimlpts has 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N.
euronro	int	Data source did not contain a description for EURONRO. Column euronro has 32786 rows, out of which 29933 are empty, making the null percent 91.30. Minimum value is 4 and maximum value is 75.
s_euronro	string	Data source did not contain a description for S_EURONRO. Column s_euronro has 32786 rows, out of which 29933 are empty, making the null percent 91.30. Minimum string is N and maximum string is N.
ternnro	string	Data source did not contain a description for TERNNRO. Column ternnro has 32786 rows, out of which 29458 are empty, making the null percent 89.85. Minimum string is N and maximum string is N.
tenluokk	int	Data source did not contain a description for TENLUOKK. Column tenluokk has 32786 rows, out of which 29163 are empty, making the null percent 88.95. Minimum value is 1 and maximum value is 3.
s_tenluokk	string	Data source did not contain a description for S_TENLUOKK. Column s_tenluokk has 32786 rows, out of which 29163 are empty, making the null percent 88.95. Minimum string is N and maximum string is N.
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 32786 rows, out of which 11 are empty, making the null percent 0.03. 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 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum string is N and maximum string is N.
liva	string	Data source did not contain a description for LIVA. Column liva has 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum value is 5 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum string is N and maximum string is N.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum value is 1 and maximum value is 19.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum string is N and maximum string is N.
laani	string	Data source did not contain a description for LAANI. Column laani has 32786 rows, out of which 11 are empty, making the null percent 0.03. Minimum string is N and maximum string is N.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N.
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 32786 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N and maximum string is N.

Additional Info

Last Updated	September 10, 2020
Created	July 9, 2018