Version History of Base Table Rows in Crime Scene Dataset from 2006 Shape Collection
Click here for a data sample
The table 'tatort2007_omr__history' is a historical record of related data points, sourced from Lantmäteriet's (The Swedish Land Survey) website in Sweden. As a history table, it provides a version history of its base table rows, allowing users to track the changes in data over time. The unique identifiers for each row in this table are a combination of the date the row was extracted from the source and the row number. This allows for precise tracking of data versions. If a row is the most recent version, its end date remains null. This table has two additional columns compared to its base table, specifically for tracking the start and end dates of each data row. The geographic data in this table has been transformed from the shapefile format, a common format for storing geographic location and attribute information. The transformation allows for more streamlined data analysis. This table can be utilized in a variety of data analytics applications. For instance, it could be used to analyze trends over time, such as changes in geographic features or attributes. Additionally, it could be used to cross-reference and verify the accuracy of other data sets, or to track the evolution of specific data rows.
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 part of the unique identifier of each row in this version history table. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column holds the number of the row in the raw data extracted from the data source. It forms a unique combination with the '_start_date' to uniquely identify each row in this version history table. |
|---|
| NAMN | string | This column contains specific data related to the dataset. The exact nature of this data depends on the dataset and the data source. |
|---|
| TATORT | string | This column contains specific data related to the dataset. The exact nature of this data depends on the dataset and the data source. |
|---|
| KOMKOD | string | This column contains specific data related to the dataset. The exact nature of this data depends on the dataset and the data source. |
|---|
| geom_geojson | string | This column contains geometric data in the format of GeoJSON, an open standard format for encoding collections of simple geographical features. |
|---|
| geom_geotext | string | This column includes geometric data in a text format. The exact nature of this text representation depends on the data source and the type of geometric data. |
|---|
| geom_type | string | This column defines the type of geometric data that is stored in the row. This could be points, lines, polygons or other types of geometric constructs. |
|---|
| geom_centroid | string | This column holds the geometric center or centroid of the geometric data. It is calculated based on the geometric data in the row. |
|---|
| geom_center_x | double | This column holds the x-coordinate of the geometric center or centroid of the geometric data. |
|---|
| geom_center_y | double | This column holds the y-coordinate of the geometric center or centroid of the geometric data. |
|---|
