Dewitt county Handbook

1. Dewitt county Handbook Final presentation Robert Gannon (Manager) Matt Ahrens (Assistant Manager) George Caracostis (GIS Analyst)

2. Background and problem • Due to increased drilling and the Eagle Ford Shale phenomena, there has been high concerns for the risk of chemical fires putting the community and the environment at risk. • The problem lies in the storage of Extremely Hazardous Substances (EHS) at facilities and the transport of these chemicals on the roads, to and from the facilities. • EHS chemicals are defined by the Environmental Protection Agency (EPA), as any substances that has toxicity and potential, in an event of a spill, to become airborne (EPCRA Guide, 2015). Each facility storing EHS chemicals is required by the EPA to file a Tier II report, listing an index of EHS chemicals with amounts stored at the facility.

3. Problem continued… • Second, DeWitt County is largely a rural county, making cell phone coverage and internet access very limited. • Third, there are only 7 volunteer fire departments in DeWitt County meaning these departments will be the first responders in the event of a chemical emergency.

4. solution • In January 2015, our team South Texas Emergency Consulting was contacted to solve these problems. • Our team used GIS technology to implement spatial data into a handbook showing pertinent facility information, chemicals, contacts and other necessary data normally needed in an emergency call, that was independent of the internet.

5. Purpose & Scope • The purpose of the project was to build an emergency handbook using GIS technology. • Independent of the internet. • For emergency responders in the oil and gas industries. • The information will be distributed via paper copy of handbook to all emergency responders. To be used in an event of an emergency. • The project (i.e. analysis) was done on all EHS chemical facilities within DeWitt County.

6. Chemical (ehs) facilities Dewitt county

7. Data • Data used for the project for the project was obtained primarily from Rosie Ybarra, Emergency Management Coordinator of DeWitt County. Information about chemicals and chemical facilities was retrieved from the DeWitt County Tier II data files. It included: • Chemical Inventory list for all facilities including means of storage, physical properties, EHS categorization, and facility reference codes for each chemical. • Facility contact information including E-mail, phone numbers of on and offsite managing personnel, and corresponding contact reference codes. • Site plan maps to assist in locating gate access information.

8. Data continued… Texas State Data Center website provided: • Shapefiles for DeWitt and adjacent counties including city boundaries, rivers and lakes United States Census Bureau provided road shapefiles United States Geological Survey: Quad index reference grid USGS aerial orthophotographic imagery was downloaded from the Texas National Resources Information System website for facility gate access location, and final guide book map display.

9. Software • Microsoft Excel: Used initially to edit, organize, and complete Tier II data. • Cameo Chemicals: chemical information database used to research chemical properties and hazards. • Areal Locations of Hazardous Atmospheres (ALOHA): Used to calculate chemical/quantity specific threat zone distances for each EHS facility. • ArcMap 10.2: Used for map production, table joins, simple overlay, and final map output.

10. Methodology Step 1: Data Management The Tier II dataset we received from the client included Excel spreadsheets of three varieties all linked through record identification codes: • Facilities • Chemical Inventories • Facility Contacts Data was edited for simplicity and consistency • Addition of necessary fields and values • Deletion of fields unrelated to project • Reclassification of field values • Preparation for table joins

11. Step 2: Definition Our Criteria for EHS Classification Inclusion of Hydrocarbons to current EHS list • Contain trace amounts of EHS chemicals: • Benzene • Hydrogen Sulfide • Large quantities pose great threats but are not classified as EHS Threshold Planning Criteria (Threat Zones) Reportable Quantity: • Max Amount Code > 08

12. Step 3: Calculation ALOHA Software • Chemical quantity/property input • 3 Threat zone distances calculated • Protective Action Criteria (PAC) Zones Assumptions • Fixed atmospheric conditions • Immediate release source

13. Step 4: Visualization • All facilities in DeWitt County added to map • EHS facility layer created from joining EHS List • Add USGS index grid for quadrant reference

14. Step 4: Visualization • Threat zone distances from ALOHA • calculations input as buffers: • Protective Action Criteria (PAC) • Zone 3: Initial Blast Area • Zone 2: Shelter in Place/Evacuation • Zone 1: Notify & Monitor • Located facility gate access points

15. Step 5: Final Output • Contact information joined to Facilities • Utilized data driven pages for creation of 307 individual EHS facility maps • List of all facilities within each map extent

16. Results & discussion • Project allowed us to provide 307 detailed maps showing, facility information, gate access and contact numbers for first responders. This will allow responders to set up road blocks and be able to warn surrounding residential homes and business of potential hazards in an event of an emergency. • Obstacles: One of the obstacles our team faced was having to learn a new program suite. Cameofm, Aloha, Marplot, Cameo Chemicals. These are GIS tools known in the chemical industry but unfamiliar to our group. • Although guidebook is a hardcopy map series, facility & threat zone shapefiles with import instructions will be given to the client for further use in Marplot.

17. conclusion Our team was able to successfully create an Emergency Handbook, independent of the internet, with all necessary information for Responders. This handbook will serve as a visual and textual guide to for our client and responders who will use it. It has been an honor to be able to do this project knowing that it will be helpful to the responders and people of DeWitt County.

18. Any questions?