Pyörätien ja jalkakäytävän yhdistelmän haara

Tables

Tl270, Avointl270, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tierekisteriin viedään pyörätieltä myös haarat, eli alle 20 m:n pätkät, jotka johtavat usein bussipysäkille, hautausmaalle tms. paikkaan.

Column Descriptions

Tl270, Avointl270, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 2334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 34577 and maximum value is 37137.
ely	int	Data source did not contain a description for ELY. Column ely has 2334 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 2334 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 96510.
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 2334 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 2334 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 2334 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 16673.
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.
haaraty	int	Data source did not contain a description for HAARATY. Column haaraty has 2334 rows, out of which 9 are empty, making the null percent 0.39. Minimum value is 1 and maximum value is 2.
s_haaraty	string	Data source did not contain a description for S_HAARATY. Column s_haaraty has 2334 rows, out of which 9 are empty, making the null percent 0.39. Minimum string is and maximum string is muu.
haarapit	int	Data source did not contain a description for HAARAPIT. Column haarapit has 2334 rows, out of which 198 are empty, making the null percent 8.48. Minimum value is 0 and maximum value is 190.
haararaj	int	Data source did not contain a description for HAARARAJ. Column haararaj has 2334 rows, out of which 2318 are empty, making the null percent 99.31. Constant value is 1.
s_haararaj	string	Data source did not contain a description for S_HAARARAJ. Column s_haararaj has 2334 rows, out of which 2318 are empty, making the null percent 99.31. The single string value is: .
haarapaa	int	Data source did not contain a description for HAARAPAA. Column haarapaa has 2334 rows, out of which 390 are empty, making the null percent 16.71. Minimum value is 2 and maximum value is 40.
s_haarapaa	string	Data source did not contain a description for S_HAARAPAA. Column s_haarapaa has 2334 rows, out of which 390 are empty, making the null percent 16.71. Minimum string is and maximum string is sora.
haarahoi	int	Data source did not contain a description for HAARAHOI. Column haarahoi has 2334 rows, out of which 216 are empty, making the null percent 9.25. Minimum value is 1 and maximum value is 9.
s_haarahoi	string	Data source did not contain a description for S_HAARAHOI. Column s_haarahoi has 2334 rows, out of which 216 are empty, making the null percent 9.25. Minimum string is and maximum string is Väylä.
haaralev	int	Data source did not contain a description for HAARALEV. Column haaralev has 2334 rows, out of which 1139 are empty, making the null percent 48.80. Minimum value is 0 and maximum value is 230.
haarasel	string	Data source did not contain a description for HAARASEL. Column haarasel has 2334 rows, out of which 1504 are empty, making the null percent 64.44. Minimum string is and maximum string is yt-liittymän kohdalla.
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 2334 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 2334 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 2334 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 2334 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 2334 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 2334 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 2334 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 2334 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.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 2334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (20.882399509663657... and first 25 characters of maximum string: POINT (30.94971064463249 ...
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 2334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated	September 11, 2020
Created	August 1, 2018