2007 Crime Scene Dataset Table with Geolocation and Detailed Information
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_date | date | This 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_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 is one of the columns that uniquely identifies each row. |
NAMN | string | This column contains the name associated with the row. |
TATORT | string | This column contains the crime scene information. |
KOMKOD | string | This column contains the municipality code. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column describes the type of geometry used. |
geom_centroid | string | This column contains the coordinates of the centroid of the geometric shape. |
geom_center_x | double | This column contains the X coordinate of the center of the geometric shape. |
geom_center_y | double | This 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 | |
Adapter | shapefile |
Country | se |
Database | se_lantmateriet |
Extract date | 2024-08-26 |
Id | 6f25ed3d-a233-4070-8c56-a1841eae6108 |
Package id | da4cb26e-c8aa-41c7-b294-1b0bf0131233 |
Revision id | 94a407d5-b69f-4405-921d-c6546eee8a7d |
State | active |
Table | utfall_ortofoto_tatort_from2006_shape_zip__tatort2007_omr |