Municipal Work Orders for Parks, Transportation, and Public Works

Daily-updated records detail maintenance tasks performed by city crews across parks, transportation, and public works departments. Data originates from Norfolk's CentralSquare Enterprise Asset Management platform, capturing costs, statuses, locations, and crew assignments for each work order. Updates are applied on weekdays.

Use Cases

• Analyze Total Cost and Contractor Cost by Department and Category Description to identify high-expense maintenance areas.
• Predict Priority or Status Code using features like Start Date, End Date, and Problem Description for task scheduling optimization.
• Map infrastructure issues by correlating Problem Code and Primary Task Description with geospatial columns like Street, Ward, and Planning District.
• Assess crew performance by examining the relationship between Assigned Crew, Actual Labor Cost, and Work Order completion times from Created DateTime to End Date.
• Track asset lifecycle and inventory by analyzing Inventory Type, Maintenance Zone, and Status Description over time.

Strengths

• Data is updated daily on weekdays, providing near-real-time visibility into municipal operations.
• Includes over 30 specific columns covering cost, location, timing, department, and task details for granular analysis.

Limitations

• Sample size and total row count are unknown, making it difficult to assess statistical significance.
• The geographic scope is limited to a single city (Norfolk), limiting generalizability.

Provenance

Source

City of Norfolk's implementation of CentralSquare's Enterprise Asset Management (Lucity) platform.

Collection Method

Operational data collected from field crews across multiple city departments.

Freshness

Updated daily on weekdays.

Geography

Norfolk, Virginia, USA.