Automaattivalvontajaksot

Tables

Tl194, Avointl194, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tällä tietolajilla ilmoitetaan poliisin pysyvin valvontavälinein varustetut tieosuudet ja liittymäalueet. Tieosoite määräytyy ko. tieosuuden molemmissa päissä valvonnasta kertovan ilmoitustaulun mukaan.

Column Descriptions

Tl194, Avointl194, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 2069 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 39458 and maximum value is 41670.
ely	int	Data source did not contain a description for ELY. Column ely has 2069 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 2069 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 43576.
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 2069 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 2069 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 506.
aet	int	Data source did not contain a description for AET. Column aet has 2069 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 17408.
losa	int	Data source did not contain a description for LOSA. Column losa has 2069 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 506.
let	int	Data source did not contain a description for LET. Column let has 2069 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 26205.
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.
valvonta	int	Data source did not contain a description for VALVONTA. Column valvonta has 2069 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 3.
s_valvonta	string	Data source did not contain a description for S_VALVONTA. Column s_valvonta has 2069 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is molemmat and maximum string is nopeus.
vjakso	string	Data source did not contain a description for VJAKSO. Column vjakso has 2069 rows, out of which 85 are empty, making the null percent 4.11. Minimum string is and maximum string is Ylöjärvi.
vtunnus	float	Data source did not contain a description for VTUNNUS. Column is empty.
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 2069 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 132 and maximum value is 1435.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 2069 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 Viinijärvi 17-22.
liva	string	Data source did not contain a description for LIVA. Column liva has 2069 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 2069 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16 and maximum value is 980.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 2069 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 Ylöjärvi.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 2069 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 2069 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 2069 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.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 2069 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 (21.5104485495... and first 25 characters of maximum string: MULTILINESTRING ((25.3739...
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 2069 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018