Green Areas: Information about Green Points in Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
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, width, and surface area of viherosat points, studying the different types of materials and structures used, understanding the maintenance levels and practices, and examining the geographical location and coordinates of the viherosat.
Field Descriptions
Name |
Data type |
Description |
_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 |