History of Crime Scene Data with Geographical Attributes from 2006
The 'tatort2006_omr__history' table is a historical data repository that records the version history of its base table rows. It is a part of the 'utfall_ortofoto_tatort_from2006_shape' dataset collection. The table contains additional columns to record the start and end dates for each row entry, allowing for tracking changes over time. If an 'end date' for a particular row is not available, it signifies that the row is the most recent version.
The table also includes a unique identifier for each row, formed by a combination of the start date and the row number. The row number represents the position of the row in the raw data extracted from the data source.
One of the key features of this table is the inclusion of geographic information, which has been converted from the shapefile format. Shapefile is a common format for storing geographic features, which can be points, lines, or polygons. The geographic information in this dataset has been transformed into the final geographic format from the shapefile format.
The data for this table is extracted from the website of Lantmäteriet (The Land Survey) in Sweden.
In terms of application, the data in this table could be used in a variety of data analytics scenarios. For example, it could be used to analyze historical changes in geographic data, such as tracking the evolution of certain areas over time. It could also be used to cross-reference the version history of data with other datasets to identify patterns or anomalies. Furthermore, the geographic information could be used in spatial analysis or mapping applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the source. It contributes to a unique identifier for each row in this version history table when combined with '_row_number'. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the source. A null value indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data as it was extracted from the source. It contributes to a unique identifier for each row in this version history table when combined with '_start_date'. |
| NAMN | string | The column represents the name attribute in the data. |
| TATORT | string | This column contains information related to the location of the event. |
| KOMKOD | string | This column represents a unique code for each municipality in the data. |
| geom_geojson | string | This column contains the geometric data of the location in GeoJSON format. |
| geom_geotext | string | This column contains a textual description of the geometric data. |
| geom_type | string | This column indicates the type of geometry used to represent the location data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column represents the X coordinate of the geometric center of the location. |
| geom_center_y | double | This column represents the Y coordinate of the geometric center of the location. |
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 | 219e34b3-c8d3-4567-a2ea-e22c7944b8af |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 3 |
| Revision id | ae1589ee-f982-4d78-b94f-5a3496c688a0 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2006_omr__history |