History Version Records of Base Table Rows in Norrbotten Dataset Collection
The table in question is a historical record that is part of a larger dataset collection. It captures the version history of its base table rows, allowing for tracking of changes over time. Each row in the table is uniquely identified by a combination of the extraction date and the row number in the original raw data. This table has two additional columns compared to its base table which capture the start and end dates of each entry. If the end date is null, it signifies that the entry is the most recent version. The table also incorporates geographic information that has been transformed from the original shapefile format. The shapefile is a geospatial vector data format for geographic information system (GIS) software and it can represent geographic features as points, lines, or polygons. This table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey).
This data could be utilized in a variety of ways in data analytics. For instance, the chronological data can be used to analyze trends over time or to track changes in geographic features. The geographic data can be utilized in spatial analysis or GIS applications, such as mapping changes in land usage or identifying patterns in geographic distribution. Additionally, the version history can be used in data quality management, by enabling the tracking of changes and identification of any anomalies or inconsistencies in the data over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column represents the date when the row was extracted from the data source. It forms part of the unique identifier for each row in this version history table, along with the '_row_number' column. |
_end_date | date | This column contains 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 | This column contains the number of the row as it appears in the raw data extracted from the data source. It, along with the '_start_date' column, uniquely identifies each row in this version history table. |
OBJECTID | long | This column represents a unique identifier for each object in the table. |
ID | string | This column represents the unique ID assigned to each entry. |
CODE_12 | string | This column contains a code related to the data row. |
Area_Ha | double | This column represents the area of the data entry in hectares. |
Remark | string | This column contains any remarks or additional information related to the data row. |
Shape_Leng | double | This column represents the length of the shape related to the data entry. |
Shape_Area | double | This column represents the area of the shape related to the data entry. |
geom_geojson | string | This column contains the geographical data of the entry in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the entry in text format. |
geom_type | string | This column identifies the type of geographical data represented (e.g., point, line, polygon). |
geom_centroid | string | This column contains the centroid of the geographical data. |
geom_center_x | double | This column represents the X coordinate of the center of the geographical data. |
geom_center_y | double | This column represents the Y coordinate of the center of the geographical data. |
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 | 15943994-5134-4864-828f-6a6281c66bfc |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 47 |
Revision id | f219d9c3-bad3-4002-b654-6a92d6d7d974 |
State | active |
Table | norrbotten_zip__clc12_75f_so__history |