Daily Archives: October 11, 2017


In today’s demonstration, I will walk you through the process of joining an Evalidator query result to a data layer in ArcMap. We will use the Evalidator reports and the 2015 Census county boundaries zip file (here).  Copy the file to your E:\ drive and uncompress it.  You’ll find the county […]

VBA MagicII


Useful EXCEL VBA Commands: Most of these commands work in EXCEL and ArcGIS Field Calculator.  ESRI support has a nice description of these commands in the context of the Field Calculator here and some examples here. left: The Microsoft Excel LEFT function allows you to extract a substring from a string, […]

VBA Magic


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 Click Geographies on left-hand side of screen Select “Congressional District” from the dialog dropdown Select “All Congressional Districts (115th Congress…)” […]

American FactFinder