Tekninen piste - Tekninen piste (Tierekisterin tietolaji 523)

Tables

Tl523, Avointl523TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan erilaiset kiinteät tutkimus- ja ohjauslaitteet ja sekalaisia teknisiä varusteita ja laitteita, joille ei ole omaa tietolajia. Voimaantulopäivämääränä käytetään laitteen asennuspäivämäärää. Puoli määräytyy laitteiston tai antureiden pääasiallisen sijainnin mukaan. Mikäli samassa paikassa (ajorata / puoli) on erityyppisiä laitteita, voidaan ne kirjata samalle metrilukemalle.

Column Descriptions

Tl523, Avointl523

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7741 and maximum value is 20161.
ely	int	Data source did not contain a description for ELY. Column ely has 6373 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 6373 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 88178.
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 6373 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 6373 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 985.
aet	int	Data source did not contain a description for AET. Column aet has 6373 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 23172.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 6373 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 9.
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.
tunniste	string	Data source did not contain a description for TUNNISTE. Column tunniste has 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi154630 and maximum string is TSAM49.
kuntoluo	int	Data source did not contain a description for KUNTOLUO. Column kuntoluo has 6373 rows, out of which 5925 are empty, making the null percent 92.97. Minimum value is 3 and maximum value is 5.
s_kuntoluo	string	Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 6373 rows, out of which 5925 are empty, making the null percent 92.97.
urakka	int	Data source did not contain a description for URAKKA. Column urakka has 6373 rows, out of which 5918 are empty, making the null percent 92.86. Minimum value is 400 and maximum value is 6001.
s_urakka	string	Data source did not contain a description for S_URAKKA. Column s_urakka has 6373 rows, out of which 5918 are empty, making the null percent 92.86.
x	int	Data source did not contain a description for X. Column x has 6373 rows, out of which 4008 are empty, making the null percent 62.89. Minimum value is 381152 and maximum value is 7776048.
y	int	Data source did not contain a description for Y. Column y has 6373 rows, out of which 4008 are empty, making the null percent 62.89. Minimum value is 198974 and maximum value is 6905510.
z	int	Data source did not contain a description for Z. Column z has 6373 rows, out of which 4381 are empty, making the null percent 68.74. Minimum value is 0 and maximum value is 475.
tektyypp	int	Data source did not contain a description for TEKTYYPP. Column tektyypp has 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 99.
s_tektyypp	string	Data source did not contain a description for S_TEKTYYPP. Column s_tektyypp has 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DSL10 and maximum string is vaihvaro.
teket	int	Data source did not contain a description for TEKET. Column teket has 6373 rows, out of which 5859 are empty, making the null percent 91.93. Minimum value is 0 and maximum value is 45.
teknro	int	Data source did not contain a description for TEKNRO. Column teknro has 6373 rows, out of which 3279 are empty, making the null percent 51.45. Minimum value is 1 and maximum value is 44321.
teknimi	string	Data source did not contain a description for TEKNIMI. Column teknimi has 6373 rows, out of which 906 are empty, making the null percent 14.22. First 25 characters of minimum string: Muovihattu,2 tolppaa,dsl-... and first 25 characters of maximum string: Äänekoski...
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 6373 rows, out of which 6 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 6373 rows, out of which 6 are empty, making the null percent 0.09. Minimum string is Hämeenlinna13 - 18 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Uudenmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 6373 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 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Janakkala and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 6373 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 6373 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kanta-Häme and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 6373 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.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018