Version History of Base Table Rows from a Swedish Dataset Collection
The table in question is a historical record, maintaining the version history of its base table rows. This means it contains two additional columns, which hold the start and end dates for when each row was extracted from the data source. If the end date for a row is null, it signifies that the current row is the most recent version. A unique identifier for each row in this version history table is formed by the combination of the start date and the row number.
The table provides geographical information, initially in shapefile format, which has been transformed into the final geographic format. Shapefiles are a simple way of storing the geometric location and attribute information of geographical features, which could be represented by points, lines, or polygons.
This table is sourced from the website of 'Lantmäteriet' (The Swedish National Land Survey) in Sweden.
The data in this table can be utilized in numerous ways in the field of data analytics. For example, it can be used to track changes in geographical features over time by comparing different versions of the same row. It can also be used in spatial analytics to analyze geographical patterns and trends. Furthermore, the start and end dates for each row can provide insight into the frequency of data updates from the source, which could be valuable in planning data collection strategies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it forms a 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. Along with '_start_date', it serves as a unique identifier for each row in the version history table. |
| OBJECTID | long | A unique identifier for each object within the dataset. |
| ID | string | A unique identifier for each entry in the dataset. |
| CODE_12 | string | A specific code associated with the data entry, used for classification or categorization purposes. |
| Area_Ha | double | The area, in hectares, associated with the data entry. |
| Remark | string | A column provided for any additional notes or comments related to the data entry. |
| Shape_Leng | double | The length of the shape associated with the data entry. |
| Shape_Area | double | The area of the shape associated with the data entry. |
| geom_geojson | string | The geometric representation of the data entry in GeoJSON format. |
| geom_geotext | string | A text-based geometric representation of the data entry. |
| geom_type | string | The type of geometry associated with the data entry, such as 'Point', 'LineString', or 'Polygon'. |
| geom_centroid | string | The central point of the geometric shape associated with the data entry. |
| geom_center_x | double | The x-coordinate of the geometric shape's center. |
| geom_center_y | double | The y-coordinate of the geometric shape's center. |
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 | 40bec637-5f00-482d-a190-ac3f346b2281 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 23 |
| Revision id | a7927d45-69f7-42e7-858f-9308a9ee6f19 |
| State | active |
| Table | vasterbotten_zip__clc12_71f_nv__history |