Historical Version Data of Crime Scene Area (2006 onwards)
The 'tatort2013_omr__history' table is a historical record of a dataset sourced from the website of Lantmäteriet (The Swedish Land Survey) in Sweden. This table is a part of the dataset collection, and it captures the version history of its base table rows, thus providing a rich timeline of data changes.
The table tracks the evolution of each row, with unique identifiers based on the combination of the start date and row number. This allows you to trace the version history of each row from when it was initially extracted from the data source to any subsequent updates. If a row doesn't have an end date, this indicates that it is the most recent version of that row.
This table is particularly notable for its inclusion of geographic information, originally in the shapefile format, which has been transformed into a final geographic format. This geographic data represents features such as points, lines, or polygons and can be utilized for geospatial analysis.
The data in this table can be particularly useful for a variety of data analytics scenarios. For instance, the historical data can be used to study trends over time, such as changes in geographical features. With the version history, analysts could track and analyze the changes in the data source itself, providing insights into the evolution of the dataset. Furthermore, the geographic data can be used in spatial analytics, offering valuable context for location-based studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when each row was extracted from the data source. It forms a unique identifier for each row in combination with the '_row_number' column in this version history table. |
| _end_date | date | This column contains the date when a new version of each 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 row number of the raw data as extracted from the data source. Together with the '_start_date' column, it uniquely identifies each row in the table. |
| NAMN | string | This column contains a name associated with each row of data. The specific type of name is dependent on the context of the data source. |
| TATORT | string | This column contains a location associated with each row of data. The specific type of location is dependent on the context of the data source. |
| KOMKOD | string | This column contains a code associated with each row of data. The specific type of code is dependent on the context of the data source. |
| geom_geojson | string | This column contains geometric data in the form of GeoJSON, a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data in text format. It allows for a human-readable representation of the geographic data. |
| geom_type | string | This column identifies the type of geometric data contained in each row, such as point, line, or polygon. |
| geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of each row's geographic data. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of each row's geographic 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 | bb46c0af-2d1d-42e5-a706-f26d9cf39d6f |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 22 |
| Revision id | 2001c0cc-9259-4789-a7e2-3dd1c2aca0ba |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2013_omr__history |