2018 okSCAUG oklahoma city CONFERENCE SUMMARY OF PRESENTATIONS
September 25, 2018
How the Census Tract Program shapes the future for your local government.
Colin Kraus - U.S. Census Bureau
The decennial Participant Statistical Areas Program (PSAP or Census Tract Program) provides a unique opportunity for local officials to refine the statistical geographies of their area. This discussion will illustrate the process and the outcome of a well-designed tract and block group plan.
Developing an Open Data Site and Responsive Mapping Applications
Joyce Green, Michelle Matthews, Rick Hoffstatter, Scott Woodruff - The City of Norman
Since 2005, the City of Norman has provided the public interactive web access to GIS maps through custom coded applications. When the City of Norman chose to upgrade from 10.1 to 10.5.1, some of the custom web applications had functionality that was not compatible with the new version. This is the second time in the last decade that required upgrades to the core ArcGIS software made it necessary to redevelop our browser based GIS applications. GIS Services staff had to decide whether the city was going to expend resources upgrading those applications to work with the current version or move that functionality to configurable applications. It was determined that we would move as much functionality as possible to Esri’s configurable applications using ArcGIS Online and ArcGIS Hub. There were two forces driving the decision. The first was Esri maintains ArcGIS Online, so hopefully we will not get into a situation where an upgrade will put the city in the position of having to rewrite large sections of applications. The second reason is that both the ArcGIS Hub and the applications that were configured in ArcGIS Online feature responsive design. This allows our clients to view applications on their preferred device whether it is a mobile phone, tablet, or desktop computer. Our current applications did not incorporate responsive design. Norman used a combination of ArcGIS Server, ArcGIS Online, Web App Builder and Story Maps to move existing functionality to the ArcGIS Hub. This presentation will highlight Norman’s Open Data & Mapping site and some of the core applications that were migrated, including our General Base Map, Oil and Injection Well Locations, and Curbside Recycling applications. It will also highlight some new applications that the experience has allowed us to share though the Hub, ArcGIS Online and social media.
What’s Happening in My Watershed? How Implementing GIS to Utilize Spatial Data and Digital Collection Techniques can Help Solve Watershed Issues
Mindi J. Parsell - City of Tulsa Stormwater Quality
What’s happening in my watershed? Is a common question for Stormwater Quality professionals to ask themselves. Technological advances and improvements in data continually change the way we find the answer. Using the new technology available, including GIS, can help with understanding what is causing changes in watersheds. GIS can also be used to target areas that need special attention to improve the health of the waters.
The City of Tulsa is moving toward fully implementing GIS and an asset management system to manage our work flow. These systems will expedite reporting, make the data set more robust, and improve the ability to implement spatial analysis. This will allow Tulsa to better target the cause of water quality issues and improve the overall health of its waters going forward.
A Spatial Look at Vehicle, Bicycle, and Pedestrian Crashes in Central Oklahoma
Charlotte Adcock and Stuart Campbell – Association of Central Oklahoma Governments (ACOG)
National crash rates are steadily increasing according to the NHTSA and, while the opposite is true for the state of Oklahoma, crash rates are also increasing in the Oklahoma City metro area. Early this year, ACOG staff conducted a regional crash study to identify and analyze problematic intersections and corridors for all users of the roads. Utilizing GIS, staff visualized crash hot-spots for vehicles, bicycles, and pedestrians, and calculated the number of crashes at intersections, around bus stops, and near schools. After receiving feedback from ACOG committee members, staff expanded upon their initial work to include additional data analysis and develop a user-friendly report using ArcGIS Online’s story map application. At this year’s Oklahoma SCAUG meeting, ACOG will present some of the study’s findings and detail steps taken.
Deploy ArcGIS Enterprise in the Cloud for a few dollars a day and get powerful reporting for free
John May - ESciences Inc.
The current mix of web-based GIS data viewers suffer from having little to no reporting or data automation capability. With support for Microsoft Azure ESRI delivers a solution that is inexpensive and will deliver a wide range of powerful reporting and automation tools for free. Integrating Sql Server Reporting Services (SSRS) with ArcGIS in Azure delivers the ability to create, deploy and manage traditional paginated reports as well as Mobile reports which are device aware. With SSRS you can create parameterized reports that incorporate sub-reports, charts, Tablix objects, and more. Reports can be leveraged for all your spatial and non-spatial data stores and are deployed through a web portal and can be viewed in any modern web browser. Azure also delivers data automation tools so that different actions can be automated to meet different data results. With SSRS and AZURE any GIS data viewer can have a powerful reporting and automation capabilities for just a few dollars a day.
Saving Time and Money on your Map Exports by switching to Python!
Sam Coldiron - Oklahoma Department of Transportation
This presentation will walk you through the basic steps of setting up your own map export scripts using Python! It will start out with the building blocks of a good export script and then it will add on some additional suggestions for those more complex situations.
NHD Markup Application
Claire DeVaughan - US Geological Survey
There are several tools available that can assist in the use of National Hydrography Dataset (NHD) data. The Markup Application is a recently released web-based mapping communication tool that allows users to suggest edits, or “markups”, to the NHD, Watershed Boundary Dataset (WBD), and NHDPlus High Resolution (NHDPlus HR). Anyone with a gmail account can suggest corrections and improvements to the data. The application has been designed to work in the Chrome Web Browser only. Suggested edits will be reviewed by the USGS and the NHD state stewards before they are approved for incorporation into the NHD or WBD datasets and future NHDPlus HR Refresh products. Markup review and status changes will be handled through the Markup Reviewer tool – an ArcGIS Add-in tool available to NHD and WBD stewards and editors. This presentation will provide a demonstration of the Markup Application, and discuss the life cycle of the markups.
The Choropleth Map: How to Use it and Why.
Michael P. Larson - OSU Cartography Services
The choropleth map is a very common mapping technique used to depict thematic areal data. When viewed within the context of the historical development of cartography, the choropleth mapping technique is a relative newcomer. With its ease of creation and use, the choropleth map has become massively popular in recent decades, especially in the world of social media. This presentation will look at the structure of the choropleth map, discuss its strengths and limitations, and identify things that should be avoided. Lastly we will discuss some design tips that can be used to create a “better” map.
Manipulating Tabular Data using Pandas
Clay Barrett - OSU Cartography Services
The majority of my job as a GIS Specialist is not actually mapping, it’s preparing data. This is a task that I’ve come to realize neither ArcMap nor Excel are best suited for. Instead there is library called “Pandas” built to extend the capabilities of Python to include efficiently managing tabular data. This presentation will feature a live demo of reading, manipulating, basic analysis, and outputting files using Jupyter Notebook.
Overview of GISCI and GISP Process
Bill Hodge, GISP - GISCI
This presentation will present an overview of GISCI and the process for the GISP. It will provide a look at the exam, its development process, and the future of the certification.
The GIS Certification Institute (GISCI) is a tax-exempt not-for-profit organization that provides the geographic information systems (GIS) community with an internationally-recognized, complete certification program. GISCI offers participants from the first early years on the job until retirement, a positive method of showing value for professionals and employers in the GIS profession. There are currently over 8000 active GISPs located throughout the world.
The current GISP Certification process consists of a portfolio that describes an applicant's background in Ethics, Education, Experience, and Contributions to the Profession. That application, accompanying documentation, and payment are submitted, and the review generally takes from 30 to 45 days for approval.
The GISCI Geospatial Core Technical Knowledge ExamR has now been developed and added to the GISP Certification process. It is based on a job analysis, informed by the GIS &T Body of Knowledge, and guided by the Geospatial Technical Competency Model (GTCM). It is offered twice each year, in the Summer and Fall.
Making old maps feel new again: Initiatives underway at Oklahoma State University Library’s Maps and Spatial Data
Kevin Dyke - Maps and Spatial Data,Oklahoma State University Library
Paper maps contain a vast amount of spatial data. Most of this data is unavailable in any other form. In this session I will demonstrate a number of projects underway in Maps and Spatial Data at Oklahoma State University's Edmon Low Library. All of these efforts seek to spotlight and preserve Oklahoma’s cartographic heritage. These projects include a spatial search interface for finding maps, a web-based tool for aerial photograph comparison, the 3-D reconstruction of a no longer extant campus building, 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. In addition to sharing these initiatives with everyone at OKSCAUG, I would like to hear from attendees about what sort of historical resources they use the most (or would like to use the most). Feedback like this will be instrumental in guiding future developments.
Save a Thousand Words: Environmental Story Maps – Complex Information in a Clear and Effective Format
Amy Brittain and Matthew Wormus - Oklahoma Department of Environmental Quality
The Oklahoma Department of Environmental Quality (ODEQ) utilizes ArcGIS Online Story Maps as way to share key topics with the public. These Story Maps allow ODEQ to organize and display information in a way that is easy to follow and understand. Story Maps have proven to be extremely beneficial to ODEQ in providing information online and at public meetings. This presentation will talk about the thought process behind and the success of ODEQ Story Maps.
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.
Corporation Commission's deployment of an open source, GIS web application to address earthquakes.
Phil Bailey - Oklahoma Corporation Commission
Development of an open source, GIS web application (OCC Well and Seismic Monitoring aka OWSM) has decreased response times by at least 1-2 orders of magnitude in investigating earthquakes in Oklahoma. Implementation of OWSM has allowed the Induced Seismicity Department the capability to explore, monitor, and analyze multiple internally and externally hosted datasets in a fraction of the time than before. This, in turn, has given decision makers within the Division, data-driven answers when it matters most. Multiple oil and gas producing States have begun assessing the need for such an application. Instances of earthquakes related to oil and gas activity has been documented in multiple States.
Implementing the NG911 Address Standard in Oklahoma – How does it change my GIS data?
Lance Terry - Oklahoma Emergency Management
Michael Davis - ACOG
Charles Brady III - City of Ardmore
As the national 2020 deadline for Next Generation 911 draws closer what changes need to be made to existing GIS datasets? 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.
This is a panel discussion.
Modernizing Broken Arrow Fire Department’s Annual Hydrant Inspection Process using ArcGIS Collector and Operations Dashboard
Mark Steward - Assistant Fire Chief, Broken Arrow Fire Department
Willard Gustafson - Meshek & Associates LLC
Broken Arrow Fire Department had grown tired of tracking their annual fire hydrant inspections on paper forms and approached Meshek to develop an iPad Application for the Firefighters to use for their fire hydrant inspections. Using Broken Arrow's existing GIS data Meshek configured several webmaps in ArcGIS Online. One of these webmaps was configured for use within Collector, one was created for use in an Operations Dashboard to track the Inspection progress, and another was created for use in an Administrative QA/QC map application.
Once these maps and apps were configured, Meshek provided on-site training for the Broken Arrow Fire Department staff to use the configured applications to perform field inspections using ArcGIS Collector, monitor the inspection progress with Operations Dashboard, and perform basic QA/QC checks with the BAFD administrative map application.
We will discuss and demonstrate Broken Arrow Fire Department’s ArcGIS Collector Fire Hydrant Inspection Application, the Operations Dashboard, and the QA/QC Map Application. This project is currently ongoing, so we also will have the opportunity to discuss the real-world challenges faced when deploying applications like these across an entire fire department for the inspection of nearly 6000 hydrants.
Professional Development in GIS Roundtable Discussion
Pamela Jurney - Cross Timbers Consulting
Willard Gustafson - Meshek & Associates
This roundtable discussion will foster an open discussion about Professional Development in the GIS industry. We invite all attendees to consider the various ways in which they have developed professionally. What worked and what didn’t work, and how might they do things differently today considering what they now know. If you are a seasoned GIS Professional please consider what advice you might have for aspiring GIS professionals, and if you are an aspiring GIS professional, come prepared with your questions about what skills to focus on to maximize your development potential.
This is a roundtable discussion.
Story Map on Why Sharing Information Makes Communities Safer
Lieutenant Ronald J Vaughn - Dallas Fire Rescue
In Public Safety it is important for agencies to share information. The days of Public and Private Sector Agencies keeping information in silos are over. Our communities are under constant threats. Active Shooters in our schools, places of worship, and entertainment are a common occurrence. Bombings at Special Events and attackers using vehicles to harm others are now this Country’s reality. These incidents show the importance of why agencies on every level must share information to protect our communities.
In this Presentation I will use a Story Map to discuss how GIS is used to share information between Dallas Fire Rescue and the Dallas Police Department. The information will show how Dallas Fire Rescue makes decisions to ensure effective operations in collaboration with the Police and other agencies.
Enhancing Collision Data Analysis and Road Safety Audits Using GIS
Terry Holman - Chickasaw Nation | Roads Program
The Chickasaw Nation Roads Program provides a look into the utilization of various GIS technologies to simplify and strengthen efforts in motor vehicle collision data analysis, and to promote a more thorough approach to safety planning through data-driven road safety audits.
An Introduction to Mobile Mapping and Mass Data Collection
Jimmy Jordan - AllTerra Central (formerly Western Data Systems)
Digital mobile mapping, the methodology that integrates digital imaging with direct geo-referencing, has developed rapidly over the recent years. What used to be a topic of academic study has become a commercially viable industry. See how this revolutionary technology allows you to rapidly collect massive amounts of data in a single visit to the field, giving you the power to analyze and utilize the data you need when you need it. This session will provide a look into how the technology works, advantages over traditional collection methods, and use cases for digital mobile mapping.
Enterprise Service Performance Tuning and Application Usage Patterns Based on Monitoring Tools
Ray Hardy, GISP and Carrie Landgraf, GISP – Williams
Williams has a robust enterprise GIS, providing data, services, web maps and mobile applications used by hundreds of employees. Capturing application statistics is imperative for identifying usage patterns and trends. Understanding the statistics allows us to increase productivity by making sure the right solutions are available. Continuous monitoring provides metrics to ensure the enterprise system is tuned and running efficiently. Together, GIS Business and IT, are leveraging Esri’s ArcGIS Monitor, MXDPerfstat and Latitude Geographic’s Geocortex Analytics. These efforts are proactively improving service performance, defining performance standards, and tailoring targeted enhancements and communications to end users.
GIS & The City of Midwest City – Current Technology & Solutions
Greg Hakman, GISP, Kelby Thomasson, & Marianna Sikkar - The City of Midwest City
GIS has long been a strategic asset within the City of Midwest City and has provided countless solutions to our departments from simple maps to data collection efforts, various analyses to online maps in order to help each department answer the questions of where and why. This presentation will provide an overview of the current GIS activities and tools available to the City of Midwest City GIS team and how we are using those to provide spatial solutions and helpful data to our departments and citizens. We’ll cover what GIS products we are currently using on a daily basis, various technology available to us to capture strategic data, and future growth and direction of GIS within the City of Midwest City.
Improved 9-1-1 Indoor Location Accuracy for Mobile Devices
Ron Helterbrand - Geo-Comm
Intro to Story Maps with Oklahoma County: A look at the Mother Road.
Tim Conner, Kareem Burch, Gary Johnson, and Mike Morrison - Oklahoma County Assessor’s Office
In this presentation you will find out how to use ESRI’s StoryMaps to display information in a way that PowerPoint just can’t keep up. We will explore Route 66 as it goes through Oklahoma County as well as look at a few that other creators made to show the broad selection of themes you can select with StoryMaps.
Understanding the Impact and Role of GIS Data in Legacy 9-1-1 versus NG 9-1-1
Mary Harris - Southwest Oklahoma Regional 9-1-1 Association (SWODA)
There is much industry hype about the importance of GIS data in NG9-1-1 and for good reason. We will quickly review the role of GIS data in legacy 9-1-1 call routing and location. Then we will review how GIS data impacts the call flow of a Next Generation 9-1-1 call. At the end you will understand why NG9-1-1 can’t work without accurate, current GIS.
Danny Mattox – OKAGE/K20 Center at the University of Oklahoma
Learn about the Oklahoma Alliance for Geographic Education (OKAGE) in this interactive session focused on the OKAGE organization and discover how you can get involved in geographic education in your community. After attending this session, participants will be able to:
Please be ready to discuss the GIS software and applications you use in your line of work and expect to use a smartphone to participate in the session.
ArcGIS Pro Tips and Tricks: Styles and Symbology
Eric Pimpler – Geospatial Training Services
In this session we'll focus on ArcGIS Pro tips for symbolizing your layers. ArcGIS Pro provides the ability to import and style both 2D and 3D layers. Esri recently released a new visualization style and supporting basemap for ArcGIS Pro that you’re going to want to check out. The new Firefly style and supporting basemap can be used to create really attractive thematic visualizations. In this session I’ll show you how to put these to use in your ArcGIS Pro projects.