Verkot

Tables

Tl153, Avointl153, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tieto rekisteröidään aina, kun 1-ajorataiselle tielle on molempien kaistojen tai 2-ajorataisella tiellä on kaistan leveydelle asennettu verkko. Tierekisteriin viedään verkon materiaali. ELY:n YHA-käyttäjä tai vastaava toimittaa tiedot päällysteeseen asennetuista verkoista tierekisterin ylläpitäjälle.

Column Descriptions

Tl153, Avointl153, Latest

Column	Type	Comment
kaista	int	Data source did not contain a description for KAISTA. Column kaista has 17957 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 31.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 17957 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 999.
aet	int	Data source did not contain a description for AET. Column aet has 17957 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 21865.
losa	int	Data source did not contain a description for LOSA. Column losa has 17957 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 999.
let	int	Data source did not contain a description for LET. Column let has 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7 and maximum value is 22068.
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.
verkkoma	int	Data source did not contain a description for VERKKOMA. Column verkkoma has 17957 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 9.
s_verkkoma	string	Data source did not contain a description for S_VERKKOMA. Column s_verkkoma has 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lasikuitu and maximum string is Teräs.
verkkota	int	Data source did not contain a description for VERKKOTA. Column verkkota has 17957 rows, out of which 16884 are empty, making the null percent 94.02. Minimum value is 1 and maximum value is 9.
s_verkkota	string	Data source did not contain a description for S_VERKKOTA. Column s_verkkota has 17957 rows, out of which 16884 are empty, making the null percent 94.02. Minimum string is and maximum string is pithalk.
verkkosi	int	Data source did not contain a description for VERKKOSI. Column verkkosi has 17957 rows, out of which 16468 are empty, making the null percent 91.71. Minimum value is 1 and maximum value is 4.
s_verkkosi	string	Data source did not contain a description for S_VERKKOSI. Column s_verkkosi has 17957 rows, out of which 16468 are empty, making the null percent 91.71. Minimum string is and maximum string is yläkantava.
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 17957 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 1437.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 17957 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 17957 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 17957 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 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 17957 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 17957 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 17957 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 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 123841 and maximum value is 141797.
ely	int	Data source did not contain a description for ELY. Column ely has 17957 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 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3 and maximum value is 89741.
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 17957 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.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 17957 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.7681111440... and first 25 characters of maximum string: LINESTRING (30.9694686898...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 17957 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated	September 10, 2020
Created	July 9, 2018