Version History of Base Table Rows in the Dataset Collection from Sweden
This table resides within a larger dataset collection, exploring a rich history of data revisions. It provides a comprehensive version history of the base table's rows, each uniquely identified by a combination of a start date and a row number. This identification system helps users track the evolution of data over time, from the date it was initially extracted from the source until the creation of its latest version. If a row has a null end date, it implies that the data is the most current version.
The table's content has a geographical focus, originally sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The dataset's geographical information, initially in shapefile format, has been transformed into a final geographic format. Shapefiles help to store the geometric location and attribute information of geographical features, which can be represented as points, lines, or polygons.
The data in this table has a vast range of analytical possibilities. For example, it can be used to analyze spatial patterns over time, providing insights into geographical changes and trends. In environmental studies, it can assist in tracking land use changes. In infrastructure planning, the data can inform about historical developments, helping to predict future trends. Moreover, the version history can be used for auditing purposes or quality control, ensuring the data's integrity over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Along with '_row_number', it uniquely identifies each row in the history version of the 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 in this column is null, it indicates 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. It is used in combination with '_start_date' to uniquely identify each row in the history version of the table. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains an identification number for each entry in the table. |
CODE_12 | string | This column contains specific codes associated with each row in the table. |
Area_Ha | double | This column represents the area (in hectares) associated with each row. |
Remark | string | This column contains any additional remarks or notes pertaining to each row in the table. |
Shape_Leng | double | This column represents the length of the shape associated with each row. |
Shape_Area | double | This column represents the area of the shape associated with each row. |
geom_geojson | string | This column contains the geometric representation of each row in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of each row in textual format. |
geom_type | string | This column indicates the type of geometry used to represent each row. |
geom_centroid | string | This column contains the centroid of the geometry associated with each row. |
geom_center_x | double | This column contains the X coordinate of the center of the geometry associated with each row. |
geom_center_y | double | This column contains the Y coordinate of the center of the geometry associated with each row. |
No sample for this dataset
Additional Information
Last updated | August 26, 2024 |
---|---|
Created | August 26, 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 | 53793549-484a-4451-bfbe-df07ff266dc8 |
Package id | c81a4f51-7faf-4d3d-8134-cd94ab4567c2 |
Position | 3 |
Revision id | 866aa2dc-48bd-42fa-8b57-46b77b01fbba |
State | active |
Table | blekinge_zip__clc12_62e_no__history |