TO: Committee of the Whole - Finance, Administration, and Communications
FROM: Mayor Angela Birney
DEPARTMENT DIRECTOR CONTACT(S):
|
Technology and Information Services |
Michael Marchand |
425-556-2173 |
DEPARTMENT STAFF:
|
Technology and Information Services |
Melissa Brady |
Information Services Manager, Enterprise Data and GIS |
TITLE:
title
Enterprise Data and GIS Program Update
OVERVIEW STATEMENT:
recommendation
The Enterprise Data Management and Geographic Information System (EDM/GIS) group is part of the City of Redmond’s Technology and Information Services Department. The EDM/GIS Group is tasked with developing, maintaining and administrating the City’s enterprise data programs. We would like to provide Council an overview of major 2023 Enterprise Data and GIS Program accomplishments and to also highlight some current work that is being done in 2024. Partners are noted in parenthesis.
Major 2023 Accomplishments
Demographics Dashboard Phase 1 and 2 (Planning)
• Interactive Dashboard released in 6/2023 on Redmond.gov
• Dashboard shows Population and Housing data, Covered Employment data
• Demographics and Statistics | Redmond, WA <https://www.redmond.gov/818/Demographics-and-Statistics>
Environmental Sustainability Dashboard Phase 2 (Executive)
• Interactive Dashboard originally released in March 2022
• Phase 2 data included Fish Barrier on Class 2 Streams and Stream Length Complexity Good or Better
• Phase 1 data refreshed in 2023
• Environmental Sustainability Data Dashboard | Redmond, WA <https://www.redmond.gov/1726/Environmental-Sustainability-Data-Dashbo>
D365/Dynamics AX Reporting Platform (Finance)
• Internal Reporting Platform developed for financial data merging our legacy Dynamics AX and D365
• Migrated from Excel reports to modern Microsoft Power BI
• Reports include Budget vs. Actuals, Voucher Transactions, Project Reports, Purchase Requisitions and more.
• Future phases include publishing financial reports to Redmond.gov
Fire Prevention EnerGOV Reporting Platform (Fire)
• Operational Reports for Fire Prevention from EnerGOV permitting system
• Reports include Development Permit Intake, Development Inspection Performance, Incomplete Review, Completed Review, Review Overdue Amount, Inspection Status
Redmond 2050 Story Map: From Suburb to City Story Map (Planning)
• Interactive Story Map showing developed alternatives for how the City can accommodate anticipated growth.
• From suburb to city (arcgis.com) <https://storymaps.arcgis.com/stories/c54dd73333b3497295a675a599e0be98>
Redmond 2050 Story Map: Complete Neighborhoods Story Map (Planning)
• Interactive Story Map to support helping making neighborhoods more complete by meeting basic needs by walking or rolling close to home.
• Complete Neighborhoods (arcgis.com) <https://storymaps.arcgis.com/stories/738194955943407c9740f380a661577d>
Redmond Traffic Viewer Updates (PW)
• Enhanced the Redmond Traffic Viewer to include Travel Congestion and better imagery
• Redmond Traffic and Alerts Viewer <https://gis.redmond.gov/traffic>
Notable Upcoming 2024 Projects:
Redmond 2050: Zoning Code Story Map (Planning)
• Develop an interactive story map to help the public understand the changes coming to the City’s zoning code.
Community Health Dashboard (Planning, Fire, Police, Executive)
• Interactive dashboard to display data from multiple systems that highlights our client care activities and monitor performance measures.
Lead Inventory Application (PW)
• Implement an application to allow the Public Works Maintenance and Operation Center to inventory lead service lines in the City as required by the Environmental Protection Agency.
Snow Plow Tracker (PW)
• Develop an interactive webmap for the public to track our snow plows during winter storm events.
CCTV Application (PW)
• Develop an application to allow easy access to wastewater and stormwater pipe TV inspection data from the Closed Circuit Television (CCTV) trucks allowing for better capital replacement planning.
EV Study Support (Planning)
• Provide GIS support to the EV Study allowing our consultants to collaborate with staff through an online private GIS portal.
Stormwater Assessment (PW)
• Provide GIS support to the Stormwater Assessment Study allowing our consultants to collaborate with staff through an online private GIS portal.
EnerGOV SB 5290 reporting (Planning)
• Develop reports and dashboards to support the Washington SB 5290 that aims to increase the timeliness and predictability of local project review.
FireGauge PCR (Fire)
• Support the development of a Patient Care Record (PCR) quality control dashboard that will help Redmond Fire ensure that our data is accurate and meeting high quality standards.
body
☐ Additional Background Information/Description of Proposal Attached
REQUESTED ACTION:
☒ Receive Information ☐ Provide Direction ☐ Approve
REQUEST RATIONALE:
• Relevant Plans/Policies:
N/A
• Required:
N/A
• Council Request:
N/A
• Other Key Facts:
N/A
OUTCOMES:
N/A
COMMUNITY/STAKEHOLDER OUTREACH AND INVOLVEMENT:
• Timeline (previous or planned):
N/A
• Outreach Methods and Results:
N/A
• Feedback Summary:
N/A
BUDGET IMPACT:
Total Cost:
None
Approved in current biennial budget: ☒ Yes ☐ No ☐ N/A
Budget Offer Number:
Part of TIS Operational Budget
Budget Priority:
Responsible Government
Other budget impacts or additional costs: ☐ Yes ☐ No ☒ N/A
If yes, explain:
N/A
Funding source(s):
N/A
Budget/Funding Constraints:
N/A
☐ Additional budget details attached
COUNCIL REVIEW:
Previous Contact(s)
|
Date |
Meeting |
Requested Action |
|
N/A |
Item has not been presented to Council |
N/A |
Proposed Upcoming Contact(s)
|
Date |
Meeting |
Requested Action |
|
N/A |
None proposed at this time |
N/A |
Time Constraints:
N/A
ANTICIPATED RESULT IF NOT APPROVED:
N/A
ATTACHMENTS:
N/A