2019 Crime Scene Geographical Data Analysis
The table under discussion is a part of a larger dataset collection and is sourced from the Lantmäteriet (The National Land Survey) website, based in Sweden. This table comprises a variety of data fields including unique identifiers for each row, geographic information, as well as other related attributes.
The table features two special columns that jointly provide a unique identifier for each row. One column contains the date of extraction for each data point, while the other records the row number from the original data source, corresponding to that extraction date.
Geographic data contained within the table is originally in the format of a shapefile, a commonly used format for storing location and attribute information of geographic features. This could represent points, lines, or polygons (areas). The shapefile data in this dataset has been converted into a final geographic format suitable for further analysis.
Examples of how this data could be utilized in data analytics include spatial analysis, where the geographic information could be used to identify patterns or anomalies geographically. This could be particularly useful in fields like urban planning or environmental studies. Additionally, the unique row identifiers could allow for tracking changes in the dataset over time, useful in trend analysis or predictive modeling. Finally, any additional attributes in the table could be used for a wide range of analyses, depending on the nature of the data.
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 source. |
| _row_number | long | This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row. |
| NAMN | string | This column contains data pertaining to the name. The specifics of what the name refers to are dependent on the context of the dataset. |
| TATORT | string | This column contains data relating to the crime scene. The specific nature of the crime scene information is dependent on the context of the dataset. |
| KOMKOD | string | This column holds the municipal code. The specific nature of the municipal code information is dependent on the context of the dataset. |
| geom_geojson | string | This column holds the geographic information in GeoJSON format. GeoJSON is an open standard format designed for representing simple geographical features, along with their non-spatial attributes. |
| geom_geotext | string | This column contains the geographic information in textual format. It may contain coordinates or other geographical details. |
| geom_type | string | This column specifies the type of the geographic feature. It could be information such as point, line, polygon, etc. |
| geom_centroid | string | This column contains the centroid of the geographical feature. The centroid is the geometric center, or the average position of all the points in the shape. |
| geom_center_x | double | This column contains the X coordinate of the center of the geographical feature. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical feature. |
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 | c61deb73-8b12-40e7-ae18-259b3306bf1d |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 23 |
| Revision id | 90fbb2fc-49cd-41e7-9ac0-152abeae25a8 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2019_omr |