lab_point_to_polygon_and_point_to_raster
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
lab_point_to_polygon_and_point_to_raster [2019/11/05 15:11] – extern redigering 127.0.0.1 | lab_point_to_polygon_and_point_to_raster [2020/03/29 14:23] (current) – Stefan Ene | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== KG2204 Exercise 2: Point to Polygon (and more) ====== | ====== KG2204 Exercise 2: Point to Polygon (and more) ====== | ||
- | {{tag> | ||
- | ==Point to Polygon== | + | {{tag>SU analys english laboration arcgis uppbyggnad}} |
+ | |||
+ | == Point to Polygon == | ||
Copy the folder '' | Copy the folder '' | ||
Open ArcMap and add the following files: | Open ArcMap and add the following files: | ||
- | * Point data with ancient monuments (fastighetskartanVektor_FS_1302_epsg3006_point.shp) | ||
- | * Election districts in Sweden (alla_valdistrikt.shp) | ||
- | * Excel file with the population 18 years old or older for each election district (population.xls) | ||
- | * Water (fastighetskartanVektor_MV_1302_epsg3006_polygon.shp) | ||
- | * Rectangle marking the study area (Study_Area.shp) | ||
- | {{*: | + | * Point data with ancient monuments (fastighetskartanVektor_FS_1302_epsg3006_point.shp) |
+ | * Election districts in Sweden (alla_valdistrikt.shp) | ||
+ | * Excel file with the population 18 years old or older for each election district (population.xls) | ||
+ | * Water (fastighetskartanVektor_MV_1302_epsg3006_polygon.shp) | ||
+ | * Rectangle marking the study area (Study_Area.shp) | ||
+ | |||
+ | {{: | ||
+ | |||
+ | == 1. The intensity of monuments and spatial autocorrelation == | ||
- | ==1. The intensity of monuments and spatial autocorrelation== | ||
Create (20 rows x 20 columns) rectangular polygons covering the study area with the tool: | Create (20 rows x 20 columns) rectangular polygons covering the study area with the tool: | ||
ArcToolbox » Data Management Tools » Feature Class » Create Fishnet | ArcToolbox » Data Management Tools » Feature Class » Create Fishnet | ||
- | If not open; click '' | + | If not open; click '' |
Give the rectangular polygons values for the number of ancient monuments inside them by right clicking on the layer name of the rectangular polygons in the '' | Give the rectangular polygons values for the number of ancient monuments inside them by right clicking on the layer name of the rectangular polygons in the '' | ||
Line 34: | Line 37: | ||
Visualize the intensity of ancient monuments: Right click on the name of the joined layer and choose '' | Visualize the intensity of ancient monuments: Right click on the name of the joined layer and choose '' | ||
- | Go to the tab '' | + | Go to the tab '' |
Quantities » Graduated colors | Quantities » Graduated colors | ||
- | The value we want to visualize is '' | + | The value we want to visualize is '' |
- | Are there any patterns? Do neighboring polygons tend to be more similar than a random polygon? Check if that is the case by calculating the Moran’s I. | + | |
ArcToolbox » Spatial Statistics Tools » Analyzing Patterns » Spatial Autocorrelation (Morans I) | ArcToolbox » Spatial Statistics Tools » Analyzing Patterns » Spatial Autocorrelation (Morans I) | ||
- | You could use '' | + | You could use '' |
: | : | ||
- | Index is the value of Moran’s I (positive if there is spatial autocorrelation and not more than 1). The p value indicate if the result is significant. | + | Index is the value of Moran’s I (positive if there is spatial autocorrelation and not more than 1). The p value indicate if the result is significant. |
- | ==2. Test the stability of where people live== | + | == 2. Test the stability of where people live == |
Now we ask the data if people tend to live in the same areas today as they did during ancient times. | Now we ask the data if people tend to live in the same areas today as they did during ancient times. | ||
Line 61: | Line 63: | ||
Joins and Relates » Join… | Joins and Relates » Join… | ||
- | Do: Join attributes from a table using the fields: '' | + | Do: Join attributes from a table using the fields: '' |
Now we have the population for each district. We want to calculate the density and therefore also need the area. | Now we have the population for each district. We want to calculate the density and therefore also need the area. | ||
Line 67: | Line 69: | ||
Open the attribute table for the election districts layer you have joined with the population. Add a new field for area of the type Float in Table Options (the icon in the upper left corner at the attribute tables). | Open the attribute table for the election districts layer you have joined with the population. Add a new field for area of the type Float in Table Options (the icon in the upper left corner at the attribute tables). | ||
- | Right click on the name of the area column and click on '' | + | Right click on the name of the area column and click on '' |
- | Add a new column for the population density (type: Float). Right click on the name of this new column and open the '' | + | Add a new column for the population density (type: Float). Right click on the name of this new column and open the '' |
Count the number of points inside of each polygon in the same way as previous with the rectangular polygons (This can take a while). | Count the number of points inside of each polygon in the same way as previous with the rectangular polygons (This can take a while). | ||
- | Create a new column and calculate the density of the monuments. | + | Create a new column and calculate the density of the monuments. Export the table as a .dbf file using '' |
- | Export the table as a .dbf file using '' | + | |
Open Microsoft Excel and open the dbf file (instead of '' | Open Microsoft Excel and open the dbf file (instead of '' | ||
Line 80: | Line 81: | ||
Insert » (Charts) » Scatter » Scatter with only Markers | Insert » (Charts) » Scatter » Scatter with only Markers | ||
- | ==3. Test of monuments are close to water== | + | == 3. Test of monuments are close to water == |
- | If we instead ask the data if ancient monuments tend to be close to water or not, we can start with reusing the previous rectangular polygons with the count of monuments. | + | If we instead ask the data if ancient monuments tend to be close to water or not, we can start with reusing the previous rectangular polygons with the count of monuments. We also want to create a raster file with the distance to water using the tool '' |
- | We also want to create a raster file with the distance to water using the tool '' | + | |
ArcToolbox » Spatial Analyst Tools » Distance » Euclidean Distance | ArcToolbox » Spatial Analyst Tools » Distance » Euclidean Distance | ||
Line 92: | Line 92: | ||
Join this new table to the rectangular polygons and export the joined attribute table and open it in Microsoft Excel. Make a scatter plot for how the count of monuments relates to the mean distance for each rectangle. | Join this new table to the rectangular polygons and export the joined attribute table and open it in Microsoft Excel. Make a scatter plot for how the count of monuments relates to the mean distance for each rectangle. | ||
- | + | ||
Observe that we this time ignored the proportion of the rectangle that consist of water. | Observe that we this time ignored the proportion of the rectangle that consist of water. | ||
- | ==The End== | + | == The End == |
Put your intensity map and the two scatter plots in a Microsoft Word document and export the document as a PDF. Send in the PDF file on Mondo. | Put your intensity map and the two scatter plots in a Microsoft Word document and export the document as a PDF. Send in the PDF file on Mondo. | ||
If you have time you can also practice map design using [[http:// | If you have time you can also practice map design using [[http:// | ||
+ | |||
+ |
lab_point_to_polygon_and_point_to_raster.txt · Last modified: 2020/03/29 14:23 by Stefan Ene