South Central Arc User Group


Established 1990


 

September 17, 2019
 
Download Presentation Template


What’s new with the USGS National Geospatial Program

Claire DeVaughan - National Geospatial Program, US Geological Survey

This presentation will provide a variety of updates on activities of the USGS National Geospatial Program (NGP). Topics will include innovative applications such as: USGS LidarExplorer, 3DEP Point Cloud as Amazon Public Dataset (a.k.a. point cloud via the cloud), NHD Markup Application, US Topo GeoTIFFs, and YouTube tutorials on using The National Map products and services.



Streamlining Data Collection and Mapping with Collector and Triggers

John May, CSM, GISP - ESciences Inc.

Cloud based platforms coupled with ArcGIS Collector offer powerful and easy to use tools enabling users to interact with spatial and non-spatial data. However a complex data model can present challenges when attributes need to be retrieved from other feature classes or related tables. These challenges can be overcome with triggers that leverage native STGeometry functions and SQL. Imagine a well feature class whose attributes included items such as county name, county FIPS code, region, latitude, longitude, etc. Traditionally these would be derived from a combination of geoprocessing functions and manual data entry. A simpler approach would be to implement a trigger using the STGeometry functions available in your Enterprise database. With STGeometry you to can automate attribute collection without user interaction. A similar approach can be used to symbolize data on your web maps with information stored in related tables. Automating data with triggers will result in improved work flows, enhanced application usability, and reduced data errors.



Bringing the Dashboard Out of the Vehicle: Creating Dashboards at ODOT

Gwen Johnson and Devin Hargus - Oklahoma Department of Transportation

ODOT’s GIS Management Branch and Road Inventory Branch work closely together to maintain ODOT’s GIS data. The Road Inventory Branch is in charge of maintaining our roadway network and reporting to the Federal Highway Administration and the Oklahoma Tax Commission. The GIS Management Branch is in charge of all other data maintenance and mapping requests. Over the last year we have created a couple Operations Dashboards to assist relaying important information to upper management and County Commissioners. ODOT will discuss the steps taken took to create the County Certification Dashboard and the MAPS-21 Performance Measures Dashboard. We will start with the elements of a dashboard then add some lessons we learned and resources you can use for your own dashboards.



Maps and Advanced Data Collection in the Palm of Your Hand

LeAnna Kilhoffer - Oklahoma Water Resources Board

The OWRB measures about 904 water levels across the state of Oklahoma in January. This year we embedded the Survey123 Application into ArcCollector to link predetermined sites with a survey to collect data. We were able to take advantage of ArcCollector's ability to display sites on a mobile map, site specific important information, and even navigate to the site, AND use Survey123 to collect new complex site information including mathematical functions. Traditionally our work was done with field sheets, pen and paper, and lots of printed out site maps. We can now enter the data straight into the phone and have that data upload automatically to the web where it can be exported in to a multitude of formats, and can then be uploaded into our database in a single batch. To further facilitate sample tracking, staff had access to an Esri dashboard that gave real time stats on the state of sampling progress and access to all the water level data that had been collected.



The City of Midwest City’s use of Cityworks PLL for Code Enforcement

Greg Hakman, GISP; Cole Davis; Kelby Thomasson - City of Midwest City

The City of Midwest City has been an avid user of Cityworks AMS since their implementation in 2011. Recently the City has expanded into Cityworks PLL, one example is the use of PLL to manage code enforcement cases. The mobile application allows a user to select a location from a map, select a code enforcement case type, add in critical details, notes, and pictures from a mobile device, and ultimately create a case in Cityworks PLL and print and post the violation all while staying in the field. This presentation will cover how code enforcement integrated GIS and Cityworks PLL into their daily workflows creating greater efficiencies and collaboration among officers and other City departments.



City of Midwest City GeoHub – Gateway to Maps and Data for the Citizens of Midwest City

Greg Hakman, GISP; Bryan Salsieder, GISP – City of Midwest City

The City of Midwest City has created an ArcGIS Hub allowing citizens of Midwest City to access valuable information about their city in the forms of maps and open data. This presentation will go through the process of creating the Hub and an in depth look at the content currently available to the public and future growth of the Hub. It will also show how the internal ArcGIS Portal Sites pages for City departments are integrated to create a one stop location for both city employees and the general public.



Location Allocation of Sugar Beet Piling Centers Using GIS and Optimization

Nimish Dharmadhikari Ph.D., GISP - INCOG

The sugar beet is one of the most important crops for both social and economic reasons, even though the area under sugar beet cultivation in the Red River valley of North Dakota and Minnesota is comparatively smaller that of corn and other crop lands. It generates a large economic activity in local and regional level with a greater impact on jobs and stimulation of agriculture, transportation, and farm economy. Sugar beet transportation takes place in two stages in Red River Valley: the first step is from farms to piling centers (pilers) and the second step from pilers to processing facilities. This study focuses on the problem of optimizing piler locations based on supply variation. Sugar beet supply and harvest varies significantly due to numerous reasons such as weather, water availability, and different maturity dates for the crop. This provides for a variable optimal harvesting time based on the plant maturity and sugar content. Sub-optimized pilers location result in the high transportation and utilization costs. The objective of this study is to minimize the sum of transportation costs to and from pilers and the pilers utilization cost. A two-step algorithm based on the geographical information system (GIS) with global optimization method is used to solve this problem. This method will also be useful for infrastructure decision makers such as planners and engineers to predict the truck volume on rural roads.



Engaging Youth with GIS: Shawnee Geo Team

Cheyenne Branscum - Shawnee Middle School

There is a myth that somehow GIS is restricted to adults or is too complicated for youth. For the past two years, students in Shawnee have consistently proved otherwise. 6th to 8th graders have been using ArcGIS, drones, Survey123, underwater ROVs, and other GIS technology to gather and analyze data for their research projects. They have presented at conferences and entered their projects into competitions in both Oklahoma and Texas. The ultimate goal for many of them is to use their GIS skills to reach the top level of International Science and Engineering Fair (ISEF) and be selected for the Regeneron Science Talent Search. While these accomplishments and goals may seem to fit a well-funded school with a high socioeconomic status, the Geo Team smashes that myth as well. Shawnee Middle School is an ethnically diverse, Title 1 school where all students receive free breakfast and lunch. There may be barriers, but they do not prevent GIS from reaching Shawnee youth and do not need to prevent any youth from engaging with GIS.



Implementing the NG911 Address Standard in Oklahoma – How does it change my GIS data?

Lance Terry - State 911 Coordinator

Charles Brady - City of Ardmore

Mike Davis - ACOG

The Next Generation 911 (NG911) and Address Standard version 2.1 was adopted by the State of Oklahoma in February. As the national deadline for Next Generation 911 draws closer what changes need to be made to existing GIS datasets in order to meet the new standard? Why do these changes need to occur? What needs to be modified within existing datasets? What new datasets need to be developed? How do you maintain current functionality while integrating the new content? These questions among others will be discussed from the integrated perspective of a Municipality, a Regional Council of Government & the State of Oklahoma all working together.



Aiding Natural Disaster Response: Regularly Updating Storm Shelter Registrations through Automation

Kevin Gustavson - City of Tulsa, Information Technology Department, GIS Services

City of Tulsa residents can register their storm shelters online so that first responders can efficiently know where to look for people in a disaster situation. To aid in this effort, the City of Tulsa GIS Services has been conducting an annual update of its storm shelter feature class by manually geocoding the latest list of registrants each Spring. Using the updated shelter points, an updated storm shelter map book has been produced and emailed to the Fire Department, and a storm shelter web map has been automatically updated with the new points. This year, GIS Services decided to fully automate the process using ArcPy and the Task Scheduler. Once the Fire Department was notified of the new procedure and capabilities, they became curious about how GIS Services could further assist them. Through a series of planning sessions, they ultimately decided that they wanted weekly updates of the registered storm shelters, along with spreadsheets of the weekly changes to help them keep their CAD (computer-aided dispatch) system up-to-date. Now, a series of Python scripts fully automate weekly geocoding, map book and spreadsheet production, and delivery of updates via email.



Updating the INCOG Regional Traffic Counts Web Map using StreetLight AADT Estimates

Ty Simmons - INCOG

INCOG, being both the Metropolitan Planning Organization (MPO) for the Tulsa area and a Council of Governments, has always had a regional focus. One aspect of INCOG’s role as a regional entity is to compile traffic counts collected by the various municipal, county, and state governments in the Tulsa area into one map for easy public consumption. In 2014, a transition was made from the once paper only regional traffic counts map to an ArcGIS online web map, which has proven to be useful to the public. However, as time has gone by, many of the local governments in the region have eliminated traffic count collections from their budgets resulting in many out-of-date counts in the map. To address this issue and to have access to other transportation related data, INCOG purchased a subscription to StreetLight, an online transportation analytics data provider. This presentation will delve into the process that INCOG used to reformat the 2,500 plus traffic count locations in the region for use in StreetLight, obtain average annual daily traffic estimates for those locations, and finally convert them back into a point feature for use in our new AADT Estimates web map. The presentation will also focus on some issues we encountered along the way and how we addressed them.



Supporting Innovation Through Data Management and Metadata: the Path Forward

Thomas E. Burley, GISP - U.S. Geological Survey

Data management is critical for supporting any organization’s mission and objectives. As data volumes across all areas increase with the advent of new technology and sensor networks, risk increases for potential missteps with managing these investments and resources. There is arguably universal recognition of the importance of this topic, however it remains an elusive moving target for many agencies and businesses alike. Considering the elements of any organization’s data lifecycle, documentation will always be a common denominator. Metadata as standard documentation is the glue that binds it all together during and after the work is done, along with the other principal components of the data lifecycle, to help ensure that data can be understood and used. More importantly, data management creates a pathway for communication of quality products along with opportunities for innovative delivery of data and information.



Updating Wetland Maps for Resource Monitoring and Management in Oklahoma

Dan Dvorett - Oklahoma Conservation Commission

Wetland maps are a foundational component of resource management and are utilized in numerous planning activities including determination of potential impacts from development and discharges. The National Wetlands Inventory (NWI) represents a statewide digital map for the entirety of Oklahoma. However these maps are approaching 40 years old; given the dynamic nature of wetland ecosystems and improved mapping techniques, the Oklahoma Wetlands Program has made wetland map updates a priority. In the last five years we have remapped 6 watersheds totaling over 1.7 million acres. These areas were targeted due to identified inaccuracies in the NWI coverage, primarily resulting from highly ephemeral and forested wetlands. NWI maps were typically drawn on single-date base imagery, often during leaf-on periods. This procedural limitation made identifying temporary water and water obscured by tree canopies difficult, and furthermore, led to inaccuracies in attribution of flood duration to wetland polygons. We have utilized new mapping protocols involving high-recurrence satellite imagery from multiple seasons and multiple years to more accurately represent the extent and hydrology of ephemeral depressions and forested wetlands. Using decision tree classification of 51 Landsat images from 1994 to 2011 we mapped over 3,000 wetland units in the Pleistocene Sand Dunes Ecoregion along the Cimarron River, 700 more than the original 1980's NWI map. More recently, we have been developing protocols for updating floodplain wetland maps, by identifying Landsat imagery that coincide with periods of flooding determined from stream gauge data. With many rivers in Oklahoma incised, it is often difficult to determine the extent of connected floodplains by elevation alone. Identifying the extent of flooding during 1-3 year flood events, should improve the accuracy of floodplain wetland boundaries.



GIS for Small Water and Wastewater Systems

Ginny Holcomb; Gaylene Riley; Karen Conrad - Communities Unlimited

Rod Pratt - McCurtain County Rural Water District #5

In the age of digital solutions, it’s no wonder GIS is widely used in water and wastewater infrastructure mapping. Accurate location information and interactive maps ensure the ability to quickly and easily find components such as water lines, valves, meters, manholes, and hydrants – all within a single click. Detailed attribute tables serve as a one-stop-shop for planning and budgeting for future maintenance, as well as preparing for emergency response. In many cases, however, smaller water and wastewater systems lack resources normally available to larger systems, such as dedicated GIS staff and software. Communities Unlimited offers GIS mapping services to help these small communities affordably map their water and wastewater infrastructure, while providing these systems with the tools and training to manage and update their own GIS data. Using ESRI’s Collector app on a smartphone or tablet, GPS points are gathered and stored in the cloud, allowing data management operations to be completed both in the field using the Collector app and remotely using ArcGIS Online.



Old maps, story maps, and aerial photos: how Oklahoma State University Library is bringing Oklahoma's cartographic past, present, and future to life

Kevin Dyke - Maps and Spatial Data,Oklahoma State University Library

In this session I will demonstrate a number of projects underway in Maps and Spatial Data at Oklahoma State University's Edmon Low Library. These efforts seek to spotlight and preserve Oklahoma’s cartographic heritage, and also show how to make maps and tell stories with them. These projects include a spatial search interface for finding maps, a web-based tool for aerial photograph/map comparison, and, thanks to the generous support of the McCasland Foundation, the addition of hundreds of new maps to the Oklahoma Digital Maps Collection, bringing the total number of maps available online to the brink of 10,000. I will also discuss how we are integrating Esri's story maps into library exhibits, workshops, and classrooms.



Pipeline Safety: Identifying High Consequence Areas for Liquid Pipelines

Sheila McGinty, PhD - Williams

Safety is the most critical function of all pipeline companies. One part of pipeline safety is understanding what and where high consequences areas are and how a pipeline can affect them. High consequence areas are defined as “specific locales and areas where a release could have the most significant adverse consequences” (49 CFR 195). High consequence areas fall under three specific categories: population, unusually sensitive areas, and commercially navigable waterways. Populated areas are determined by the US Census bureau and broken down into highly populated and other populated areas. Unusually sensitive areas are critical drinking water sources and ecological areas. Commercially navigable waterways are defined by Congress and fall under the authority of the Corps of Engineers. Pipeline operators are required by federal regulation to determine what and how areas would be affected in case of pipeline failure. Pipeline companies are then required to build and manage a pipeline in order to prevent and mitigate damage. This presentation will focus on how GIS is used to determine high consequence areas, 3D spill modeling, and associated regulatory requirements for maintaining safe pipeline operation. The discussion will include existing pipelines as well as proposed pipelines.



Hidden Treasures Beneath

Kellie Lewelling - Oklahoma Corporation Commission

The Oil and Gas Division at the OCC is starting a new and exciting journey. Drones are beginning to be used to solve many problems in the oilfield. With the drones we can locate missing equipment after a weather event, assess polluted areas without getting too close, take measurements, and even locate wells up to 65 ft. beneath the surface. We will have 5 drones to cover all parts of the state, and approximately 15 people will be licensed. One of the drones will come equipped with its own LiDAR sensor and magnetometer. This ground-penetrating technology will aid us in locating old wells that were never known to have existed, allow us to see old pits, possibly prevent some spills and/or seeps, etc. The other 4 drones are going to be equipped with thermal cameras to show changes in heat signatures and check for gas leaks. Not only will this project help us find out more about what is under our feet, it will also add a layer of security for our field staff.



SUPERMAP: Truth, Justice, and the GIS way

Matthew Wormus; Amy Brittain - Oklahoma Department of Environmental Quality

Sharing our story is the top priority for the Oklahoma Department of Environmental Quality, one way to do that is using web based GIS. Recently, the DEQ has compiled a series of Story Maps and their new Dashboard developed for the OK Legislatures into one “Mega” Story Map. This new application compiles in one place spatial stories for the public. Learn how the application came to be, where the application is going next, and what lessons were learned along the way.



This Land is My Land: How Ownership of Real Estate Happens

Tami Mohow; Joel Foster - Canadian County Assessor’s Office

Private ownership of land has been a fundamental idea going back at least as far as early systems of writing but how does that happen in today’s world. How does anyone know, let alone map, who owns what land? This presentation will cover some basics on the types of documents that prove to the world, or at least the property tax system, that you own what you think you own. It will cover different types of instruments, or deeds, parts of those instruments, and some of the problems that could be encountered. It will also cover basics of legal descriptions used in Oklahoma, the peculiarities of real estate in Oklahoma, and how parcel data, which can be a fundamental GIS layer for many types of projects, is pieced together from those descriptions. It may even be helpful in general for all those who own or live on land.



Drone mapping at UNT Facilities

Peter Palacios - University of North Texas

This presentation will outline the journey of using drone technology for mapping purposes at the University of North Texas Facilities department. The department currently operates two unmanned aerial systems (UAS) and uses the derivative orthomosaic products to extract features for integration into the department’s GIS by using GNSS-enabled registration markers that allows them to georeference the images. The topographic derivative products also support campus planning.



Collector for Water Rescue

Lieutenant Ronald Vaughn - Dallas Fire Rescue

Summer time brings people to lakes for recreation. Individuals spend time on the water fishing, water sports and relaxing. Unfortunately accidents do occur on lakes and some of these individuals need assistance.

In this presentation I will show how Dallas Fire Rescue has begun using the Collector App to assist in Water Rescue.



Label Manager, ArcMap BFF

Pamela Jurney - Cross Timbers Consulting, LLC

Are you one of those people to whom using ArcMap comes easily? Like it’s smooth sailing to navigate through the software? Yeah, me neither. ArcMap is hard but sometimes you find tools that make your mapping life a lot easier. Label Manager is one those things. I have often called in my ArcMap BFF. It gets me, I can communicate with it, and in the end, it helps me (well, my map) look good. So, if you want to explore label classes, expression queries, placements, abbreviation dictionaries, and more, join us for this Label Manager / Maplex Label Engine session.


Excel-lent Preparations

Pamela Jurney - Cross Timbers Consulting, LLC

Do you recall one of the standard definitions of GIS – Digital Mapping with Data Management? This presentation is all about data management in Excel. We will look at efficient ways to clean up and organize U.S. Census data. We will explore formula expressions. We will build pivot tables to summarize data. We will dabble with arrays (a formula that can perform multiple calculations on one or more items). In this session, we will share ideas and techniques to save time and ensure accuracy.



Supercharging Survey123

Christopher L. Rogers - Quantum Leap Geospatial Intelligence Solutions

This presentation, “Supercharging Survey123”, will introduce you to several powerhouse features that can be implemented through Survey123 Connect. Officially released at Esri’s 2016 User Conference, Survey123 for ArcGIS has continued to make its mark in the GIS user community while maturing at a rapid pace. Built upon the XLSForm and ODK XForm Standards, Survey123 for ArcGIS is a powerful and intuitive form-centric data collection tool which can transform paper forms and field data collection into “Intelligent Workflow Processes”. New Survey123 features and bug fixes are released about every six to eight weeks making it a challenge for even the best end-users to keep up with and take advantage of all these new capabilities. Survey123 can also be easily integrated with other Esri solutions such as Web App Builder, Workforce, Operations Dashboard, and/or Story Maps. If you want to find out how to improve your data collection and analysis workflows while taking advantage of the advanced features in Survey123 for ArcGIS then this session is a must.



Making Lawton Beautiful with ESRI Solutions

Judy Franco - City of Lawton

When the City of Lawton started looking for a citizen engagement app, the GIS division to the initiative to show what GIS can do. With the use of ESRI’s solutions, ArcGIS Online, and Portal, we were able to empower our citizens with the tools to report issues in their neighborhood or around the City of Lawton. It provides management to view the status of issues and how quickly it is resolved.



GIS in Economic Development

Ashley Hicks - Greater Oklahoma City Chamber

The Chamber is directly involved in economic development efforts to attract new businesses and quality jobs to the Greater Oklahoma City region. This presentation will cover how GIS is used in the process of attracting those companies as well as other every day practices at the Chamber.



Application of State Natural Heritage Program Databases for Biodiversity Planning and Research:

The Oklahoma Natural Heritage Inventory and the Oklahoma Biodiversity Information System (OBIS)

Bruce Hoagland; Todd Fagin - Oklahoma Natural Heritage Inventory / Oklahoma Biological Survey

The Oklahoma Natural Heritage Inventory (ONHI) is legislatively mandated to maintain dynamic, georeferenced information on the state's biological diversity, including rare and endangered species, species of special concern, and significant ecological communities. ONHI biologists conduct field inventories to find and evaluate occurrences of species and communities throughout the state. These data, as well as biodiversity data collated from a variety of sources, are stored within a centralized database, the Oklahoma Biodiversity Information System (OBIS), for dissemination to researchers, state and federal policy makers, educators, and other interested parties. ONHI is also one of the few state heritage programs located at a university and that effectively services as both a research unit and a state agency. We present several ongoing ONHI projects, with a focus on the Oklahoma Biodiversity Information System, to demonstrate the role state natural heritage programs can play to inform biogeographic knowledge, assess biodiversity and species rarity, provide consistent methodology and standards for data storage and dissemination, and aid biodiversity conservation from the local to global.


Fun with Projections: When the Misuse of a Projection Causes a Kerfuffle or a Brouhaha

Michael Larson – Oklahoma State University Cartography Services

How many times have we opened up a third-party data set only to scratch our collective heads and wonder what projection is this and why does it not match my existing data? Or, how many times do we accept the software defaults not knowing we can or even should change the projection parameters? This presentation will briefly examine the basic properties of projections and explore what can happens when we get it wrong.




| 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