100 likes | 121 Views
City of Overland Park requests work orders for street storm sign lights bridges R-O-W sidewalks ramps retaining walls guardrails inventory parts trees/parks usage. Installed on every Public Works computer, approximately 100 users, 70,000 work orders, and more. Learn about FEMA impacts, performance measures, maintenance history, and challenges in setup and database management.
E N D
GBA Master Series City of Overland Park
Requests Work Orders Street Storm Sign Street Lights Signals Bridges R-O-W Sidewalks Ramps Retaining Walls Guardrails Inventory (Parts) Trees/Parks Modules
Usage • Installed on every Public Works computer • Approximately 100 regular users • 70,000 work orders • 58,000 requests • 28,000 signs • 15,000 street lights • 800 miles of sidewalk • 30,000 storm structures • 600 miles of storm conduit
Impact/Advantages • FEMA • October 4, 1998 Flood • January 2002 Ice Storm • Performance Measures • Maintenance History • Central Repository
Challenges/Tips • Challenges • Structure set-up • Importing existing databases • Selling GBA to field personnel • Tips • Database administrator/support person • Spend a lot of time on the front end • Involve users from all parts of the department