Version History Table of Base Rows for Historical Analysis in Jamtland Collection
The table in question is a history table, sourced from the Swedish website 'Lantmäteriet'. It provides an organized and detailed record of the version history of its base table rows, allowing for efficient tracking of changes over time.
The table includes a unique combination of specific date and row number to accurately identify each row in the version history. It also contains two additional columns to the base table, detailing the start and end dates for when the row was extracted from the data source. If the end date appears as null, it simply suggests that the row is the most recent version.
Furthermore, this table incorporates geographic information, transformed from the shapefile format, a common format for storing the geometric location and attribute information of geographic features.
This data table can prove to be a valuable asset in data analytics. For instance, it could be utilized to analyze changes in geographic features over time, providing valuable insights into environmental trends or urban development patterns. Additionally, its unique identification of rows can support in-depth auditing or tracing of data extraction processes, allowing for enhanced quality control and data integrity assurance.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. It is part of the unique identifier for 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 is null, it indicates 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. It forms part of the unique identifier for each row in conjunction with the _start_date. |
| OBJECTID | long | A unique identifier for the object in the table. |
| ID | string | An identifier for the data entry. |
| CODE_12 | string | A code associated with the data entry. |
| Area_Ha | double | The area of the object, measured in hectares. |
| Remark | string | Any remarks or comments associated with the data entry. |
| 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 in text format. |
| geom_type | string | The type of the geometry of the object. |
| geom_centroid | string | The centroid of the geometry of the object. |
| geom_center_x | double | The X coordinate of the center of the geometry of the object. |
| geom_center_y | double | The Y coordinate of the center of the geometry 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 | 3f5b33f7-7fab-4302-8908-c4549ea6221d |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 14 |
| Revision id | c5f4095e-5e2e-41ca-8dcb-8e86f273d171 |
| State | active |
| Table | jamtland_zip__clc12_70f_nv__history |