Historical Version Records of Base Table Rows in Crime Scene Dataset Collection from 2006
The 'tatort2010_omr__history' table is a historical record of its base table, containing comprehensive version history of its rows. This table belongs to the dataset collection 'utfall_ortofoto_tatort_from2006_shape'. The table is unique in that it includes additional columns compared to its base table, specifically columns that contain the start and end dates of when each row was extracted from the data source. Each row in the table can be uniquely identified by a combination of its start date and row number.
The table also contains geographical information, which has been converted from the shapefile format. This format is a standard for storing geographical location and attribute information of geographic features, and can represent these features as points, lines, or polygons.
The data for this table is sourced from the website of Lantmäteriet (The Land Survey) in Sweden.
In terms of data analytics, this table can be quite versatile. For instance, it could be used to track changes in geographical data over time, allowing for the analysis of trends and patterns. Alternatively, it could be used to verify the accuracy of other data sources, by comparing their data against the version history stored in this table. Additionally, the geographical information could be used in a range of spatial analytics applications, such as determining proximity between different geographical features.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when each row was extracted from the data source. It forms part of a unique identifier for each row in the version history, along with '_row_number'. |
| _end_date | date | This column contains the date when a new version of each 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 each row in the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| NAMN | string | This column contains the name associated with each row in the data. |
| TATORT | string | This column contains the location information associated with each row in the data. |
| KOMKOD | string | This column contains the community code associated with each row in the data. |
| geom_geojson | string | This column contains the geographic data for each row in GeoJSON format. |
| geom_geotext | string | This column contains the geographic data for each row in text format. |
| geom_type | string | This column identifies the type of the geographic data associated with each row. |
| geom_centroid | string | This column contains the centroid of the geographic data associated with each row. |
| geom_center_x | double | This column contains the x-coordinate of the geographic data center for each row. |
| geom_center_y | double | This column contains the y-coordinate of the geographic data center for each row. |
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 | 3e8e00dc-6fd5-4288-a50c-ef66e59fd7a0 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 20 |
| Revision id | 6c31dbb1-caea-43fb-b323-273cba3f939e |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2010_omr__history |