Vegetation Points in Helsinki, Finland (Helsingin kaupunkiympariston toimiala)
Tables
-
Green Areas: Information about Green Points in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains point data on viherosat (green spaces) in Helsinki, Finland. The table is sourced from the website of Helsingin kaupunkiympariston toimiala. It includes various columns such as '_extract_date', '_row_number', 'osan_id', 'paatyyppi', 'paatyyppi_c2', 'alatyyppi', 'alatyyppi_c4', 'materiaali', 'materiaal0', 'rakenteell', 'rakenteel0', 'talvikunno', 'talvikunn0', 'tkp_kiiree', 'tyhjentava', 'hoitoluokk', 'hoitoluok0', 'hoitoluoka', 'puhtaanapi', 'puhtaanap0', 'puhtaanap1', 'pituus', 'leveys', 'pinta_ala', 'puiston_ni', 'viheraluee', 'viheralue0', 'viheralue1', 'osan_nro', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. The table provides useful data for data analytics, such as analyzing the length,...
-
Version History of Green Areas Points in Helsinki, FinlandTSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source in the country 'Finland'. It is a historical record of the base table called 'ylre_viherosat_pointpoint'. Each row in this table represents a specific version of a row in the base table. The columns '_start_date' and '_end_date' indicate the extraction dates for each row version. If the '_end_date' column is null, it means that the row is the most recent version. The table contains additional columns such as '_row_number', 'osan_id', 'paatyyppi', 'paatyyppi_c2', 'alatyyppi', 'alatyyppi_c4', 'materiaali', 'materiaal0', 'rakenteell', 'rakenteel0', 'talvikunno', 'talvikunn0', 'tkp_kiiree', 'tyhjentava', 'hoitoluokk', 'hoitoluok0', 'hoitoluoka', 'puhtaanapi',...
Column Descriptions
Green Areas: Information about Green Points in Helsingin kaupunkiympariston toimiala, Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date of extraction for the data |
| _row_number | long | The sequential number of the row |
| osan_id | int | The ID of the osan |
| paatyyppi | string | The main type of the record |
| paatyyppi_c2 | int | The second-level main type of the record |
| alatyyppi | string | The sub-type of the record |
| alatyyppi_c4 | int | The second-level sub-type of the record |
| materiaali | string | The material used |
| materiaal0 | int | The second material used |
| rakenteell | string | The structural aspect |
| rakenteel0 | int | The second structural aspect |
| talvikunno | string | The winter maintenance |
| talvikunn0 | int | The second winter maintenance |
| tkp_kiiree | string | The urgency of repairs needed |
| tyhjentava | string | Whether the area needs to be emptied |
| hoitoluokk | string | The maintenance class |
| hoitoluok0 | int | The second maintenance class |
| hoitoluoka | string | The type of maintenance class |
| puhtaanapi | string | The cleanliness level |
| puhtaanap0 | int | The second cleanliness level |
| puhtaanap1 | int | The third cleanliness level |
| pituus | int | The length |
| leveys | int | The width |
| pinta_ala | int | The surface area |
| puiston_ni | string | The park's name |
| viheraluee | string | The green area |
| viheralue0 | int | The second green area |
| viheralue1 | int | The third green area |
| osan_nro | int | The number of the osan |
| paivitetty | string | The date of last update |
| geom_geojson | string | The geometry in GeoJSON format |
| geom_geotext | string | The geometry in Geotext format |
| geom_type | string | The type of geometry |
| geom_centroid | string | The centroid of the geometry |
| geom_center_x | double | The x-coordinate of the geometric center |
| geom_center_y | double | The y-coordinate of the geometric center |
| geom | binary | The geometry |
Version History of Green Areas Points in Helsinki, Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column indicates the start date of the validity period for the row version in the table. |
| _end_date | date | This column indicates the end date of the validity period for the row version in the table. |
| _row_number | long | This column represents the row number or identifier for the version history row. |
| osan_id | int | This column stores the identifier of the base table row for which the version history is recorded. |
| paatyyppi | string | This column stores the main type value of the base table row. |
| paatyyppi_c2 | int | This column stores the secondary main type value of the base table row. |
| alatyyppi | string | This column stores the sub-type value of the base table row. |
| alatyyppi_c4 | int | This column stores the secondary sub-type value of the base table row. |
| materiaali | string | This column stores the material value of the base table row. |
| materiaal0 | int | This column stores the secondary material value of the base table row. |
| rakenteell | string | This column stores the structural value of the base table row. |
| rakenteel0 | int | This column stores the secondary structural value of the base table row. |
| talvikunno | string | This column stores the winter maintenance value of the base table row. |
| talvikunn0 | int | This column stores the secondary winter maintenance value of the base table row. |
| tkp_kiiree | string | This column stores the urgency value of the base table row. |
| tyhjentava | string | This column stores the evacuating value of the base table row. |
| hoitoluokk | string | This column stores the maintenance class value of the base table row. |
| hoitoluok0 | int | This column stores the secondary maintenance class value of the base table row. |
| hoitoluoka | string | This column stores the tertiary maintenance class value of the base table row. |
| puhtaanapi | string | This column stores the cleanliness value of the base table row. |
| puhtaanap0 | int | This column stores the secondary cleanliness value of the base table row. |
| puhtaanap1 | int | This column stores the tertiary cleanliness value of the base table row. |
| pituus | int | This column stores the length value of the base table row. |
| leveys | int | This column stores the width value of the base table row. |
| pinta_ala | int | This column stores the area value of the base table row. |
| puiston_ni | string | This column stores the park name value of the base table row. |
| viheraluee | string | This column stores the green area value of the base table row. |
| viheralue0 | int | This column stores the secondary green area value of the base table row. |
| viheralue1 | int | This column stores the tertiary green area value of the base table row. |
| osan_nro | int | This column stores the part number or identifier of the base table row. |
| paivitetty | string | This column stores the date of the last update for the base table row. |
| geom_geojson | string | This column stores the geometry data in GeoJSON format for the base table row. |
| geom_geotext | string | This column stores the geometry data in Geotext format for the base table row. |
| geom_type | string | This column stores the type of geometry for the base table row. |
| geom_centroid | string | This column stores the centroid point geometry for the base table row. |
| geom_center_x | double | This column stores the x-coordinate of the centroid point geometry for the base table row. |
| geom_center_y | double | This column stores the y-coordinate of the centroid point geometry for the base table row. |
| geom | binary | This column stores the full geometry information for the base table row. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | October 22, 2018 |