Sodermanland: Version History of Base Table Rows
The history table is part of a dataset from Sweden, specifically sourced from the website of Lantmäteriet (The Land Survey). It maintains the version history of its base table rows, allowing for a comprehensive understanding of how the data has evolved over time. Each row in the table is uniquely identified by a combination of the extraction date and the raw row number from the original data source. The table also includes an end date for each row, indicating when a new version of the row was extracted. If the end date for a row is null, it signifies that this row is the most recent version.
The table contains geographic information which has been transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. These features can be represented by points, lines, or polygons (areas).
In terms of data analytics, this table could be leveraged in several ways. For instance, the historical data could be utilized to analyze trends over time and make predictions about future changes. The geographic information could be used to create visual geographic representations of the data, providing spatial insights. Additionally, the version history feature of the table could be used to track data changes and analyze the rate of these changes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | 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 | 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 | 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 version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identifier for each row in the table. |
| CODE_12 | string | A specific code associated with each row. |
| Area_Ha | double | The area of the object in hectares. |
| Remark | string | Additional notes or comments associated with each row. |
| Shape_Leng | double | The length of the shape representing the object. |
| Shape_Area | double | The area of the shape representing the object. |
| geom_geojson | string | The geometry of the object in GeoJSON format. |
| geom_geotext | string | The geometry of the object in text format. |
| geom_type | string | The type of the geometry of the object. |
| geom_centroid | string | The centroid of the geometry of the object. |
| geom_center_x | double | The x-coordinate of the center of the geometry of the object. |
| geom_center_y | double | The y-coordinate of the center of the geometry of the object. |
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 | 22f6203b-6b90-43c5-9198-a3a99c45f4fc |
| Package id | e88c5cab-003c-4619-92cb-135e8e103dc2 |
| Position | 1 |
| Revision id | b51cf087-607c-4bee-8791-e142883d179f |
| State | active |
| Table | sodermanland_zip__clc12_65g_nv__history |