South Central Arc User Group

Established 1990

September 19, 2017

Alexander Posey and the North Canadian Posey’s Hole

Raymond Irwin – Muskogee (Creek) Nation

Rebecca Coleman – Muskogee (Creek) Nation

Alexander Posey gained international fame as a humorist, poet, and journalist in the period of land allotment as Oklahoma transitioned from Indian Territory into statehood. Over one hundred years later, his work is still studied for both historical context and artistic appreciation. Ironically, he drowned in the North Canadian River, an area he loved to write about and explore. The exact location of his death has been lost to history. Today it is covered by a lake. Known as Posey’s Hole, many odd events happened there before Lake Eufaula was impounded.

Our first poster covers the locations and events that shaped Posey’s life.

The second poster reveals the spot of his death that we rediscovered with historical maps and through analysis of narratives. We found a contributing factor in that May and June 1908 brought major flooding to the area, making normal river crossings dangerous. It also tells of the rumored hauntings and other strange occurrences we uncovered in our research to pin-point the exact location of Posey’s Hole.

Bathymetry and Capacity of Shawnee Reservoir, Oklahoma, 2016

Chad E. Ashworth – U.S. Geological Survey

S. Jerrod Smith – U.S. Geological Survey

Kevin A. Smith – U.S. Geological Survey

The U.S. Geological Survey (USGS), in cooperation with the City of Shawnee, performed a bathymetric survey of Shawnee Reservoir (locally known as Shawnee Twin Lakes) in 2016 and released the bathymetric-survey data in 2017. The purposes of the bathymetric survey were to (1) develop a detailed bathymetric map of the reservoir and (2) determine the relations between stage and reservoir storage capacity and between stage and reservoir surface area. The bathymetric map may serve as a baseline to which temporal changes in storage capacity, due to sedimentation and other factors, can be compared. The stage-storage relation may be used in the reporting of real-time Shawnee Reservoir storage capacity at USGS station 07241600 to support water-resource management decisions by the City of Shawnee.

Shawnee Reservoir consists of two lakes connected by an equilibrium channel. The southern lake (Shawnee City Lake Number 1) was impounded in 1935, and the northern lake (Shawnee City Lake Number 2) was impounded in 1960. Shawnee Reservoir serves as a municipal water supply, and water is transferred about 9 miles by gravity to a water treatment plant in Shawnee, Oklahoma. Secondary uses of the reservoir are for recreation, fish and wildlife habitat, and flood control. Shawnee Reservoir has a normal-pool elevation of 1,069.0 feet above North American Vertical Datum of 1988 (NAVD 88). The auxiliary spillway, which defines the flood-pool elevation, is at an elevation of 1,075.0 feet above NAVD 88.

Where We Live: Assessing Health Outcomes in Oklahoma’s Two Largest Metro Areas

Kiran Duggirala – Tulsa City-County Health Department

Luisa Krug – Tulsa City-County Health Department

The goal of this project was to develop a health and wellness index in order to evaluate health outcomes and the built environment in Oklahoma City-County and Tulsa County. This project was done as a partnership between the Oklahoma City-County Health Department, the City of Oklahoma City, and the Tulsa Health Department. ArcGIS network analyst was used to identify areas around built environments for population calculations.The health index formula standardizes variables in nine categories (education, income, maternal and child health, mental health, mortality, health care access, crime, infectious disease, and built environment) so that they are all given equal weight in a composite index. The index represents the average of the standardized ratios of all nine component variables. The index ranges from 0 to 100 with a higher number indicating greater health burden. This formula was adapted from both the County Health Rankings and Urban Hardship Index and finalized in collaboration with all partners. The health and wellness index identified zip codes in Oklahoma City-County and Tulsa County that are disproportionately burdened with poor health outcomes. The built environment portion of the index is also the first step to exploring the relationship between the environment in which people live and life expectancy—the general trend shows that as the built environment index goes up, life expectancy decreases. This project provided an opportunity to evaluate health outcomes in both Oklahoma City and Tulsa. As the two largest metro areas in Oklahoma, it is important to understand the health outcomes and challenges facing each area and how they relate to each other. This project is an excellent starting place for further collaboration and coordination between efforts to improve the built environment and other indicators that strongly influence health in both communities.

A Comparison of Means of Travel to Work by Census Block Group in Central Oklahoma

Charlotte Adcock – Association of Central Oklahoma Governments (ACOG)

Jennifer Sebesta – Association of Central Oklahoma Governments (ACOG)

Over the years, the interest in alternative means of transportation has grown in America. ACOG’s recent surveys for the long range transportation plans have shown local support for more bicycle, pedestrian, and public transportation infrastructure in the region. That support is beginning to show, not just in the growing regional infrastructure, but also with means of travel to work. ACOG staff compared 2010 and 2015 5-year American Community Survey data for the Central Oklahoma region and found that, overall, these alternative forms of transportation are on the rise. At the Oklahoma SCAUG, ACOG staff will share these comparative maps with attendees.

Forecasting Growth by Transit Oriented Development Using Spatial Analysis

Nimish Dharmadhikari – INCOG

There are an increasing number of new public transit project developments in the United States and all over the world. These projects are developed for the main goal of the traffic congestion mitigation. At the same time these transit projects help with another form of development called Transit Oriented Development (TOD). TOD proposes a different set of zoning policies with the mixed use, high density developments to maximize the access to the faster public transit system. TODs are gaining popularity to address some of the urban problems such as affordable housing, air pollution, and sprawl. Cities are planning TODs in conjunction with their light rail systems, bus rapid systems, or metro-rail systems. They expect the TODs to be the future growth corridors. This research proposes a methodology to forecast the growth happening with TODs. We use spatial analysis techniques to study the current land use and the future potential. This method will be useful for the cities to study the potential of the TOD they are proposing. It will also generate a map of the growth centers and potential growth corridors to focus.

GIS for FEMA Discovery: Flood Risk in the Little River Watershed

David J. Littlejohn – Meshek & Associates, LLC

GIS plays a key role in the FEMA Discovery process by effectively managing spatial data and communicating flood risk through web maps, thematic figures, and reports. Discovery was recently completed for the Little River Watershed as the first phase in FEMA's Risk MAP program. This poster highlights the information gathered, processes developed, and conclusions reached to advance flood risk mitigation efforts for communities in central Oklahoma.

GIS Utilization within MCN Cemetery Recordation

Gano Perez Jr. – Muscogee (Creek) Nation Historic & Cultural Preservation Department

The Cemetery Program consists of a 4 man crew dedicated to preserving and documenting tribal church and family cemeteries within the tribal jurisdiction of the Muscogee (Creek) Nation which consists of whole and partial segments of 11 Oklahoma counties. The data collected in the field is then applied within the GIS server to create geospatial records of location, condition and cultural significance within each cemetery. Services include removing debris, mowing, resetting headstones, cutting trees, stump-grinding, brush clearing, and on a case by case basis a fence may be installed if necessary to prevent livestock from entering cemetery and accidentally moving headstones. The application process gathers information and once permitted on the cemetery site further documentation is gathered using Trimble dataloggers and heavy site form and sketch documentation of each and every headstone and notes are made for possible or suspected unmarked burials.

Identifying Places to Play in Tulsa County through Shared Use

Kiran Duggirala – Tulsa City-County Health Department

Chad Call – Tulsa City-County Health Department

Luisa Krug – Tulsa City-County Health Department

In 2015, 33.0 percent of Tulsa County adults reported no leisure time physical activity in the previous month, which was higher than United States rate of 25.4 percent. This lack of physical activity can be influenced by limited access to physical activity opportunities and can lead to poor health outcomes.

The goal of this project was to increase access to physical activity by implementing shared use strategies at Tulsa County schools. Shared use strategies aim to increase access to physical activity by encouraging school playgrounds to become a place to play after school hours, especially in areas where people do not have access to a park. This project was implemented as part of the Plan4Health grant, which the Tulsa Health Department, Pathways to Health, and the Oklahoma Chapter of the American Planning Association received in 2015.

Our objective was to increase access to physical activity for Tulsa County residents by forming and promoting shared use agreements in four public schools districts in Tulsa County (Jenks, Tulsa, Union, and Broken Arrow).

Initially, a ‘play desert’ criteria was developed in order to evaluate areas of Tulsa County where people did not have access to a park while also looking at socioeconomic factors that also play a role in access to physical activity and overall health outcomes. Once this criteria was developed and these areas were identified, school surveys and physical audits were conducted to evaluate current shared use capacity and potential. School districts, as well as individual schools, were then approached in order to propose unlocking the schools’ playgrounds in order to promote shared use and physical activity. Park assessment and usage tools were utilized to evaluate usage and physical condition of the playgrounds.

Mobile GIS Data Collection and Reporting: A Stormwater Case Study

Chris Hill – Meshek & Associates, LLC

Jason Kleps – Meshek & Associates, LLC

Many Oklahomans rely on their community’s stormwater systems to keep them safe from flooding during Oklahoma’s severe weather. At the municipal level, stormwater management involves the use of many different datasets including mapped FEMA floodplains, landuse planning/permitting, capital improvement planning (CIP), and infrastructure maintenance. GIS provides the tools to make work easier for communities that wish to effectively maintain their stormwater program.

Oklahoma communities are leveraging GIS to help them manage these datasets and to improve the efficiency of handling their drainage systems. One of the more important aspects of a community’s stormwater program is inventorying the condition of the existing stormwater infrastructure. Leveraging GIS tools for data collection, processing, and visualization can help local officials make informed decisions about how to better maintain their system. With the support of GIS, the City of Tulsa has developed a program for inventorying and reporting on the condition of the storm sewer system and their open channels. This poster will highlight the methodology, technology, and mapping utilized to inspect the condition of the City’s stormwater infrastructure using Collector for ArcGIS and hosted WebGIS services.

OHADP Inventory Web App

Madeline Dillner – Oklahoma Corporation Commission

This is the latest news on the Oklahoma Historical Aerial Digitization Project! Since 2014, the Oklahoma Corporation Commission has been constantly working to create ways to make their vast collection of scanned and georeferenced historical aerial photographs easily accessible to the public. In 2015, the Office of Geographic Information agreed to make all of the OCC’s photos available on an FTP site, with login credentials freely available. For the past couple years, there have been multiple ways to access a desired photo set. Photos from sets that were scanned and separated by township could be found by going through OKMaps’ Data Viewer. Information (including FTP site links) for all existing photos sets could be found in a 1,000-record Inventory spreadsheet updated periodically by the Oklahoma Corporation Commission. Now, this new installment turns the data-rich but unwieldy Inventory spreadsheet into a layer in a streamlined, easy-to-update, easy-to-use ArcGIS Online web app. Like the OKMaps Data Viewer, this web app allows you to use a map to search for spatially-specific data. And, like the Inventory spreadsheet, the data contained in the layer’s attribute table is complete—it contains information on every Oklahoma photo set the OCC is aware of from across the nation. With the new OHADP Inventory web app, you now have the best of both worlds.

OSU Cartography Services Work on the Geological Highway Map Series

Hayden Harrison – OSU Cartography Services

Lauren Wood – OSU Cartography Services

Clay Barrett – OSU Cartography Services

Michael Larson – OSU Cartography Services

This poster details the ongoing partnership between the American Association of Geologists Foundation and OSU Cartography Services in updating and reprinting the American Association of Geologists’ (AAPG) Geological Highway Map Series publications. This partnership, now eight years old, began with working on Petroleum production documents under the Boone Pickens Digital Geology Fund reserved for use by AAPG members. The Geological Highway Map projects are more accessible and available for public purchase. Examples of the work being done and which region’s maps are complete will be displayed.

Quantifying Historical Red River Farm Land Change Since 1970

Kushendra Shah – Noble Research Institute, LLC

Tresa Trammell – Noble Research Institute, LLC

Noble Research Institute’s Red River Farm lies in the southernmost part of Oklahoma. The property is bound by the Red River. The southern part of the farm that is adjacent to the Red River has undergone a series of changes from several decades. While the publicly available data has low spatial and temporal resolution, it is difficult to accurately map the loss of land due to the gradual shift of the Red River over time. The utilization of UAS technology with high spatial and temporal resolution data helps to better understand and quantify the change of the farm. With this information, we are able to estimate the economic loss of the land change.

Spatial Implications of Wind Power Buildout in Oklahoma

Lauren Wood – Oklahoma State University

Stephen J. Stadler – Oklahoma State University

The purpose of this poster is to examine the geography of suitability of Oklahoma for the installation of wind farms. The placement of wind farms in Oklahoma is important so as to ascertain areas most suitable and lessen the conflicts created by these large structures. Despite the stipulations placed on wind farms by Oklahoma Senate Bill 808, the hypothesis here is that there is enough suitable area for wind farms to be installed to meet the Department of Energy 2030 vision for Oklahoma.

Tulsa Regional Collision Analysis

Ty Simmons – INCOG

Understanding the cause of automobile-related fatality and injury collisions can shed light on potential solutions, especially when the cause is related to roadway design. The goal of this analysis is to identify roadways in the Tulsa region with the highest crash rates for fatality and injury collisions and determine if there are correlations between number of collisions and the number of lanes, lane widths, posted speed limits, and traffic volumes of those roadways. Identifying strong positive correlations may help to inform future roadway designs in the region. For the purposes of this study, roadways were ranked, based on the crash rate for fatality and injury collisions, by “segments.” Segments are defined as a stretch of roadway that is half the distance of the roadway between two intersections (not including intersections). Highways and neighborhood streets as well as roadway segments with fewer than 10,000 vehicles per day were excluded. Collision data for the years 2011 through 2015 was obtained from the ODOT Safe-T database and a crash rate by vehicle miles travel was calculated for this analysis.

A Vehicle Crash Analysis of the Oklahoma City Area Regional Transportation Study

Hayden Harrison – Association of Central Oklahoma Governments

With a growing population of over one million inhabitants, the Oklahoma City Area Regional Transportation Study encompasses 47 communities within 6 counties including Cleveland, Oklahoma, Logan, Canadian, Grady and McClain county. The communities within the OCARTS boundary experience an average of 27,000 car crashes annually. As new drivers emerge on the road daily, it is important to understand the causes behind an accident. Using crash data provided by the Oklahoma Highway Safety Office, an analysis of the accidents within the OCARTS boundary was compiled using ESRI ArcGIS and Microsoft Excel software.

| SCAUG is a not for profit organization dedicated to benefit users of ESRI’s geographic information software | Founded in 1990 | © SCAUG 2009 |
| South Central Arc Users Group | P.O. Box 96 | Ardmore, OK 73402  | Fax- 214-291-5659 | Email Webmaster | SCAUG Email |

Email me & I'll chat back at ya later, Tug out!!!

Follow us on Facebook

Powered by Wild Apricot Membership Software