Green Areas - Helsingin kaupunkiympariston toimiala (Helsinki, Finland)
Tables
-
Green Areas Line Data in Helsinki, FinlandTSV
This table contains data from the 'Helsinki Urban Environment Sector' website, sourced from the country Finland (ISO country code: 'fi'). It represents information about green areas and their attributes. The table consists of various columns including '_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'. This table provides valuable...
-
Version History of Green Area LinesTSV
This table represents the version history of rows in the 'Helsingin kaupunkiympariston toimiala' dataset. It is sourced from the website of 'City of Helsinki Urban Environment Division' in Finland. The table contains the base table rows from 'hkrylre_viherosat_line__ylre_viherosat_lineline' and includes additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a newer version of the row was extracted. If the value of '_end_date' is null, it means that the row represents the most recent version. The table provides valuable data for data analytics and insights. Some examples of how the data can be utilized include analyzing changes and trends in the...
Column Descriptions
Green Areas Line Data in Helsinki, Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the record. |
| osan_id | int | The identifier of the OSAN. |
| paatyyppi | string | The main type of the object. |
| paatyyppi_c2 | int | The second level main type of the object. |
| alatyyppi | string | The subtype of the object. |
| alatyyppi_c4 | int | The second level subtype of the object. |
| materiaali | string | The material of the object. |
| materiaal0 | int | The additional material information of the object. |
| rakenteell | string | The structural information of the object. |
| rakenteel0 | int | The additional structural information of the object. |
| talvikunno | string | The winter maintenance information of the object. |
| talvikunn0 | int | Additional winter maintenance information of the object. |
| tkp_kiiree | string | Flag indicating urgency of maintenance need for the object. |
| tyhjentava | string | Flag indicating if the object is emptyable. |
| hoitoluokk | string | The maintenance class of the object. |
| hoitoluok0 | int | The additional maintenance class of the object. |
| hoitoluoka | string | The maintenance class quality of the object. |
| puhtaanapi | string | The cleanliness level of the object. |
| puhtaanap0 | int | The additional cleanliness level of the object. |
| puhtaanap1 | int | The second additional cleanliness level of the object. |
| pituus | int | The length of the object. |
| leveys | int | The width of the object. |
| pinta_ala | int | The surface area of the object. |
| puiston_ni | string | The name of the park where the object is located. |
| viheraluee | string | The green area where the object is located. |
| viheralue0 | int | Additional green area where the object is located. |
| viheralue1 | int | Second additional green area where the object is located. |
| osan_nro | int | The part number of the object. |
| paivitetty | string | The date when the record was last updated. |
| geom_geojson | string | The geometry information of the object in GeoJSON format. |
| geom_geotext | string | The geometry information of the object in Geotext format. |
| geom_type | string | The type of the geometry of the object. |
| geom_centroid | string | The centroid point of the geometry of the object. |
| geom_center_x | double | The x-coordinate of the center point of the geometry of the object. |
| geom_center_y | double | The y-coordinate of the center point of the geometry of the object. |
| geom | binary | The geometry of the object. |
Version History of Green Area Lines
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period for the row version |
| _end_date | date | The end date of the validity period for the row version |
| _row_number | long | The row number of the version history |
| osan_id | int | The identifier of the base table row |
| paatyyppi | string | The main type of the data |
| paatyyppi_c2 | int | The secondary main type of the data |
| alatyyppi | string | The sub-type of the data |
| alatyyppi_c4 | int | The secondary sub-type of the data |
| materiaali | string | The material of the data |
| materiaal0 | int | The secondary material of the data |
| rakenteell | string | The structural information of the data |
| rakenteel0 | int | The secondary structural information of the data |
| talvikunno | string | The winter maintenance information of the data |
| talvikunn0 | int | The secondary winter maintenance information of the data |
| tkp_kiiree | string | The urgency of the repair work |
| tyhjentava | string | The emptying information of the data |
| hoitoluokk | string | The maintenance class of the data |
| hoitoluok0 | int | The secondary maintenance class of the data |
| hoitoluoka | string | The tertiary maintenance class of the data |
| puhtaanapi | string | The cleanliness information of the data |
| puhtaanap0 | int | The secondary cleanliness information of the data |
| puhtaanap1 | int | The tertiary cleanliness information of the data |
| pituus | int | The length of the data |
| leveys | int | The width of the data |
| pinta_ala | int | The surface area of the data |
| puiston_ni | string | The park name or number of the data |
| viheraluee | string | The green area of the data |
| viheralue0 | int | The secondary green area of the data |
| viheralue1 | int | The tertiary green area of the data |
| osan_nro | int | The part number of the data |
| paivitetty | string | The date of the data 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 center of the geometry |
| geom_center_y | double | The y-coordinate of the center of the geometry |
| geom | binary | The geometry information of the data |
Additional Info
| Last Updated | April 23, 2024 |
|---|---|
| Created | October 22, 2018 |