HW (Due 04/04)

Online Module

Learning ArcGIS Desktop, Module #7

Bring in Certificate

LINK

Class Plan

Return Exams

• 100: 3
  
• 89+: 6
  
• 69+: 2
• 59+ 1

Go Over Exam Question

Beginning Model builder

+ Create a Model that will take a table of addresses and create a 2-mile buffer shapefile.

Use exam foreclosure list

• First, do it manually using only geoprocessing tools
• Geocode: ArcToolbox/Geocoding Tools/Geocode Addresses
• Buffer: ArcToolbox/Analysis Tools/Proximity/Buffer
  

• Second, create a Model to duplpicate those steps
• Create a new Toolbox: Right-click ArcToolbox/New Toolbox
• Create a new Model: Right-click new Toolbox/New/Model
• Drag appropriate tools to Model
• Connect using the Connector Tool

Midterm

Access Exam

Necessary Resources:

1. Dataset
   
2. Spatial Join Tools
3. Super Spatial Join
4. Demographic Data
   

Extra Credit (For Real This TIme!)

GIS Workshop
Thursday, March 12 3pm
Central Library Basement, room B20

All who attend will receive 5 points added to their final grade. There will be 1 additional workshop to attend, for a total of 10 additional points to final grade (out of 100). Next one April 15.

Title: ArcGIS & Google Earth for 3D Visualization
Time: Thursday, March 12, 3-5pm
Location: Central Library B20 (basement)
Description: Learn how you can easily use the campus-wide ArcGIS software to include custom created geographic data into Google Earth. Examples include demographic data (such as population, income, race), land features not currently included in Google Earth (such as land use, zoning, and different aerial/satellite imagery), and customized features you create yourself (such as GPS points, or the results of GIS analysis).

Midterm Practice Questions

1. How many foreclosures are currently available in Tarrant County with a Property Status as 'New Listing' (status option available on form)? (dowload page)

• Data
• Answer: 52
  

2. Geocode the foreclosures listed from answer #1 using TAD parcel shapefile. What % of addresses are not geocoded? (No sufficient address match found.)

• 0%
  

3. What is the street number and street name of the foreclosure property with the highest square feet? (If a tie occurs, list them all.)

• 8122 Abbey Glen Ct
  

4. What is the price per square foot of this property?

• $50.04
  

5. Which foreclosure property has the lowest price per square foot?

• 4008 Wiman Drive
  

6. What is the crime rate (total crime index) within .5 mile radius around this property? (demo data) (spatial join tools)

• 171.09
  

7. How many other foreclosures are currently available within this .5 mile radius?

• 0 (because each buffer contains itself as the point)
• Right-click the buffer and joins/joins and relates
• Make sure it is a spatial join
• select the points in the drop down menu to join to the buffers
• FILE LOCATION/NAME !!! Beware of it
• OK
  

8. Which MLS contains the highest number of other MLS within .25 miles that contain within one bedroom. (Data) (super spatial join)


The field to average FOR THIS PARTICULAR QUESTION does not matter, but the script requires it so pick one.

• 6042 MERCEDES AVE
• 5906 MCCOMMAS BLVD
• 6015 MCCOMMAS BLVD
• 5946 MCCOMMAS BLVD