Version History Details of Base Table Rows in Jonkoping Dataset Collection
The table in question holds a collection of historical data, maintaining a version history of its base table rows. This enables tracking the changes over time for each row. Essential elements such as the unique row number and start date form a combination that distinctly identifies each row in the version history. This table also records the dates of extraction and updates for each row, with the most recent version indicated by a null end date.
The data in this table is geographic in nature, originally in shapefile format, which has been transformed into the final geographic format. This geographic information presents the geometric location and attribute data of geographic features, which can be points, lines, or polygons.
Sourced from the 'Lantmäteriet' website in Sweden, this dataset provides a rich source of information for various analytical purposes. For instance, one could track the evolution of geographic features over time, study the patterns of change, or even forecast future changes based on historical data. Comparing different versions of the same row could reveal trends or anomalies, providing valuable insights for decision-making in areas such as urban planning, environmental conservation, and resource allocation.
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 the '_row_number' column, 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 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 identifier for each row in conjunction with the '_start_date' column. |
| OBJECTID | long | This column serves as an object identifier. The specific function of this column may vary depending on the context of the table. |
| ID | string | This column typically contains a unique identifier for each row or object in the table. |
| CODE_12 | string | This column likely contains specific codes or identifiers related to the data. The exact meaning of these codes may be contingent on the context of the dataset. |
| Area_Ha | double | This column contains area measurements, likely in hectares (Ha). The specific areas these measurements represent would be context-dependent. |
| Remark | string | This column is likely to contain additional comments or notes related to each row or object in the table. |
| Shape_Leng | double | This column probably contains the lengths of various shapes, potentially related to geographic or spatial data. The specific interpretation of these lengths would depend on the context. |
| Shape_Area | double | This column likely contains measurements of the areas of various shapes, possibly related to geographic or spatial data. The specific areas these measurements represent would be context-dependent. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, a common format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data in text format. The specific format and interpretation of this data would depend on the context of the dataset. |
| geom_type | string | This column specifies the type of geometric data stored in the row. The type could refer to various forms of geometric shapes or structures. |
| geom_centroid | string | This column contains the centroid of the geometric shape represented in the row. A centroid is the center point of a geometric shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape represented in the row. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape represented in the row. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 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 | bb9c7995-3dfb-4e29-85c5-54e7325c498e |
| Package id | 1453d6cd-4a88-47c4-a433-b16478346411 |
| Position | 9 |
| Revision id | 1528d7a4-a7ce-4528-9d54-effb134e7266 |
| State | active |
| Table | jonkoping_zip__clc12_63e_nv__history |