Yleisten alueiden rekisteri, viherosat

Tables

Ylre Viherosatline, Hkrylre ViherosatTSV
Luontotietojärjestelmässä voi tutustua Helsingin monipuoliseen luontoon. Järjestelmän keskeisimpiä luontoaineistoja ovat luonnonsuojelukohteet, arvokkaat kasvisto- ja kasvillisuuskohteet, linnustollisesti arvokkaat kohteet, arvokkaat geologiset kohteet, tärkeät lepakkoalueet, kääpäkohteet ja arvokkaat metsäluonnon monimuotoisuuskohteet. Palvelusta on yleisöversio ja virkaversio. Yleisöversion tietosisältöä on suodatettu luonnonsuojelusyistä. Virkaversiota käytetään kaupungin sisäisissä suunnittelu- ja tutkimustarkoituksissa. Helsingin Luontotietojärjestelmän avoimena datana julkaistava aineisto koostuu seuraavista WFS-rajapinnan tasoista, jotka on ryhmitelty rauhoitettuihin / rauhoitettaviin kohteisiin, arvokkaisiin luontokohteisiin, vesistöaineistoihin ja muuhun luontotietooon....

Column Descriptions

Ylre Viherosatline, Hkrylre Viherosat

Column	Type	Comment
osan_id	int	Data source did not contain a description for osan_id. Column osan_id has 5915 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 562408.
paatyyppi	string	Data source did not contain a description for paatyyppi. Column paatyyppi has 5915 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...
alatyyppi	string	Data source did not contain a description for alatyyppi. Column alatyyppi has 5915 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 Rummut.
materiaali	string	Data source did not contain a description for materiaali. Column materiaali has 5915 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ajojohde... and first 25 characters of maximum string: HKR - A5, suoja-aita, ter...
rakenteell	string	Data source did not contain a description for rakenteell. Column rakenteell has 5915 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 Kaupunkiympäristö Länsi.
talvikunno	string	Data source did not contain a description for talvikunno. Column talvikunno has 5915 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 HKL.
tkp_kiiree	string	Data source did not contain a description for tkp_kiiree. Column tkp_kiiree has 5915 rows, out of which 5910 are empty, making the null percent 99.92. Minimum string is and maximum string is C - hoitotapa.
hoitoluokk	string	Data source did not contain a description for hoitoluokk. Column hoitoluokk has 5915 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 A2.
hoitoluoka	string	Data source did not contain a description for hoitoluoka. Column hoitoluoka has 5915 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvometsä and maximum string is Käyttöviheralue.
pituus	int	Data source did not contain a description for pituus. Column pituus has 5915 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 5915 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 5915 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 5915 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 HESPERIANPUISTO.
viheraluee	int	Data source did not contain a description for viheraluee. Column viheraluee has 5915 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 236841.
viheralue0	int	Data source did not contain a description for viheralue0. Column viheralue0 has 5915 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 10364.
osan_nro	int	Data source did not contain a description for osan_nro. Column osan_nro has 5915 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	string	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 5915 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 (24.9338541591...
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 5915 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.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	November 26, 2023
Created	October 22, 2018