Version History of Crime Scene Location Data from 2015
The table 'tatort2015_omr__history' is a historical archive that contains the version history of its base table rows. It is sourced from the website of Lantmäteriet (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. This table consists of unique identifiers for each row, extracted from the raw data, and the dates when the rows were extracted and updated. The table is especially unique in its inclusion of two additional columns for indicating the timeline of data extraction, which are not present in its base table. If a row is the most recent version, it is indicated by a null value in the 'end date' column.
The table also contains geographic information transformed from the shapefile format, a popular format for storing geographic location and attribute information. This geographic information can be represented by points, lines, or polygons, and this dataset includes the final transformed geographic format from the shapefile format.
In terms of data analytics, this table can be quite powerful. For instance, it could be used to analyze the changes in geographical features over time, by comparing the versions of rows. It can also be beneficial in studies related to land use or urban planning, as the geographic information can provide insights about the spatial characteristics of the data. Furthermore, the time-specific data allows for temporal analysis, which can be useful in observing trends or patterns over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is one of the columns that uniquely identifies each row in this 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 of 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 in the raw data extracted from the data source. It is one of the columns that uniquely identifies each row in this version history table. |
| NAMN | string | This column contains the name associated with the data row. |
| TATORT | string | This column contains specific location information. |
| KOMKOD | string | This column holds a code that is associated with the data row. |
| geom_geojson | string | This column holds geographical data in GeoJSON format. |
| geom_geotext | string | This column contains geographical data in text format. |
| geom_type | string | This column specifies the type of geographical data contained in the row. |
| geom_centroid | string | This column contains geographical data representing the centroid of the geographical object. |
| geom_center_x | double | This column holds the X-coordinate of the geographical object's center. |
| geom_center_y | double | This column holds the Y-coordinate of the geographical object's center. |
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 | f2865e16-1a22-4769-b68f-91e8c2f2770c |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 12 |
| Revision id | 1bdc1655-321f-404f-a26f-96cfe78078cb |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2015_omr__history |