Historical Versions of Sand Dunes from Finnish Geological Survey
Click here for a data sample
This table contains the version history of the 'Geologian tutkimuskeskus' dataset related to the 'hiekkasarkat' feature. It has additional columns compared to the base table, namely '_start_date' and '_end_date', which represent the extraction dates of each row. The data in this table can be utilized for various data analytics purposes. For example, it can be used to track changes in the 'luontotyyppi' (nature type) and 'aluenimi' (area name) over time. Additionally, by analyzing the 'shape_area' and 'shape_len' columns, one can gain insights into the size and perimeter of the features. The 'geom_geojson', 'geom_geotext', and 'geom' columns provide geometrical information that can be utilized for spatial analyses. By examining the 'geom_type' column, the type of geometry can be determined. Furthermore, the 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns offer information about the centroid and center coordinates of the features, which can be useful for mapping and visualization purposes. The data in this table originates from the country with the ISO code 'fi' (Finland).
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 | A sequential number assigned to each row in the table. |
|---|
| gml_id | string | The ID of the geographic markup language (GML) associated with the row. |
|---|
| objectid | int | The unique identifier for the row. |
|---|
| luontotyyppi_koodi | int | The code representing the type of nature. |
|---|
| luontotyyppi | string | The type of nature. |
|---|
| aluenimi | string | The name of the area. |
|---|
| shape_area | int | The area of the shape geometry. |
|---|
| shape_len | int | The length of the shape geometry. |
|---|
| geom_geojson | string | The geometric data represented in GeoJSON format. |
|---|
| geom_geotext | string | The geometric data represented in Geotext format. |
|---|
| geom_type | string | The type of geometric data. |
|---|
| geom_centroid | string | The centroid point 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 geometric data. |
|---|
