Tienvarsimainokset - Tienvarsimainokset (Tierekisterin tietolaji 197)

Tables

Tl197, Avointl197TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin viedään sekä maastossa havaitut tienvarsimainokset, että mainoksille annetut lupapäätökset sitä mukaa kun uusia lupia myönnetään. Mainoksen osoitteena käytetään sen kohtisuoraa projektiota tien keskilinjaan.

Column Descriptions

Tl197, Avointl197

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 34295 and maximum value is 42913.
ely	int	Data source did not contain a description for ELY. Column ely has 5701 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 5701 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 25005.
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 5701 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 5701 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 582.
aet	int	Data source did not contain a description for AET. Column aet has 5701 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 23212.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 5701 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 7.
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.
mainoslu	int	Data source did not contain a description for MAINOSLU. Column mainoslu has 5701 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 4.
s_mainoslu	string	Data source did not contain a description for S_MAINOSLU. Column s_mainoslu has 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ei tietoa and maximum string is määräaik.
mainoseta	int	Data source did not contain a description for MAINOSETA. Column mainoseta has 5701 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 200.
mainoskuva	int	Data source did not contain a description for MAINOSKUVA. Column mainoskuva has 5701 rows, out of which 3553 are empty, making the null percent 62.32. Minimum value is 101 and maximum value is 31214.
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 5701 rows, out of which 5 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 5701 rows, out of which 5 are empty, making the null percent 0.09. Minimum string is Pyhäjärvi 17-22 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pohjois-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 5701 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 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pyhäjärvi and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 5701 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 19.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pohjois-Pohjanmaa and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 5701 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Itä-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