2 Exercises Today

New Skills:

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