Crime Scene Geospatial Data Extracted from Swedish Land Survey - 2014 Edition
The table in focus is a significant part of a dataset collection. It carries a myriad of pertinent data organized neatly in rows and columns. The table is enriched with information extracted from the Swedish website 'Lantmäteriet' (The National Land Survey of Sweden).
The table contains a mix of both typical and special columns. Two of these special columns are responsible for uniquely identifying each row. One holds the date when the data row was extracted while the other records the row number in the data extracted on the specified date.
The table also contains geographic information initially in the shapefile format. Shapefile is a popular format used to store geographical location and attribute information of geographic features such as points, lines, or polygons (areas). This geographic information has been transformed into the final geographic format for this dataset.
In terms of data analytics, this table offers a wealth of possibilities. For example, changes in geographical data over time can be analyzed by using the extraction date, providing valuable insights into spatial trends and patterns. The unique identification of each row also allows for precise tracking and analysis of specific data points. Furthermore, the geographic data can be used in spatial analysis or geostatistics, contributing to studies in fields such as environmental planning or urban development.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row. |
| NAMN | string | This column contains the name associated with the row in the database. |
| TATORT | string | This column holds information related to the crime scene. |
| KOMKOD | string | This column contains a unique code associated with the row in the database. |
| geom_geojson | string | This column contains the GeoJSON representation of the geographical data associated with the row. |
| geom_geotext | string | This column contains the textual representation of the geographical data associated with the row. |
| geom_type | string | This column specifies the type of the geographical data associated with the row. |
| geom_centroid | string | This column contains the centroid of the geographical data associated with the row. |
| geom_center_x | double | This column represents the X coordinate of the central point of the geographical data associated with the row. |
| geom_center_y | double | This column represents the Y coordinate of the central point of the geographical data associated with the 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 | 6dc4d787-780f-4b32-90db-3c436b535a97 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 15 |
| Revision id | 5ff5cd1a-b4ce-48fd-bfe5-79ac779a0afa |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2014_omr |