Historical Version Record of Crime Scene Locations from 2006 Onwards
The 'tatort2012_omr__history' table is a historical dataset that provides a versioned record of its base data. Each row in this table is uniquely identified by a combination of the start date of the data extraction and the row number from the raw data source. The table consists of two additional columns compared to its base table, representing the start and end dates of each row's lifespan. If the end date of a row is not present, it signifies that the data row is the most recent version.
The table includes geographic information, transformed from the shapefile format, a standard used for storing geographical location and attribute information. This information can be represented in various formats such as points, lines, or polygons (areas).
This data is sourced from the 'Lantmäteriet' (The Land Survey) website, located in Sweden.
The table can be a valuable asset for various data analytics applications. For example, the version history can be used to track changes in geographic feature attributes over time, providing insights into spatial trends and patterns. The geographic information could also be used in environmental studies for habitat mapping or land use planning. Moreover, the unique identifiers of each row can assist in maintaining data integrity and accuracy across different versions, supporting rigorous data management processes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. This column, in combination with '_row_number', 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. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in this version history table. |
| NAMN | string | This column contains the name associated with each row of data. |
| TATORT | string | This column contains information related to the site of the data source. |
| KOMKOD | string | This column contains the code associated with each row of data. |
| geom_geojson | string | This column contains the geographical data of the row in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains the geographical data of the row in a text format. |
| geom_type | string | This column contains information about the type of geographical data represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid or geometric center point of the geographical data. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographical data. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographical data. |
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 | 9384318f-f5ae-44d9-a411-d51b5ceb676f |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 9 |
| Revision id | 4df4e33e-e3e0-49f7-a821-f5979f5297c1 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2012_omr__history |