Historical Version Records of Crime Scene Data from 2008
The 'tatort2008_omr__history' table is a historical archive that stores the version history of its base table rows. It contains unique identifiers for each row, determined by the combination of the date when the row was extracted and the row number. This allows for tracking changes to the data over time, with the start and end dates indicating the lifespan of each version of a row. If the end date is null, this indicates that the version is the most recent. This detailed versioning makes the table valuable for monitoring trends and changes over time.
The table contains geographic information, originally in the shapefile format, which has been transformed into a final geographic format. This includes geometric descriptions of geographic features, which can be represented by points, lines, or polygons. The geometric information is supplemented with attribute data.
The table is sourced from the 'Lantmäteriet' website, based in Sweden. The information in this table could be utilised in a variety of data analytics applications. For instance, it could be used to study geographic trends over time, monitor changes in the geographic features, and integrate with other data sources for comprehensive spatial analysis. Given its historical nature, it could also be useful in predictive modeling and trend forecasting, and to understand the evolution of the areas covered by the dataset.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. This, together 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 this column's value is null, it means 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 from the data source. This, in combination with '_start_date', uniquely identifies each row in the version history table. |
| NAMN | string | This column contains specific name data related to the row. |
| TATORT | string | This column contains specific location data related to the row. |
| KOMKOD | string | This column contains specific code data associated with the row. |
| geom_geojson | string | This column contains GeoJSON data representing the geometry of the location. |
| geom_geotext | string | This column contains geospatial data in text format. |
| geom_type | string | This column specifies the type of the geospatial data. |
| geom_centroid | string | This column contains the centroid of the geospatial data. |
| geom_center_x | double | This column represents the x-coordinate of the center of the geospatial data. |
| geom_center_y | double | This column represents the y-coordinate of the center of the geospatial 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 | 0ae92684-3438-4774-a8f7-90ef20677b88 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 5 |
| Revision id | 3d180cb0-db6d-41c2-b4e0-5e438d3af08a |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2008_omr__history |