Johdot ja kaapelit

Tables

Tl314, Avointl314, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille voi rekisteröidä teiden varsilla ja ajoradoilla olevat johdot ja kaapelit. Ajoradan poikki menevä kaapeli olisi periaatteessa pistekohtainen, mutta tässä sille annetaan metrin pituus tai enemmän, jos kaapelin sijainnille halutaan antaa tiettyä turvamarginaalia.

Column Descriptions

Tl314, Avointl314, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 66986 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 376662 and maximum value is 445168.
ely	int	Data source did not contain a description for ELY. Column ely has 66986 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 66986 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 88857.
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 66986 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 66986 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 995.
aet	int	Data source did not contain a description for AET. Column aet has 66986 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 24115.
losa	int	Data source did not contain a description for LOSA. Column losa has 66986 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 995.
let	int	Data source did not contain a description for LET. Column let has 66986 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 26205.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 66986 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	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.
jokaty	int	Data source did not contain a description for JOKATY. Column jokaty has 66986 rows, out of which 2 are empty, making the null percent 0.00. Minimum value is 10 and maximum value is 50.
s_jokaty	string	Data source did not contain a description for S_JOKATY. Column s_jokaty has 66986 rows, out of which 2 are empty, making the null percent 0.00. Minimum string is and maximum string is viesti.
jokasi	int	Data source did not contain a description for JOKASI. Column jokasi has 66986 rows, out of which 187 are empty, making the null percent 0.28. Minimum value is 1 and maximum value is 9.
s_jokasi	string	Data source did not contain a description for S_JOKASI. Column s_jokasi has 66986 rows, out of which 2 are empty, making the null percent 0.00. Minimum string is and maximum string is välikaista.
jokaeta	int	Data source did not contain a description for JOKAETA. Column jokaeta has 66986 rows, out of which 65412 are empty, making the null percent 97.65. Minimum value is 1 and maximum value is 42.
jokanro	int	Data source did not contain a description for JOKANRO. Column jokanro has 66986 rows, out of which 2303 are empty, making the null percent 3.44. Minimum value is 1 and maximum value is 73617.
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 66986 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 132 and maximum value is 9000.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 66986 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 66986 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 66986 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 66986 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 66986 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 66986 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.
laani	string	Data source did not contain a description for LAANI. Column laani has 66986 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.
jokanimi	string	Data source did not contain a description for JOKANIMI. Column jokanimi has 66986 rows, out of which 1929 are empty, making the null percent 2.88. First 25 characters of minimum string: ... and first 25 characters of maximum string: Övermark centralantennand...
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 66986 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 (21.1094581412... and first 25 characters of maximum string: MULTILINESTRING ((26.0589...
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 66986 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 11, 2020
Created	July 9, 2018