Historical Version Records of Crime Scene Area data from 2006 onwards

The 'tatort2023_omr__history' table is a historical collection of geographical data sourced from the Swedish website, Lantmäteriet. This table serves as a version history for its base table rows, documenting changes over time. It contains unique identifiers for each row, formed by the combination of the row number and the date when the row data was extracted. This allows for precise tracking and identification of each data row throughout its history. Furthermore, there are date markers indicating when a new version of a row was extracted, and if a particular row is the most recent version. The most recent versions are identified by a null value in the 'end date' column. The table also contains geographic information, formatted from the original shapefile format into a final geographic format. This geographic data includes attributes like geographic name, crime scene, municipal code, and the geographic location in various forms including geojson, geotext, type, centroid, and center coordinates. This table is an invaluable resource for data analytics, providing historical and geographic data for various uses. For example, it could be used for studying crime patterns over time in different locations, tracking changes in municipal codes, or analyzing geographical feature changes. The version history aspect of the table would allow for time-series analyses, adding a dynamic dimension to the data exploration.