Yleisten alueiden rekisteri, viherosat (line)

Tables

Ylre viherosat lineline, Hkrylre viherosat line, LatestTSV
No description available for layer hkr:ylre_viherosat_line (Yleisten alueiden rekisteri, viherosat (line))

Column Descriptions

Ylre viherosat lineline, Hkrylre viherosat line, Latest

Column	Type	Comment
osan_id	int	Data source did not contain a description for osan_id. Column osan_id has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 128052 and maximum value is 569090.
paatyyppi	string	Data source did not contain a description for paatyyppi. Column paatyyppi has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kalusteet ja leikkiväline... and first 25 characters of maximum string: Varusteet...
paatyyppi_c2	int	Data source did not contain a description for paatyyppi_c2. Column paatyyppi_c2 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 26 and maximum value is 32.
alatyyppi	string	Data source did not contain a description for alatyyppi. Column alatyyppi has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aidat and maximum string is Vesijohdot.
alatyyppi_c4	int	Data source did not contain a description for alatyyppi_c4. Column alatyyppi_c4 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 238 and maximum value is 495.
materiaali	string	Data source did not contain a description for materiaali. Column materiaali has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ajojohde and maximum string is Välppä.
materiaal0	int	Data source did not contain a description for materiaal0. Column materiaal0 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82 and maximum value is 7256.
rakenteell	string	Data source did not contain a description for rakenteell. Column rakenteell has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HELEN and maximum string is Valtio, Ely-keskus.
rakenteel0	int	Data source did not contain a description for rakenteel0. Column rakenteel0 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23 and maximum value is 581.
talvikunno	string	Data source did not contain a description for talvikunno. Column talvikunno has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Kiinteistö / Yksityinen.
talvikunn0	int	Data source did not contain a description for talvikunn0. Column talvikunn0 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 383.
tkp_kiiree	string	Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 6094 rows, out of which 6087 are empty, making the null percent 99.89. Minimum string is and maximum string is C - hoitotapa.
tyhjentava	string	Data source did not contain a description for tyhjentava. Column tyhjentava has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A-luokka and maximum string is Ei talvikunnossapitoa.
hoitoluokk	string	Data source did not contain a description for hoitoluokk. Column hoitoluokk has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1 and maximum string is H1.
hoitoluok0	int	Data source did not contain a description for hoitoluok0. Column hoitoluok0 has 6094 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 2021.
hoitoluoka	string	Data source did not contain a description for hoitoluoka. Column hoitoluoka has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arvometsä... and first 25 characters of maximum string: Ulkoilu- ja virkistysmets...
puhtaanapi	string	Data source did not contain a description for puhtaanapi. Column puhtaanapi has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Sosiaalivirasto.
puhtaanap0	int	Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 6094 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 301.
puhtaanap1	int	Data source did not contain a description for puhtaanap1. Column puhtaanap1 has 6094 rows, out of which 293 are empty, making the null percent 4.81. Minimum value is 1 and maximum value is 5.
pituus	int	Data source did not contain a description for pituus. Column pituus has 6094 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 1728.
leveys	int	Data source did not contain a description for leveys. Column leveys has 6094 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 1000.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 6094 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 234.
puiston_ni	string	Data source did not contain a description for puiston_ni. Column puiston_ni has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A501 and maximum string is Ystävyyden puisto.
viheraluee	string	Data source did not contain a description for viheraluee. Column viheraluee has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
viheralue0	int	Data source did not contain a description for viheralue0. Column viheralue0 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 240801.
viheralue1	int	Data source did not contain a description for viheralue1. Column viheralue1 has 6094 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 10542.
osan_nro	int	Data source did not contain a description for osan_nro. Column osan_nro has 6094 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 1197.
paivitetty	date	Data source did not contain a description for paivitetty. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 6094 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 (24.8349757623... and first 25 characters of maximum string: LINESTRING (25.2470836123...
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 6094 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 9, 2020
Created	August 6, 2018