Version History of Green Areas Polygons
Click here for a data sample
This table contains the version history of the 'seutukarttaviheralueetviheralueetpolygon' table, sourced from the website of 'Helsinki City Environment Sector'. The data originates from Finland (ISO country code 'fi'). The table includes additional columns compared to its base table, namely '_start_date' and '_end_date', which represent the extraction dates of each row. This version history table can be used for data analytics purposes, such as tracking changes over time, analyzing trends, or comparing different versions of the 'seutukarttaviheralueetviheralueetpolygon' rows.
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 or identifier of the version. |
|---|
| maankay | string | The value of the 'maankay' attribute. |
|---|
| mtryhm | int | The value of the 'mtryhm' attribute. |
|---|
| geom_geojson | string | The GeoJSON representation of the geometry. |
|---|
| geom_geotext | string | The geotext representation of the geometry. |
|---|
| geom_type | string | The type of geometry, e.g., Point, LineString, Polygon. |
|---|
| 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 itself. |
|---|
