Version History Table for Base Rows of Dataset Collection in Jamtland
The table in question is a history table that keeps track of the version history of its base table rows. It is part of a dataset collection from the Swedish website Lantmäteriet. This table is unique as it has two additional columns compared to its base table which help in tracking the row's history. One column records the date when the row was first extracted, and the other logs the date when a new version of the row was extracted. If the latter column is null, it signifies that the row is the most recent version. Also, each row is uniquely identified by a combination of the date of extraction and the row number from the raw data.
The table also contains geographic information, originally in the shapefile format, a common format for storing geometric location and attribute information of geographic features. This data has been transformed into a final geographic format for use in this dataset.
In terms of data analytics, there are many possible applications for this table. For example, analysing the changes in data over time can help identify trends or anomalies in the data, which could be crucial for decision making in various industries. The geographic information could be used in spatial analytics, such as identifying patterns or trends based on location. Furthermore, the complete version history of each row stored in this table allows for comprehensive back-testing and accuracy checks of predictive models.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, together with '_row_number', uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value of this column is null, it signifies that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in the version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identifier for each row in the table. |
| CODE_12 | string | A unique code assigned to each row. |
| Area_Ha | double | The area of the object in hectares. |
| Remark | string | Any comments or additional information related to the row. |
| Shape_Leng | double | The length of the shape of the object. |
| Shape_Area | double | The area of the shape of the object. |
| geom_geojson | string | The geometric representation of the object in GeoJson format. |
| geom_geotext | string | The geometric representation of the object as a text string. |
| geom_type | string | The type of the geometric representation of the object. |
| geom_centroid | string | The centroid of the geometric representation of the object. |
| geom_center_x | double | The x-coordinate of the center of the geometric representation of the object. |
| geom_center_y | double | The y-coordinate of the center of the geometric representation of the object. |
No sample for this dataset
Additional Information
| Last updated | August 27, 2024 |
|---|---|
| Created | August 27, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Adapter | shapefile |
| Country | se |
| Database | se_lantmateriet |
| Extract date | 2024-08-26 |
| Id | 3680fb55-8d97-47cf-936c-1dfd5335ab2b |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 34 |
| Revision id | f6bcab11-f1e2-49a0-83fc-9fef14ea305d |
| State | active |
| Table | jamtland_zip__clc12_71f_nv__history |