2013 OKSCAug GIS conference summary of presentations
Title: Modeling Obstructions in Controlled Airspace Near Randolph Air Force Base
Presenter: Wesley Keller
Company Name: City of Universal City
Abstract: Construction of tall objects near an Air Force base or airport can be complicated by the fact that air space must be tightly controlled to prevent collisions between aircraft and obstructions. Air space is controlled through the implementation of virtual surfaces called "air space imaginary surfaces". The City of Universal City in an effort to create an additional revenue stream is considering leasing some publicly owned land to cellular communications companies. Site selection is difficult because Randolph Air Force Base imaginary surfaces completely overlapUniversal City. Due to this fact modeling of cell tower heights in relation to these imaginary surfaces was required for site pre-selection and elimination.
Title: Oklahoma Oilfields From the Air: Historical Aerials and LiDAR
Presenters: Madeline Dillner, Kellie Duncan, Charles Lord, Jeff Myers
Company: OK Corporation Commission
Abstract: There are two tools that the Corporation Commission uses more than others to keep track of oil and gas well locations over time, across the state: historical aerial photos and LiDAR. By showing us how a well site’s condition progressed over time, historical aerial photos allow us to track leaks, spills and potential pollution and find the correct responsible party for pollution cases. The extremely high-resolution hillshade/DEM combination LiDAR will show both active production and injection sites which may be hidden (by vegetation etc.) in aerial photos, and the topographic evidence of past oil and gas field operations. By using a combination of these aerial systems, the Corporation Commission is better able to watch over oil and gas E&P activities across the state and respond swiftly and accurately to both recent spill complaints and discoveries of historic pollution.
This presentation will explain the production of historical aerial photos and their acquisition, georectification, and use at the Corporation Commission. The Commission is attempting to acquire for GIS use all aerial photos across the state since 1937, and will make this information available to others. We will also show examples of LIDAR use.
Title: Data Driven Approach to Crime and Traffic Safety: Utilizing Limited Law Enforcement Resources
Presenters: Jason Redden and SGT Gary Schmidt
Company: Norman Police Department
Abstract: The City of Norman Police Department has been utilizing the Data Driven Approach to Crime and Traffic Safety (DDACTS) model to apply the concept of high visibility enforcement techniques with the usage of hot spot policing and GIS techniques to target key locations and time periods to make the most impact with current limited resources.Two target zones with areas of approximately one square mile were selected to apply the DDACTS concept to reduce crime and improve the traffic safety in the area. Crime data and crash data was extracted from the Record Management System and used to develop DDACTS products to direct resource allocation and enforcement operations. A GIS Python tool was developed to spatially distribute crash locations at intersection to better identify crash patterns for traffic enforcement. Contributing causes, time of day and day of week were extracted to aid the traffic enforcement process. Kernel density analysis methods were utilized to determine high crime and crash locations in the City boundary and the DDACTS Zones. Weekly overview reports were developed for police personnel to display the current crime locations and reconnaissance packets were develop to determine possible future crash and crime locations based on the previous five years of crash and crime data available. Current crime and crash patterns area utilized to fine tune resource deployments in focused operations. The general overview of the Norman DDACTS program is to provide crime and crash information to law enforcement officer through the weekly reports for current situational awareness, crash and crime trend analysis for tactical deployments and reconnaissance research for strategic planning and operations of police resources.
The current DDACTS program has been successful in reducing crime and has shown to have an impact on traffic accidents in the areas of high visibility enforcement. The City of Norman experienced a 20% crime decrease in Larceny from Vehicle from 2011 to 2012. During May 2013 the Norman Police Department applied department resources to an identified accident hotspot area along 12th Ave which resulted in a significant decrease in the crashes experienced for the month and also had an observable reduction in crime in the surrounding area.
Title: The role of ESRI GIS Technology in the City of Oklahoma City's response to theMay 2013 tornado and flooding events.
Presenter: Chris Ksepka
Company: City of Oklahoma City
Abstract: ESRI’s GIS technology plays a key role in each phase of Oklahoma City's emergency operations. The integration that exists among the systems Oklahoma City staffuse to plan, respond, and recover from disasters originates from GIS software and data. Collection and distribution of key information occurs during each phase of the response process. Much of that information has a spatial component. This presentation will highlight some of the systems, data, and processes Oklahoma City has in place to help staff respond to an event like the May 2013 tornado and flooding outbreak.
Title: Using GIS to Evaluate Groundwater Pollution Risks from Old Oilfield Areas
Presenters: Patricia Billingsley and Madeline Dillner
Company: OK Corporation Commission
Abstract: In the past 16 years the Corporation Commission has responded to many well water pollution complaints, and has taken over 2,000 ground water samples from wells, springs, borings, and monitoring wells across the state. We have found numerous groundwater pollution problems, most often related to old (first drilled pre-1980, often abandoned) oil and gas fields. Most of the groundwater pollution problems are related to petroleum or salinity, but there have also been occasional impacts from heavy metals, sulfate, and other pollutants.
Some of this pollution is just in the fairly shallow subsurface waters. However, in other cases deeper water wells and portions of aquifers have become polluted. In this talk we will show how we are using GIS to map and evaluate where different types (chemical signatures) of groundwater pollution has been found, the pollution depths, areas, aquifers impacted, and the proximity to the old oilfields.
Title: GIS in Education: Examples from Tulsa Community College
Presenters: Kelly Allen, PhD, GISP
Company: Tulsa Community College
Abstract: The establishment of GIS in educational institutions has become quite common in the last 20 years. At Tulsa Community College students have the opportunity to earn a Certificate of Achievement in GIS. The certificate program provides students with a chance to gain technical knowledge and skills in GIS. The program is completed with students gaining experience by working on a community project. Examples of some of the student’s work include mapping meth labs for the Tulsa Police Department, bathymetric mapping of a lake in Sand Springs, and flood plain analysis for the military.
Demand for geospatial skills and knowledge continues but there still remain challenges to institutions providing training and education in the geospatial field. TCC’s GIS Certificate Program, initially developed as part of an ESRI grant, has gone through a number of changes in the past few years. Curriculum continues to be updated and the expansion of academic options for students is being developed.
Title: Address Standards Progress and OKMAPS E-911 Project
Presenters: Shellie Willoughby, GISP, Charles Brady, III, GISP
Company: OK Office of Geographic Information, City of Ardmore
Abstract: Two years ago the State GI Council developed a workgroup to create Address Standards for the State of Oklahoma. With the help and input of the OK GIS Community a draft version of the OK Address Standards are out for community review. As a result of this project 9 counties in southern
Title: The National Geospatial Program: The National Map, Program Priorities and Emerging Trends
Presenter: Darryl S Williams
Abstract: The National Map (TNM) is the primary program of the U.S. Geological Survey’s National Geospatial Program (NGP), and has come to be known as one of the primary sources of GIS related geospatial data within the U.S. Geological Survey. The presentation will provide you with an update about the new 2013 US Topo Map coverage for the State and other ongoing activities relevant to Oklahoma and the Nation. Included will be information on the evolving 3D Elevation Program (3DEP), crowdsourcing activities for the Structures data layer of TNM (how you can participate), and the transition to interfacing with focused Communities of Use (COU) as primary sources of requirements gathering and user feedback for the National Geospatial Program and TNM.
Title: Selling GIS
Presenter: Sheila McGinty Wilson, PhD, GISP
Company: Select Engineering
Abstract: GIS is a critical tool within any industry yet we struggle with how to effectively describe GIS and the importance of the people doing the work. This talk with explore and provide innovative ways to educate non-GIS people about GIS. Participants in this presentation will leave with ideas and tools in hand that can be used to communicate the extraordinary value of GIS and the people who know how to use it. Participants will be equipped to share GIS with colleagues, managers, and CEOs. We will be better prepared to promote GIS within our companies, in job interviews, sales, and marketing. The end goal of promoting GIS is to strengthen the industry and the people doing GIS, thereby increasing our value to our employers and other industries.
Title: The GSI Tornado Website for Disaster Recovery
Presenters: Bill Bean, GIS Web Application Developer, Manerd Gayler, Director – GeoSpatial Information
Organization: The Chickasaw Nation Department of GeoSpatial InformationAbstract: In May of 2013, the National Weather Service reported more than 25 tornadoes that culminated in 200 miles of damage in Oklahoma from May 19 to May 31, 2013. Many Oklahomans were devastated by these tornadoes; several of which were Chickasaw citizens and employees. To aid and support the Chickasaw Disaster Relief and Recovery, the Chickasaw Nation’s Department of Geospatial Information created an ESRI ArcGIS web application used at the Chickasaw Command Center. The Chickasaw Nation Emergency Management System (EMS) web application is based on the ArcGIS API for Flex 3.1 and allowed thousands of addresses to be geocoded. With the tornado path already projected, EMS efficiently located those Chickasaw citizens and employees affected by the tornadoes. Post-imagery of the May 20th, Moore tornado (provided by Bearingtree & Pictometry) was utilized to compare and assess the damage in specific locations. The post-imagery allowed a citizen or employee to view their location and help workers understand the extent of their damage. The EMS application allowed Chickasaw Nation volunteers to start the clean-up process for those homes affected.EMS was also used to view possible damage to citizens affected by the Colorado wildfires in June. In the future, EMS could be used in Disaster Relief and Recovery efforts for Chickasaw citizens and employees affected by hurricanes, wildfires, and earthquakes
Presenters: Kenny Legleiter, GISP
Abstract: Accurate and current geospatial data is vital for business activities of state and local governments. Mr. Legleiter will discuss the necessity, requirements, and management of some of the key base layers that are critical for most geospatial activities. These include aerial imagery, LiDAR, oblique imagery, road centerlines, parcels and addresses to name a few. Some of these base layers will be discussed in this presentation and various models for acquiring these data that create efficiencies and lower costs for everyone. Mr. Legleiter will explain how local and statewide data programs can be structured and be more suitable for maintaining these base layers versus ad hoc acquisition projects at the local level.
Title: City of Edmond, Oklahoma – Mapping the Gracelawn Cemetery
Presenters: Christy Batterson and Ian Peebles
Organization: City of Edmond, Oklahoma
Abstract: The City of Edmond maintains Gracelawn Cemetery which was established in the late 1800s. Since the early 1990’s cemetery records were maintained in an old database and in paper records. There was a need to transfer existing cemetery records into a spatial referenced database. The city’s GIS team began working with the city clerk’s and cemetery staff to initiate a conversion project from an obsolete database to a GIS database and mapping solution. Goals within the project included transferring existing database records as well as hand written records, mapping cemetery blocks, lots and spaces, providing record searching capabilities and developing tools for maintaining and updating records. These tasks were accomplished utilizing several ArcGIS tools, GPS collection and analysis of existing data/plats. The final product included an ArcGIS Server application that is utilized by the city to support the public. This presentation explains the processes involved with the project, the results, challenges and future development of the cemetery application.
Title: Tomnod Crowdsourcing System and the Moore Tornado
Presenter: Luke Barrington
Abstract: In response to the tornado in Moore, OK on May 20, 2013, DigitalGlobe tasked its satellite constellation to capture imagery of the area as part of its FirstLook service. The high resolution WorldView-1 and GeoEye-1 satellite imagery revealed the vast extend of the damage caused to homes and buildings in Moore. The Tomnod crowdsourcing system was immediately deployed to engage the public's help in mapping the damage and converting the plethora of pixels to information. Users arriving at Tomnod.com were asked to view imagery and identify destroyed buildings, tarped roofs, and fallen trees. On the backend, we constantly analyze the CrowdRank score of each location and each member of our crowd. CrowdRank is a statistical reliability algorithm that combines the crowd’s inputs to zero-in on the most accurate results. Within 60 minutes, we collected over 15,000 points of interest from the crowd and published a crowdsourced damage assessment map.
The Tomnod approach is most powerful in situations where rapid insight is required in order to enable fast decision making. Crowdsourcing reduces the time between data collection and decisions. Therefore, it is critical to distribute these results quickly and efficiently. The damage assessment map is immediately available in a variety of formats such as SHP, WFS, and KMZ. In the produced KMZ file we include an image chip of the location that had been damaged accessible in a lightweight package.
Title: Business Practices Using GIS
Presenters: Mark Zitzow-Research Coordinator, Eric Long - Research Economist
Company: Greater OKC Chamber of Commerce
Title: Using the Leica Zeno implementation of Arcmap & Arcpad to preserve accuracy metadata
Presenter: Nathan E. M. Mayer, PLS
Company: Geomatic Resources, LLC
Abstract: GIS data can be valuable without being spatially accurate, however in certain cases its valuable is increased many fold by being spatially accurate and having spatial metadata proving its pedigree.
This presentation will detail from beginning to end, the process of creating a project, sending it to the field, collection of data, importing data and producing a final map.
Title: Access Midstream - Chronology through Story Maps
Presenters: JP Reynolds, GIS Intern, and Katy Rich, GIS Manager
Company: Access Midstream
Abstract: Story maps are incredibly useful in reaching out to, and educating, people who have little experience with GIS or custom web maps. While there is some additional backend and development work in creating a story map, the end product is something which is far more aesthetic and user-friendly than an MXD or PDF. The Access Midstream historical map is an example of the flexibility and power of story maps. It is based on the Esri “Playlist Story Map” template which draws the user into exploring an ArcGIS Online map service, which is supplemented with thumbnails, pictures, and a rich set of descriptive text about the company’s history. This presentation will cover the steps involved in planning, creating and deploying the story map and attendees will see a demonstration of the end product.
Title: Upgrading Asset Management Systems: Cityworks Desktop to Cityworks Server
Presenters: John McIntosh, Joyce Green, Larry Knapp, Rick Hoffstatter (City of Norman) and Jeremy White (Azteca Systems, Inc.)
Companies: City of Norman and Azteca Systems, Inc.
Abstract: The City of Norman manages and maintains 572 miles of water mains and 485 miles of sewer over a 73 square mile area. Until 2000, the City used a patchwork of methods including an in-house system to help manage the water and sewer facilities. Tasks such as needs assessments and analysis were difficult and time consuming with this ad hoc approach. In 2000, the City began using Azteca Cityworks®, an asset management system, to support management of the water and sewer facilities. Cityworks has provided a unified system that is well integrated with our GIS and facilitates management and analysis needs.
Cityworks is closely integrated with ArcGIS. Until earlier this year, we ran ArcGIS Server 9.2 and in recent years this has limited us to older versions of Cityworks. The City upgraded to ArcGIS Server 10.1 earlier this year and has been able to upgrade and deploy the latest server and browser based version of the Cityworks application. This has allowed us to take advantage of the product enhancements and to streamline administration and support for end users.
Changes in the functionality and interface between the older desktop version and the browser based version of Cityworks are significant from the perspective of the end users. To facilitate the upgrade, the primary users attended training sessions provided by Azteca as part of our upgrade process and the GIS division has provided individual assistance as needed. We have plans to expand use of Cityworks to our Street Maintenance Division. In this presentation, we will provide an overview of the Cityworks Suite and discuss issues relating to the City of Norman’s deployment and upgrade to Cityworks Server and plans for expanded use.