Kaiteet

Tables

Tl501, Avointl501, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan teiden ja kevyen liikenteen väylien varrella sijaitsevat kaiteet. Kaiteista inventoidaan tyyppi- ja materiaalitiedot. Lisäksi inventoidaan kaiteiden puutteet silmämääräisesti ja ilmoitetaan puutteellisen osuuden pituus prosentteina kaiteen kokonaispituudesta.

Column Descriptions

Tl501, Avointl501, Latest

Column	Type	Comment
laani	string	Data source did not contain a description for LAANI. Column laani has 81981 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.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 81981 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 443642 and maximum value is 534689.
ely	int	Data source did not contain a description for ELY. Column ely has 81981 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 81981 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 96522.
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 81981 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 81981 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 998.
aet	int	Data source did not contain a description for AET. Column aet has 81981 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 31442.
losa	int	Data source did not contain a description for LOSA. Column losa has 81981 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 998.
let	int	Data source did not contain a description for LET. Column let has 81981 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 31454.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 81981 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	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.
tunniste	string	Data source did not contain a description for TUNNISTE. Column tunniste has 81981 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HARJ0000000000000107 and maximum string is TMTMVL815651983.
urakka	float	Data source did not contain a description for URAKKA. Column urakka has 81981 rows, out of which 81938 are empty, making the null percent 99.95. Constant value is 3007.00.
s_urakka	string	Data source did not contain a description for S_URAKKA. Column s_urakka has 81981 rows, out of which 81938 are empty, making the null percent 99.95. The single string value is: .
x	int	Data source did not contain a description for X. Column x has 81981 rows, out of which 81749 are empty, making the null percent 99.72. Minimum value is 250758 and maximum value is 505200.
y	int	Data source did not contain a description for Y. Column y has 81981 rows, out of which 81749 are empty, making the null percent 99.72. Minimum value is 6717807 and maximum value is 7695918.
z	float	Data source did not contain a description for Z. Column is empty.
kaidety	int	Data source did not contain a description for KAIDETY. Column kaidety has 81981 rows, out of which 14 are empty, making the null percent 0.02. Minimum value is 1 and maximum value is 7.
s_kaidety	string	Data source did not contain a description for S_KAIDETY. Column s_kaidety has 81981 rows, out of which 14 are empty, making the null percent 0.02. Minimum string is and maximum string is vaijerik.
kaidemat	int	Data source did not contain a description for KAIDEMAT. Column kaidemat has 81981 rows, out of which 195 are empty, making the null percent 0.24. Minimum value is 1 and maximum value is 13.
s_kaidemat	string	Data source did not contain a description for S_KAIDEMAT. Column s_kaidemat has 81981 rows, out of which 195 are empty, making the null percent 0.24. Minimum string is and maximum string is teräs.
kaidepyl	int	Data source did not contain a description for KAIDEPYL. Column kaidepyl has 81981 rows, out of which 601 are empty, making the null percent 0.73. Minimum value is 1 and maximum value is 5.
s_kaidepyl	string	Data source did not contain a description for S_KAIDEPYL. Column s_kaidepyl has 81981 rows, out of which 601 are empty, making the null percent 0.73. Minimum string is and maximum string is U-100.
kaidekolh	int	Data source did not contain a description for KAIDEKOLH. Column kaidekolh has 81981 rows, out of which 6247 are empty, making the null percent 7.62. Minimum value is 0 and maximum value is 115.
kaideruost	int	Data source did not contain a description for KAIDERUOST. Column kaideruost has 81981 rows, out of which 6457 are empty, making the null percent 7.88. Minimum value is 0 and maximum value is 330.
kaidemaal	int	Data source did not contain a description for KAIDEMAAL. Column kaidemaal has 81981 rows, out of which 6759 are empty, making the null percent 8.24. Minimum value is 0 and maximum value is 110.
nollaama	int	Data source did not contain a description for NOLLAAMA. Column nollaama has 81981 rows, out of which 78348 are empty, making the null percent 95.57. Minimum value is 1 and maximum value is 2.
s_nollaama	string	Data source did not contain a description for S_NOLLAAMA. Column s_nollaama has 81981 rows, out of which 78348 are empty, making the null percent 95.57. Minimum string is and maximum string is toinen_paa.
kaidematal	int	Data source did not contain a description for KAIDEMATAL. Column kaidematal has 81981 rows, out of which 5677 are empty, making the null percent 6.92. Minimum value is 0 and maximum value is 300.
pylvasvika	int	Data source did not contain a description for PYLVASVIKA. Column pylvasvika has 81981 rows, out of which 7662 are empty, making the null percent 9.35. Minimum value is 0 and maximum value is 100.
kaidevinos	int	Data source did not contain a description for KAIDEVINOS. Column kaidevinos has 81981 rows, out of which 7350 are empty, making the null percent 8.97. Minimum value is 0 and maximum value is 500.
kiinnvaur	int	Data source did not contain a description for KIINNVAUR. Column kiinnvaur has 81981 rows, out of which 7765 are empty, making the null percent 9.47. Minimum value is 0 and maximum value is 100.
muuvaurio	int	Data source did not contain a description for MUUVAURIO. Column muuvaurio has 81981 rows, out of which 7692 are empty, making the null percent 9.38. Minimum value is 0 and maximum value is 100.
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 81981 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 1437.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 81981 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 81981 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 81981 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 81981 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 Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 81981 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 81981 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.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 81981 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 (20.7612121131... and first 25 characters of maximum string: MULTILINESTRING ((30.9360...
geom_center_x	float	Longitude of center. Column is empty.
geom_center_y	float	Latitude of center. Column is empty.
geom_type	string	Geometry type. Column geom_type has 81981 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 10, 2020
Created	July 9, 2018