Version History of Land Use and Water Areas in the Metropolitan Area Map
Click here for a data sample
This table contains the version history of the rows in the 'avoindataseutukartta_maankaytto_ja_vesistot__seutukartta_maankaytto_ja_vesistotpolygon' table sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. 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 table can be utilized in data analytics to track changes over time, analyze historical trends, and identify patterns or anomalies in geographic features and their attributes.
Field Descriptions
| Name |
Data type |
Description |
| _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 number of the row version. |
|---|
| kohdenimi | string | The name of the destination. |
|---|
| mtryhm | int | The maintenance group of the destination. |
|---|
| geom_geojson | string | The geometry of the destination in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the destination in Geotext format. |
|---|
| geom_type | string | The type of the geometry of the destination. |
|---|
| geom_centroid | string | The centroid of the geometry of the destination. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the destination. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the destination. |
|---|
| geom | binary | The geometry of the destination. |
|---|
| tietopalve | int | Additional information about the destination. |
|---|
