KCGIS User Group

East Pierce County Interlocal Coalition (EPIC) Hub Site

Getting creative in government: an outside-the-box GIS solution supports high-quality customer service

Efficiently Produced Maps for Metro Snow Reroutes

no meeting this month

Road Asset Editor (Rae-Rae)

no meeting this month

Office cube reservations via ArcGIS Indoors

Seattle City Council Redistricting

Using GeoPackages for local geospatial analysis with OGR and SQL

no meeting this month

New wayfinding maps to help Link light rail riders complete their journeys

Data and tools for PSERN’s coverage testing

The Future of Work at King County

The DNRP Reservation Resource application supports the new Department of Natural Resources and Parks (DNRP) hybrid work model by displaying where work spaces are located across the region and information about those spaces. It also includes a reservation process. DNRP work spaces were identified across King, Pierce, and Snohomish counties and include a diverse variety of facility types, such as park shelters and conference rooms. The application was developed in King County’s ArcGIS Enterprise portal to provide easy, secure access to King County employees. It was created using Esri’s configurable ArcGIS Dashboard product which allowed for the inclusion of attribute filters and interactive components.

The Customer Support Services Tech Center application assists in suitability analysis for placing King County Information Technology (KCIT) tech centers around the county. These tech centers will offer on-site support for remote employees and enable them to receive services typically available only in downtown Seattle. By combining available parcel, building, and address data, and generalizing employee data by ZIP Code, insights are gained into where to place each tech center. The goal is to maximize the impact of each location and get an idea of how many employees could potentially be served in 15, 20, 25, and 30-minute drive times. This application is deployed in King County's ArcGIS Enterprise portal so KCIT planners have secure access. When the final locations of the tech centers are identified, employees will save time and work more efficiently from home by enabling them to access the KCIT services closest to them.

King County Council District Redistricting Process

The 2020 Census is complete! What are the next steps for King County? The County has created the 2021 Districting Committee to redraw King County Council Districts using the new Census data. By law, district boundaries must be realigned every 10 years to reflect changes in population distribution. Rebeccah will present King County demographic trends that the Districting Committee will use to prepare for their work. Dennis will explain how the King County GIS Center will be involved in supporting the committee in their work. For more information, please see the Districting Committee webpage.

Automating map folio production with ArcPy in ArcGIS Pro
Fred Lott, King County GIS Center

King County's Department of Natural Resources and Parks Shore Friendly team needs to generate a set of 14 maps for a parcel depicting different environmental scenarios before meeting with a property owner. This was previously a time- and labor-intensive task for staff, but no more! Fred will discuss what's new with mapping automation in ArcGIS Pro and arcpy.mp, his process for setting up the mapping script in Python, and how to turn it all into a user-friendly script tool.

Fred's slide presentation

ArcGIS Workforce integration with other mobile apps
Harkeerat Kang, King County IT Product Engineering

ArcGIS Workforce is a mobile app which is used to complete field assignments. A new version of Workforce with important new capabilities and some simplifications was released last year. Methods for integrating Workforce with other native apps changed. Harkeerat will discuss integration and intricacies of the newer version.

Harkeerat's slide presentation

GIS Potpourri 5

King County Staff

New Road Services Capital Improvement Project (CIP) data & public web application
Josh Popelka, King County GIS Center

King County Road Services Division and KCIT staff created new CIP feature classes to provide an authoritative data source for the division’s capital improvement program. The data utilizes existing and familiar internal mapping workflows and combines location data with attribution from project management software via a nightly process. The final products from this process are two feature classes, one for internal use with detailed project management and financial data, and one for public consumption which includes basic project information. The public-facing data drives the new Roads CIP web application which is embedded into the new Roads CIP webpage and will provide the public with a reliable, automated resource for capital project information.

Josh's slide presentation

Using an Esri Hub community organization and initiative for project collaboration
Harkeerat Kang, King County IT Product Engineering

King County works very closely with various partnering cities in the county and non-profit organizations to help track revegetation projects. Come see how we are leveraging ArcGIS Online, Hub, and webhooks to manage project participants.

Harkeerat's slide presentation

Drowned Cities: Extreme Sea Level Rise

Jeffery Linn, King County GIS Center

Since creating his first sea level rise map of the city of Seattle, Jeffrey has created dozens of them for cities around the world. He will discuss the processes, cartographic techniques, and data sources he uses for these maps, as well as sources of inspiration for speculative place names.

GIS Potpourri 4

KCGIS Staff

Metro Transit Route Book Online (RBO)
Phil DeVault, Metro Transit

Metro publishes a 600-page transit route training manual twice a year. Phil will discuss the development of an online alternative.

Open Access COVID-19 Testing Locations Web Application
Toni Carpenter, King County GIS Center, Spatial Services

Public Health - Seattle & King County worked with the King County GIS center to create an online interactive map showing the locations of COVID-19 testing sites within King County. The locations provide testing for anyone who is experiencing COVID-19 symptoms or has been in close contact with someone who has COVID-19. Pop-ups for each testing site include phone number, website, insurance requirements, language interpretation and appointment details. The data is gathered by Public Health and the sites are located and mapped by King County GIS Center Spatial Services. The data and map are updated frequently.

COVID-19 Testing Locations

Salmon SEEson Web Application
Fred Lott, King County GIS Center, Spatial Services

Salmon SEEson is a site for finding salmon viewing sites, either in-person or virtually. It was built with ArcGIS Experience Builder, and uses custom pop-ups for displaying dynamic site information.

Salmon SEEson

Local Food Finder Web Application
Fred Lott, King County GIS Center, Spatial Services

Local Food Finder is Web AppBuilder application for finding local farm products. Local farm businesses submit data via several Survey123 forms. A Python workflow combines the form data into a feature dataset for the web app.

Local Food Finder

GIS Potpourri 3

KCGIS Staff

Using GIS floor plans to help coordinate office changes at King Street Center
Patrick Sowers, Wastewater Treatment Division

With the reorganization of staff at King Street Center coming soon, King County Wastewater Treatment Division is working to leverage GIS to help plan and schedule the move. Patrick will describe his process for creating GIS-formatted floor-plan data from CAD files. He will also demonstrate a dashboard application which can be used to schedule staff presence to help limit the number of people on the floor at one time.

Patrick's slide presentation

Utilizing ArcGIS Enterprise Portal
Harkeerat Kang, King County GIS Center, Software Engineering Team

King County Water and Land Resources Division, River and Floodplain Management Section is piloting the use of ArcGIS Enterprise Portal to manage GIS data in the field and office. Harkeerat will give a quick overview of Portal and discuss project start-up, the pros and cons of using ArcGIS Online vs. Portal, and more.

Harkeerat's slide presentation

Sharing drone imagery data through ArcGIS Enterprise Portal

Peter Keum, Wastewater Treatment Division
Peter will describe a workflow for leveraging the Portal platform to share imagery to King County staff via a webmap.

Peter's slide presentation (Slides.com)

no meeting this month

GIS for COVID-19 Roundtable

This meeting was held via Skype with speakers from across the country.

A round-table discussion on issues related to using GIS to support agency response to the COVID-19 crisis in our communities.

Many agencies struggle with how best to leverage GIS as part of their COVID-19 response efforts. This roundtable brought together people from the Puget Sound region and across the U.S. They shared a snapshot of their approaches for using GIS for COVID-19 response, including such challenges and issues as balancing personal location privacy with the public's desire to know case locations. After the panel discussion, the audience had an opportunity to ask questions.

Moderator: Greg Babinski, assisted by Mary Ullrich and Patrick Jankanish

Agenda

• Introductions: Greg [5 minutes]
• Speakers [9 speakers, 3-5 min each]
• Speaker roundtable [15 minutes]
• Open forum [20 minutes]
• Adjournment: Greg [5 min]

Speakers

1. Stephen Beimborn: City of Seattle GIS Manager (Washington)
2. Katie Miga, GISP, Fairfax County GIS Project Manager (Virginia) 
3. Joanne Markert, Washington State GIS Coordinator
4. Daniel Stoelb, GIS Program Coordinator, Oregon Office of Emergency Management (absent from call)
5. Joseph Elfelt, MappingSupport.com (Redmond, Washington)
6. Cheryl Wilder, Health GIS Professional (Houston,Texas)
7. Dara Seidl, EthicalGEO Fellow (San Luis Obispo, California)
8. Tamara Kamara, City of Detroit Enterprise Applications Manager (Michigan)
9. George Horning: King County GIS Manager (Seattle, Washington)

Video (YouTube)

King County Metro: Travel Options Web App

Adam Cabrera & Matt Kozleski, King County Information Technology

How do you deliver a simple and intuitive transit system app to a wide public audience? What if you combine the Layer List and Legend controls into a single control and take the GIS out of it? Or expand and modify the popup control and augment it with rich real-time information?

Adam and Matt will demonstrate King County Metro Transit's Travel Options app illustrating how they modified the standard UI/UX to deliver a user-friendly interface using the Web AppBuilder framework. This will include a deep dive into the interactive Legend control and modifications to the Popup control.

GIS for ESJ Best Practices

Greg Babinski, King County GIS Center

Greg will present an effort he is leading to develop and publish best practices for using GIS for issues related to equity and social justice (ESJ), which is being supported by an Ethical GEO Fellowship awarded to him by the American Geographical Society. This subject has been accepted by the GIS&T Body of Knowledge editorial board as a future GIS&T topic. Greg will cover the background and scope of the effort, as well as the project plan and schedule. Greg will also describe how GIS users with an interest in ESJ can participate.

Slide Deck

Using GIS in King County Elections to map voters and voter turnout

Katrina Sroufe & Vance Julien, King County Elections GIS

The King County Department of Elections maps voter turnout to inspire the community to get involved in voting. Come learn how Elections uses ArcGIS Online and GIS to map voter registration and turnout data.

no meeting this month

GIS Potpourri 2

KCGIS Staff

Connecting the Wastewater Treatment Division's facilities asset management system to GIS
Kim Vo, Wastewater Treatment Division (WTD)

Kim will describe the web application that WTD developed to locate and identify wastewater equipment assets. She will explain how she utilized the ArcGIS API for Python and ArcPy to integrate GIS with the not-GIS-friendly Computerized Maintenance Management System (CMMS) that the WTD Asset Management team is using. She will demonstrate how tabular asset data from the CMMS is accessed through ArcGIS Online.

GeoPackages: Your friendly new geospatial format
Fred Lott, KCGIS Center

Geospatial data is everywhere now—not just in Esri products—and a modern, open-exchange format is needed. Enter GeoPackages! If you want the portability and flexibility of shapefiles without the technical limitations, these might just be the solution. Fred will provide an overview of the features and use cases for GeoPackages in the current geospatial landscape.

Slide Deck

Using GIS to manage King County Elections ballot drop-box collections
Toni Carpenter and Harkeerat Kang, KCGIS Center

The King County Department of Elections went paperless earlier this year for the April election—no, not for ballots, but for managing and tracking ballot retrievals from drop boxes. Come learn how GIS apps were used to create work assignments, complete driver surveys, and display progress live on a dashboard. You’ll see how GIS helps your ballot travel to the Department of Elections headquarters to be counted.

GIS Potpourri

KCGIS Center Staff

Turning dumb map-label text into smart interactive-map data

Patrick Jankanish

Patrick will demonstrate a methodology for using text objects in an Adobe Illustrator map drawing to produce a geospatial overlay of associated polygons which include feature attributes derived from the text. The polygons can then be layered with the Adobe Illustrator map image in an interactive web map which has the effect of making the text labels selectable, producing pop-ups that reveal links to bus route schedules and maps. The methodology relies on tools in the third-party Illustrator plug-in, MAPublisher, with additional processing in ArcGIS.

Using R/RStudio as a fast and flexible data exploration tool
Fred Lott

Fred will discuss how he’s been using R, and specifically the tidyverse  packages, as a data exploration and analysis tool for census, building footprint, and property data. R provides options for manipulating large datasets that might otherwise be unwieldy in Excel or ArcGIS. Starting with importing data from CSVs and database connections, several methods of data cleanup, filtering, and summarizing will be demonstrated.

Understanding King County Demographic Index and Demographic Base datasets
Mary Ullrich

King County provides a wealth of demographic information from the Census Bureau through its spatial data catalog, data download portal, and open data site. Two of these datasets take the heavy lifting out of data compilation: Demographic Base and Demographic Index. Mary will explain the differences between these datasets and the methodologies that produce them.

Ground-Truthing: GIS as a Community-Based and Anti-Racist Praxis
Veronica Velez, Western Washington University, Associate Professor and Founding Director of the Education and Social Justice Minor

Critical race spatial analysis (CRSA) is a recently developed methodological framework that extends GIS from its traditional use in geography and urban planning into new avenues and possibilities for examining educational interests concerned with the social, cultural, political, and historic role of space and place as it relates to schools and educational inopportunity. By re-imagining how socio-spatial relationships are explored, analyzed, and displayed, CRSA positions GIS as a critical research tool for addressing spatial inequities and furthering racial justice efforts within education and beyond.

This presentation explores the potential of CRSA as critical community-based and anti-racist praxis through a case study of Latina immigrant mothers who initiated a community-led GIS project to explore spatial indicators of educational inopportunity, drawing evidence from their own lives and the lives of their children. These mothers engaged GIS to tell counter-cartographic narratives about the racial divides, or “color lines,” defining uneven geographies of opportunity in their school district. By redefining GIS mapping as a community-based praxis, the mothers “ground-truthed” the maps, revealing spaces and spatial relationships that otherwise would go unnoticed. They transformed the power of the maps to rest not in their “gee-whiz” displays of data, but in the weaving of a spatial narrative that linked their current efforts to historical struggles for educational equity.

Methodologically, their efforts reveal the potential of GIS and CRSA to build spatial models of the world from the lived experiences of People of Color. Beyond the importance of GIS for critical race research, it also serves as an important pedagogical tool for teaching about race and racism. Through a CRSA framework, GIS maps function as teaching devices that highlight the importance of geographical and spatial features for maintaining racial divides in schools and society.

Slide Deck

Video

Martin Luther King, William Bunge, URISA, and GIS for Equity and Social Justice

Greg Babinski, King County GIS Center, Marketing & Business Development Manager
Nicole Franklin, King County Information Technology, Diversity and Inclusion Manager

Beginning with the coincidence of Martin Luther King, Jr.’s “I Have a Dream” speech and the precursor conference for the Urban and Regional Information Systems Association (URISA) on Wednesday, August 28, 1963, we will survey the role of GIS in addressing issues of Equity and Social Justice (ESJ).

Professor William Bunge, who earned a doctorate in geography from the University of Washington in 1960, anticipated the development of GIS through his work in theoretical geography. Bunge also pioneered the use of quantitative spatial analysis and applied geography as tools to address community-based social issues. Bunge’s time at the UW coincided with the tenure there of Edgar Horwood who first applied computer technology to urban planning. Horwood also organized that August 1963 conference which led to the formation of URISA.

In this presentation we will survey research and publications related to Equity and Social Justice as reported in URISA conference proceedings and workshops, and in the URISA journal, during the past 55 years. We will also outline how GIS is applied to ESJ issues at King County, other local agencies, and academic institutions. King County, which was renamed in 2005 for Dr. King, is a leader in applying ESJ criteria in all of its priorities and programs. We will describe how King County GIS supports this work by creating a rich foundation of data and tools to put ESJ analysis into the hands of everyone within the county and communities that we serve.

Slide deck

Announcing the Sound to Summit Regional GIS Study
Greg Babinski, King County GIS Center, Marketing & Business Development Manager

In Washington, public agency operating budgets are restricted by a mandated 1% limit on annual increases in property tax revenue. Fortunately, regional collaboration could lower the need for increases in GIS budgets by reducing duplication of effort and expense among local GIS operations. Regional sharing could also effect a shift of costs away from data maintenance and administration toward greater provision of services.

Recently the Sound to Summit Regional GIS Steering Committee announced the launch of a project to explore ways to collaboratively organize and operate GIS data and services within the region. The goal is to maximize the benefits and minimize the costs of GIS for all regional agencies while ensuring sustainability. A key outcome will be low-cost access for medium and small agencies to state-of-the-art GIS applications.

This presentation will describe the factors that motivated the launch of this multi-year project, outline our work plan, and provide examples of other viable regional GIS enterprises in the US and Canada.

Slide deck.

Vector tiles and other GIS news
Peter Keum, King County Wastewater Treatment Division

You’ve heard about vector tiles. You’ve used vector tiles in a variety of online maps, perhaps without even realizing it. But have you created your own vector tile maps? King County GIS specialist Peter Keum works with a variety of open source tools to create powerful vector tile map layers and maps. He’ll show us how.

Peter will also summarize what he learned at this year’s Washington GIS Conference and at the Mapbox Locate conference , their “first event celebrating and exploring the connectedness of the world around us.” Come hear Peter’s perspective on what’s new in GIS technologies!

Slide deck.

Rats! A virtual GIS-based guided tour of rat activity in Seattle's sewer system
A demonstration of the use of Esri's Collector for ArcGIS in Public Health's sewer baiting program
Leah Helms, Public Health — Seattle & King County

Public Health’s Environmental Health Services Division provides sewer baiting services to control rat populations in sewer systems in Seattle. In 2017 the program began utilizing the Collector for ArcGIS application to track the status of sewer manhole baiting with real-time data capture and display.

So what is sewer baiting anyway? Sewer manholes are assessed for rodent activity by the insertion of non-toxic monitoring bait. If there is activity, the manhole will subsequently be re-baited with rodenticide. Areas of the city that have sewer rat activity will be re-assessed annually.

From AVL to My Commute: How hard can it be?
Jeffery Gregg, GIS Analyst, King County GIS Center

To further assist travelers in making informed decisions about road conditions throughout King County, KCDOT wanted to have a layer added to the existing My Commute web-map application to show which County-maintained roads have been plowed or sanded within the previous hour at any particular time during a snow event.

On-board devices spit out streams of data from snow plows—GPS* waypoints in an AVL^† feed. Waypoints and timestamps (in GMT^‡) go into a database table every day. And… but I digress, just come to the User Group meeting to hear how we put the plows on the map. I'll cover the project objective, technical details, and project resolution. (But it probably won't be snowing.)

Slide deck.

*Global Positioning System
^†Automated Vehicle Location
^‡Greenwich Mean Time

no meeting this month