Version History Records of Base Table Rows in Kalmar Collection
The 'clc12_62f_nv__history' table is a historical data table, part of the 'kalmar' dataset collection, offering a version history of its base table rows. Each row in this table is unique, identified by a combination of the start date of data extraction and the row number from the raw data. This ensures an accurate record of changes over time. It chronicles the period from the date the row was first extracted from the data source, up until when a new version was extracted, represented by start and end dates. When the end date is null, it signifies that the row is the most recent version.
The table also contains geographical information, which originates from a shapefile format and has been transformed into the final geographic format. This geographic data can be represented by points, lines, or polygons.
The table has been sourced from the 'Lantmäteriet' website, located in Sweden.
In terms of data analytics, this table can be used in various ways. For instance, analysts can track changes in geographical features over time, using the version history. This could be valuable in environmental studies, where changes in land use or habitat could be monitored. Additionally, the data could be used in urban planning, where changes in land allocation could be studied over time. Furthermore, the geographical data could be used to create detailed maps or to conduct spatial analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the respective row was extracted from the data source. It is part of a unique identifier for each row in this version history table, in combination with the '_row_number' column. |
| _end_date | date | This column logs the date when a new version of the respective row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It forms a part of the unique identifier for each row in the table, in combination with the '_start_date' column. |
| OBJECTID | long | This column is likely to contain the unique identifier for each object in the dataset. |
| ID | string | This column is likely to contain an additional identification value for each row in the table. |
| CODE_12 | string | The purpose of this column is not fully clear without additional context, but it likely contains some form of classification or coding related to the data. |
| Area_Ha | double | This column presumably contains the area of an object or region, likely measured in hectares. |
| Remark | string | This column probably contains additional notes or comments related to the respective row. |
| Shape_Leng | double | This column probably records the length of the boundary of a geographical shape or area. |
| Shape_Area | double | This column is likely to contain the area of a geographical shape, probably in a specific unit of measurement. |
| geom_geojson | string | This column likely contains geographical data in the GeoJSON format, a common open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column may contain geographical data in a text format. |
| geom_type | string | This column presumably identifies the type of the geographical object or shape, such as 'polygon' or 'point'. |
| geom_centroid | string | This column probably refers to the geographical coordinates of the centroid, or geometric center, of a shape or object. |
| geom_center_x | double | This column likely represents the X coordinate of the center of a geographical object or shape. |
| geom_center_y | double | This column likely represents the Y coordinate of the center of a geographical object or shape. |
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 | cf6c9f92-86db-4b37-89b3-5e3ef3191c75 |
| Package id | 920fd79a-aa00-4de6-a177-f311300c82c6 |
| Position | 9 |
| Revision id | 4764a424-6404-45cd-8787-1a46d35245f2 |
| State | active |
| Table | kalmar_zip__clc12_62f_nv__history |