Using GIS Floor Plans for Office Space Coordination

Using GIS Floor Plans for Office Space Coordination Patrick Sowers King County Wastewater Division

Office Reorganization in Times of COVID-19 Background “We can pilot remote work for this one department (Natural Resources and Parks), and determine whether and how to expand across the County …to clean the air, ease gridlock, get more work done, and lead by example. ”

Move Staff from 5 th Floor • Coordinate move out of workspaces • Equipment/office asset management Uses for GIS Floorplan Safe Office Environment Moving Forward • Safe distance analysis • Pathways • Sanitation Stations • Staff Scheduling/Tracking

1. GIS Layers of office spaces Products 2. Prototype staff scheduling system

Goal - Staff Scheduling System

• Arc. GIS Portal – App Templates Software Options • Arc. GIS Indoors • More features, but likely more work to manage • Extra licensing costs

Arc. GIS Indoors

Data Development Host Data Process Staff Scheduling Form Applications - Edit and Dashboard

Data Development

Data Development 1. Georeference CAD. dwg file 2. Convert to GIS Line Feature Class

Data Development - Mind the Gaps

Creating Cubes – Feature to Polygon tool

Data Development - Sections

Data Development – Scheduling Table • Python itertools – permutation tool

Data Development – Host data to Arc. GIS Portal Cubes Sections Scheduling table

Making Edits - Arc. GIS Web App Builder

Arc. GIS Dashboard - Scheduling App Consumes Web Map

Survey 123 Scheduling Form

Survey 123 – URL Parameters • https: //survey 123. arcgis. com/share/565 b 9665721 d 4 c 0 4 aa 5 f 4 a 971 f 5 fee 36? portal. Url=https: //gisenterprisedev. kingcounty. gov/portal&mode=edit&object. Id=5281

App Demo

Related Data – No good way to symbolize out of the box Issues – Displaying Occupancy Status SQL Views – Slow rendering Multiple Features per Date/time – Slow Rendering

Future Development Opportunities Calendar Integration Automated Emails Asset Management Staff Tracking