Visualizing Hazmat Truck Crashes
Nimish Dharmadhikari - INCOG
Visualizing data is an important task in any analysis process. Emergency management preparation involves tracking Hazmat movements through the city. For analyzing Hazmat movements through Tulsa it is important to visualize the truck flows and the Hazmat truck crashes. Hazmat crash data arrives in a tabular form. It needs to be converted in the GIS dataset. Various tools such as density analysis are used to create different layers. These layers are superimposed on other datasets such as population data to generate a coherent story of Hazmat truck crashes and their potential effects.
Find Your Place With Ease Using the Updated OHADP Inventory Web App
Madeline Dillner - Oklahoma Corporation Commission
In the newest iteration of the Oklahoma Historical Aerial Digitization Project, finding the photos you need is easier than ever. The web app now contains county-year layers that display footprints of each individual georeferenced photo that is hosted on the Oklahoma Conservation Commission’s FTP site. Gone are the days when you are forced to navigate through entire folders of anywhere from 16 to 300 photos to find the 1 or 2 you are looking for. Simply zoom to the area you are interested in, turn on the appropriate layer(s), click your area of interest, and follow the links inside the pop-ups to download only the photographs you need.
Historical Aerial Photography – Bringing a Large Physical Collection into the Digital Age
Wendy Kramer - INCOG
Spatial-temporal Associations of Earthquakes and Well Completions in Oklahoma: An ArcGIS Model-Based Approach
Colin Brooks, Vicente Vasquez, and Phillip Bailey - Oklahoma Corporation Commission
The Induced Seismicity Department (ISD) of the Oklahoma Corporation Commission’s Oil and Gas Conservation Division (OGCD) has recently developed multiple Spatial-temporal models within ESRI’s visual programming toolbox ModelBuilder. ModelBuilder incorporates multiple geoprocessing toolsets in a visual framework to “perform various operations on geographic or tabular datasets” (ESRI, 2018). The purpose of this development project is to automate and streamline geoprocessing techniques to efficiently analyze multiple streams of data from disparate sources into a single model. Reoccurring tasks can be made more efficient by means of model-based tools aiding regulators in their reaction to seismic events and in decision making. Model outputs help the OCC to enforce commission rules and protocols. Output products from models can also be used to standardize data dissemination to select research and regulatory entities with the aim of inter-agency information release and data sharing. We find efficiencies derived from the use of automated models created using ESRI based tools have greatly reduced the labor and processing time for analysis of well completions and correlated seismicity in Oklahoma.
Constructing Work Plan Maps in ArcGIS
Authors: Nate Smith, Sam Coldiron, Paige Floire - Oklahoma Department of Transportation
Presenters: Devin Hargus, Kris Gibson - Oklahoma Department of Transportation
The OKDOT 8 year Workplan Maps are created by the GIS Development branch based on Projected Plan data from our Project Management division. They are then presented to the Oklahoma Transportation Commission for approval. Upon approval they serve as a reference to the entire Department showing where future construction projects are slated to occur. The maps are generated on a yearly cycle and are subject to change throughout the year. The farther out the project is projected to be, the more likely it is to be changed at some point within the cycle. The labelling format is under strict requirements and must also pass the approval process. With some ingenuity, the use of Excel, and a few lengthy label expressions we are now able to accomplish this task rather quickly every year.
Use of ArcGIS Collector App to protect Superfund Remedies
Amy Brittain - Oklahoma Department of Environmental Quality
The Oklahoma Department of Environmental Quality (DEQ) is responsible for protecting Superfund remedies at federally designated Superfund sites. Superfund is a federal program used to clean up our nation’s uncontrolled hazardous waste sites. DEQ works with EPA to address these sites in Oklahoma. DEQ Superfund inspectors visit sites where cleanup has been completed regularly to ensure that the remedy remains protective of human health and the environment. In the past the inspectors only had paper maps to tell there where capped soil areas are located. Today, DEQ uses the ArcGIS Collector Application in the field to help inspectors target areas with caps. The Collector app also allows the inspectors to capture photos and notes in the field when potential issues are identified and communicate back with management in our central office in real time. This allows for faster response to issues before a problem becomes dangerous.
Investigations into Social Vulnerability, Scale, and Hazardous Weather
Clay Barrett, Dr. Peter Kedron, Dr. Joseph Holler - Department of Geography, Oklahoma State University
Oklahoma’s infamous severe weather makes it the perfect location to look for a relationship between hazardous weather events and vulnerability. Research supported by the Oklahoma EPSCoR Program examines socio-ecological systems and their adaptability to climate variability. Ongoing research excerpts give insight into the relationship between Social Vulnerability, weather hazards in general, specific weather hazards, seasonality, and scale of analysis.
The Effect of the “Dead Red” Law in Central Oklahoma
Charlotte Adcock and Jennifer Sebesta - ACOG
There are two main categories of traffic lights: timed and demand-actuated. For some users of the roadways, the latter form can pose problems, especially if an inductive loop is in place. This is where what is known as the “Dead Red” law comes into play. In Oklahoma, Senate Bill 1329 states that "the driver of a motorcycle facing any steady red signal may cautiously proceed through the intersection..." This bill aimed to offer motorcyclists a safe and legal way of navigating intersections that could not detect them. The view on the Motorcycle Mobility and Safety Act is divided: some do not support the act, others do, and still others want it to go further and protect bicyclists, who were omitted from the final version of the bill. For this poster, ACOG looks into the number of crashes involving motorcyclists at intersections before and after SB 1329 came into effect in November 2010.