Historical Version Records of Base Table Rows: A Component of Norrbotten Dataset Collection
The table in question is a historical data collection, found within the 'norrbotten' dataset. It serves as a comprehensive record of the version history of its base table rows. This aspect of the table is showcased through two additional columns that record the start and end dates of each row's extraction from the data source. A unique identifier for each row is generated through a combination of its start date and its row number.
This table also includes a geographic component. The geographic data is stored in shapefile format, a widely used format for storing the geometric location and attribute information of geographic features. The geographic features in this dataset can be points, lines, or polygons (areas). This data has been transformed from its original shapefile format into the final geographic format.
The table's data is sourced from the 'Lantmäteriet' website, based in Sweden.
From a data analytics perspective, this table could be used in a variety of ways. For example, its temporal data could be utilized to track changes in the dataset over time, providing valuable insights into trends and patterns. The geographic data, meanwhile, could be used in spatial analysis, contributing to studies in fields like environmental science, urban planning, or transportation logistics. Furthermore, the unique identifiers for each row allow for precise tracking and analysis of specific data points across different versions.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains 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 | 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 shows the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in conjunction with '_start_date'. |
OBJECTID | long | This column contains the identification number of the object. |
ID | string | This column contains the identification number. |
CODE_12 | string | This column contains a 12-digit code associated with the data. |
Area_Ha | double | This column represents the area of the object in hectares. |
Remark | string | This column contains any remarks or comments related to the data. |
Shape_Leng | double | This column contains the length of the shape. |
Shape_Area | double | This column contains the area of the shape. |
geom_geojson | string | This column contains the geometric data of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric data of the object in text format. |
geom_type | string | This column specifies the type of the geometric shape of the object. |
geom_centroid | string | This column contains the centroid of the geometric shape of the object. |
geom_center_x | double | This column contains the X coordinate of the geometric center of the object. |
geom_center_y | double | This column contains the Y coordinate of the geometric center 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 | 5716f094-ab1f-4c63-9141-72eb245f56cb |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 33 |
Revision id | b9d197ff-bd1f-447d-826b-a48e37c56b75 |
State | active |
Table | norrbotten_zip__clc12_74i_no__history |