Version History of Sea Area Data from Metsantutkimuslaitos in Finland
Click here for a data sample
This table contains the version history of rows from the 'seal_sea_area' table. The 'seal_sea_area__history' table is sourced from the website of 'Finnish Forest Research Institute' located in Finland. It provides information about various seal sea areas in Finland. Each row in the table represents a particular version of a seal sea area, captured at different times. The '_start_date' column indicates the date when the particular version was extracted from the data source, while the '_end_date' column represents the date when a newer version of the row was extracted. If the '_end_date' value is null, it implies that the row is the most recent version. This table could be utilized in data analytics to track the changes and updates made to seal sea areas over time, analyze the frequency of updates, identify trends in seal sea area modifications, study the spatial distribution of seal sea areas using 'geom' column which contains the geometric data, and perform historical comparisons of different versions of seal sea areas.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row version becomes valid. |
|---|
| _end_date | date | The date when the row version expires. |
|---|
| _row_number | long | A sequential number indicating the position of the row version in the version history. |
|---|
| id | int | The unique identifier of the row. |
|---|
| name | string | The name of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in geotext format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| 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 of the row in a general format. |
|---|
