SARA Reporting Tool

The SARA Risk Radius Analysis Tool is a custom ArcGIS tool developed to assist the Cumberland County Public Safety department in their SARA Tier II reporting. The tool performs a series of analyses on sites with certain quantities of hazardous chemicals. The results of the analysis go into a plan for each site. The user enters in the latitude and longitude for the site, a unique ID for the site, the distances for the risk radii, the units for the risk radii, and a folder location for output files.

There are four Python scripts comprising the tool:

  1. obtains the user inputs from the tool’s dialog window, and imports functions from the other three scripts.
  2. converts a latitude and longitude coordinate pair from the WGS 1984 geographic coordinate system into a projected coordinate system, and creates the risk radii (multi-ring buffers).
  3. loops through each risk radius and calculates the proportional population in each risk radius using U.S. Census block data.
  4. loops through each risk radius and selects any vulnerable facilities within each radius. The selected vulnerable facilities are exported to a Microsoft Excel file.

sketch diagram of the SARA report geoprocessing tool