History Version Data of Base Table Rows in Norrbotten Dataset Collection
The 'clc12_74h_sv__history' table is a historical record from the 'norrbotten' dataset collection. This table serves as a version history log for its base table rows, tracking changes over time. Every row in this table is uniquely identified by a combination of a start date and a row number, allowing for the precise tracking of each row's evolution. In addition to the base table columns, this history table includes two more columns: one indicating when the row was extracted from the data source, and another indicating when a new version of that row was extracted. If the end date is not specified, it signifies that the row is the most recent version. The table also contains geographic data transformed from the shapefile format, a common format for storing geographic location and feature information. The data source for this table is the Lantmäteriet website in Sweden.
The data from this table could be utilized in various data analytics scenarios. For instance, the temporal data can be used to track changes in geographic features over time, enabling trend analysis. The geographic information could be used in spatial analysis to identify patterns or anomalies in the data. Furthermore, the version history could be used for auditing purposes or to recover information from a specific point in time.
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 uniquely identifies 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 signifies 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 identifier for each row in conjunction with '_start_date'. |
| OBJECTID | long | This column contains a unique identifier for each object in the table. The exact nature of the objects depends on the nature of the dataset. |
| ID | string | This is another column that provides an identification number for each row in the table. |
| CODE_12 | string | This column contains specific codes associated with the rows. The nature and meaning of these codes depend on the dataset. |
| Area_Ha | double | This column represents the area of the object, measured in hectares. |
| Remark | string | This column is reserved for any additional comments or remarks regarding the row. |
| Shape_Leng | double | This column denotes the length of the shape of the object, possibly in geographical terms. |
| Shape_Area | double | This column represents the area of the shape of the object, possibly in geographical terms. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format, a type of format for encoding geographic data structures. |
| geom_geotext | string | This column contains a textual representation of the object's geometry. |
| geom_type | string | This column indicates the type of the geometric object, such as 'Point', 'LineString', 'Polygon', etc. |
| geom_centroid | string | This column contains the centroid of the geometric object. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the object. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center 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 | f2c20f7e-0f43-4642-a8ee-1dd0a72ca95b |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 35 |
| Revision id | 9e0f65e0-d0bb-4a35-bf64-1530634c2256 |
| State | active |
| Table | norrbotten_zip__clc12_74h_sv__history |