Seal Islets History
Click here for a data sample
The 'lukeseal_isletsseal_isletshistory' table contains the version history of the 'lukeseal_islets__seal_islets' table. It tracks changes to the rows of the base table by including two additional columns: '_start_date' and '_end_date'. The '_start_date' column represents the date when a specific version of a row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. This table can be utilized in data analytics to analyze the evolution of seal islets over time, track changes in their geographic locations, or study trends in their characteristics. The data in this table is sourced from the website of 'Metsantutkimuslaitos', which originates from the country with the ISO country code 'fi' (Finland).
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 sequential number assigned to each row version. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in geotext format. |
|---|
| geom_type | string | The type of geometry stored in the row version. |
|---|
| geom_centroid | string | The centroid of the geometry in the row version. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry in the row version. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry in the row version. |
|---|
| geom | binary | The geometry in the row version. |
|---|
