Version History of Crime Scenes from 2006 in Geo-Spatial Format
The 'tatort2018_omr__history' table is a historical archive, maintaining the version history of its base table rows. Each row in this table represents a unique version of the row, identifiable by a combination of a start date and a unique row number. This set-up allows for tracking changes over time, from when the row was first extracted from the data source to when a new version of the row was extracted. If a row is the most recent version, this is indicated by a null value in the end date column.
This table also includes geographic data, which has been converted from the original shapefile format into the final geographic format. This includes geographic feature representations such as points, lines, or polygons.
Sourced from Lantmäteriet's website in Sweden, this table offers a wealth of data for various analytical purposes. For instance, one could use this data to study patterns or changes in geographic features over time, or to correlate these changes with other data points in the table. Additionally, the version history could be useful for troubleshooting or auditing purposes, as it allows for a detailed look back at the state of the data at any given 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. This, along with '_row_number', uniquely identifies each row in the 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. This, along with '_start_date', uniquely identifies each row in the version history table. |
| NAMN | string | This column contains data specific to the dataset. The data's specific nature and usage will be defined by the dataset's owner. |
| TATORT | string | This column contains data specific to the dataset. The data's specific nature and usage will be defined by the dataset's owner. |
| KOMKOD | string | This column contains data specific to the dataset. The data's specific nature and usage will be defined by the dataset's owner. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. The data represents the spatial features of the dataset. |
| geom_geotext | string | This column contains geometric data in text format. The data represents the spatial features of the dataset. |
| geom_type | string | This column contains the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the center point of the geometric shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric 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 | ec2dab2e-540e-4d31-ac50-31d3a0f50169 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 14 |
| Revision id | 894d0eec-afab-434e-bb1b-c0fbc24b5afd |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2018_omr__history |