Melurakenteet - Melurakenteet (Tierekisterin tietolaji 514)

Tables

Tl514, Avointl514TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tällä tietolajilla ilmoitetaan melurakenteella varustettu tieosuus. Myös silloilla olevat erityiset melukaiteet inventoidaan. Melurakenteesta inventoidaan tyyppi ja materiaali sekä erikseen pintaverhoilun materiaali. Hoitoon liittyvät poikkeusjärjestelyt selvitetään toimistotyönä ELY:issä. Melurakenteesta otetaan edustava kuva. Lisäksi määritellään rakenteen yläreunan keskimääräinen etäisyys ajoradan reunasta ja rakenteen ylä- ja alareunan keskimääräinen korkeus ajoradan pinnan suhteen. Melurakenne tulee rekisteröidä useampana tieosoitevälinä jos se muodostuu selkeästi useammasta, em. keskimääräisten tunnuslukujen suhteen erilaisesta osuudesta.

Column Descriptions

Tl514, Avointl514

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 2589 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 17308 and maximum value is 22430.
ely	int	Data source did not contain a description for ELY. Column ely has 2589 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 2589 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 82409.
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 2589 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 2589 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 919.
aet	int	Data source did not contain a description for AET. Column aet has 2589 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 15320.
losa	int	Data source did not contain a description for LOSA. Column losa has 2589 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 919.
let	int	Data source did not contain a description for LET. Column let has 2589 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 15440.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 2589 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 8.
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 2589 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is TMTMMI1969529619 and maximum string is TMTMVK2121227874.
kuntoluo	int	Data source did not contain a description for KUNTOLUO. Column kuntoluo has 2589 rows, out of which 449 are empty, making the null percent 17.34. Minimum value is 1 and maximum value is 5.
s_kuntoluo	string	Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 2589 rows, out of which 449 are empty, making the null percent 17.34. Minimum string is erinomaine and maximum string is välttävä.
urakka	int	Data source did not contain a description for URAKKA. Column urakka has 2589 rows, out of which 2579 are empty, making the null percent 99.61. Minimum value is 100 and maximum value is 3007.
s_urakka	string	Data source did not contain a description for S_URAKKA. Column s_urakka has 2589 rows, out of which 2579 are empty, making the null percent 99.61.
x	string	Data source did not contain a description for X. Column is empty.
y	string	Data source did not contain a description for Y. Column is empty.
z	string	Data source did not contain a description for Z. Column is empty.
melurtyy	int	Data source did not contain a description for MELURTYY. Column melurtyy has 2589 rows, out of which 48 are empty, making the null percent 1.85. Minimum value is 1 and maximum value is 9.
s_melurtyy	string	Data source did not contain a description for S_MELURTYY. Column s_melurtyy has 2589 rows, out of which 48 are empty, making the null percent 1.85. Minimum string is kaide and maximum string is valli.
melurmat	int	Data source did not contain a description for MELURMAT. Column melurmat has 2589 rows, out of which 4 are empty, making the null percent 0.15. Minimum value is 3 and maximum value is 15.
s_melurmat	string	Data source did not contain a description for S_MELURMAT. Column s_melurmat has 2589 rows, out of which 4 are empty, making the null percent 0.15. Minimum string is betoni and maximum string is teräs.
melurver	int	Data source did not contain a description for MELURVER. Column melurver has 2589 rows, out of which 618 are empty, making the null percent 23.87. Minimum value is 0 and maximum value is 7.
s_melurver	string	Data source did not contain a description for S_MELURVER. Column s_melurver has 2589 rows, out of which 618 are empty, making the null percent 23.87. Minimum string is ei verhoil and maximum string is sepeli.
melurhoi	int	Data source did not contain a description for MELURHOI. Column melurhoi has 2589 rows, out of which 1385 are empty, making the null percent 53.50. Minimum value is 0 and maximum value is 3.
s_melurhoi	string	Data source did not contain a description for S_MELURHOI. Column s_melurhoi has 2589 rows, out of which 1385 are empty, making the null percent 53.50.
meluret	int	Data source did not contain a description for MELURET. Column meluret has 2589 rows, out of which 2539 are empty, making the null percent 98.07. Minimum value is 5 and maximum value is 250.
meluryla	int	Data source did not contain a description for MELURYLA. Column meluryla has 2589 rows, out of which 2465 are empty, making the null percent 95.21. Minimum value is 7 and maximum value is 85.
melurala	int	Data source did not contain a description for MELURALA. Column melurala has 2589 rows, out of which 2519 are empty, making the null percent 97.30. Minimum value is 0 and maximum value is 0.
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 2589 rows, out of which 2 are empty, making the null percent 0.08. 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 2589 rows, out of which 2 are empty, making the null percent 0.08. Minimum string is Pietarsaari 16-21 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 2589 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 2589 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 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 2589 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pietarsaari and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 2589 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 2589 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pohjanmaa and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 2589 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Länsi-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