2011 Crime Scene Data Overview
The table under consideration is a rich collection of geographic data, obtained from the 'Lantmäteriet' website, a Swedish authority responsible for land and geographic information in Sweden. It features a wide array of columns that store various types of data, each with its unique purpose and significance.
The table includes a special pair of columns that together form a unique identifier for each row. One of these columns contains the date when the data was extracted, and the other stores the row number in the data extracted on that date. This combination provides a reliable way to identify each entry in the table uniquely.
The table also contains a wealth of geographic data translated from the shapefile format, a popular geospatial vector data format for geographic information system (GIS) software. This geographic data can be points, lines, or polygons representing different geographic features.
This table's data can be extremely useful in various data analytics scenarios. For instance, one could analyze the geographic data to understand patterns and trends in land usage over time, or study the relationship between different geographic features. The extraction dates could be used to track changes in the data over time, enabling analysts to identify trends and anomalies. Furthermore, the unique identifiers can be used in data cleaning and preparation processes, ensuring accuracy and consistency of the resulting analyses.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | The date when the data in the row was extracted from the data source. |
_row_number | long | The row number in the data extracted from the source on the date specified by _extract_date. This, combined with _extract_date, uniquely identifies each row. |
NAMN | string | The name associated with the data entry. |
TATORT | string | The specific location or place related to the data entry. |
KOMKOD | string | The code associated with a specific community or region related to the data entry. |
geom_geojson | string | The geographical data of the location in GeoJSON format. |
geom_geotext | string | The geographical data of the location in textual format. |
geom_type | string | The type of geographical data, for example point, line, polygon, etc. |
geom_centroid | string | The centroid or geometric center of the geographical data. |
geom_center_x | double | The X-coordinate of the center of the geographical data. |
geom_center_y | double | 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 | fade584e-f5c3-4770-be63-5709e89cbe27 |
Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
Position | 6 |
Revision id | 258b592c-5fb3-4435-a066-92a43352a552 |
State | active |
Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2011_omr |