To download the data set, please sign up or log in

Vesi purot ja lammet

Vesi purot ja lammet

Tables

  • Vesi Purot Ja Lammetline, Ltj Avoinvesi Purot Ja LammetTSV

    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

Vesi Purot Ja Lammetline, Ltj Avoinvesi Purot Ja Lammet

Column Type Comment
id int Data source did not contain a description for id. Column id has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 182014 and maximum value is 182777.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 37 rows, out of which 1 are empty, making the null percent 2.70. Minimum string is and maximum string is P65.
luokkatunn string Data source did not contain a description for luokkatunn. Column luokkatunn has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: PPO.
luokan_nim string Data source did not contain a description for luokan_nim. Column luokan_nim has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pienvesi: Purot ja lammet.
nimi string Data source did not contain a description for nimi. Column nimi has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Fallbäcken and maximum string is Korppaanoja.
kuvaus string Data source did not contain a description for kuvaus. Column kuvaus has 37 rows, out of which 1 are empty, making the null percent 2.70. First 25 characters of minimum string: ... and first 25 characters of maximum string: Korppaanojan pituus: 661 ...
huom string Data source did not contain a description for huom. Column is empty.
digipvm string Data source did not contain a description for digipvm. Column is empty.
pvm_editoi string Data source did not contain a description for pvm_editoi. Column is empty.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
kohdetekst string Data source did not contain a description for kohdetekst. Column kohdetekst has 37 rows, out of which 12 are empty, making the null percent 32.43. First 25 characters of minimum string: ... and first 25 characters of maximum string: Korppaanojan uoma on lyhy...
metadata string Data source did not contain a description for metadata. Column metadata has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: https://kartta.hel.fi/pai...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 37 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.8861617383... and first 25 characters of maximum string: LINESTRING (24.8900320451...
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 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created October 22, 2018