Open Urban Data Map Land Use Green Areas - History
Click here for a data sample
This table contains the version history of rows from the 'avoindataseutukartta_maankaytto_viheralueet__seutukartta_maankaytto_viheralueetpolygon' base table. Each row in this table represents a specific version of a row from the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table provides valuable information for data analytics tasks. For example, it can be used to analyze changes in land use ('maankaytto') and its corresponding master group ('mtryhm') over time. With the 'geom_geojson' column, the geographic features of the green areas can be visualized and analyzed. The 'geom_type' column provides information about the type of geometry used to represent the geographic features. The 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns provide geometric information about the center point of each feature. The 'geom' column stores the complete geometry of each feature. The 'tietopalve' column might be useful for discovering additional data service endpoints related to the green areas. This table is sourced from the website of Helsinki City Environment Sector ('Helsingin kaupunkiympariston toimiala') and originates from Finland (iso country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _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 indicating the position of the row version. |
|---|
| maankaytto | string | The land use associated with the row version. |
|---|
| mtryhm | int | The land use group associated with the row version. |
|---|
| geom_geojson | string | The geometric representation of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometric representation of the row version in plain text format. |
|---|
| geom_type | string | The type of geometry represented by the row version. |
|---|
| geom_centroid | string | The centroid of the geometry represented by the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry represented by the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry represented by the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
| tietopalve | int | The data serving status of the row version. |
|---|
