Using Social Explorer

The following tutorial explains the steps necessary in order to download Social Explorer data and use it within ArcMap.

For this tutorial, we will be downloading RACE data by Los Angeles County CENSUS TRACTs from the ACS 2006-2010.

Step 1: Getting the data from Social Explorer

  1. go to the social explorer Reports page
  2. click on the » ACS 2006-2010 new link on the left menu bar
  3. for “select geography type” choose “census tract”
  4. for “state” choose California
  5. for “county” choose Los Angeles
  6. highlight “all census tracts in Los Angeles County” and click the “add” button
  7. click “next”
  8. click on the “search” tab and enter “race”
  9. highlight “T13 Race” and click “add”
  10. click on “show results”
  11. click on the “Data Download” tab
  12. uncheck “output labels on 2nd line” (IMPORTANT)
  13. click on the “Census Data (CSV)” and save the file

Step 2: Getting the matching boundary data

  1. Since we are working with 2010 data, we need to join this data with 2010 Census Tracts.  To do so, go to the Tiger Download Site
  2. For “Layer type”, choose “Census Tracts”, then select “California” to download the zipped shapefile.

Step 3: Mapping the data in ArcMap

  1. Open ArcMap and add the California Census Tract file and the downloaded csv data file
  2. Right click on the census tract layer, choose join and relates, join
  3. Make sure you are on “join attributes from a table”, and select the following:
    1. Step 1: “GEOID”
    2. Step 2: Choose the csv file you added
    3. Step 3: “Geo_FIPS”
  4. Now that your data is joined, you can choose to symbolize the census tract layer on the new race fields you imported