To download the data set, please sign up or log in
OpenAhjo-päätökset
Tables
-
Openahjo Agenda Itemspoint, Helopenahjo Agenda ItemsTSV
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
Openahjo Agenda Itemspoint, Helopenahjo Agenda Items
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2373 and maximum value is 72841. |
| register_i | string | Data source did not contain a description for register_i. Column register_i has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HEL 2011-000193 and maximum string is HEL 2016-005205. |
| subject | string | Data source did not contain a description for subject. Column subject has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 09 Helsinki Human Rights ... and first 25 characters of maximum string: Metsälän vastaanottokesku... |
| policymake | string | Data source did not contain a description for policymake. Column policymake has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 021400VH1 and maximum string is 12920VH1. |
| meeting_da | string | Data source did not contain a description for meeting_da. Column is empty. |
| meeting_id | string | Data source did not contain a description for meeting_id. Column meeting_id has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1/2012 and maximum string is 180/2016. |
| preparer | string | Data source did not contain a description for preparer. Column preparer has 15975 rows, out of which 64 are empty, making the null percent 0.40. Minimum string is and maximum string is Paula Huttunen. |
| introducer | string | Data source did not contain a description for introducer. Column introducer has 15975 rows, out of which 8962 are empty, making the null percent 56.10. Minimum string is and maximum string is Anni Sinnemäki. |
| geometry_t | string | Data source did not contain a description for geometry_t. Column geometry_t has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is address and maximum string is plan_unit. |
| geometry_n | string | Data source did not contain a description for geometry_n. Column geometry_n has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 91-10-252-2 and maximum string is Metsäläntie 2. |
| view_url | string | Data source did not contain a description for view_url. Column view_url has 15975 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://dev.hel.fi/openahj... and first 25 characters of maximum string: http://dev.hel.fi/openahj... |
| origin_id | string | Data source did not contain a description for origin_id. Column origin_id has 15975 rows, out of which 12111 are empty, making the null percent 75.81. First 25 characters of minimum string: ... and first 25 characters of maximum string: 7EF9F74D-2E79-7584-F0DE-D... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 15975 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 (24.833481092861 60... and first 25 characters of maximum string: POINT (24.929729321173866... |
| 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 15975 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. |
| 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 |