LabActivity8

.docx

School

DePaul University *

*We aren’t endorsed by this school

Course

241

Subject

Computer Science

Date

Jun 11, 2024

Type

docx

Pages

Uploaded by CorporalComputerPelican11

Lab Activity 8 | Advanced Spatial Analysis Objective: In this lab activity, you will implement the following:  Define a problem, formulate and solve the problem using data and map visualizations  Interpolation to compute unknown values from known values  Writing SQL queries (attribute queries) spatial queries (selection), and performing buffer analysis  Identifying and extracting external data from various data sources (geodatabases, ArcGIS online data repository) to provide a mappable solution  Working with vector data models, geodatabases, data types (spatial and no-spatial data, quantitative and qualitative data)  Overlay multiple shapefiles to visualize data  Create technically correct maps (correctly populated data, use correct map types, colors, symbols and visual elements) with visual hierarchy  Analyze, describe, and apply the algorithm (methodology)  Technical writing (answering technical questions) S ubmit a single word document with the map and the answers to all the questions. Part A: Interpolation [8 Points] (1) Create a folder called LabActivity_8 on your flash drive or hard drive. (2) Download the LabActivity8.zip file into this folder. (3) Unzip the LabActivity8.zip file into the folder LabActivity_8 you created. (4) Open ArcGIS Pro, navigate to LabActivity_8 folder. Add the shapefiles "CCA_Boundary.shp" and "PublicSchools_2000.shp". (5) Make the CCA_Boundary shapefile layer hollow (no fill color, only a thick outline). Then make the PublicSchools_2000 shapfile layer to about 2 points (very small). (6) Click on “Analysis” tab on top menu. Click on “Analysis Gallery” tool. (7) Select “Empirical Bayesian Kriging” under the “Analyze Patterns” section. (8) You will see the “Empirical Bayesian Kriging” pane load on the right hand side. Enter the following values:  Input Features  PublicSchools_2000 shapefile  Z-Value  ENROLLEMNT  Output geospatial layer  Type Enrollment_Interpolation  Output raster  Type Enrollment_Interpolation Do not click RUN Yet. Next, we have to set the “Environments” to ensure the processing extent and masking is set. Click on “Environments” on the right hand side pane.  Scroll down until you see “Processing Extent”. Select “CCA_Bounday” from the drop down.  For the “Mask” select CCA_Bounday from the drop down. Click “Run” button. It will take a few minutes to run. (9) Deselect (uncheck) the lower layer (2 nd layer” named “Enrollment_Interpolation” under Contents. _________________________________________________________________________________ © Nandhini Gulasingam 1

(10) Complete the map. Overlay schools shapefile on top of the interpolated layer. Make sure that the map is technically correct with all the necessary map elements and variables/shapefiles relabeled. Include the completed map in the word document. Data source is Chicago Public Schools, 2000. Part B: Working with Geodatabase [8 Points] (1) Download the Housing_Schools.zip file into your current lab activity folder. (2) Unzip the Housing_Schools.zip file into your current lab activity folder. (3) Create a new map within your existing project (or start a new project). i.e. got “Insert” tab, select “New Map”. (4) Then click “Add” and then “Data” to add the data (similar to adding shapefiles). Navigate to the folder you have unzipped the files. See screen below. Double click on “Housing_Schools” folder. (5) Now you will see the “Housing_Schools.gdb” like the one below. Highlight it and click “Open”. (6) You will see 4 shapefiles. Add all 4 shapefiles. (7) Using the “Community_Housing” shapefile layer, create a map to show population in poverty (“In_Poverty”). Change the symbols/colors for the reaming 3 school shaplefile layers. (8) Overlay the shapefile layers. Complete the map, add all map elements. Data source is “GIS Class Data, 2021”. Make sure that the map is technically correct with all the necessary map elements and variables/shapefiles relabeled. Include the completed map in the word document. Data source is “GIS Class Data, 2021”. Part C: Add data from ArcGIS Online [8 Points] (1) Create a new map within your existing project (or start a new project). i.e. got “Insert” tab, select “New Map”. (2) Then click “Add” and then “Data” to add the data (similar to adding shapefiles). You will see the following window. It does not matter what is visible on the right hand side. From the left hand side click “ArcGIS Online” You will see data files load into that window. If you want to look for more click on the “Find more items…” link at the bottom of that window. It will load more data files to this window. _________________________________________________________________________________ © Nandhini Gulasingam 2

None of these correspond to the same location, if you load one, you may have to click on the shapefile layer under contents (left hand side) and then select “Zoom to Layer”. Experiment with a few different ones. Use option-1 or option-2. Option-1: Pick any one you like and create a map. Complete the maps with all map elements. OR Option-2: Try what we added during the lab: Try some of the files we added in the lab video. Please note that you may not find the same files, if that is the case, revert to option-1. The goal is for you to learn how to look for data on ArcGIS Online and add the data to create a map, so you can pick anything that is available. Complete the map. Make sure that the map is technically correct with all the necessary map elements and variables/shapefiles relabeled. Include the completed map in the word document. Part D: Attribute Queries (Select by Attribute) [20 Points] For this activity, we will use the following shapefiles. We will write queries to see how many schools satisfy the conditions stated below. For each question, you will include a screen print of the GUI (graphical user interphase), the SQL (Query), the answer and a couple of lines explaining what the command does as discussed in the video and shown below. Exercise: (1) [ 5 pts] How many schools are in Austin Community? Field Name OPERATOR Value _________________________________________________________________________________ © Nandhini Gulasingam 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version