Green Areas Line Data in Helsinki, Finland
Click here for a data sample
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 data for various data analytics purposes such as analyzing the distribution of green areas across different geographical locations, assessing the maintenance and cleanliness levels of green areas based on 'hoitoluokka' columns, determining the dimensions and sizes of green areas using 'pituus', 'leveys', and 'pinta_ala' columns, and analyzing the types of materials and structures used in the green areas with the 'materiaali' and 'rakenteell' columns respectively.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
