2007 Crime Scene Dataset Table with Geolocation and Detailed Information

To download the data set, please sign up or log in

Click here for a data sample

The table in question is a rich dataset that includes information originally sourced from the website of Lantmäteriet (Swedish Mapping, Cadastral, and Land Registration Authority) in Sweden. It has been structured into an organized format of columns and rows, making it a valuable resource for various data analytics applications.

The table contains several interesting columns of data, including geographical information transformed from the original shapefile format. Shapefiles are a simple format for storing the geometric location and attribute information of geographic features, which can be represented by points, lines, or polygons (areas).

Two notable columns of the table are the extraction date and the row number. The extraction date indicates when the data in the particular row was sourced from the original dataset, while the row number provides a unique identifier for each row when combined with the extraction date.

Potential uses for this table in data analytics could range from tracking geographic changes over time, by comparing the geometric information across different extract dates, to analyzing patterns or trends in the data based on the unique identifiers provided by the combination of extraction date and row number. For instance, an analyst could investigate if there are any temporal patterns in the geographical features recorded in the dataset, or use the geographical information to gain insights into spatial distributions and relationships. These features make this table a very versatile tool in the hands of data analysts.

Field Descriptions

Name Data type Description
_extract_datedateThis column contains the date when the data on the row of the table was extracted from the source. It is one of the columns that uniquely identifies each row.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It is one of the columns that uniquely identifies each row.
NAMNstringThis column contains the name associated with the row.
TATORTstringThis column contains the crime scene information.
KOMKODstringThis column contains the municipality code.
geom_geojsonstringThis column contains the geometric data in GeoJSON format.
geom_geotextstringThis column contains the geometric data in text format.
geom_typestringThis column describes the type of geometry used.
geom_centroidstringThis column contains the coordinates of the centroid of the geometric shape.
geom_center_xdoubleThis column contains the X coordinate of the center of the geometric shape.
geom_center_ydoubleThis column contains the Y coordinate of the center of the geometric shape.

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
Adaptershapefile
Countryse
Databasese_lantmateriet
Extract date2024-08-26
Id6f25ed3d-a233-4070-8c56-a1841eae6108
Package idda4cb26e-c8aa-41c7-b294-1b0bf0131233
Revision id94a407d5-b69f-4405-921d-c6546eee8a7d
Stateactive
Tableutfall_ortofoto_tatort_from2006_shape_zip__tatort2007_omr