Jätehuolto

Tables

Tl505, Avointl505, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan levähdysalueilla olevien jäteastioiden lukumäärät. Jäteastioiden tieosoitteen on oltava sama kuin ao. levähdysalueen. Jäteastiat ja jätesäiliöt kuvataan.

Column Descriptions

Tl505, Avointl505, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 765 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16331 and maximum value is 18441.
ely	int	Data source did not contain a description for ELY. Column ely has 765 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 765 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 24874.
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 765 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 765 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 912.
aet	int	Data source did not contain a description for AET. Column aet has 765 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 17600.
puoli	int	Data source did not contain a description for PUOLI. Column puoli has 765 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 7.
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 765 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1006867 and maximum string is TMTMVI933992999.
kuntoluo	int	Data source did not contain a description for KUNTOLUO. Column kuntoluo has 765 rows, out of which 150 are empty, making the null percent 19.61. Minimum value is 1 and maximum value is 5.
s_kuntoluo	string	Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 765 rows, out of which 150 are empty, making the null percent 19.61. Minimum string is and maximum string is tyydyttävä.
urakka	int	Data source did not contain a description for URAKKA. Column urakka has 765 rows, out of which 700 are empty, making the null percent 91.50. Minimum value is 100 and maximum value is 400.
s_urakka	string	Data source did not contain a description for S_URAKKA. Column s_urakka has 765 rows, out of which 700 are empty, making the null percent 91.50. Minimum string is and maximum string is yrittäjä.
x	int	Data source did not contain a description for X. Column x has 765 rows, out of which 763 are empty, making the null percent 99.74. Minimum value is 383383 and maximum value is 553162.
y	int	Data source did not contain a description for Y. Column y has 765 rows, out of which 763 are empty, making the null percent 99.74. Minimum value is 7111736 and maximum value is 7537304.
z	float	Data source did not contain a description for Z. Column is empty.
patunnus	string	Data source did not contain a description for PATUNNUS. Column patunnus has 765 rows, out of which 1 are empty, making the null percent 0.13. Minimum string is and maximum string is TMTMVI933992999.
jatemaanp	int	Data source did not contain a description for JATEMAANP. Column jatemaanp has 765 rows, out of which 130 are empty, making the null percent 16.99. Minimum value is 0 and maximum value is 15.
jateupotet	int	Data source did not contain a description for JATEUPOTET. Column jateupotet has 765 rows, out of which 101 are empty, making the null percent 13.20. Minimum value is 0 and maximum value is 6.
jatesailio	int	Data source did not contain a description for JATESAILIO. Column jatesailio has 765 rows, out of which 202 are empty, making the null percent 26.41. Minimum value is 0 and maximum value is 3.
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 765 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 765 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is E18 Muurla-Lohja 09-29 and maximum string is Äänekoski 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 765 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 765 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 765 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asikkala and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 765 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 765 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 765 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 765 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 (21.249485156295936... and first 25 characters of maximum string: POINT (30.75097970431225 ...
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 765 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	July 9, 2018