Green Areas Dataset Collection in Helsinki, Finland
Tables
-
Green Area Polygon - Helsinki, FinlandTSV
This table contains data from the 'Helsinki City Environment Sector' website, which originates from Finland. It provides information about green areas (viheralue), parks (puistonume), park districts (puiston_ni), park names (puistonimi), addresses (osoite), city districts (kaupungino), sub-areas (osa_alue), major districts (suurpiiri), planning marks (kaavamerki), land use marks (kaavamerk0), designated usage (kayttotark), other usage (kayttotar0), owners (omistaja), rentals (vuokraus), tenants (vuokraaja), surface area (pinta_ala), last updated date (paivitetty), geographical information in GeoJSON format (geom_geojson), geographical information in Geotext format (geom_geotext), geographical information type (geom_type), centroid of geographical information (geom_centroid), x...
-
Version History of Viheralue and Ylre Viheraluepolygon RowsTSV
This table provides the version history of the base table rows for 'Helsinki Urban Environment' sourced from the country Finland. It contains information such as the start and end dates of each row version, row numbers, green area details, park names, addresses, city regions, district areas, land use designations, ownership details, rental information, surface area, update timestamps, geometry information in various formats, and centroid coordinates. The table enables data analytics by allowing analysis of changes made over time, tracking the evolution of green areas, identifying trends in land use and ownership, analyzing rental patterns, and conducting spatial analysis based on the provided geometry and centroid information.
Column Descriptions
Green Area Polygon - Helsinki, Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | A sequential number assigned to each row. |
| viheralue | int | The name of the green area. |
| puistonume | int | The name of the park. |
| puiston_ni | string | The number assigned to the park. |
| puistonimi | int | The name of the park. |
| osoite | string | The address of the park. |
| kaupungino | string | The name of the city where the park is located. |
| osa_alue | string | The area where the park is located. |
| suurpiiri | string | The larger district where the park is located. |
| kaavamerki | string | The zoning designation of the park. |
| kaavamerk0 | string | An alternate zoning designation of the park. |
| kayttotark | string | The designated use of the park. |
| kayttotar0 | int | An alternate designated use of the park. |
| omistaja | string | The owner of the park. |
| vuokraus | string | The rental status of the park. |
| vuokraaja | string | The renter of the park. |
| pinta_ala | int | The area of the park in square meters. |
| paivitetty | string | The date when the park information was last updated. |
| geom_geojson | string | The geometric representation of the park in GeoJSON format. |
| geom_geotext | string | The geometric representation of the park in Well-Known Text (WKT) format. |
| geom_type | string | The type of geometry used to represent the park. |
| geom_centroid | string | The centroid of the park geometry. |
| geom_center_x | double | The X-coordinate of the center of the park geometry. |
| geom_center_y | double | The Y-coordinate of the center of the park geometry. |
| geom | binary | The complete geometry of the park. |
Version History of Viheralue and Ylre Viheraluepolygon Rows
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period of the row version. |
| _end_date | date | The end date of the validity period of the row version. |
| _row_number | long | The row number of the version history. |
| viheralue | int | The green area related to the park. |
| puistonume | int | The park number. |
| puiston_ni | string | The park's N-I value. |
| puistonimi | int | The name of the park. |
| osoite | string | The address of the park. |
| kaupungino | string | The city or town where the park is located. |
| osa_alue | string | The sub-area where the park is located. |
| suurpiiri | string | The major district where the park is located. |
| kaavamerki | string | The zoning mark of the park. |
| kaavamerk0 | string | An additional zoning mark of the park. |
| kayttotark | string | The designated use of the park. |
| kayttotar0 | int | An additional designated use of the park. |
| omistaja | string | The owner of the park. |
| vuokraus | string | The rental status of the park. |
| vuokraaja | string | The renter of the park. |
| pinta_ala | int | The surface area of the park. |
| paivitetty | string | The last updated date of park information. |
| geom_geojson | string | The geometry of the park in GeoJSON format. |
| geom_geotext | string | The geometry of the park in Geotext format. |
| geom_type | string | The type of geometry for the park. |
| geom_centroid | string | The centroid point geometry of the park. |
| geom_center_x | double | The x-coordinate of the center point of the park. |
| geom_center_y | double | The y-coordinate of the center point of the park. |
| geom | binary | The complete geometry information of the park. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | October 22, 2018 |