Laskentapaikka

Tables

Tl202, Avointl202, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tietolajilla kerrotaan, missä pisteessä tierekisteriin viedyn, liikenteeltään homogeenisen välin liikennemäärät (tietolaji 201) on laskettu. Tieto siirretään liikennemäärien estimointisovelluksesta automaattisesti tierekisteriin samalla kun liikennetiedotkin (kerran vuodessa). Vaikka liikennemäärä ilmoitetaan koko tien poikkileikkausta koskevana, niin laskentalaitteiden sijainti kerrotaan tässä ajoradoittain.

Column Descriptions

Tl202, Avointl202, Latest

Column	Type	Comment
lasvuosi	int	Data source did not contain a description for LASVUOSI. Column lasvuosi has 53984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1998 and maximum value is 2019.
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 53984 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 53984 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 53984 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 53984 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 53984 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 53984 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 53984 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.
laani	string	Data source did not contain a description for LAANI. Column laani has 53984 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 53984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 421236 and maximum value is 475571.
ely	int	Data source did not contain a description for ELY. Column ely has 53984 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 53984 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 49548.
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 53984 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 53984 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 998.
aet	int	Data source did not contain a description for AET. Column aet has 53984 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 29925.
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.
laslaite	int	Data source did not contain a description for LASLAITE. Column laslaite has 53984 rows, out of which 7 are empty, making the null percent 0.01. Minimum value is 0 and maximum value is 9.
s_laslaite	string	Data source did not contain a description for S_LASLAITE. Column s_laslaite has 53984 rows, out of which 7 are empty, making the null percent 0.01. Minimum string is and maximum string is VC2.
laslaji	int	Data source did not contain a description for LASLAJI. Column laslaji has 53984 rows, out of which 1684 are empty, making the null percent 3.12. Minimum value is 1 and maximum value is 9.
s_laslaji	string	Data source did not contain a description for S_LASLAJI. Column s_laslaji has 53984 rows, out of which 1684 are empty, making the null percent 3.12. Minimum string is and maximum string is YL-ramppi.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 53984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (20.756479161260504... and first 25 characters of maximum string: POINT (31.313865939816374...
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 53984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated	September 10, 2020
Created	August 1, 2018