American FactFinder

American FactFinder: (https://factfinder.census.gov/)

NOTE:  The subsections for each bulleted step below tell you how to perform the task.
  • Visit AFF >> Advanced Search >> SHOW ME ALL
  • Filter to Congressional District
    1. Click Geographies on left-hand side of screen
    2. Select “Congressional District” from the dialog dropdown
    3. Select “All Congressional Districts (115th Congress…)” >> Hit “Add to Your Selections” button
    4. Hit the CLOSE button in the upper-right to close the Select Geographies dialog
  • Filter to Real Estate Taxes
    1. Click Topics on left-hand side of screen
    2. Expand the Housing >> Financial Characteristic >> Select Real Estate Taxes
    3. Close the Select Topics dialog
  • Open the “Mortgage Status by Aggregate Real Estate Taxes Paid (Dollars) table
    1. Tick the box next to the first table B25090
    2. Select the Download link shown above the list of tables
  • Move the compressed file to your workspace and extract
  • Download the 115th Congress boundary shapefile (“…20m.zip”)
    1. https://www.census.gov/cgi-bin/geo/shapefiles/index.php
    2. Save the 2019 congressional district boundaries
  • Move the compressed file to your workspace and extract

Prepare CSV for use in ArcMap

  • Open the ACS_16_1YR_B25090_with_ann.csv in Excel and fix the field names
    • First row must have short (<13 characters) and MEANINGFUL field names that contain no strange characters or spaces
    • Remaining rows must be data
    • Save as new CSV (<<something>>_version1.csv)
  • Load your CSV into ArcMap; you can not make edits to a TXT or CSV so
  • Save this file out as <<something>>_version1.dbf; YES, load it into ArcMap
    • Table Options > Export
    • Change the Save As Type to dBASE Table
    • Append “.dbf” (you  must do this each time you save out as a dBASE file)