Matka-ajan seuranta

Tables

Tl181, Avointl181, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tällä tietolajilla ilmoitetaan automaattisen matka-ajan seurannan piirissä olevat tieosuudet, jotka ovat lähinnä päätieverkolla.

Column Descriptions

Tl181, Avointl181, Latest

Column	Type	Comment
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 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 133 and maximum value is 400.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo 19-24 and maximum string is Vantaa 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Uudenmaan ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 927.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Vihti.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Uusimaa.
laani	string	Data source did not contain a description for LAANI. Column laani has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Etelä-Suomen lääni.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2049 and maximum value is 2176.
ely	int	Data source did not contain a description for ELY. Column ely has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
tie	int	Data source did not contain a description for TIE. Column tie has 128 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 40912.
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 128 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.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 128 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 103.
aet	int	Data source did not contain a description for AET. Column aet has 128 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 11072.
losa	int	Data source did not contain a description for LOSA. Column losa has 128 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 103.
let	int	Data source did not contain a description for LET. Column let has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30 and maximum value is 11986.
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.
m_ajarje	int	Data source did not contain a description for M_AJARJE. Column m_ajarje has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
s_m_ajarje	string	Data source did not contain a description for S_M_AJARJE. Column s_m_ajarje has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: pks.
m_alinkki	float	Data source did not contain a description for M_ALINKKI. Column is empty.
m_alinkkio	float	Data source did not contain a description for M_ALINKKIO. Column is empty.
m_alinkkiv	float	Data source did not contain a description for M_ALINKKIV. Column is empty.
m_aurakk	int	Data source did not contain a description for M_AURAKK. Column m_aurakk has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 6001.
s_m_aurakk	string	Data source did not contain a description for S_M_AURAKK. Column s_m_aurakk has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: U-telemat.
m_avalvo	int	Data source did not contain a description for M_AVALVO. Column m_avalvo has 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 101.
matka_aika	float	Data source did not contain a description for MATKA_AIKA. Column is empty.
m_animi	string	Data source did not contain a description for M_ANIMI. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 128 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 (24.2898386566... and first 25 characters of maximum string: LINESTRING (25.6166254639...
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 128 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018