Geospatial Information of Crime Scenes in Sweden from 2006
The table under consideration originates from 'Lantmäteriet' (Sweden's land surveying agency) and forms part of a larger dataset. This table is structured into several columns, each holding specific information.
Two distinctive columns in the table provide a unique identifier for each row. One column holds the date when data on that specific row was extracted from the source, and the other column stores the row number in the extracted data, corresponding to the extraction date. This combination allows each row to be uniquely identified.
The table also houses geographic information, which has been transformed from the shapefile format. This format is a simple, non-topological way of storing the geometric location and attribute information of geographic features, which can be points, lines, or polygons. The data in this table has been transformed into a final geographic format from this shapefile format.
In terms of data analytics, this table can be highly useful. For instance, the unique identifiers can help in tracking changes in the data source over time. The geographic information can also be leveraged for spatial analysis, such as identifying patterns or trends in the geographic features, or for conducting geographic segmentation. Furthermore, the combination of time-stamped data and geographic information could enable more advanced analytics, such as time series analysis of geographic data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the date specified by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
| NAMN | string | This column contains the name associated with the data point. |
| TATORT | string | This column represents the crime scene associated with the data point. |
| KOMKOD | string | This column represents the municipality code associated with the data point. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometric data. |
| geom_geotext | string | This column contains the textual representation of the geometric data. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric 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 | f61613ad-206d-4239-a64d-4aa2fb277615 |
| Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
| Position | 27 |
| Revision id | cb58390b-8119-413d-9777-4406de777720 |
| State | active |
| Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2023_omr |