NG911 - build GIS representation of cell-sector routing spreadsheets

[eneemann]

Benefit

A GIS representation of cell tower sector routing can clarify the way cell tower sectors are configured to route wireless calls so the PSAPs have a better understanding and can make better decisions when PSAP boundaries change. When a cellular 911 call is made and the caller's location can't be determine within 1.5 seconds, the call is routing with a fallback method based on the cell tower and sector that the call is hitting. Right now, those sectors are configured to route to specific PSAPs based on spreadsheets. A GIS representation of these sheets would make them much easier to understand and facilitate decisions to change routing when misroutes occur or PSAP boundaries change. Demonstrating this analysis to PSAPs may help motivate them to analyze their areas, make adjustments, and decrease call transfers. UGRC could perform PSAP-level analysis upon request with an SBA.

Acceptance Criteria

• Build demo GIS polygon layer that represents sample of cell tower sectors and PSAPs they route to in fallback scenarios
• Acquire and add ECaTS call locations for a given period of time
• Perform analysis of calls by cell sector and PSAP, ID misroutes, show where calls in sector primarily originate
• Determine number/percentage of calls within City PSAP boundaries that would fall in UHP buffer
• Present analysis capability to group of PSAP directors

Notes

• Collect cell-sector routing sheets from all Utah PSAPs/carriers with UCA/Motorola assistance
• Combine cell-sector routing sheets into 1 dataset
• Plot coordinates of each cell tower/sector
• Build polygon representation of sectors w/ routing attributes (azimuth, beamwidth)

Risks

• Carriers might not be willing to share all routing sheets
• Routing sheets may have different schemas and information
• Poor data quality may render this task infeasible

Issue Reference

[eneemann]

FY25-Q4 Sprint 2

• Initially focusing on Davis county for analysis and demonstration
• Davis County cell tower sector polygons have been built
• Davis county 2024 call logs have been pulled from ECaTS and mapped
• Might try to integrate this analysis with UHP buffer discussion to analyze number of calls that would fall within the proposed freeway buffer

[eneemann]

FY25-Q4 Sprint 4

• Mapped all calls from 2024 and Jan-Apr 2025 for Davis county
• Performed analysis of call before/after Bountiful PSAP addition of Farmington/Kaysville
• Performed analysis of current call volumes against anticipated volumes if UHP buffer for DCSO was implemented
• Presented call volume analysis to UCA, Motorola, and Davis county PSAPs
• Met separately with UCA and Bountiful PSAP to show anticipated call volumes with DCSO buffer and how calls per day would likely return to similar numbers from 2024, prior to addition of Farmington/Kaysville

[eneemann]

FY26-Q1 Sprint 3

• Reached out to Weber Area 911 about project and presentation idea in August
• Didn't get a response and didn't follow-up due to lack of available time to pursue the project

[chriswnek]

Moved to FY26 Q3 and will reassess next steps in that quarter's PI Planning.

[chriswnek]

Moved this one to FY26 Q4, and will re-review in that quarter's PI Planning

[chriswnek]

Discussed in FY27 Q1 PI Planning, and for now will move this feature to the backlog.