Version History of Base Table Rows in Sodermanland Dataset Collection
The table is a history table that forms an integral part of a larger dataset collection. It is responsible for tracking the version history of its base table rows, representing a dynamic record of changes over time. Each row in the table is uniquely identified by a combination of its extraction date and its original row number from the raw data. This table also includes start and end dates for each row version, giving a clear timeline of changes. If a row's end date is null, this indicates that it's the most recent version. The table was sourced from Lantmäteriet's website, located in Sweden.
The table is enriched with a substantial amount of geographic information, which is represented in a final geographic format transformed from the original shapefile format. Shapefile is a widely used format for storing the geometric location and attribute information of geographic features, which can be points, lines, or polygons (areas).
This table can serve various purposes in data analytics. For instance, it could be used to analyze changes in geographic features over time, given its history-tracking nature and rich geographic data. It could also enable the study of patterns or anomalies in the data, possibly identifying trends or irregularities in the data source. The combination of temporal and geographic data makes this table an invaluable resource for longitudinal and spatial analyses.
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 means 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 forms a unique pair with '_start_date' for each row. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identification number assigned to each entry in the table. |
| CODE_12 | string | A specific code associated with each entry in the table. |
| Area_Ha | double | The area of the object represented by each row, measured in hectares. |
| Remark | string | A column for additional comments or notes pertaining to each entry. |
| Shape_Leng | double | The length of the shape or boundary of the object represented by each row. |
| Shape_Area | double | The area of the shape of the object represented by each row. |
| geom_geojson | string | The geometry of the object in GeoJSON format. |
| geom_geotext | string | The geometry of the object in a textual format. |
| geom_type | string | The type of the geometry of the object. |
| geom_centroid | string | The centroid or geometric center of the object. |
| geom_center_x | double | The x-coordinate of the center of the object. |
| geom_center_y | double | The y-coordinate of the center 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 | 61c7803a-4d8c-4722-a1e6-b256182d6833 |
| Package id | e88c5cab-003c-4619-92cb-135e8e103dc2 |
| Position | 7 |
| Revision id | dfab200f-9df3-4bbf-8775-602cc882e360 |
| State | active |
| Table | sodermanland_zip__clc12_65f_sv__history |