Historical Version Records of Base Table Rows for Crime Scene Data Since 2006
Click here for a data sample
The 'tatort2022_omr__history' table is a historical record of its corresponding base table. It contains a sequential record of each version of the data rows from the base table. Unique identifiers for each row are formed by a combination of the row number and the date the row was extracted. The table contains two additional columns compared to its base table to indicate the start and end dates of each row version. If the end date is null, it signifies that the row is the most recent version. The data in this table is sourced from the 'Lantmäteriet' website in Sweden. The geographic information in this table, originally in shapefile format, has been transformed into a final geographic format. Some examples of how this data could be utilized include historical analysis of geographic feature changes over time, identifying trends in the data, or validating data consistency by comparing different versions of the same row.
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 part of a unique identifier for each row in this version history table, in combination with the '_row_number' column. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value in this column is null, 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. It forms part of a unique identifier for each row in this version history table, in combination with the '_start_date' column. |
|---|
| NAMN | string | This column contains specific data related to the dataset, but without additional context, its specific content cannot be described. |
|---|
| TATORT | string | This column contains specific data related to the dataset, but without additional context, its specific content cannot be described. |
|---|
| KOMKOD | string | This column contains specific data related to the dataset, but without additional context, its specific content cannot be described. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format. |
|---|
| geom_geotext | string | This column contains geometric data in a text format. |
|---|
| geom_type | string | This column describes the type of geometric data contained in the row. |
|---|
| geom_centroid | string | This column contains the centroid, or geometric center, of the shape defined by the geometric data in the row. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the shape defined by the geometric data. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the shape defined by the geometric data. |
|---|
