Version History of Open Value Forest Sites - Polygon - Helsinki Urban Environment Sector
Click here for a data sample
This table contains the version history of the ltj_avoinarvo_metsakohteet__arvo_metsakohteetpolygon table. It includes additional columns '_start_date' and '_end_date' to indicate the start and end dates of each row's version. The data in this table is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from the country Finland (ISO country code: FI). The table provides information about various forest areas, including their identifiers, class codes, names, descriptions, surface areas, digitalization dates, editing dates, metadata, geographic coordinates (in geoJSON and geotext formats), and geometries. The data in this table can be utilized in data analytics for various purposes, such as analyzing the changes in forest areas over different versions, performing spatial analysis on the geometries, studying the distribution of forest classes, and exploring the relationships between forest attributes and other variables.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period of the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period of the row version. |
|---|
| _row_number | long | This column contains the row number of the version history entry. |
|---|
| id | int | This column stores the unique identifier of the row. |
|---|
| tunnus | string | This column stores a specific code or identifier related to the row. |
|---|
| luokkatunn | string | This column stores a code or identifier that represents the category of the row. |
|---|
| luokan_nim | string | This column stores the name associated with the category of the row. |
|---|
| nimi | string | This column stores the name associated with the row. |
|---|
| kuvaus | string | This column stores a description or additional information about the row. |
|---|
| huom | string | This column stores any additional remarks or notes related to the row. |
|---|
| digipvm | string | This column stores the digital date associated with the row. |
|---|
| pvm_editoi | string | This column stores the date when the row was last edited. |
|---|
| pinta_ala | float | This column stores the value indicating the surface area related to the row. |
|---|
| kohdetekst | string | This column stores a specific target text associated with the row. |
|---|
| metadata | string | This column stores metadata or additional information about the row. |
|---|
| geom_geojson | string | This column stores the geometrical representation of the row in the GeoJSON format. |
|---|
| geom_geotext | string | This column stores the geometrical text representation of the row. |
|---|
| geom_type | string | This column stores the type of geometry associated with the row. |
|---|
| geom_centroid | string | This column stores the centroid point of the geometry associated with the row. |
|---|
| geom_center_x | double | This column stores the x-coordinate of the center point of the geometry associated with the row. |
|---|
| geom_center_y | double | This column stores the y-coordinate of the center point of the geometry associated with the row. |
|---|
| geom | binary | This column stores the geometry associated with the row. |
|---|
