Version History of Base Table Rows in Vasterbotten Dataset Collection
The 'clc12_71e_no__history' table forms a part of a larger dataset collection named 'vasterbotten'. This table functions as a history table, preserving the version history of its base table rows. This is reflected in the presence of two extra columns that record the '_start_date' and '_end_date' of each row, signifying when a row was extracted from the data source, and when a new version of the same row was extracted, respectively. Rows with a null value in the '_end_date' column indicate that they represent the most recent version of the row. Additionally, each row is uniquely identified by a combination of the '_start_date' and '_row_number' columns, with '_row_number' signifying the row number in the raw data sourced from the data source.
The table also holds geographic information, originally in the shapefile format, which has been transformed into its final format within this dataset. The geographic features can be represented by points, lines, or polygons (areas).
The data for this table is sourced from the 'Lantmäteriet' website, situated in Sweden.
This table is highly versatile in its application in data analytics. For instance, it can be used to track changes in geographic features over time, with the ability to specifically identify when these changes occurred. Additionally, it can be used to analyze the most current versions of the rows, providing a real-time snapshot of the dataset. The geographic information can be utilized in spatial analysis, such as assessing the proximity of features to each other, analyzing patterns and trends in geographical distribution, and even predicting future geographic changes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for 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 represents the number of the row in the raw data extracted from the data source. It forms part of the unique identifier for each row when combined with '_start_date'. |
| OBJECTID | long | This column is likely to contain a unique identifier for each object in the table. |
| ID | string | This column is likely to hold a unique identifier for each record in the table. |
| CODE_12 | string | The purpose of this column is not clearly given, but it likely contains specific codes related to the dataset records. |
| Area_Ha | double | This column probably contains data pertaining to the area of a given object, measured in hectares. |
| Remark | string | This column is likely to contain comments or additional information about the table rows. |
| Shape_Leng | double | This column likely represents the length of the shape, possibly used in geographical or spatial data. |
| Shape_Area | double | This column is likely to represent the area of the shape, often used in geographical or spatial data. |
| geom_geojson | string | This column possibly contains geographic data in the form of GeoJSON, a popular geospatial data interchange format. |
| geom_geotext | string | This column likely holds geographic data in a textual format. |
| geom_type | string | This column probably distinguishes the type of geometric data stored in the row, such as 'point', 'line', 'polygon', etc. |
| geom_centroid | string | This column likely contains the centroid (geometric center) of the shape represented in the row. |
| geom_center_x | double | This column probably represents the X coordinate of the geometric center of the shape. |
| geom_center_y | double | This column likely represents the Y coordinate of the geometric center of the shape. |
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 | 72440898-9790-4dc3-92b2-383076d7653e |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 13 |
| Revision id | de2e046c-4283-48d8-93d3-fad98810a4b9 |
| State | active |
| Table | vasterbotten_zip__clc12_71e_no__history |