Ohio.gov  |   State Agencies   |   Online Services
2017 Ohio GIS Conference Abstracts and Bios

 2017 Ohio GIS Conference

 CEAO  URISAOGRIP

September 25-27, 2017 (Monday - Wednesday)

This is a tentative agenda and is subject to change. Last Updated: 7/10/2017
Monday 8:30am - 11:00am
Room
Workshop - ArcGIS Hands-On Mobile Workshop Basic
This half day Mobile Solutions Hands-on Workshop will focus on several mobile solutions that Esri offers, including Collector, Survey123, Workforce and Operations Dashboard. In addition to hands-on activities, there will be an extensive discussion of field mobility capabilities and workflows. What you learn in this workshop will go a long way toward immediately improving your field operations. To that end, we encourage you to come to the Workshop with a specific project in mind regarding how you would leverage Esri’s Mobile Technologies to meet your business needs. Attendees must bring their own laptop computer to the workshop, and they must have at least Publisher privileges to an ArcGIS Online Organization. Also, prior to attending the workshop, please review the workshop preparation document at the following URL: http://stl.esri.com/AGOLWorkshop/MobileSolutionsWorkshop.pdf

Note: Internet is not provided to attendees so you will need a cellular connection, mi-fi card or another type of data connection.


Tim Hensley - Esri


Monday 8:30am - 11:00am
Room
Workshop - ArcGIS Open Data: Creating Hubs of Innovation BasicIntermediate
Do you just make maps or do you curate data, craft applications, deliver information and communicate relationships that can only be discovered through the Science of Where? If you do more than make maps, join in on this informative session on how to leverage Esri’s ArcGIS platform to create a new framework of innovation and engagement, by launching a Hub for your organization. This framework is complete with Open Data, storytelling, configurable apps, open APIs, charting, dashboards and a systematic, repeatable approach to align with your top priorities and initiatives. This approach is helping add context to vast amount content which accelerates transparency, tracks performance and fosters collaboration. Please join us to learn how you can take leverage these capabilities for your community.

Ryan Sellman - Esri


Monday 8:30am - 11:00am
Room
Workshop - DIY Street Level Photos for Assets & Assessment Basic
Street level imagery is often a missing appraisal component that complements assessors in conducting efficient and equitable property valuation. Historically, street level imagery was an expensive option with a short use life, but new tools are now available for users to self-collect photos. While these tools cannot completely eliminate the need for site visits, they can be used by office staff members to justify and prove valuations to constituents. Crowdsourced and ArcGIS Online products have made it possible for local governments to obtain and use affordable, do-it-yourself solutions. With these tools, imagery can be collected and viewed almost immediately. These Esri-powered solutions provide access to GIS, CAMA, oblique and street level photography.
Part of this workshop will be mobile (weather dependent) as groups will be walking around capturing photos. There will be some professional grade equipment available but attendees are encouraged to bring their own devices for use in the workshop.

Janine Yoong - Mapillary


Mark Wroblewski - Erie County


Travis Gregorich - Bruce Harris & Associates


Steve Koenig - Bruce Harris & Associates


Monday 8:30am - 11:00am
Room
Workshop - Modeling, Python & Scripting: Managing GIS While You're Not in Office Advanced
There are times when it is just easier to build a model rather than build a script. On the other hand, there are times when a model and all the Esri tools cannot meet a specific need and a script must be used for that finer grain control. Then there are times where you can use python to run a model as a scheduled task. We will show various scenarios where you might choose model builder, python script, or a combination of both. The goal is to show how GIS can be managed through automation and how you can monitor your processes through logs, email, or writing results to a table. Lastly, we will show real world examples of how complicated processes can be automated through geoprocessing services and consumed via web maps and apps.

Ken Carrier - City of Hamilton


Joe Guzi - Stark Co


Brandon Longenberger - Stark Co


Monday 2:30pm - 4:30pm
Room
Workshop - AGOL Web Templates Intermediate
The ArcGIS Online platform allows local governments to create configurable applications to serve a wide variety of purposes. Esri’s configurable app templates include: built-in templates, COTS solutions, and custom built templates. GIS professionals can easily share data across all devices and platforms, as well as expand their reporting, searching, and printing options. The platform allows the sharing of GIS layers through feature services with hyperlinks to source documents such as plats and surveys. We will also discuss and showcase possible setup options with map services that allow your GIS web presence to grow. These web services can include property photos, surveys, plats, and transfer cards. We will also be discussing app projections (pros/cons), and a high overview of ETL (Extract / Transform / Load) procedures to successfully create an update process.

Colin Russell - Bruce Harris & Associates


Travis Gregorich - Bruce Harris & Associates


Steve Koenig - Bruce Harris & Associates


Shayne Grey - Clark County


Dustin Reed - Belmont Co GIS Dept


Don Pickenpaugh - Belmont Co GIS Dept


Monday 2:30pm - 4:30pm
Room
Workshop - The Nuts & Bolts of GIS: The Job of Cleaning Dirty Data! BasicIntermediate
John Woodard, MS, GISP, EA, is joined by Ms Kelly Wright in this installment of The Nuts & Bolts of GIS series about dealing with this issue of "DIRTY" data. This year’s workshop will highlight guest presenters who are willing to share their techniques and experiences for dealing with data dirt! The goal of this workshop is to teach and demonstrate how to avoid the pitfalls of incorporating “dirty” (error filled) data into a new or established GIS system. This workshop will discuss and demonstrate how to use field calculator, custom scripts, and MS Excel to scrub away those data errors. Clean and error free data produces accurate and trustworthy GIS results!

John Woodard - Davey Resource Group


Kelly Wright - LJB, Inc


Monday 2:30pm - 4:30pm
Room
Workshop - Implementing ArcGIS for Local Government in your Organization BasicIntermediate
This session will provide an overview of ArcGIS for Local Government and describe how to deploy and configure the ArcGIS for Local Government maps and apps to meet specific business needs in your organization. Newly released maps and apps that help organizations tackle the opioid epidemic, reduce homelessness and combat vector borne diseases will be highlighted in this session.

Scott Oppmann - Esri


Ryan Sellman - Esri


Monday 2:30pm - 4:30pm
Room
Workshop - Creating a 311 with Esri’s CrowdSource Apps and GeoEvent Server IntermediateAdvanced
Having a 311 system for citizens to report problems or observations is crucial for being proactive in keeping your community clean and safe. Utilizing Esri’s Crowdsource Apps in ArcGIS Online or Portal you can give your citizens a simple way to submit requests while out in the community via the mobile or web application interface. In addition, with the GeoEvent Server we can leverage real-time management of the system by completing tasks like automatically sending an email to a department when a request comes in. In this workshop we will go over setting the Crowdsource Reporter and Manager sites, how to interact with the mobile application, and automating processes in real-time utilizing ArcGIS GeoEvent Server.

Larry Rover - City of Hamilton


Ken Carrier - City of Hamilton


Tuesday 8:30am - 9:00am
Franklin A
Prioritizing Natural Areas for Habitat Restoration in Parks of Hamilton County through Use of GIS Basic
A large number of natural areas exist in the parks of Greater Parks of Hamilton County (GPHC), but only limited resources are available to manage the areas for habitat restoration. The main objective of this project is to develop a quick method for the GPHC staff to prioritize the natural areas in GPHC parks through use of GIS tools. This study applies the scoring approach, which evaluates candidate sites individually using scores for multiple factors and then selects prioritization sites from the top of a ranked list. Three sets of multiple factors are used to compute the prioritization index. They generate similar priority index maps. These maps will help the GPHC staff to make a better plan for habitat restoration activities in their parks.

Hongmei Wang - Northern Kentucky University


Jessica Spencer - Great Parks of Hamilton County


Margaret Minzner - Great Parks of Hamilton County


Zurijanne Carter - Great Parks of Hamilton County


Amy Code -


Tuesday 8:30am - 9:00am
Franklin B
Using AGO for Data Organization and Economic Development Analysis Intermediate
Columbus 2020 recently created a custom web-mapping portal to upload outside data sources through ArcGIS Online or GIS files. The application utilizes .NET, Esri JavaScript API and Bootstrap for organizing, viewing, querying and exporting data. By tagging and managing feature layers on ArcGIS Online, users can upload information instantly onto the portal to begin analysis. Custom reports with metadata are also available to disseminate information quickly to site selectors, clients and potential investors in the Columbus Region. This presentation will highlight the process to upload and organize information within AGO as well as the demonstrate the tools within the site.

Laura Hess - Columbus 2020


Jay Knox - Columbus 2020


Tuesday 8:30am - 9:00am
Franklin C
Getting off the Ground: How Grove City is Implementing a UAS Program Intermediate
Back in 2016, the City of Grove City began utilizing unmanned aerial systems (UAS) to capture imagery of its ongoing development projects. This presentation will discuss the process of obtaining the proper approvals for the operation of a UAS, how that process has changed, and the various technologies the City’s Information Systems Department utilizes with the UAS. We will touch on the various technological, regulatory, and other hurdles involved in starting a small-scale UAS program as well as how the City utilizes the UAS to enhance its daily operations.

Devin Brooks - City of Grove City


Daryl Lotz - City of Grove City


Nick Soltes - City of Grove City


Tuesday 8:30am - 9:00am
Franklin D
ODOT’s Implementation of Collector for Asset Management Intermediate
In 2014, ODOT used Collector for ArcGIS to perform an inventory of all the tower lighting structures throughout the state. Since Collector’s initial exposure to ODOT, asset owners throughout the enterprise have been requesting a solution that includes using Collector for ArcGIS in the field. To date ODOT has deployed approximately 200 mobile devices and trained 300+ people how to use these custom solutions.

In this presentation we will discuss the phases involved in deploying an asset to our Collector Program. While doing so we will highlight requirements gathering, software, custom tools, hardware, and other resources that help make ODOT’s Asset Management more efficient and productive.


Anthony Clark - Ohio Department of Transportation


Michael Weakley - Ohio Department of Transportation


Tuesday 9:10am - 9:40am
Franklin A
“Less is More”: Automated LIDAR Smoothing / Filtering for Derivative Data Products Intermediate
LIDAR data collection creates dense point-clouds with millions or more points in a standard LAS file. These points are highly accurate, but small amounts of vertical error resulting from limitations in the collection techniques can create issues with utilizing ‘raw’ LIDAR data for a variety of engineering and mapping tasks. A high ratio of horizontal sample density to vertical accuracy in LIDAR results in data noise, resulting in unusually high estimates of slope and unattractive topographic contours when these are derived from raw LIDAR data. To address these issues, the author has automated a GIS-based process to reduce data noise and produce derivative elevation grids and topographic contours. A minimal amount of resolution is lost and maximum accuracy, based on raw LIDAR stated accuracy(s), is maintained. The automated process is built to be flexible and includes parameters that can be adjusted as needed based on the initial accuracy of the raw data and topography of the locale. Processing occurs rapidly, and in excess of 2 million points per minute are converted into final, deliverable products – smooth, visually appealing contours and elevation grids. Potential applications include efficient processing for large LIDAR datasets into consumer-friendly data deliverables for public entities that are procuring such data from typical aerial LIDAR vendors.

Jonathan Frodge - Civil & Environmental Consultants, Inc.


Tuesday 9:10am - 9:40am
Franklin B
Python + QGIS + Qt = Field Data Collection App Intermediate
Do you like to program in python? Looking for an open source/free software application for field data collection? Learn how IJUS, LLC (a Gahanna, OH engineering firm) has utilized QGIS and Qt Designer to create and configure python form based field data collection applications for asset management.

Kevin Surbella is the GIS Manager at IJUS, LLC, and a GIS Adjunct Instructor for Columbus State Community College (CSCC) with 13 years’ experience working in both the public and private geospatial sectors. He has extensive knowledge using various suites of proprietary and open source applications and has a strong background in the following areas of GIS; database management, server administration, data analysis, and application development. He enjoys helping others strengthen their skills in GIS by mentoring through GISCI, GIS tutor for CSCC, and answering many questions on the GIS Stack Exchange website. Kevin received his M.A. in Geography and B.S. in Conservation from Kent State University.


Kevin Surbella - IJUS


Tuesday 9:10am - 9:40am
Franklin C
From Idea to Application Intermediate
This presentation will go through the process that the City of Columbus has adopted to bring applications from defined user workflows to a final product. In the past two years, the GIS division has developed multiple applications in-house, trying different tools and methods to make the process as streamlined as possible. We will highlight our latest refinement that includes using Pivotal Tracker to list requirements and iterate through an agile development process and a combination of Esri’s Web AppBuilder with Git to develop code simultaneously between multiple developers. We will go through a couple of examples of how we use these tools to build great products and some tips we learned along the way.

Melissa Williams - City of Columbus


Jaclyn Cardillo - City of Columbus


Tuesday 9:10am - 9:40am
Franklin D
The Nuts & Bolts of GIS: Get It Surveyed? Advanced
When asked what GIS stands for, a common response among GIS professionals and the Engineering & Surveying community is “Get It Surveyed”. While this is often said tongue-in-cheek there are some who maintain that GIS professionals should not be in the business of developing location based data, while others just maintain a healthy skepticism that the accuracy of data used in a GIS is suspect. John Woodard offers this interactive seminar to examine how clear communication between professionals can build the bridge of trust to close this gap between GIS and survey/engineering.

John Woodard - Davey Resource Group


Tuesday 10:20am - 11:20am
Franklin A
Fantastic Beasts (and where to geolocate them) Intermediate
Here be dragons! A phrase that has grown in usage over the centuries to describe those unknown regions on maps and itself a bit of a urban legend as to its frequency of use (only 2 known maps includes this wording). The talk will focus on the history and usage of fantastic and mythical beasts on maps throughout the centuries. Largely used to characterize the unknown, deep down they tended to serve as warning that ‘bad stuff’ is out there. So if you’ve ever ventured into Terra incognito (or Mare incognito for those sailors in the crowd) or wandered into the land of HIC SVNT LEONES; and with all due apologies and respect to J.K Rowling and her coextensive universe we will explore and go in search of Fantastic Beasts (and where to geolocate them)!

Todd Tucky - Heartland GIS


Tuesday 10:20am - 11:20am
Franklin B
Automating Service Publishing in an Optimized Server Environment Intermediate
Throughout the past year, the Stark County GIS department has begun transitioning to an optimized ArcGIS Server infrastructure. The server environment developed features load balanced servers and workload separation. To minimize publishing time of new services to this environment, we automated the publishing process between our staging and production servers. Join us as we explore the lessons learned regarding our server deployment and revolutionary service publishing automation. Get excited!

Brandon Longenberger - Stark County GIS
Brandon Longenberger has been working for the Stark County GIS Department for over a year. During this time, he has worked on service publishing, map creation, and script development. Brandon assisted in the migration of services to a new server infrastructure. He is involved in the maintenance and standardization of scripts that automate processes performed on a daily basis. Brandon has developed and deployed geoprocessing services to web applications, as well as maintained hosted applications through Web AppBuilder Developer Edition.

Tuesday 10:20am - 11:20am
Franklin C
Women In GIS: Challenges and Opportunities Intermediate
A panel of leading women in GIS will come together for this 60-minute session to spur conversation about differing workplaces, such as the academic, government, private, or nonprofit sectors, and what challenges panelists have faced as women in those spaces. Potential discussion points include:
•Differing paths into a career in GIS and surprising turns a career trajectory can take
•Differences in experiences between women at different life stages
•Bias and discrimination based on gender, age, sexual orientation, race, national origin, ethnicity, or able-bodiedness
•Lean in or Out? Balancing professional responsibility and workplace expectations with self-care, mental and physical health, and family obligations
•Selling your own success by embracing your fiscal and emotional value
•Negotiating While Female: Successes and backfires of negotiating “like a man”
The purpose of this session is for both women and men to discuss practical ways to overcome bias and challenges that may be unspoken in the workplace. Following opening comments from the panel members, the floor will be open for questions from the audience. Conference attendees at all stages in their careers are welcome, and a major focus of the session will be networking among attendees. This one-hour session will underline the importance of making connections within the GIS community to build a network of professional resources, especially among women in the field.


Kelly Wright - LJB, Inc


Tuesday 10:20am - 11:20am
Franklin D
Data Observation Utilizing Survey123 within Collector for ArcGIS Intermediate
Several departments in the city have been utilizing Collector mapping applications for various workflows, including inspections and asset management. However, Collector does not lend itself well to certain workflows, due to the complexities involved in the observations of specific assets. In the interest of data integrity and ease of use, we found the “smart” form aspects of Survey123 to be more appropriate in these types of situations. The issue that comes with the implementation of these smart forms is the loss of the mapping component that data collectors rely upon to complete their tasks. Ultimately, we decided to leverage the smart forms of Survey123 within Collector, thereby employing the best of both worlds.

This presentation will briefly discuss the differences of the two applications, followed by an in-depth look at how to set up a custom survey through Survey123. This will include developing look-up tables and external choices as domains, as well as utilizing constraint, relevant, and calculation fields to ensure integrity and maximize functionality. We will then discuss the integration of the two applications using the Survey123 custom URL scheme. The above strategies and procedures will be demonstrated in the context of a specific case study, in which we developed a custom web application for continual monthly water sampling and lab testing with multiple related tables. To conclude the presentation, we will consider additional areas and disciplines that could ben

Craig Bruner - City of Hamilton


Tuesday 1:00pm - 1:30pm
Franklin A
Utilizing GIS for Fire Resource Management Advanced
GIS has become increasingly important throughout diverse professions and studies, but perhaps most important in the professions that are responsible for the safety of our citizens. The tools that are available through GIS departments from the Esri platform such as ArcMap, Web AppBuilder, and ArcGIS Solutions can be customized to create a series of maps and tools to better serve fire departments in resource management. These tools, created in collaboration with local fire departments, can be leveraged to create fire responses that are safer, more effective, and efficient.

Carissa Signore - County of Summit


Dennis Tubbs - County of Summit


Michael Benson - Copley Township Fire Department


Stephen Knittel - County of Summit


Tuesday 1:00pm - 1:30pm
Franklin B
Comparison of Low Stress Classification and BLOS using HPMS data Basic
Low Stress Classification has been proposed with the acknowledgement of the need to bring ease and simplicity to the network classification of municipal roadways.

This study compares and contrasts the two methodologies as to how the classification of the streets perform under each criteria. The comparison is made on select representative segments as well as on measures of network connectivity. The outputs on sections or roadways and their suitability for cycling will be explored.

Maaza Mekuria - Hawaii DOT


Tuesday 1:00pm - 1:30pm
Franklin C
Enterprise Open Data Initiative in Indianapolis Intermediate
In 2015, the City of Indianapolis/Marion County Information Services Agency (ISA) embarked on a new project to disseminate GIS information using ESRI’s Open Data infrastructure. This presentation will describe how the project began, how it evolved over time to fall under and fit into the NavigateIndy umbrella, how ESRI Open Data technology is used, and the lessons learned along the way.

Cheryl Spencer - Woolpert


Tuesday 1:00pm - 1:30pm
Franklin D
Beyond GIS - Integrating GIS with billing software to create operational efficiencies Intermediate
In utility management, GIS is one of several software programs used throughout the organization. Billing software is critical to the success of any utility company. Several points of overlap exist between GIS and billing software. This presentation will demonstrate an integration of desktop GIS, online GIS and SSI billing software. This integration allows work orders to be created within the billing software and dispatched to ArcGIS online into the WorkForce application. Field workers receive mobile notification of pending work orders and react to these work orders on mobile devices. When workers complete each work order, completion notes are captured by WorkForce. Synchronization software then loads the completion notes into the billing software. Operational efficiencies are created by removing paper work orders, eliminating multiple data entry, and reducing drive time to collect work orders from a central location. This presentation will also examine challenges associated with data synchronization and migration between platforms and examine how other ArcGIS Online applications (including Survey123 and Explorer) can be integrated into a work order management system.

Kerry Zwierschke - Bennett & Williams


Tuesday 1:40pm - 2:10pm
Franklin A
USGS Update on National Map, 3DEP, US Topo, ... Basic
As part of the National Map, USGS efforts in Ohio include support for the lidar-based 3D Elevation Program (3DEP), the National Hydrography Dataset (NHD), and new US Topo maps. One goal of 3DEP in Ohio is to help refresh the OGRIP statewide lidar and elevation layer with new, higher resolution data. 3DEP and other National Map elements will be discussed during this presentation.

Charles Hickman - U.S. Geological Survey


Tuesday 1:40pm - 2:10pm
Franklin B
Cincinnati’s GIS-Based Customer Service Request System: 15 Years of Success Basic
In early 2002, Cincinnati City Council requested a report on the feasibility of a single inter-departmental customer service request system for essential city services. Shortly thereafter, City Council approved a plan to develop and implement a customer service request (CSR) system in-house to improve the coordination and management of services provided to city residents, companies, workers, and visitors and between city agencies. The system was created by the Cincinnati Area Geographic Information System (CAGIS). The system leverages CAGIS's extensive integration of GIS with transactional data stored in an Accela Permits Plus database. This presentation will discuss the resounding success of Cincinnati’s Customer Service Request system in the 15 years since its development as well as discussing some of the challenges the system has faced. This presentation will also highlight new products being created to ensure that the City’s vision of progressive improvement in customer service delivery is met.

Alexandria Horne - Cincinnati Area Geographic Information System
Alexandria Horne is a Senior Computer Programming Analyst at CAGIS. She holds a masters degree in geography from the University of Cincinnati and a bachelors degree in atmospheric science from Purdue University. Prior to working at CAGIS, Alexandria was a geospatial analyst for Woolpert in Dayton, Ohio. In her spare time, she works on her family’s farm near Springfield, Ohio.

Joshua Murphy - Cincinnati Area Geographic Information System
Joshua Murphy is a Senior Computer Programming Analyst at CAGIS. He holds both a masters and bachelors degree in geography from the University of Cincinnati. Prior to working at CAGIS, Joshua was a GIS analyst for Clermont County, Ohio.

Tuesday 1:40pm - 2:10pm
Franklin C
Small City GIS and Lessons Learned Basic
My presentation will showcase how a leap of faith by a small city and a part-time position gave one student a chance at a career and the City of Sandusky a push into the 21st century. It will show how from nothing but a new workstation, GIS became a reality in Sandusky. I joined the City as a temporary employee, following an internship. As an intern, I attended a GIS workshop on Collector, where I met the Director of IT for the City of Sandusky. A few months later, he and the City Engineer approached me with an offer; They would hire me with the sole purpose of proving the critical importance of a GIS program to City management and elected officials. I happily accepted this challenge and began a five-month project to improve City functions by leveraging GIS. Ironically, I am a Biology major and a Fine Arts minor. I’ve taken one GIS class in my college career. The majority of the experience that I have with GIS is self-taught or gained through trial by fire. During my time with the City, I gained knowledge that transcends the classroom by interacting with all levels of City government to create solutions to problems, increase efficiency, transparency and bolster accountability. I now have a full-time position as the GIS Analyst, developing and implementing projects from citizen reporting to infrastructure mapping and everything in between, all because of one workshop and the forward-thinking City administrators who envisioned what could be. What’s next? Smart City: Sandusky.

Tiffany Taylor - City of Sandusky


Tuesday 1:40pm - 2:10pm
Franklin D
Enterprise Data Collection – It’s not just an asset anymore Intermediate
Introducing a Statewide Asset Inventory program is daunting enough; add in a new infrastructure and taking on old business processes and your plate is completely full.

This presentation will review what ODOT has experienced over the course of an ESRI Collector implementation on administration and development of the program. We will review lessons learned in adjusting to the needs of the organization, modifying years of ‘this is how we have always done it’ mentality and introducing a project management approach to getting the best out of your new process. This presentation also highlights organizational change occurring in parallel with this project, providing insight to what ODOT is implementing to overcome the higher level challenges.

John Puente - ODOT


Tuesday 2:40pm - 3:10pm
Franklin A
The Future of Lidar Intermediate
Lidar technology has been providing accurate 3D elevation data for the commercial market for over 20 years. Woolpert, a pioneer and innovator of this technology, has been at the forefront, completing first-ever projects while leading the market with advanced sensor research, development and applications. Most recently, we were asked to assist the United States Geological Survey (USGS) with evaluating two new lidar sensors that could have a dramatic, positive impact on the future of the lidar market. These two new sensors are Single-Photon and Geiger mode lidar. While similar in how they operate, they each offer unique opportunities and challenges in their application for real world projects. This talk will give an overview of currently accepted technology, as well as an explanation of the pros and cons for each of these new sensors. Despite the challenges, both sensors offer opportunities to capture high density point clouds over larger areas, more quickly and at a lower cost than traditional lidar systems.

tbd tbd - tbd


Jeff Lovin - Woolpert


Tuesday 2:40pm - 3:10pm
Franklin B
ArcGIS Pro: An Introduction Basic
This workshop is intended for users who want to learn more about ArcGIS Pro. It will cover different workflows for creating meaningful and compelling geographic information products, discuss licensing options, and provide a road map ahead for future releases. ArcGIS Pro offers a multitude of analytic capabilities, an intuitive user interface, a simplified editing experience, and workflows to create compelling visualizations. The ArcGIS Pro 1.4 release continues to expand its capabilities and innovation through the inclusion of dynamic legends and aggregation, orthomapping, georeferencing, and much more.

Ryan Sellman - Esri


Tuesday 2:40pm - 3:10pm
Franklin C
All You Need is... GIS Intermediate
The Miami Valley Regional Planning Commission (MVRPC) is a forum and resource where regional partners identify priorities, develop public policy and implement collaborative strategies to improve the quality of life and economic vitality throughout the Miami Valley.

Many communities in our region use GIS as part of their daily operation but at a different level. In 2015, MVRPC in partnership with Southwest Ohio GIS Users Group (SWOGIS) completed a survey of GIS users in the Miami Valley Region to better understand various needs that exist at the regional and local level.

MVRPC learned detailed information about how people are using GIS throughout the region. Users were also asked about what GIS themes and projects interest them. Those results were analyzed and were used to direct MVRPC’s actions regarding upcoming projects. Those projects will be discussed as well.

The session will discuss:
• The results of the 2015 GIS Needs Assessment Survey
• Ongoing and completed GIS projects that MVRPC has undertaken with their regional partners
• Upcoming GIS projects planned as a result of the survey


Tom Harner - MVRPC


Kathryn Youra-Polk - MVRPC


Martin Kim - MVRPC


Tuesday 2:40pm - 3:10pm
Franklin D
Using Mobile GIS Applications for Municipal Utility Asset Management Basic
The Ohio EPA has announced a coming mandate that all Ohio public water utilities develop an asset management program to improve infrastructure sustainability. Although a GIS integrated plan is not required, it is the most effective way to maintain the plan. This presentation will demonstrate 2 to 3 mobile GIS and infrastructure Asset Management apps and software for municipal utilities. It will also talk about integrating data from pipe & leak locators, sewer cameras, and other equipment data into the GIS database. The focus is on putting GIS in the hands of non-technical field workers.

Mark Beatty - Utility Technologies, LLC


Tuesday 3:20pm - 3:50pm
Franklin A
Clustering for Selecting Traffic Count Stations Intermediate
Cluster Statistics was used to select 44 Pedestrian/Bicycle Crash Locations (44 Street Links and about 80 related intersections) for use as representative links (cluster medoids) from over 4,300 locations that had pedestrian or bicycle crashes between years 2007-2014 on the island of Oahu, Hawaii. These streets are representative of the streets on the Island of Oahu for the purpose of setting-up continuous count stations.
The base street network is composed of City and County of Honolulu roads augmented with Hawaii State DOT Highway Performance Measurement System (HPMS) Links including bicycle paths and associated network attributes. First the low stress classification was applied classify the street network. Crash data from State Department of Health was overlaid and mapped to street links using Spatial Joins. The crash data was aggregated for the two modes (Pedestrian and Bicycles) and crash rates were computed for all links. Streets with pedestrian or bike incidents were selected for further analysis.
The attributes used for clustering were : Functional Class (Census Roadway Class Codes were merged with State DOT Class Codes ), Area Type (Census/DOT), Facility Type, Lane Count, Speed Limit, AADT, Road Ownership, as well as derived data including roadway traffic stress (Low Stress Classification), Crash Count, and Crash Rate.
The result is a list of candidate links and a cluster network suitable for use in selecting permanent count stations.

Maaza Mekuria - Hawaii DOT


Tuesday 3:20pm - 3:50pm
Franklin B
A More Open Data Portal for County GIS Data and Applications Basic
3SG Plus recently created a web portal so that users can view, download and manage GIS data and applications from the County’s Enterprise GIS. Users can download data layers in multiple formats such as CSV, GeoJSON, Shapefile and FileGDB. The tiered log-in model allows administrators to manage data dissemination and monitor site activity with a robust dashboard showing metrics such as server status, data download frequency and availability. The dashboard also shows detailed metadata updated live from SDE layers edited by multiple stewards. Administrators can easily edit, update and add applications from other sites for easy viewing by the public on the front page. The interactive map also allows users to view, print and download spatial information. Technology for this portal consists of .NET, JavaScript, Bootstrap, D3, and new cutting edge technology referred to as “copy and paste”. This presentation will demonstrate the application and management tools developed for a county agency.

Darlene Magold - 3SG Plus


Jesse Glascock - 3SG Plus


Tuesday 3:20pm - 3:50pm
Franklin C
An Introduction to Project Management Concepts and Practices Basic
Here we will take a critical look at geospatial project management. Project management is a broad discipline that encompasses both technical methods such as system design and analysis, and interpersonal factors that affect professional relationships. Though project management has matured outside of our discipline, it can still be incorporated into GIS technology.

By the end of the presentation, you will have the tools to create a project plan. The project plan will include a scope, detailed work structure with a timeline, a budget, and a project roles responsibility matrix. If you feel like this is daunting, don’t worry Mapgirl (a.k.a. Rose Haverkos) will save the day. We will work through each of these components in an organized and logical manner. Using the City of Hamilton’s Crimeview Dashboard project as an example, participants will walk away with templates to use in the office for their own projects.


Rosemary Haverkos - City of Hamilton


Tuesday 3:20pm - 3:50pm
Franklin D
Automated Procedures to Improve Data Quality Basic
To ensure a consistent level of quality while also providing cost-savings, we have implemented automated and semi-automated data review processes in a number of our projects supporting a range of clients. We have applied ESRI’s standard topology tools in ArcMap to our FEMA regulatory products to check for coherence and completion of data. When working with municipal and utility datasets, additional checks have been implemented in order to catch issues with more complex spatial relationships, including the development of custom Model Builder-based topology toolboxes. This presentation will begin with a discussion of how we have utilized standard topology tools and how we have applied custom queries to form a unique topology ruleset, followed by an open discussion with attendees in a lessons-learned format on how automated spatial checks have helped others in their work and how these solutions were developed.

Cathy Wicks - Stantec Consulting


Ryan Branch - Stantec Consulting


Tuesday 4:00pm - 4:30pm
Franklin A
Harmonizing Geospatial Metadata Standards Intermediate
FGDC CSDGM, ISO19115, SDSFIE, Dublin Core, and deviations. How can we, as an industry, better document our products while neither overloading users with useless information nor omitting vital details? Delve into the options and decide the best methodology while also finding a common ground across the industry.

Ryan Bowe - Woolpert


Tuesday 4:00pm - 4:30pm
Franklin B
Publishing to Open Data Portal – Our 1-2-3-4 Workflow Intermediate
Open government initiatives are bringing a new wealth of public data to the web, enabling citizens and other stakeholders in the community to share a common picture of information that drives decisions and fosters innovation. Esri’s Open Data portal makes it easier than ever to get your data out there, but how can you streamline the publishing workflow to ensure data is accurate, maintained, and well documented? The City of Columbus follows a 1-2-3-4 workflow to get authoritative datasets directly from editors to our open data portal. We will review the data cleansing steps that were necessary in the beginning and how we systematically identified which datasets and fields would be shared. From there we will go through how we replicate our data from our edit database (1) to our read only repository (2), publish the data in map services (3) and how we make sure the data and metadata make it to Esri’s Open Data portal (4). Join us to get the tips and tricks we learned along the way on our open data journey!

Matt Fancher - City of Columbus


Jaclyn Cardillo - City of Columbus


Tuesday 4:00pm - 4:30pm
Franklin C
Best Practices for Implementing a GIS Platform Basic
Whether you are extending a new aspect of your GIS implementation, looking to improve an existing enterprise GIS, starting from scratch, or anything in between, a trusted and repeatable methodology is key for success. In this presentation, we will discuss the four steps for successfully implementing new location driven initiatives: define a location strategy, assess and plan, build capacity, operate and measure.

We will discuss different performance metrics, tools, and real world implementations where GIS projects have taken shape and impacted their organization in a positive way. The methodology is not specific to any project, brand, or technology, but rather something that anyone at any phase of their GIS maturity and experience can utilize.

Anna Sokol - Esri
Anna is the Lead Technical Advisor for State and Local Government at Esri, joining the organization in 2008. Anna has worked on GIS planning and implementation strategies for state and local governments clients throughout the United States, bringing experience from her direct work in local government prior to joining Esri. Anna holds a Master of Urban Planning degree from the University of Michigan and Bachelor of Arts degrees in Geography and Urban Studies from Macalester College.

Tuesday 4:00pm - 4:30pm
Franklin D
High Accuracy Bluetooth Data Collection, On A Budget! Basic
A look into utilizing a cost-effective approach for sub-foot data collection using mobile devices. Ohio Valley Regional Development Commission (OVRDC) recently started to use “EOS” and “BadElf” bluetooth devices for asset collection. This presentation will look at GNSS technology and what the future holds for Ohio GNSS users. GNSS technology is rapidly changing and it is expected within a few years all new devices will be multi-constellation capable. What does that mean for asset collection? We will then venture through the workflow that the small GIS staff at OVRDC uses with its EOS Arrow unit, BadElf unit and Samsung Galaxy tablet. An optional demonstration will take place outside, weather dependent.

Nick Kroncke - Ohio Valley Regional Development Comission


Wednesday 9:00am - 9:30am
Franklin A
A Needs Assessment for Costa Rica's GIS-based Rain Forest Conservation Program Intermediate
"A GISCorps volunteer is needed for an onsite mission in Costa Rica. Costa Rica’s National Forestry Financing Fund (FONAFIFO) is requesting a GISCorps volunteer with expertise in conducting GIS Needs Assessments and providing recommendations for upgrading the geospatial information management system of Costa Rica’s National Forestry Financing Fund." Bucket list opportunity here I thought.

This presentation will provide attendees with a view into a comprehensive Needs Assessment for the national government of Costa Rica. This US Forest Service supported volunteer mission advised the national agency in Costa Rica that is tasked with directing Costa Rica’s largest tropical rain forest conservation program - the Payments for Environmental Services Program (PSA). It is managed by FONAFIFO. FONAFIFO has been using GIS for many years in a conservation program that is recognized as the global leader in tropical rain forest conservation programs.

Costa Rica rain forest eco-tourism provides the largest source of national revenue. These GIS Needs Assessment recommendations include documentation of the existing geospatial environment and work flows, recommendations and information on further implementations of Open Source GIS software (QGIS) and Esri software solutions - both of which are in use currently. Also, recommendations on servers, mobile and cloud options and UAS are covered, as well as costs, risks and benefits.


Richard Kotapish - Geo-centric Consulting, Inc.


Wednesday 9:00am - 9:30am
Franklin B
Creating a Regional 3-D Printed Population Model for the Hyperloop One Global Challenge Intermediate
With 3-D printing becoming cheaper and increasingly accessible, more people are choosing to use it in various ways. ESRI software, however, does not currently provide a simple path to create 3-D models of GIS data. Luckily there are many third party tools available to facilitate this conversion. This presentation will communicate the process of using ArcMap, ArcScene, a free third party 3-D editing software and the help of a local 3-D printing firm to create a depiction of real geographic data using 3-D printing technology.
In March of 2017, the Mid-Ohio Regional Planning Commission joined a team in proposing the Midwest Connect Corridor for the Hyperloop One Global Challenge in Washington D.C. The team suggested including a 3-D model of populations that would be served by the new transportation and freight line. This line would cross five states in the Midwest, impacting millions of citizens. A project of this type had never been attempted before at MORPC and a true collaboration among MORPC staff and IC3D was integral to its success. This presentation will walk thru the steps of creating and converting the data and have a 3D printed model for display.


Jason Kaper - Mid-Ohio Regional Planning Commission


Wednesday 9:00am - 9:30am
Franklin C
Vector Control and Mosquito Management with GIS Intermediate
In this sessions, we'll discuss how a series of Local Government solutions can be configured to manage mosquito populations and the spread of vector-borne diseases in your local government.

Ryan Sellman - Esri


Wednesday 9:00am - 9:30am
Franklin D
Streamlining GIS Data Input & Processing with Custom Web Apps, Model Builder & Python Intermediate
Many businesses throughout ODOT are seeing the increasing value that web mapping applications offer. With this growth in popularity, creating and managing the data can become time consuming & burdensome for the GIS team. To solve this problem, ODOT has been developing customized solutions to allow the businesses to create and manage their own GIS data to support these Web Mapping Applications.

This presentation will highlight a few of the unique solutions built by ODOT's GIS team to support database input and management from users who otherwise have little to no interaction with GIS systems. ODOT uses a combination of Custom Web Applications, Model Builder, and Python to help streamline GIS data creation and management.

Stephen Hale - ODOT


Wednesday 9:40am - 10:10am
Franklin A
NG9-1-1 and Your GIS Data Basic
This presentation will provide an update on the latest information related to NG9-1-1 deployment and how it relates to your GIS data. Getting your data into the NENA database schema will be discussed as well as do’s and don’ts in regard to data maintenance and topology. This discussion will answer the questions “How do I properly compare my Master Street Address Guide (MSAG) to my GIS data?” and “Why are some of my Automatic Location Information (ALI) records not geocoding to my GIS road centerlines?” Also, this session will contain a “Find the Error” quiz that will highlight common flaws in emergency management GIS data that are often overlooked and discussions on how to find and fix the issues.

Jeremy Jurick - Michael Baker International


Wednesday 9:40am - 10:10am
Franklin B
OSU Maps - The Story Intermediate
This presentation will present the history behind and the road to The Ohio State University’s (OSU) “GIS for everyone” vision. The story starts with humble data gathering, a live OSU Maps web application, and a future vision of 3D GIS.
We will provide an overview of how we started. We will then present the current OSU Maps enterprise GIS web application developed to provide students, staff, and faculty a view into useful information about the campus as a whole. Finally, we will conclude by sharing our vision for future 3D GIS and how we plan to get there.


Marianne Cardwell - Woolpert


Wednesday 9:40am - 10:10am
Franklin C
GIS for Managers Basic
As GIS continues to become progressively more integrated into IT mainstream, the managers of these systems have to take a markedly different approach to be successful. The days of simply being able to produce printed maps, static PDFs, or all-in-one mega map sites and declare a GIS as successful have passed. In this session, we’ll discuss how CIOs, government administrators and the public view GIS, and how to take a more modern approach to meeting the needs and expectations of all of these groups. We’ll discuss how to involve executives, generate real citizen engagement, and make sure you’re a key part of your CIO’s vision for IT within the organization.

John Borisenko - Esri


Wednesday 9:40am - 10:10am
Franklin D
Is There Lead in My Water? – The Story Behind the Interactive Columbus Lead Service Line Map Intermediate
The Columbus Department of Public Utilities submitted and received approval from the Ohio Environmental Protection Agency (OEPA) for a lead service line map that meets the requirements of HB 512 passed by the state legislature last year. The department created an interactive map that allows the user to view publicly owned lead service lines in Columbus and within its service area. The map allows the user to search by address or scroll to a street level view while providing links to information to reduce exposure to lead in drinking water.

This presentation will cover the requirements specified in HB 512 and how the City went above and beyond the letter of the law. Careful planning and coordination between multiple groups within the City of Columbus were critical to meeting the deadlines imposed within a narrow time frame. Important data validation processes were implemented and performed before the application went live. Finally, the presentation will cover the system architecture of the web application using ArcGIS Online, followed by a live demonstration of the web application: https://tinyurl.com/zl5f24e


Mike Edwards - City of Columbus
Mike Edwards is the GIS Mapping Section Manager for the Department of Public Utilities at the City of Columbus where he currently oversees a group of 15 GIS Analysts and Technicians. He has over 16 years of experience in the GIS field, in both the public and private sector.

Melissa Williams - City of Columbus
Melissa Williams is a Software Engineer at the City of Columbus, Department of Technology and has over 15 years of GIS experience in both the public and private sectors. Registered as a certified GIS Professional (GISP) and also as a professional civil engineer (PE), Melissa has developed many custom GIS solutions related to water, sewer, electric, and fiber networks. Melissa graduated from the University of Pittsburgh with a BS in Civil Engineering and has a Master's degree in Geography from The Ohio State University.

Wednesday 10:20am - 10:50am
Franklin A
THE BENEFITS OF PARTICIPATING IN OSIP - VALUE ADDED DATASETS Basic
The need for improved planning, assessment, and response has been a heightened subject of concern for federal, state, and local agencies nationwide. As conditions in the economy increasingly impact resources, more cost-effective and efficient means of managing and maintaining a state’s assets are becoming more of a challenge. The statewide imagery program provides a current, accurate and seamless solution to produce an interoperable resource used by all agencies, eliminating duplication of maintenance and collection efforts while providing improved communication between organizations.

This presentation offers a review of the benefits of a statewide imagery program, primarily focusing on the value added products, which can be gleaned from the initial investment by the use of feature extraction techniques, to produce data layers including, but not limited to: building outlines, impervious surfaces, land-cover, change detection, cropland delineation. The presentation will also touch upon the technical differences between the current and the prior iterations of OSIP.



Brian Stevens, CP, GISP - Woolpert


Wednesday 10:20am - 10:50am
Franklin B
Data-Driven Styling, 3D Polygons and Vector Tiles with Mapbox GL Intermediate
Over the past year, OVRDC has expanded our web mapping platform to include maps based on Mapbox GL JS and Vector Tiles. This has enabled us to generate dynamic data visualizations with very large datasets while maintaining cross-platform performance – all without having to invest time, effort and money into a costly GIS server. In this presentation we will give a brief introduction into uploading and styling data in the browser-based Mapbox Studio. We will then do an introductory dive into the Mapbox GL JavaScript library and how we utilize Mapbox GL at OVRDC. Finally, we will describe the Node JS application OVRDC customized to serve our Vector Tiles. For a preview of the examples we will go over please visit https://ovrdc.github.io/gis-tutorials/mapbox/.

Malcolm Meyer - OVRDC
Malcolm works as a Transportation Planning Coordinator for OVRDC, specializing in GIS analysis and visualization. His previous work experience includes GIS positions with the City of Columbus, EMH&T and CACI. Malcolm received a Master of Arts in International Affairs from Ohio University, and a BA in Sociology/Urban Planning from The College of Wooster. He is a devoted supporter of open source software and works to expand the accessibility of GIS to small communities throughout southern Ohio.

Wednesday 10:20am - 10:50am
Franklin C
We Have Wildfires? Using GIS to Communicate Natural Hazard Risk to the Public Basic
While Ohio does not experience the news-dominating wildfires that occur elsewhere in the country, firefighters in the Buckeye State still respond to more than 5,000 brush, grass and woods fires each year. Because our fires are smaller and less in the public eye, residents of areas with wildfire exposure are often unaware of the scope of the hazard, and less likely to heed mitigation and prevention messages. Bellefontaine Fire & EMS conducted a study of the wildfire hazard for Logan County, integrating several data sources to produce a composite risk assessment. Pulling together data from diverse sources on vegetative fuels, historic fire occurrence, fire department response time, and other factors, we produced a four-tier hazard rating layer for the county designed to clearly communicate the wildfire hazard to residents and decision-makers.

Jeremy Keller - Bellefontaine Fire & EMS


Wednesday 10:20am - 10:50am
Franklin D
Survey 123 and Pavement Condition Rating: A County Solution to Rating Pavement Conditions by ODOT Standards Intermediate
The Butler County Engineer’s Office is using ODOT’s Pavement Condition Ratings (PCR) System and ESRI’s Survey 123 Application. Survey 123 provides a way for the county to create an efficient and affordable method that helps maintain data to keep track of pavement conditions for county roads. Survey 123 allows our inspectors to field locate points and calculate pavement ratings by answering a few questions based on the ODOT pavement rating matrix. Survey 123 has simplified the process of rating pavement and allows for easy pavement maintenance scheduling and reporting to the state.

Michael Mordini - Butler County Engineer's Office


Suggested Audience Experience Level: BasicBasic  IntermediateIntermediate  AdvancedAdvanced