Version History of Base Table Rows as Part of Uppsala Dataset Collection Sourced from Swedish Website
Click here for a data sample
The 'clc12_66g_so__history' is a historical data table that is part of the 'uppsala' dataset collection. This table stands out for its purpose of storing the version history of its base table rows, providing a timeline of changes to the data. Key features of this table include a unique identifier for each row, which is a combination of the date the data was extracted and the row number. This allows for effective tracking of data changes over time. A particularly interesting aspect of this table is the presence of start and end dates for each row. The start date indicates when the data was extracted while the end date signifies when a new version of the data was pulled. If the end date is null, this signifies that the current version of the data is the most recent. The table also contains geographical data, transformed from a shapefile format, which can be represented as points, lines, or polygons. As for its source, this table originates from the website of 'Lantmäteriet' (The Land Survey) in Sweden. In terms of data analytics, the table can serve multiple purposes. For example, the version history can be used to analyze trends over time, the geographical data can be utilized for spatial analysis or mapping, and the unique identifiers can facilitate data integrity checks and cleaning.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column records the date when each specific row was extracted from the data source. In conjunction with '_row_number', it uniquely identifies each row. |
|---|
| _end_date | date | This column holds the date when a new version of the row was extracted from the source. If this column is null, the row is the most current version. |
|---|
| _row_number | long | This column contains the row number from the raw data extracted from the source. It works with '_start_date' to uniquely identify each row. |
|---|
| OBJECTID | long | A column that likely contains a unique identifier for each object or entry within the table. |
|---|
| ID | string | This column typically holds an identification number or code for the records in the table. |
|---|
| CODE_12 | string | This column likely contains specific codes related to the data in the table. |
|---|
| Area_Ha | double | This column probably carries data relevant to a certain area, potentially measured in hectares. |
|---|
| Remark | string | This column potentially includes any additional comments, notes, or observations about the records. |
|---|
| Shape_Leng | double | This column likely contains data related to the length of a shape, presumably related to geographic features. |
|---|
| Shape_Area | double | This column likely holds data related to the area of a shape, presumably related to geographic features. |
|---|
| geom_geojson | string | This column likely contains geographic data in the GeoJSON format. |
|---|
| geom_geotext | string | This column likely contains geographic data in text format. |
|---|
| geom_type | string | This column likely describes the type of geometric data represented (e.g., point, line, polygon). |
|---|
| geom_centroid | string | This column presumably contains the centroid (geographic center) of a geometric feature. |
|---|
| geom_center_x | double | This column likely represents the x-coordinate of the geometric feature's center. |
|---|
| geom_center_y | double | This column likely represents the y-coordinate of the geometric feature's center. |
|---|
