Reunakivet - Reunakivet (Tierekisterin tietolaji 522)

Tables

Tl522, Avointl522TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan teiden ja kevyen liikenteen väylien varrella sijaitsevat reunakivet. Reunakivistä inventoidaan materiaali ja kirjataan kunto-puutteet. Keskisaarekkeiden reunakivet kirjataan keskelle. Yli metrin pituiset puutteelliset reunakivijaksot inventoidaan omiksi jaksoikseen. Jaksoa ei tarvitse katkaista liittymän vuoksi jos ko. puolen reunakiveys jatkuu liittymän jälkeen.

Column Descriptions

Tl522, Avointl522

Column	Type	Comment
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.
rkivimat	int	Data source did not contain a description for RKIVIMAT. Column rkivimat has 30055 rows, out of which 114 are empty, making the null percent 0.38. Minimum value is 1 and maximum value is 14.
s_rkivimat	string	Data source did not contain a description for S_RKIVIMAT. Column s_rkivimat has 30055 rows, out of which 114 are empty, making the null percent 0.38.
rkivipuu	int	Data source did not contain a description for RKIVIPUU. Column rkivipuu has 30055 rows, out of which 196 are empty, making the null percent 0.65. Minimum value is 0 and maximum value is 4.
s_rkivipuu	string	Data source did not contain a description for S_RKIVIPUU. Column s_rkivipuu has 30055 rows, out of which 196 are empty, making the null percent 0.65. Minimum string is kunnossa and maximum string is vaurioitun.
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 30055 rows, out of which 8 are empty, making the null percent 0.03. Minimum value is 127 and maximum value is 9000.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 30055 rows, out of which 8 are empty, making the null percent 0.03. Minimum string is Kunta hoitaa and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 30055 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pohjois-Savon ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 30055 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 30055 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kitee and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 30055 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 30055 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pohjois-Karjala and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 30055 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.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 30055 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 35849.
ely	int	Data source did not contain a description for ELY. Column ely has 30055 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 30055 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 99507.
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 30055 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 30055 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 997.
aet	int	Data source did not contain a description for AET. Column aet has 30055 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 24805.
losa	int	Data source did not contain a description for LOSA. Column losa has 30055 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 997.
let	int	Data source did not contain a description for LET. Column let has 30055 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 24840.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 30055 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 30055 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi744343 and maximum string is TMTMVK2121351466.
urakka	int	Data source did not contain a description for URAKKA. Column urakka has 30055 rows, out of which 30015 are empty, making the null percent 99.87. This column is filled with a constant value. Constant value is 3007.
s_urakka	string	Data source did not contain a description for S_URAKKA. Column s_urakka has 30055 rows, out of which 30015 are empty, making the null percent 99.87. This column is filled with a constant value.
x	string	Data source did not contain a description for X. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018