Version History of Base Table Rows in Swedish Dataset Collection
The 'clc12_62g_nv__history' table is a historical record of a set of geographic features, sourced from Sweden's Lantmäteriet website. This history table is part of the 'kalmar' dataset collection and it contains the version history of its base table rows.
The table is uniquely organized by a combination of the start date and the row number. The start date indicates when the row was extracted from the data source, while the row number pertains to the position of the row in the raw data. The end date is also provided, showcasing when a new version of the row was extracted. If the end date is null, it implies that the current row is the most recent version.
The table includes geographic information transformed from the shapefile format, which is a simple format for storing the geometric location and attribute information of geographic features. These features can be points, lines, or polygons.
In terms of data analytics, this historical table could be used for a variety of applications. For instance, the time series data could be used to track changes in geographic features over time, such as observing the evolution of land use patterns. Additionally, the geometric data could be employed to create detailed maps or conduct spatial analyses. Furthermore, the unique identifiers could be used to cross-reference with other tables in the 'kalmar' dataset collection, enabling more complex and layered analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies 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 of this column is null, it indicates 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 a unique identifier for each row in combination with '_start_date'. |
| OBJECTID | long | This column contains the object identifier for each row. |
| ID | string | This column contains the unique identification number for each row. |
| CODE_12 | string | This column contains a code associated with each row. |
| Area_Ha | double | This column contains the area measurement (in hectares) associated with each row. |
| Remark | string | This column contains any remarks or comments associated with each row. |
| Shape_Leng | double | This column contains the length of the shape associated with each row. |
| Shape_Area | double | This column contains the area of the shape associated with each row. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data in textual format. |
| geom_type | string | This column contains the type of geometry. |
| geom_centroid | string | This column contains the centroid (geometric center) of the shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 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 | 50d2ad2c-7e43-4880-aa14-3dd613ea0401 |
| Package id | 920fd79a-aa00-4de6-a177-f311300c82c6 |
| Position | 13 |
| Revision id | c11af78f-dcfd-4221-9ec8-065d0e2843db |
| State | active |
| Table | kalmar_zip__clc12_62g_nv__history |