History of Version Changes in Land Classification Records
The table in question is a historical record that tracks the evolution of its base table over time. Each row within the table is uniquely identified by a combination of a start date and a row number, which denotes the number of the row in the raw data from the data source. The table is equipped with a start and end date for each row, indicating when the data was extracted and when a new version of the row was pulled from the source. If the end date is null, it indicates that the row is the most recent version.
Geographic information is also included in the table, originally sourced in shapefile format - a common system for storing geographic location and feature data. This information has been transformed into a final geographic format from its original shapefile state.
The data for the table comes from the Swedish website 'Lantmäteriet' (The Land Survey).
In terms of potential applications, the historical nature of the table makes it a valuable resource for tracking changes over time. For instance, analysts could use the data to monitor fluctuations in geographical features, or to assess temporal patterns or trends within the dataset. It could also be used to validate or cross-reference other data sources, enhancing the accuracy and reliability of data-driven insights.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. It is part of an unique identifier for each row in this version history table, together with '_row_number'. |
| _end_date | date | This column signifies the date when a new version of the row was extracted from the data source. A null value 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 is part of an unique identifier for each row in this version history table, together with '_start_date'. |
| OBJECTID | long | This column represents the object identifier. |
| ID | string | This column contains the unique identification for each record. |
| CODE_12 | string | This column holds specific code values related to the dataset. |
| Area_Ha | double | This column indicates the area of the geographical object represented by the row, measured in hectares. |
| Remark | string | This column contains any additional comments or remarks related to the record. |
| Shape_Leng | double | This column denotes the length of the shape of the geographical object. |
| Shape_Area | double | This column indicates the area of the shape of the geographical object. |
| geom_geojson | string | This column stores the geographical data of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data of the object in a text format. |
| geom_type | string | This column specifies the type of the geographical object (for example, point, line, polygon etc.). |
| geom_centroid | string | This column contains the centroid of the geographical object. |
| geom_center_x | double | This column indicates the x-coordinate of the center of the geographical object. |
| geom_center_y | double | This column denotes the y-coordinate of the center of the geographical 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 | 3c3d2ad5-f249-4e64-9bc5-e50a7ce313c1 |
| Package id | 75c6aab8-75b3-4d4f-8b22-3c7b3fb4eb0b |
| Position | 15 |
| Revision id | 7754f39e-69f0-46e5-a9ba-61d3d72596e4 |
| State | active |
| Table | orebro_zip__clc12_66f_sv__history |