Navigation

Discuss a projectsupport@lostonbell.com
Site mapPrivacy
Municipal systemsEditorial article

Municipal software: moving from spreadsheets to a managed process

Where to start with municipal software, how to assign responsibility, and how to check whether the new service helps staff in their everyday work.

A municipal software project is best started with one recurring process: requests about public space improvements, asset records, or document approvals. Follow several real cases from receipt to outcome. Where does the information originate, who makes the decision, who receives the task, and how is completion confirmed? This map will reveal where staff re-enter information, search for the latest file version, or call to check a status. These are the areas to include in the first stage of automation.

Describe how a task moves through the process

For each stage, define the person responsible, the input data, and the condition for completion. An “in progress” status offers little help if it simultaneously covers address verification, a specialist’s site visit, and waiting for a contractor’s response. Choose states that tell staff what to do next and show managers the reason for a delay. Separately describe returning a task for revision, transferring it to another department, and reopening it. Include these scenarios in the model early, before they become workarounds outside the system.

The next step is a shared data dictionary. The same asset may have different names in a department’s spreadsheet, on a map, and in a contractor’s documents. Agree on a stable identifier, address recording rules, required fields, and the source of each piece of information. Before migrating old data, assess duplicates, incomplete records, and inconsistencies. Prepare a small reference sample for a subject matter specialist to check manually. It is easier to agree on data cleanup rules using that sample than to dispute errors after a bulk import.

Check the system against real scenarios

Design access around staff responsibilities. The person carrying out a task needs assigned work and the information required to complete it; a dispatcher needs routing; a manager needs an overview of workload and deviations. Keep a history of changes to important fields: who corrected a record, when, and why. Review request forms and internal application forms with the people who will fill them in. If a staff member needs to keep a paper guide nearby, consider improving the hints, field names, or sequence of actions.

A pilot can be run in one department or a limited area with a clear flow of tasks. Before launch, measure the time spent registering requests, finding information, and preparing reports. Collect the same metrics during the pilot, noting exceptions and the amount of manual work. Acceptance examples should include a standard request, incomplete data, an incorrect assignment, and a repeat request. Evaluating these cases provides a more useful picture than demonstrating screens filled with prepared data.

Prepare the system for everyday operation

Before expanding the pilot, assign ownership of reference data, define how the process can be changed, and establish a support channel for staff. Prepare instructions for common actions, a backup schedule, and a recovery check in a separate test environment. List settings, integrations, access arrangements, and known limitations in the handover documents. The new system then has a clear role in the municipality’s work: staff know where reliable information is held, who owns a task, and what to do when a failure occurs.