Norrbotten Collection: History Version Records of Base Table Rows
The table in question is a historical table, which means it contains the version history of each row from its base table. This history is tracked through two additional columns that specify the start and end dates of each unique row version. The start date marks when the row was extracted from the data source, while the end date indicates when a new version of the same row was extracted. If the end date is null, it indicates that the row is the most recent version.
The information in this table is extracted from geographical data in the shapefile format, which is a simple non-topological format used for storing the geometric location and attribute information of geographic features. These geographic features can be represented by points, lines, or polygons (areas). The geographic information in this dataset has been transformed from the shapefile format into its final form.
This table is part of a larger dataset collection originating from the website of Lantmäteriet (the Swedish Mapping, Cadastral and Land Registration Authority) in Sweden.
The data from this table can be used in various data analytics applications. For example, one could track the changes to a specific geographic feature over time, gaining insights into patterns of geographic development or land use changes. Alternatively, the data could be used in environmental studies to monitor changes in specific areas. Furthermore, as the data is geographically oriented, it could be used in conjunction with other datasets to conduct complex spatial analyses.
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 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 is null, it denotes that the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identifier for each entry in the table. |
CODE_12 | string | A column for a specific code related to the entry. |
Area_Ha | double | This column represents the area of the entry in hectares. |
Remark | string | A column for any additional remarks or notes about the entry. |
Shape_Leng | double | This column represents the length of the shape associated with the entry. |
Shape_Area | double | This column represents the area of the shape associated with the entry. |
geom_geojson | string | This column contains the GeoJSON representation of the geometry associated with the entry. |
geom_geotext | string | This column contains a textual representation of the geometry associated with the entry. |
geom_type | string | This column specifies the type of geometry associated with the entry. |
geom_centroid | string | This column contains the centroid of the geometry associated with the entry. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with the entry. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with the entry. |
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 | 2d0fd177-6d60-473e-afcc-fb8a5c46d3fc |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 19 |
Revision id | 73e80e13-7d6b-43bc-b85b-81269dd03572 |
State | active |
Table | norrbotten_zip__clc12_73f_no__history |