Version History of Base Table Rows for Crime Scene Data (2019) from a Swedish Geographic Dataset Collection
The table 'tatort2019_omr__history' is a history table, sourced from the website of Lantmäteriet (The Land Survey) in Sweden. This table is part of a dataset collection and features a detailed record of version history for its base table rows, enabling users to track how the data has evolved over time.
The table uniquely identifies each row with a combination of a start date and a row number, providing a precise timeline of changes for each data entry. It also includes an end date, marking when a new version of the row was extracted. If the end date is null, it signifies that the row is the most current version.
The table also contains geographic data, which has been transformed from the shapefile format. This allows for the representation of geographic features as points, lines, or polygons, providing highly detailed location and attribute information.
In data analytics, the history table could be extremely valuable. For example, it could be used to study the evolution of geographic features over time, providing insights into patterns of spatial change. Additionally, the version history could be used to validate data quality, by tracking changes and identifying any anomalies or inconsistencies. Furthermore, the geographic data could be utilized for spatial analytics, such as identifying clusters or trends in geographic distribution.
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 unique identifier in combination with the '_row_number' column 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 this column contains a null value, it 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. In combination with '_start_date', this forms a unique identifier for each row. |
| NAMN | string | This column contains data related to the name attribute of the row. The specific data it holds may vary based on the dataset. |
| TATORT | string | This column contains data related to the location attribute of the row. The specific data it holds may vary based on the dataset. |
| KOMKOD | string | This column contains data related to the code attribute of the row. The specific data it holds may vary based on the dataset. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometry of the row. |
| geom_geotext | string | This column contains the textual representation of the geometry of the row. |
| geom_type | string | This column contains data indicating the type of geometry for the row. |
| geom_centroid | string | This column contains data representing the centroid of the geometry for the row. |
| geom_center_x | double | This column contains the X-coordinate of the center point of the geometry for the row. |
| geom_center_y | double | This column contains the Y-coordinate of the center point of the geometry for 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 | 1ca47136-0912-4ace-ba00-d28d6c8eb8f0 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 24 |
| Revision id | 96c7e942-1fe0-454f-8140-e41a796580f3 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2019_omr__history |