Version History of Base Table Rows in Swedish Land Survey Dataset
Click here for a data sample
The table in question is a historical record, providing a version history of the rows in its base table. The table, part of a dataset collection, is sourced from the website of Lantmäteriet (The Land Survey) in Sweden. It offers a unique view into the evolution of data over time, with each row identified by a unique combination of its start date and row number. This allows for efficient tracking of changes over time. The start date indicates when the row was extracted from the data source, while the end date signifies when a new version of the row was extracted. A null value in the end date column indicates that the row is the most recent version. The table contains additional geographic information, originally in shapefile format but transformed into a final geographic format for this dataset. This geographic information can represent points, lines, or polygons (areas), providing valuable spatial insights. In data analytics, this table could prove useful in various ways. For instance, it could be used to track changes in geographic data over time, identify trends or anomalies in the data evolution, or provide a historical context for predictive analytics. The geographic information could also be used for spatial analysis, such as identifying patterns or correlations in geographic features.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of the 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 signifies 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 forms part of the unique identifier for each row in this table. |
|---|
| OBJECTID | long | An identifier for the object represented in the row. |
|---|
| ID | string | An additional identifier for the object represented in the row. |
|---|
| CODE_12 | string | This is a code associated with the object represented in the row. |
|---|
| Area_Ha | double | This column represents the area of the object in hectares. |
|---|
| Remark | string | This column may contain additional remarks or comments about the object represented in the row. |
|---|
| Shape_Leng | double | This column contains the length of the shape of the object. |
|---|
| Shape_Area | double | This column contains the area of the shape of the object. |
|---|
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
|---|
| geom_geotext | string | This column contains the geometric representation of the object in a textual format. |
|---|
| geom_type | string | This column specifies the type of the geometry of the object. |
|---|
| geom_centroid | string | This column contains the centroid of the geometry of the object. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the object. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the object. |
|---|
