1. Select by attributes (for chosen counties)

​

         a. Query Expression -“Fid = # or Fid = # or”

​

​

​

​

2. Cancer Data created as an Excel Table

         and FID of the counties added to match.

​

​

​

​

​

3. USA_Counties_Selection_withCancerData                              join

         Cancer Rates Excel Table

​

​

​

​

​

4. USACountiesSelection_withCancerData     

         a. Data > Export Data

         as shapefile,  “SelectedCounties_withCancerData”

 

​

​

​

​

5. Superfund_NPL_Sites_.mxd(arcGIS)

         created into shapefile “superfundsites”

​

​

​

​

​

6. Geoprocessing > Clip

       a. input fent-superfund

       b. clip-selected counties with Cancer Data   

       c. output-selected Counties_withCancer_Superfund

​

​

​

​

​

7. SelectedCounties_withCancerSuperfund

          a. Properties > Symbology > Quantities >                             Graduated Colors

​

         i. Value: AV_ANCount

         ii.Normalization: Pop2012_SQMI (10 classes)

​

​

​

​

​

8. SelectedCounties_withCancerSuperfund

          a. Properties > Symbology > Quantities >                             Graduated Colors

​

         i. Value: AV_ANCount

         ii.Normalization: Pop2012_SQMI (10 classes)