Sort of a review class. Only new item learned is geocoding via GPS Visualizer and three new sources: HUD Foreclosures Data & TEA School District Locator & Arlington Police Department.

1. Create a shapefile of all available HUD foreclosures in Arlington.

HUD Foreclosures Data

• Geocode using the GPS Visualizer
  (uses Yahoo! Maps to geocode)
• Alternative is Excel Geocoding Tool - ( - backup - ) (uses Yahoo! Maps to geocode)
  
• Yahoo & Google Geocoders Use Geographic/World/WGS84

1. Coordinate systems
2. Geocoding (more detail)
3. Personal Geodatabases

1. Textbook, pg. 339 - 365 exercises 13a & 13b. Print off last step of each exercise and bring in.
2. Which zip code in Texas has the largest number of Municipal Solid Waste Sites/Landfills in it? If there is a tie, list them all.
1. Municipal Solid Waste Sites/Landfills via Texas Commission on Environmental Quality
2. Texas Zip Codes via TIGER (Please use the 2010 zip codes.)
   

• SimplyMap
• Texas Water Development Board

• Select by Location
  
• Buffers
  

1. Download 2010 estimates by block group from SimplyMap.
1. This is a proprietary database, limited to 10 simultaneous users.
1. Prepared table
2. Walk-through video
   
2. Clean SimplyMap table
3. Add to ArcMap
2. Download 2000 block group shapefile from TIGER
1. Add to ArcMap
3. Join SimplyMap table to TIGER shapefile. (See a problem here?)
1. Fix field type in shapefile
1. Open shapefile attribute table
2. Click 'Table Options' button on top left corner, and select 'Add Field'
3. Give name (following rules)
4. Type: Double
5. OK
6. Scroll to far right of table and you will see your new field
7. Right click your new field and select 'Field Calculator'
8. Double-click 'BKGPIDFP00' so it appears in the text area box below.
9. OK
10. Now Join
    
2. Export to make join permanent
4. Download statewide well shapefile from Texas Water Development Board
1. Add to ArcMap
5. Create UT Arlington point shapefile
   
1. Click the 'Find' button (binoculars)
2. In the 'Locations' tab, select the U.S. Streets Geocode Service
3. Enter: 701 S. Nedderman Drive, Arlington, TX 76019
4. Click 'Find'
5. Right-click top result and select 'Add Point'
6. Close 'Find' dialog box
7. Right-click 'Layers' and select 'Convert Graphics to Features'
8. Specify a suitable location/name and OK
6. Create a 1-mile buffer (radius) around UT Arlington
1. ArcToolbox/Analysis Tools/Proximity/Buffer
7. Tested exercise before class (not typical) and the spatial join against the well data took a long time due to the nigh number of wells in Texas. It will run faster if we clip the well data to Tarrant County first.
1. At top of screen, Selection/Select by Location
2. Select all features from [XYwelldata]
3. Source Layer: BG Layer
4. OK
5. Export
   
8. Spatial Joins
   

1. Graduated Symbols
   
2. Spatial Join
3. Buffers
   

1. ReferenceUSA
   

• Download prepared database here
• View the graduated symbols of total air emissions by facility
• Spatial Join #1: (Which zip codes have the highest number of facilities reporting air emissions?)
• Right-click zip codes/Joins & Relates/Join
• Change join type to spatial join
• Join to the TRI data
• Specify output location/name
• Spatial Join #2: (Which zip codes have the highest amount of air emission releases?)
• Repeat above, but this time we will check the 'Sum' checkbox.

• Download Garbage Collection facilities from ReferenceUSA
• Click U.S. Businesses
• Select Custom Search tab
• Click Business Type
• Check Keyword/SIC/NAICS
• Type Garbage Collection and click Lookup
• Select Garbage Collection (should be first item)
• On the left again, click Geography
• Check Metro Area
  
• Specify Dallas/Fort Worth
• On the right, click View Results
  
• We are limited to 50 records per download! This will therefore take multiple downloads that need to be copied together.
• Clean resulting table. Remove any fields you do not need, but it is required to keep the name of the company and the lat/long at a minimum
  
• Tricksey Part! We need to convert the lat and long fields from numbers stored as text to actual numeric fields. Select entire fields and click the exclamation and select Convert to Number.
• Create Points
• Right-click on table and select Display XY Data
• Longitude: X
• Latitude: Y
• Must assign a coordinate system!
• ReferenceUSA (and TIGER) use NAD 1983 (North American Datum)
• Geographic/North America/North American Datum 1983
• Buffer Points 1 Mile
• ArcToolbox/Analysis Tools/Proximity/Buffer
• Spatial Join