Loading…
Spring NEARC 2018 has ended
Welcome to the interactive web schedule for the 2018 Spring NEARC Conference! For tips on how to navigate this site, visit the "Helpful Info" section. To return to the NEARC website, go to: www.northeastarc.org/spring-nearc.html.

UPDATE AS OF MAY 16: Some of our presenters have made their slides or other resources available to download. Under the "Filter by Type" heading, click on "Presentation Slides Available" to view which ones have been posted. Check back for updates! 

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Concurrent Sessions (30 Minutes) [clear filter]
Tuesday, May 8
 

10:30am

ESRI SESSION: ArcGIS Platform Overview Part 1 (Desktop and Apps)
AUTHORS: Rachel Weeden, Mark Scott

ABSTRACT: Whether you use ArcGIS to manage data and asset information, engage with internal and external stakeholders, perform spatial analysis (or, all of the above!), you know that there are a variety of applications and implementation patterns that meet your needs. This session will put those different options into context by providing an overview of ArcGIS, including a look at new and future capabilities. Understanding how the different components of ArcGIS work together and what capabilities are provided will help you better understand how ArcGIS is a complete platform that allows you to unlock the power of location, which leads to improved decision-making. Note: this session is divided into two 30-minute sessions. Part 1 will focus on the Desktop, and Apps, and Part 2 will concentrate on Enterprise and ArcGIS Online.


Tuesday May 8, 2018 10:30am - 11:00am
Room 102

10:30am

PRESENTATION: Mapping and Analysis of Walkability and Bikeability on the Daniel Webster Highway, Merrimack, New Hampshire
AUTHORS: Matt Waitkins, Nashua Regional Planning Commission; Sara Siskavich, Nashua Regional Planning Commission; Ryan Friedman, Nashua Regional Planning Commission; Andrew Smeltz*, Nashua Regional Planning Commission

ABSTRACT: Making roadways and other urban infrastructure favorable for bicycles and pedestrians has numerous benefits for communities and society at large. In order for planners to make informed decisions on where to allocate resources for bicycle and pedestrian improvement projects, it is necessary to review and analyze a variety of GIS data sources and take input from constituency groups. In this project, staff members from Nashua Regional Planning Commission (NRPC) assisted the Town of Merrimack, NH, acting through its planning board, in compiling and analyzing various types of spatial data, which we used to map current conditions for bicycling and walking on the Route 3 (Daniel Webster Highway) corridor. Our goal was to assist the town in identifying areas most in need of improvements to pedestrian and bicycle infrastructure. NRPC collected field data on existing pedestrian and bicycle features using the NH Statewide Asset Data Exchange System (SADES), which we merged into an existing statewide dataset. With ArcGIS, we analyzed roadway segments for bicycle and pedestrian level of stress and mapped these findings in the context of datalayers characterizing existing conditions. We also synthesized the planning board?s anecdotal observations and added them to the map as graphical elements. Our final product is a map that incorporates objective spatial data with interpretive analysis. After further public comment and any subsequent refinement, the map will be used to inform a corridor plan that summarizes analyses, recommendations, and action steps that address the town's specific goals and priorities for pedestrian and bicycle infrastructure.


Tuesday May 8, 2018 10:30am - 11:00am
Room 201

10:30am

PRESENTATION: Mapping Call Before You Dig Tickets with Collector for ArcGIS
AUTHORS: Rich Gallacher, GISP Town of Manchester; Liz DaRos, GISP Town of Manchester

ABSTRACT: During construction season the Town of Manchester receives on average 20-30 Call Before You Dig (CBYD) tickets from the CBYD Call Center in the form of emails. The Town has two business days for routine tickets to mark out underground utilities allowing for construction to start. For emergency tickets such as a broken water service, the Town must immediately mark out the construction zone. The Town's GIS Unit was tasked to create a mobile application that would automatically map incoming CBYD ticket emails allowing the Town's locator staff to schedule the daily CBYD mark out's more efficiently and to keep an inventory of all the CBYD tickets for the entire construction season. The GIS Unit used ArcGIS Desktop (ArcPy) and Collector for ArcGIS/ArcGIS Online to create a mobile application that allowed locator staff to see incoming CBYD tickets on their mobile devices, determine if they were routine or emergencies, edit the ticket attributes at the construction zone and associate photos with each ticket.


Tuesday May 8, 2018 10:30am - 11:00am
Room 205

10:30am

PRESENTATION: Practical GIS Drone Applications
AUTHORS: Andy Street, CivilView, Inc.

ABSTRACT: Over the past several years, the functionality of drone technology has rapidly improved. Applications fit into many industries and the GIS world is no different. High resolution, georeferenced orthomosaics easily insert into GIS and drone data can be processed to provide planimetric and topographic data that is both accurate and current. This data can be quickly captured and produced. While the general outputs are often known, sometimes real world, practical applications are not as easy to pinpoint. This presentation explores how the use of drones can enhance actual GIS projects through several case studies. Asset management and inventory projects are made easier by high-resolution imagery that clearly displays surface features. Gone are the days of waiting for another manned aircraft flyover to update base mapping after new developments or capital projects are complete. Drone technology is another tool in the tool belt for GIS professionals to accurately manage and present information about in-the-moment conditions.

Tuesday May 8, 2018 10:30am - 11:00am
Room 202

11:00am

ESRI SESSION: ArcGIS Platform Overview Part 2 (Enterprise)
AUTHORS: Rachel Weeden, Mark Scott

ABSTRACT: Whether you use ArcGIS to manage data and asset information, engage with internal and external stakeholders, perform spatial analysis (or, all of the above!), you know that there are a variety of applications and implementation patterns that meet your needs. This session will put those different options into context by providing an overview of ArcGIS, including a look at new and future capabilities. Understanding how the different components of ArcGIS work together and what capabilities are provided will help you better understand how ArcGIS is a complete platform that allows you to unlock the power of location, which leads to improved decision-making. Note: this session is divided into two 30-minute sessions. Part 1 will focus on the Desktop, and Apps, and Part 2 will concentrate on Enterprise and ArcGIS Online.


Tuesday May 8, 2018 11:00am - 11:30am
Room 102

11:00am

PRESENTATION: An Analysis of Enhanced Tree Trimming Effectiveness in Connecticut using a Geospatial Approach
AUTHORS: Jason Parent, University of Connecticut; Tom Meyer, University of Connecticut; John Volin, University of Connecticut; Robert Fahey, University of Connecticut; Chandi Witharana, University of Connecticut

ABSTRACT: We evaluated the effectiveness of an enhanced tree trimming (ETT) program for its ability to reduce tree-related power outages on an electric distribution system during storm events. Evaluations encompassed thirteen years of trimming (i.e. 2005-2017) data and were performed for both backbone (originating directly from a substation) and lateral (offshoots of backbones) utility lines. The study site spanned the entire state of Connecticut, where the dominant vegetation is temperate deciduous forest. We controlled for variations in weather, tree cover, and wire type, by pairing ETT-treated zones with nearby untreated zones. ETT-treated and untreated control zones had the same wire type and similar percent tree cover and line lengths. Relative outage rates were calculated for each pair to indicate the performance of ETT-treated zones relative to background outage rates of untreated zones. ETT-treated backbone conductors had overall outage rates that were 0.07 - 0.09 outages/km/year lower than untreated backbones, which is a 33 - 42% reduction when compared to all untreated laterals (0.2 outages/km/year). ETT-treated lateral conductors had significantly lower outage rates, than untreated laterals, for "minor" outage types (i.e., blown fuse, tripped recloser, etc.) but not for "major" outage types (broken poles or wires). Overall outage rates on laterals were reduced by 0.07 - 0.36 outages/km/year which amounts to 35 - 150% reduction over the outage rate for all untreated lateral zones; it should be noted that these results are applicable only to storm-damaged areas. Our study provides a robust empirical evaluation of ETT and also proposes a geospatial methodology that controls for variations in weather and environment.


Tuesday May 8, 2018 11:00am - 11:30am
Room 205

11:00am

PRESENTATION: Generating a 3D Point Cloud from UAV Images
AUTHORS: Katrina Schweikert, Blue Marble Geographics

ABSTRACT: These days, it seems that more and more people are discovering creative uses for UAVs or drones. Whether it's Amazon's plans to deliver packages, film makers looking for that perfect shot, or law enforcement officials keeping an eye on the bad guys. The GIS industry is eagerly jumped on this proverbial band wagon, with the rapid proliferation of UAVs opening the broad field of remote data collection and processing to an ever wider audience. Continual improvements in airborne technology and the miniaturization of the requisite sensors has cultivated a nimble new branch of the industry that provides cost-effective data collection services on demand. In this presentation we will explore one increasingly common workflow for UAV operators, in which overlapping geotagged images are processed to create a high-density 3D point cloud. Using the new Pixels-to-Points tool in Global Mapper's LiDAR Module, we address the challenge of calculating the volume of a landfill represented in a surface model derived from a photogrammetrically-generated point cloud. This procedure involves initial visualization of the array of images to ensure optimal and consistent coverage of the landfill area; the establishment of the parameters and settings that allow the output to be customized; the generation of the point cloud along with an accompanying orthoimage and 3D mesh; the identification, reclassification, and filtering of ground or bare earth points; and the creation of a precise Digital Terrain Model (DTM) from which accurate volumetric calculations can be derived.

Tuesday May 8, 2018 11:00am - 11:30am
Room 202

11:00am

PRESENTATION: MassDOT GIS for Municipalities
AUTHORS: Quinn Molloy, MassDOT GIS

ABSTRACT: MassDOT's GIS Services group has been working to better serve municipal partners through the development of new tools and increased access to web-based workflows. Using the geoDOT portal (AGOL) as a staging area for innovative solutions, staff has worked with municipalities to create a suite of new products that help better maintain transportation facilities in the real world, and the data that represent them digitally. Tools like the Road Inventory Update Tool, the Highway Project Intake Tool, and Pictometry Explorer bring classic transportation planning processes to the next level. It is our hope that these and tools yet to be developed will empower local governments with a limited staff capacity to take more of an active role in data stewardship without needing to invest heavily in infrastructure themselves.


Tuesday May 8, 2018 11:00am - 11:30am
Room 201

11:30am

ESRI SESSION: Insights for ArcGIS
AUTHORS: Rachel Weeden

ABSTRACT: We all know that GIS allows us to learn more about where, why, and how things happen; but we also know how challenging it can be to sort through a variety of large or complex datasets looking for that understanding. Insights for ArcGIS is a new application that will change the way you work with your data, and helps you perform complex spatial analysis from disparate data sources. Learn how Insights provides a new interactive analysis environment, ideal for both the GIS and non-GIS users that puts the focus on the visual exploration of your data through maps, charts and tables.


Tuesday May 8, 2018 11:30am - 12:00pm
Room 102

11:30am

PRESENTATION: ESRI Drone2Map
AUTHORS: Patrick Demer

ABSTRACT: Drone2Map for ArcGIS streamlines the creation of professional imagery products from drone-captured still imagery for visualization and analysis across the ArcGIS Platform. See the software in action using imagery captured from a water treatment plant in California.

Tuesday May 8, 2018 11:30am - 12:00pm
Room 202

11:30am

PRESENTATION: Optimizing School Bus Routing
AUTHORS: Nicole Rogers, EIT*, Greenman-Pedersen, Inc.; John Diaz, P.E., PTOE, Greenman-Pedersen, Inc.

ABSTRACT: Many school districts have been proactive in investigating delayed high school start times because of the national scientific research validating the academic/health benefits of additional sleep for high school students. This presentation provides insight to implications of pupil transportation as it becomes a critical operational and fiscal aspect when altering school scheduling. GPI completed a study for Acton-Boxborough which analyzed the implications of merging from a three-tier start time/routing system to a two-tier start time/routing system and created a new optimized routing schedule for the school choice district. An in-depth analysis of the existing transportation practices resulted in the recommendation of several new policies with the intent to minimize the number of buses required for a two-tier merge including: planning based on actual ridership; removal of cul-de-sac service; "cluster" stops; student pick-up/drop-off time window; and district seat target rates. GIS tools were utilized to implement cluster stopping which located optimal bus stops to safely service more students in a shorter amount of time based on a district wide ?walk to stop? distance. Stop locations were determined via density mapping and students were assigned via the closest facility layer tool. GPI also utilized TransFinder, a school bus routing software, in conjunction with ArcGIS to map final routing into existing database for a seamless transition._x000D_ Overall, the merge resulted in a reduction of overall trips, dead head mileage, total bus stop time and trip duration, better utilization rates, and most importantly a 40-minute delay in school start time for high school students.


Tuesday May 8, 2018 11:30am - 12:00pm
Room 201

11:30am

PRESENTATION: The Re-purposing of Two Rural Towns for New York City's Water Supply Watershed, and Challenges in Historic Geographic Analysis
AUTHORS: Neil Curri, PVE, LLC; April Beisaw, Vassar College

ABSTRACT: New York City began creating its distant watershed with the construction of the Croton Dam at Yorktown in 1837. Over the next 150 years, subsequent reservoirs would displace thousands from homes and businesses by submerging land and by regulating land uses within the larger watersheds. In this study, we attempt to measure the impacts of the New York City watersheds on two rural communities (Town of Olive in Ulster County and Town of Kent in Putnam County) in terms of lost land for businesses, farmsteads, villages, roads, etc. A series of maps show how the watershed permanently changed the composition and character of both communities, and encourage new dialogue regarding the acceptable costs of water management programs. There are many challenges when using archival sources to generate historic geographic analyses, but the long-term perspectives that can be generated (here maps show over 100 years of changes) are well worth the added effort.

Tuesday May 8, 2018 11:30am - 12:00pm
Room 205

1:15pm

ESRI SESSION: ArcGIS Enterprise 10.6 and the Site Builder
AUTHORS: Alex Brown

ABSTRACT: The ArcGIS Platform supports automation in two distinct categories: Deployment & Operational efficiencies.  Enterprise Builder and Chef, an IT standard automation framework , offer two distinct patterns for deploying ArcGIS Enterprise -- The session will provide an overview of deployment automations, the Chef framework, demonstrate how to utilize the tools, and provide resources for understanding your deployment options.

Tuesday May 8, 2018 1:15pm - 1:45pm
Room 102

1:15pm

PRESENTATION: 2020 Census Participant Statistical Areas Program (PSAP)
AUTHORS: Cynthia Hale Gillham, U.S. Census Bureau; Trent A Berger, U.S. Census Bureau

ABSTRACT: The decennial census is fast approaching. The 2020 Census Participant Statistical Areas Program (PSAP) offers regional planning organizations, councils of governments, and local governments the opportunity to review and modify select statistical boundaries that the U.S. Census Bureau uses to collect data in your community, so that we can give you the most relevant, useful information possible. Statistical boundaries let us give you the small-area statistics and spatial data you need. The 2020 PSAP geography review includes census tracts, block groups, Census Designated Places, Census County Divisions, and for the first time, American Indian and Alaska Native areas. Data made available by Census for these statistical areas is often used in grant applications to fund community and regional development, education, agriculture, energy, and environmental programs, as well as other needed community improvements and enhancements. You know your local community best. By participating in PSAP, you can help us provide relevant, useful data about population, income, and housing for small-geographic analyses. The Census Bureau will use the statistical areas defined for the 2020 Census to tabulate data for the 2020 Census, Annual Population Estimates Program, the American Community Survey (ACS), and Economic Census throughout the decade. Come learn more about PSAP today. The next opportunity to review and delineate statistical areas will not come again until Census 2030!


Tuesday May 8, 2018 1:15pm - 1:45pm
Room 205

1:15pm

PRESENTATION: Building Effective Dashboards for Web-based ArcGIS Apps
AUTHORS: Larry Spraker, VHB*; Dale Abbott, VHB*

ABSTRACT: When designing and developing dashboards for web-based applications using ArcGIS Online or Portal for ArcGIS, there are many different options. This presentation will provide an overview and demonstration of the various tools within the ArcGIS platform for deploying effective web-based dashboards as well as the pros and cons of each. ArcGIS technology to be discussed, compared and demonstrated include Operations Dashboard, Insights, Web App Builder, StoryMaps, and ArcGIS Maps for PowerBI.


Tuesday May 8, 2018 1:15pm - 1:45pm
Room 202

1:15pm

PRESENTATION: NH Statewide Asset Data Exchange System (SADES): Statewide Mapping Tool for Roadside Assets
AUTHORS: Chris Dowd, SADES Manager

ABSTRACT: Through a partnership with the New Hampshire Department of Transportation (NHDOT) the University of New Hampshire Technology Transfer Center (UNH T2) hosts a suite of statewide collection modules for a variety of roadside assets. UNH T2 facilitates the development, training, and technical support for these statewide collection efforts. UNH T2 leverages ESRI ArcGIS products to change the way data is collected across New Hampshire. Users of SADES range from State agencies, Regional Planning Commissions (RPC), and municipal level. Current collection efforts include: Stream Crossings, Guardrails, Road Surface Condition, Pedestrian Infrastructure, and more.


Tuesday May 8, 2018 1:15pm - 1:45pm
Room 201

1:45pm

ESRI SESSION: The ArcGIS Python API
AUTHORS: Alex Brown

ABSTRACT: The ArcGIS Python API is a powerful, modern and easy to use Pythonic API for GIS professionals, developers, organization administrators, content publishers and anyone with access to the ArcGIS Platform – specifically this refers to either ArcGIS Online or ArcGIS Enterprise.   The session will provide an overview of the python API, how one can leverage the tools within, demonstrate some basic use cases for administering a Web GIS, and provide additional resources to get started.

Tuesday May 8, 2018 1:45pm - 2:15pm
Room 102

1:45pm

PRESENTATION: Election Polling Place Solutions
AUTHORS: Amanda Guers*, GeoDecisions

ABSTRACT: Finding the correct polling place is important on Election Day. Using a website specifically set up to find the correct polling place prior to Election Day can help make the process of getting to the polling place to vote easy. Hanover County, Virginia enlisted the help of GeoDecisions to make this a reality for their residents. GeoDecisions incorporated Hanover County's data into ESRI's Election Polling Places for Web App Builder as a solution to Hanover County's request. Within this application, residents can find their polling location by searching for their address or clicking their location on the interactive map. If additional assistance is needed, this application generates turn by turn directions and gives other helpful information. All of this information can be printed out or used on a mobile device as well. This application is useful for county residents.


Tuesday May 8, 2018 1:45pm - 2:15pm
Room 202

1:45pm

PRESENTATION: Integrating Field Collected Data into Linear Referencing Systems (LRS): The Case for Crash Data
AUTHORS: Mike Kamalabad*, University of Connecticut - Connecticut Transportation Safety Research Center

ABSTRACT: The Connecticut Transportation Safety Research Center supports the Connecticut Department of Transportation (ConnDOT) in maintaining sophisticated crash data entry, collection, and safety analysis systems. Advanced safety analysis methodologies, such as those outlined in the Highway Safety Manual, require accurate and robust crash data. Embarking upon an effort to enhance safety analysis capabilities, enterprise crash data, with multiple forms of location information, is integrated into a linear referenced roadway network maintained by ConnDOT to ensure consistency and accuracy. This presentation seeks to outline the process via ArcGIS Desktop and the challenges encountered in properly integrating crash data into the ConnDOT roadway network. Additional discussion will address the potential benefits of integrating field data into LRS - including validation, visualization, analysis, and metrics.


Tuesday May 8, 2018 1:45pm - 2:15pm
Room 201

1:45pm

PRESENTATION: Municipal Solutions with AGOL and Collector
AUTHORS: Fred Kapinos*, Town of West Springfield, Stephanie Straitiff*, Town of West Springfield.

ABSTRACT: 'The Town of West Springfield has developed several innovative approaches to using GIS for municipal applications. Using AGOL with related tables, our Building Department and Town Clerk have switched to using Collector to track building permits and dog licenses, instead of relying on outdated and under-supported software. We also implemented a Python script to send notification emails when new features are added to a DPW Request map, which alerts supervisors to work requests and potential emergencies. Moving forward this year, we hope to use Survey123 for Health Department inspections, as well as AGOL GeoForms--allowing utility companies to submit Street Occupancy Permits directly to our Engineering Department. All of these GIS applications are complemented by browser-based SQL reports, which can be customized to fit each department's unique needs. The goal of this presentation is to provide an overview of how we implemented these applications and address the issues we encountered along the way.


Tuesday May 8, 2018 1:45pm - 2:15pm
Room 205

2:15pm

ESRI SESSION: Introduction to the ArcGIS Utility Network
AUTHORS: Patrick Demer

ABSTRACT: Utilities have been using the geometric network and ArcMap to manage their water, gas and electric networks since 2000. In January with the release of ArcGIS Enterprise 10.6 and ArcGIS Pro 2.1 we introduced a new extension for ArcGIS Enterprise to help utilities manage their networks. With this update come many new advancements which will be covered and demonstrated in this session.

Tuesday May 8, 2018 2:15pm - 2:45pm
Room 102

2:15pm

PRESENTATION: Building an Ecosystem of Data Users
AUTHORS: Michelle Riordan-Nold, CT Data Collaborative

ABSTRACT: Striving for informed decision-making across Connecticut, the CT Data Collaborative empowers an ecosystem of data users by democratizing access to public data and building data literacy. With the increased availability of public data and open data initiatives, users now find themselves with more data than they could have accessed even a decade ago. Though data users have more data at their fingertips, their ability to evaluate data quality and navigate data analysis and reporting remains a challenge. In this session, we present our work to make data not only available but also accessible through www.ctdata.org; our efforts to liberate public data; and our data user engagement workshops held through our CT Data Academy-- designed to increase data literacy, expand data capacity and enable all to use data effectively.


Tuesday May 8, 2018 2:15pm - 2:45pm
Room 205

2:15pm

PRESENTATION: CT Crash Data: Meandering Through a Wealth of Information and Methodologies to Produce Viable Results in ArcMap and ArcGIS Pro
AUTHORS: Mark Hoover*, CT MetroCOG; Mark Goetz, CT MetroCOG

ABSTRACT: The Connecticut Crash Data Repository provides access to detailed accident information from state and local police. Updating nightly, this dataset includes critical attribute information, in addition to accident location, that can help guide analysis. This presentation will detail the process in which MetroCOG utilized pertinent attributes along with ROW boundaries to perform hot spot analysis on state and local roads in ArcMap. It will highlight how scale and feature selection can create vastly different results. Space-time patterns were also explored using ArcGIS Pro. Following a published workflow from ArcGIS Analytics, hot spot trends were visualized using space-time cubes in 2D and 3D. Temporal trends were visualized graphically, and hot spots were scaled down to individual street segments. Finally, accident data was summarized by day of the week and hour of the day to identify peak days and time periods for accidents in the region.

Tuesday May 8, 2018 2:15pm - 2:45pm
Room 201

2:15pm

PRESENTATION: Hard-to-Survey Populations: Response Outreach Area Mapper (ROAM) by the U.S. Census Bureau
AUTHORS: Cynthia Hale Gillham, U.S. Census Bureau; James Bogart, U.S. Census Bureau

ABSTRACT: Nationwide, 79.3 percent of households that received a 2010 Census mail questionnaire completed it and mailed it back. The resulting non-response rate of 20.7 percent was not evenly distributed across the country, but rather varied greatly by location. The Census Bureau's Response Outreach Area Mapper (ROAM) application was developed to make it easier to identify hard-to-survey areas and to provide a socioeconomic and demographic characteristic profile of these areas using American Community Survey estimates available in the Census Planning Database. The Planning Database is publicly available, but it is a large comma-delimited file that requires software to open and explore it. Additionally, mapping the Low Response Score (LRS) metric (predicted mail non-response rate) from this data would require an entirely different set of software skills. ROAM is an interactive web mapping application developed to make the Planning Database and the LRS much easier access and visualize. In ROAM, Census tracts are classified and symbolized by their LRS, and users click on a tract to display a subset of socioeconomic and demographic variables to reveal what factors influence an area in being harder to count, eliminating the necessity of user software proficiency. ROAM Users include Census Bureau Field staff, local officials, external stakeholders and partners, and the public. Learning about each hard-to-survey area allows the U.S. Census Bureau to create tailored outreach, marketing, and promotional partnership campaigns, as well as planning for field resources such as hiring specialized staff with appropriate language skills. These and other efforts can improve response rates.


Tuesday May 8, 2018 2:15pm - 2:45pm
Room 202

3:00pm

ESRI SESSION: ArcGIS Online Tips and Tricks
AUTHORS: Krithica Kantharaj

ABSTRACT: ArcGIS Online gives you the ability to create interactive web maps and apps that you can share with anyone. With ready-to-use content, apps, and templates, you can be productive right away. From sharing your work with others to preventing accidental deletion of items and more, this session will provide tips and tricks that will help you maximize your use of ArcGIS Online.


Tuesday May 8, 2018 3:00pm - 3:30pm
Room 102

3:00pm

PRESENTATION: Did You See NBEP's Poster at the Fall Conference? This Is How We Did It. Harmonizing Data Across States to Create Sound and Natural Resource Indicators in a Shared GIS Database
AUTHORS: Eivy Monroy*, Narragansett Bay Estuary Program; Julia Twichell, Narragansett Bay Estuary Program; Anne Kuhn, US EPA Atlantic Ecology Division; Mike A. Charpentier, CSRA; Jessica Cressman, Environmental Data Center URI; Juliet Swigor, MassDEP; Peter August, University of Rhode Island; Paul Jordan, RIDEM; Courtney Schmidt, Narragansett Bay Estuary Program.

ABSTRACT: The poster presented at the 2017 NEARC Fall Conference "2017 State of the Bay and Its Watershed, Mapping Drivers of Change and Variation" was awarded People's Choice and Best Overall. This presentation describes the process and practices related to the results displayed on the poster and documented in 2017 State of Narragansett Bay and Its Watershed report by the Narragansett Bay Estuary Program (NBEP). The Narragansett Bay Watershed is bi-state (MA and RI) and there are obvious challenges for compiling and harmonizing data in a seamless way across political boundaries for which data are not consistent, insufficient, or not comparable in terms of what data is collected, data definition, and temporal and geographic-scale. These challenges are compounded when dealing with an extensive range of environmental indicators. The approach involved three best practices ? partnerships, data selection with a focus on spatial and temporal scales and representativeness, and using proper (and diverse) methods for each indicator (including advanced geospatial tools in ArcMap, and Dasymetric Analysis). The goal of bringing harmonized data together and developing sound science and data management continues with creating data sharing protocols and updating databases. Concrete benefits are visible - NBEP partners representing state, NGO, and academic institutions are requesting and using the improved geospatial and tabular data and results for their own initiatives, outreach and watershed management. Use of data that cuts across political boundaries facilitates better management for a common purpose - the conservation and enhanced environmental management of the bi-state Narragansett Bay and watershed.


Tuesday May 8, 2018 3:00pm - 3:30pm
Room 201

3:00pm

PRESENTATION: How to Communicate the Value of your GIS Program and Increase your Budget
AUTHORS: Michele Giorgianni*, Applied Geographics, Inc. (AppGeo)

ABSTRACT: To geospatial professionals, the value of GIS technology and services seems indisputable. But does the leadership of your organization feel the same? Do those who make decisions about budgets and investments, understand how GIS brings value to every department and every citizen each and every day? This presentation will focus on articulating and communicating the ROI (return on investment) of your GIS and garnering the support you need to build an innovative, thriving program. We'll describe methods for capturing and quantifying the current value (time saved, money saved, better decisions, mistakes avoided, and opportunities identified) and explore examples that will demonstrate value to your organization.


Tuesday May 8, 2018 3:00pm - 3:30pm
Room 202

3:00pm

PRESENTATION: Yes, Queries Can Be Spatial, Too
AUTHORS: Michael Olkin*, Springfield Water & Sewer Commission

ABSTRACT: Did you know that it's possible to conduct the most common types of spatial analysis without using any ArcGIS geoprocessing tools? Thanks to Esri's adoption of Open Geospatial Consortium data specifications, the power of spatial queries are available within geodatabases stored in relational databases (SQL Server, Oracle, SQLite, PostgreSQL, etc). In this presentation, we'll explore several ways to unleash the power of spatial queries in Microsoft SQL Server. Examples will include results displayed both in ArcGIS Desktop/Pro and in web/mobile map apps.


Tuesday May 8, 2018 3:00pm - 3:30pm
Room 205

3:30pm

ESRI SESSION: Using ArcGIS Maps for Office
AUTHORS: Mark Scott

ABSTRACT: Do you manage data in Microsoft Excel? Want to use Excel to create, use, and share this data in the form of a map? ArcGIS Maps for Office gives you the ability to create and analyze your spreadsheets using maps that can then be shared into your ArcGIS Online or ArcGIS Enterprise portal. Do you use PowerPoint as a presentation tool? See how to embed interactive maps into your presentation, and make a bigger impact at that next meeting.


Tuesday May 8, 2018 3:30pm - 4:00pm
Room 102

3:30pm

PRESENTATION: Demystifying Data Science and Putting it to Work for Geospatial Projects
AUTHORS: Guido Stein, Applied Geographics, Inc.

ABSTRACT: Why is data science becoming the new hipster of analysis? Can data science be a tool you can use for problem solving? How can you become a geospatial data scientist? Guido Stein will share his take on data science and how to answer questions geospatially using a data science approach. You will learn to use Jupyter, Python, and CartoFrames to process geospatial data and run experiments. Using these tools you will learn why Jupyter notebooks are core to building and sharing analysis across organizations and teams. It's not rocket science, it's data science.


Tuesday May 8, 2018 3:30pm - 4:00pm
Room 205

3:30pm

PRESENTATION: ROI - or NOT Another GIS Presentation
AUTHORS: Thad J. Dymkowski GISP*, 3SG Plus

ABSTRACT: Return on Investment is typically a clear cut metric for any project or tool. However, because GIS is an intangible technology that can provide solutions that cannot be easily equated or encapsulated it is challenging to resolve it as a number that can be quantified. Or is it? This presentation will examine ROI from the viewpoint of GIS. It will illustrate clear examples and provide evidence to support an ROI determination.


Tuesday May 8, 2018 3:30pm - 4:00pm
Room 202

3:30pm

PRESENTATION: Using Gazpacho and ArcGIS to Create Forecast Snowfall Bias, Error, and Composite Maps Stratified by Flow Regime
AUTHORS: Joseph P. Villani, NOAA/National Weather Service Albany, NY

ABSTRACT: In order to evaluate patterns of snowfall forecast error, the Gridded Automated Zonal Precipitation and Complete Hi-Res Output (GAZPACHO) verification program and ArcGIS were used to create maps of observed snowfall, zone-average snowfall and forecast error maps for 56 snowfall events in the National Weather Service Albany, NY County Warning Area (ALY CWA; eastern New York and western New England). Events from the 2013-2017 winter seasons were used for the study. The criteria for an event was when at least advisory level snow fell or advisory level snow was forecast (around 4 inches or greater somewhere in the ALY CWA). Each event was categorized by determining a representative wind direction and speed at 925 and 850 mb. The wind direction categories were 0-90, 90-180, 180-270, and 270-360. The wind speed categories were 0-19 kt, 20-39 kt, and 40 kt or greater. Twelve categories were defined based on the various direction and speed combinations. The winds were derived from Albany, NY (ALY) observed sounding data for each snowfall event. The wind direction and speed (at 0000 or 1200 UTC) closest to the midpoint time of each event was used to categorize each event. Forecast bias, mean absolute error (MAE), and snowfall composite maps were created for each of the twelve wind categories from the 56 total snowfall events using ArcGIS. Since there were 12 wind categories and 56 total snowfall events, some of the categories only contained a few events. However, there were several wind categories with five or more events. Results from a few of the wind categories using 925 mb winds will be presented, with some discernible patterns noted in the forecast bias, MAE and snowfall composite maps. It is hypothesized that some of the larger forecast biases can be attributed to terrain influences based on the over/under forecast of snowfall in favored upslope/downslope areas in the ALY CWA.


Tuesday May 8, 2018 3:30pm - 4:00pm
Room 201

4:00pm

ESRI SESSION: Implementing Workforce for ArcGIS
AUTHORS: Mark Scott

ABSTRACT: Do you manage a group of field crews ? Do they use Collector or Survey 123 to collect data and integrate it into web maps? See how Workforce for ArcGIS provides a simple tool to manage work in the field, fully integrated with your current use of ArcGIS field mobility apps like Collector, Survey 123, and Navigator, or as a stand-alone app. A project will be created, configured, and deployed in a live demonstration.


Tuesday May 8, 2018 4:00pm - 4:30pm
Room 102

4:00pm

PRESENTATION: Integrating Conversational Bots into Web Mapping Apps
AUTHORS: John Waterman

ABSTRACT: "Hey Siri: How do I add a chatbot to my map?" Using "Vermont Cow Talk" as an example, we will discuss how to mesh a conversational bot with spatial data. A Cowbot helping you discover Vermont through an interactive web map. "Vermont Cow Talk" is the 1st place award winning HACKVT 2017 app. It uses Amazon Lex. Moo.

Tuesday May 8, 2018 4:00pm - 4:30pm
Room 205

4:00pm

PRESENTATION: TBD
AUTHORS: Coming soon!

ABSTRACT: Coming soon!

Tuesday May 8, 2018 4:00pm - 4:30pm
Room 202

4:00pm

PRESENTATION: What Works in a GIS MOOC
AUTHORS: Peggy Minnis

ABSTRACT: Ten semesters of teaching a free online Desktop GIS class has yielded information about who takes such a course, what the retention of students is, how the students respond to their electronic rewards and how they evaluate the course when they finish.


Tuesday May 8, 2018 4:00pm - 4:30pm
Room 201