Version History of 2011 Crime Scenes Area Records
The table 'tatort2011_omr__history' is a history table that houses the version history of its base table rows. This table is part of a larger dataset collection, sourced from the Swedish website 'Lantmäteriet'. It is unique in how it tracks the evolution of data over time, with each row in the table uniquely identified by a combination of a start date and a row number.
This table also has a unique feature, it contains two additional columns compared to its base table. The first is a start date column, which notes when the row was first extracted from the data source. The second is an end date column, which signifies when a new version of the row was extracted. If the end date column is null, it denotes that the current row is the most recent version.
Additionally, this table also contains geographical information. This information, originally in shapefile format - a standard for storing geographical location and attribute information, has been transformed into a final geographic format for ease of use.
Given its historical and geographic nature, this data could be utilized in various data analytics exercises. For instance, it could be used to track changes in geographical features over time, aiding in environmental studies. Furthermore, it could assist in urban planning, by providing insights into how certain areas have evolved. Lastly, it could be used in social studies to understand how changes in the environment have impacted local communities.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in the 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 in this column is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number in the raw data extracted from the data source. It forms a unique identifier for each row in conjunction with '_start_date'. |
| NAMN | string | This column contains specific names associated with the data. |
| TATORT | string | This column contains information related to a particular location. |
| KOMKOD | string | This column holds codes that are relevant to the data. |
| geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format. |
| geom_geotext | string | This column holds the geometric representation of the data as a text string. |
| geom_type | string | This column specifies the type of the geometric 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 data. |
| geom_center_y | double | This column represents the Y coordinate of the geometric center of the 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 | e67dcfd9-13bf-45b5-aec7-ec3980628a65 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 7 |
| Revision id | f2432d8c-606b-47b1-9c9a-3f9453ea42d7 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2011_omr__history |