Version History of Base Table Rows in the Jamtland Dataset Collection
The 'clc12_70f_sv__history' table is a historical data record that is part of the 'jamtland' dataset collection. This particular table serves as a version history log for its base table rows. It contains unique data entries identified by a specific combination of the row's extraction date and its original row number from the source data.
Each entry in this table includes a starting date, indicating when the information was pulled from the source, and an ending date, which denotes when a new version of the same row was extracted. If the ending date is marked as null, it signifies that the current row is the most recent version available.
The table also includes geographical data, originally in shapefile format, which has been transformed into a final geographic format. These geographical features can represent points, lines, or polygons (areas), providing an array of geographical information.
This table is sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden.
Potential applications of this table in data analytics could include tracking changes in geographic features over time, analyzing trends and patterns within the data, or even predicting future changes based on historical data. For instance, one could study the evolution of land use patterns, or analyze changes to specific geographic features. Additionally, the data could be utilized in machine learning models to predict future trends or changes in the data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date at which the row was extracted from the data source. It forms a unique combination with the '_row_number' column to uniquely identify each row in this table. |
| _end_date | date | 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 | Represents the number of the row in the raw data extracted from the data source. This column is part of a unique identifier for each row in combination with the '_start_date' column. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | A unique identifier for each record in the table. |
| CODE_12 | string | A code that represents a specific attribute or characteristic of the row. |
| Area_Ha | double | The area of the geographical feature or location represented by the row, measured in hectares. |
| Remark | string | A column for additional notes or comments related to the row. |
| Shape_Leng | double | The length of the shape or geographical feature represented by the row. |
| Shape_Area | double | The area of the shape or geographical feature represented by the row. |
| geom_geojson | string | The geographical shape or feature represented by the row, stored in GeoJSON format. |
| geom_geotext | string | The textual representation of the geographical shape or feature represented by the row. |
| geom_type | string | The type of the geographical shape or feature represented by the row. |
| geom_centroid | string | The centroid or geometric center of the shape or feature represented by the row. |
| geom_center_x | double | The x-coordinate of the center of the geographical shape or feature represented by the row. |
| geom_center_y | double | The y-coordinate of the center of the geographical shape or feature represented by the row. |
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 | d30172a2-3cc1-43d9-9870-5c08e13f941c |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 16 |
| Revision id | b8fbc007-a576-4314-a92d-5d88cc7bf9d8 |
| State | active |
| Table | jamtland_zip__clc12_70f_sv__history |