Version History of Base Table Rows in Jamtland Dataset Collection
The 'clc12_71e_sv__history' table is a historical record of a dataset collection, sourced from the Lantmäteriet (The Land Survey) website in Sweden. It carries extensive information organized into various columns that provide a complete view of the data from its inception to its most recent version. The data in this table is unique for each version of the row, identified by a combination of the start date of extraction and the row number from the original source.
The table has two added columns compared to its base table that track the start and end dates of each row. If the end date in a row is null, it indicates that this row is the most recent version. It also carries geographic information, originally in shapefile format, which has been converted into the final geographic format in this dataset. This geographic data can represent points, lines, or polygons, providing a detailed geographical context.
The data in this table can be utilized in numerous ways in data analytics. For example, it can be used to track changes in geographic features over time, which could be valuable for environmental studies or urban planning. The version history could also be useful in audit trails or in understanding the evolution of data over time. Moreover, the geographical information can be used for spatial analysis, visualization on maps, or for creating geographic models in various domains such as logistics, real estate, or transportation.
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 unique combination with '_row_number' to identify 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 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 combination with '_start_date' to identify each row in this version history table. |
| OBJECTID | long | This column contains the object identifier. |
| ID | string | This column contains the ID of the object. |
| CODE_12 | string | This column contains the 12-digit code associated with the object. |
| Area_Ha | double | This column contains the area of the object in hectares. |
| Remark | string | This column contains any remarks or comments related to the object. |
| Shape_Leng | double | This column contains the length of the object's shape. |
| Shape_Area | double | This column contains the area of the object's shape. |
| 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 text format. |
| geom_type | string | This column contains the type of the geometric representation of the object. |
| geom_centroid | string | This column contains the centroid of the geometric representation of the object. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometric representation of the object. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometric representation 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 | fbd820bb-c58a-4673-94a9-5887288a885e |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 32 |
| Revision id | b281f357-2206-4c58-8297-2b41039285a3 |
| State | active |
| Table | jamtland_zip__clc12_71e_sv__history |