Public WorksStandard
Work Orders
Manages road segments with PostGIS LineString geometry and Pavement Condition Index (PCI) scoring (0-100, mapped to 6 condition ratings from Excellent to Failed). Activities cover 14 types including pothole repair, resurfacing, crack seal, striping, snow/ice removal, and mowing — each auto-numbered (PW-YYYY-NNNNN) and tracked from reported → scheduled → in progress → completed. Crews are managed with specializations and member assignments. Street sweeping routes define frequency (weekly, biweekly, monthly, seasonal) with compliance monitoring. Road closures track detour geometry with geo-alert integration. Cost tracking covers materials, labor (with overtime), and equipment.
Key Capabilities
- Road segments with PostGIS geometry and PCI scoring (0-100)
- 14 activity types: pothole repair, resurfacing, snow/ice, striping, and more
- Crew management with specialization and member assignment
- Street sweeping routes with frequency tracking and compliance monitoring
- Road closure management with detour geometry and geo-alerts
- Cost tracking: materials, labor (with OT), and equipment per activity
Related Modules in Public Works
See Work Orders in action
Get a personalized demo tailored to your municipality's needs.