Version History of Base Table Rows from a Swedish Geographic Dataset
The table in question is a part of a dataset collection and serves as a history table, keeping track of various versions of its base table rows. It provides a snapshot of the data at different points in time, allowing users to see how the data has changed over time. The table has two additional columns for this purpose, which contain the dates when a row was added and when it was updated. If the update date is null, it signifies that the current row is the most recent version.
This table is unique in that it includes geographic data transformed from the shapefile format, which includes geometric locations and attribute information of geographic features. These features can be represented by points, lines, or polygons.
The data for this table is sourced from the Lantmäteriet website, which is based in Sweden.
The information in this table could be used in a variety of data analytics scenarios. For example, one could track changes in geographic features over time, such as the expansion or reduction of specific areas. This could be particularly useful for environmental studies or urban planning. Additionally, the historical data could be used to analyze trends and make predictions about future changes. The geographic data could also be used in conjunction with other data to provide richer, more context-specific analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' that 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 of this column is null, it means that the row is the most recent version of the row. |
| _row_number | long | The column contains the number of the row in the raw data extracted from the data source. It works in combination with '_start_date' to uniquely identify each row in this version history table. |
| ID | string | This column represents the unique identifier of the row in the table. |
| CODE_06 | string | This column holds specific code values pertaining to the data row. |
| Area_Ha | double | This column contains data related to the area (in hectares) associated with the row. |
| Remark | string | This column is used to store any additional notes or remarks related to the data row. |
| Shape_Leng | double | This column contains the length of the shape associated with the data row. |
| Shape_Area | double | This column contains the area of the shape associated with the data row. |
| geom_geojson | string | This column contains the geographical data of the row in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data of the row in a text format. |
| geom_type | string | This column indicates the type of the geographical data associated with the row. |
| geom_centroid | string | This column contains the centroid of the geographical data associated with the row. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical data associated with the row. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical data associated with 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 | 83bd3d76-7025-4756-a3b5-8bb3ae7fcf1e |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 26 |
| Revision id | 408c5353-6999-4d16-9288-c10e9bacc023 |
| State | active |
| Table | jamtland_zip__06_71esv__history |