Version History of Base Table Rows in Varmland Dataset
The table under discussion is a historical record, sourced from the website of Lantmäteriet (The Land Surveying Department) in Sweden. It keeps track of the version history of its base table rows, which is particularly useful for understanding the temporal changes in the data. Each row in the table can be uniquely identified by a specific combination of the date when the row was extracted from the data source and the number of the row in the raw data. The table also records the date when a new version of the row was extracted. If this date is not available, it indicates that the row is the most current version.
The table also includes geographic information, transformed from the shapefile format. Shapefile is a standard format for storing geometric location and attribute information of geographic features, represented by points, lines, or polygons. The geographic data in this table has been converted into a final geographic format from the original shapefile format.
In terms of data analytics, this table can be used in various ways. For example, the temporal data can be used to track changes over time in the geographic features represented in the table, such as monitoring land use changes, urban development, or environmental changes. The geographic data can also be used in spatial analysis, for instance, to identify patterns or trends in the location and shape of geographic features. Additionally, the version history data can be used to validate and verify previous data analyses. This can ensure the accuracy and reliability of the results.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | The date when the row was extracted from the data source, forming a unique combination with '_row_number' to identify 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. A null value indicates that the row is the latest version. |
_row_number | long | The number of the row in the raw data extracted from the data source. It is combined with '_start_date' to uniquely identify each row in this version history table. |
OBJECTID | long | The unique identifier of the object within the table. |
ID | string | The unique identification number assigned to each row. |
CODE_12 | string | The code associated with the data in the row. |
Area_Ha | double | The area of the geographical object represented in the row, measured in hectares. |
Remark | string | Any additional comments or notes associated with the row. |
Shape_Leng | double | The length of the geographical object represented in the row. |
Shape_Area | double | The area of the geographical object represented in the row. |
geom_geojson | string | The geometric representation of the object in GeoJSON format. |
geom_geotext | string | The geometric representation of the object in text format. |
geom_type | string | The type of geometric shape that represents the object. |
geom_centroid | string | The center point of the geometric shape that represents the object. |
geom_center_x | double | The X coordinate of the center point of the geometric shape. |
geom_center_y | double | The Y coordinate of the center point of the geometric shape. |
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 | f84365e8-8d06-4e64-b89b-0b24b0409ed7 |
Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
Position | 3 |
Revision id | f6a23e07-1760-43dd-8f76-9fd745037210 |
State | active |
Table | varmland_zip__clc12_65e_so__history |