Version History Records of Base Table in Norrbotten Dataset Collection
The table in question is a historical record from the data collection of Norrbotten. It is primarily a version history of its base table rows. This means that it keeps a track of the changes made to the base table rows over time, thus enabling users to view and analyze the evolution of data.
Each row in this table is assigned a unique identification through a combination of start date and row number. The start date indicates when the row was extracted from the data source, while the end date signifies when a new version was fetched. If the end date column is left blank, it implies that the current row is the most recent version.
In addition to the base table columns, there are two additional columns that reflect the start and end dates. This table also includes geographic data, which has been transformed from the shapefile format. Shapefile is a widely used data format for storing the location and attribute information of geographic features, which can be points, lines, or polygons.
The data for this table is derived from the website of Lantmäteriet (The National Land Survey) in Sweden. This data can prove valuable in various data analytics scenarios. For instance, it can be used to track land use changes over time, understand patterns in geographical features, or analyze the impact of policy changes on land utilization. Additionally, the version history can help in tracing errors or modifications to the original data, thus ensuring data integrity.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it implies that the row is the most recent version. |
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. It forms a unique combination with '_start_date' to identify each row in the table. |
| OBJECTID | long | This column contains unique identifiers for each object in the table. |
| ID | string | This column contains internal identification numbers for the objects. |
| CODE_12 | string | This column contains specific codes associated with the objects. |
| Area_Ha | double | This column represents the area of the objects, measured in hectares. |
| Remark | string | This column includes any additional notes or comments about the objects. |
| Shape_Leng | double | This column provides the length of the object's shape. |
| Shape_Area | double | This column indicates the area of the object's shape. |
| geom_geojson | string | This column contains the geojson geometry representation of the objects. |
| geom_geotext | string | This column includes the geotext geometry representation of the objects. |
| geom_type | string | This column identifies the type of geometry of the objects. |
| geom_centroid | string | This column contains the centroid of the geometry of the objects. |
| geom_center_x | double | This column provides the x-coordinate of the center of the object's geometry. |
| geom_center_y | double | This column provides the y-coordinate of the center of the object's geometry. |
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 | 92075d73-9014-4490-b3fc-5c12e43be644 |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 21 |
| Revision id | 5a59156f-6058-4c63-b040-c48c02bad9b9 |
| State | active |
| Table | norrbotten_zip__clc12_72i_nv__history |