2009 Crime Scene Data with Geographical Details
The table under consideration is a comprehensive collection of geographically related data, sourced from the official website of Lantmäteriet, the National Land Survey of Sweden. The table comprises of various columns which contain diverse information, including the date of data extraction, the row number, name, crime scene, municipality code, and several aspects of geographic information in various formats.
Two special columns in the table, namely the date of data extraction and the row number, jointly provide a unique identifier for each row. This ensures that each piece of data can be accurately tracked and identified. The geographic data included in the table is originally in the shapefile format - a common geospatial vector data format for geographic information system software. However, it has been transformed into a more easily digestible and useable format for the purposes of this dataset.
The geographic information contained in this table could be extremely valuable in a variety of data analytics applications. For instance, it could be used in the analysis of crime rates and crime types in different geographical areas, assisting in the development of predictive policing strategies. Additionally, the municipality code can be utilized for correlating demographic information with crime rates, potentially revealing social factors influencing crime. Furthermore, the geographic columns can be used to create detailed crime maps, allowing for improved resource allocation and strategic planning for law enforcement agencies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. It forms part of the unique identifier for each row when combined with the '_row_number' column. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It forms part of the unique identifier for each row when combined with the '_extract_date' column. |
| NAMN | string | This column contains the name associated with the data row. |
| TATORT | string | This column contains information related to the crime scene. |
| KOMKOD | string | This column contains the community code associated with the data row. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. |
| geom_geotext | string | This column contains textual representation of the geographical data. |
| geom_type | string | This column indicates the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical data. |
| geom_center_x | double | This column contains the X coordinate of the center of the geographical data. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical 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 | 02e4d355-1371-42bd-bffa-a8f07c9cba6e |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 10 |
| Revision id | 3e09e04a-dc0a-4df3-9f5f-160fccee1a90 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2009_omr |