How to build a storm drain inventory map
What to record for each drain, how to rate its condition, a free spreadsheet template, and how to turn it into a shared map your crew updates from the field. Written for public works and stormwater teams who want the inventory on a shared map.
A storm drain inventory answers three questions before the next heavy rain: where are our drains, which ones are blocked or broken, and which ones nobody has looked at in a while. Your crew already knows most of those answers. Putting them on a shared map means everyone can see them, including whoever covers the route next.
A spreadsheet with the four columns below is a real inventory. Putting it on a map adds two things a spreadsheet cannot do: your crew records each inspection on a phone while standing at the grate, and the office sees the blocked and overdue drains at a glance.
What to record for each drain
Keep the form short enough to fill in at the curb. These four fields, plus the location and a photo, cover what you need to plan cleaning and repairs:
| Field | What goes in it | Why it matters |
|---|---|---|
| Condition | Good, Fair, or Poor | Your repair list. The scale is defined below so everyone rates the same way. |
| Blocked | No or Yes | Your cleaning list: water cannot get in today. |
| Last inspected | The date of the most recent visit | Shows which drains are overdue for a look. |
| Notes | Anything else worth knowing | “Sump about one third full of sediment.” |
How to rate condition
Ratings are only useful if two people looking at the same drain give it the same one. Agree on a short definition and keep it on the crew’s phones:
- Good: grate and frame intact, structure sound, little or no debris.
- Fair: still drains, but has minor cracks, a loose or worn grate, or sediment building up in the sump.
- Poor: broken or missing grate, a damaged frame or structure, or a sump so full it barely drains. Needs repair or cleaning soon.
Record blockage separately from condition. A sound drain covered in leaves is Good and Blocked; a cracked drain that flows freely is Poor and not blocked. Keeping the two apart gives you a cleaning list and a repair list instead of one mixed list.
How often to inspect
There is no single national schedule. If your town is covered by a municipal separate storm sewer system (MS4) stormwater permit, the permit requires a program for maintaining the storm sewer system, and many permits set how often catch basins are inspected or cleaned. Check the operation and maintenance, or good housekeeping, section of your permit. The EPA explains who needs an MS4 permit on its municipal stormwater page.
Without a permit schedule, a reasonable starting point is one visit per drain per year, plus a check of the known trouble spots before and after big storms. The Last inspected date is what lets you prove the schedule was kept.
Download the storm drain inventory spreadsheet template (CSV). It opens in Excel or Google Sheets, has these columns ready, and includes three example rows to replace with your own.
Create the Storm Drains layer
Sign up at map.rillium.com with a Google account, or with your email and a password (you confirm the address with a code we email you). Then create an organization for your town or department. There is nothing to install and no credit card. Next, set up the layer that will hold your drains:
- In the left sidebar, click Data.
- Click + New and choose Feature layer.
- Name it
Storm Drainsand set the Geometry type to Point. Geometry type cannot be changed later. - Click + Add field once for each row below.
| Field label | Type | Settings |
|---|---|---|
| Condition | Dropdown | Allowed values: Good, Fair, Poor. |
| Blocked | Dropdown | Allowed values: No, Yes. A default of No speeds up entry. |
| Last inspected | Date | Leave it optional, so you can add drains you have not inspected yet. |
| Notes | Memo | Free-form text. |
Use these exact labels if you plan to import the template. Each field gets a key generated from its label (Last inspected becomes last_inspected), and the template’s column names match those keys. Field types and keys cannot be changed after the layer is created.
Click Create feature layer. Photos are not a field: you attach them to each drain from its Attachments tab.
Import the drains you already have
If you are starting from nothing, skip to the next step. If you already have drains in a spreadsheet, or you filled in the template, bring them in now:
- Make sure the spreadsheet has
latitudeandlongitudecolumns in decimal degrees, and that its other column names match the template. Keep the template’sdisplay_idcolumn and leave it blank: a blank ID tells Rillium Maps the row is a new drain. - Save it as a CSV file.
- On the Data page, open the Storm Drains layer’s table and click Import CSV.
- Check the preview. It shows how many drains will be added and lists any rows with problems, such as a condition that is not one of your three options.
- Click Import.
Write dates as year-month-day, such as 2026-04-14, and leave the cell empty for drains that have never been inspected. Nothing is imported until the whole file is clean, so a bad row never leaves you with half an inventory.
Add drains in the field
First put the layer on a map. You only do this once:
- Click Maps in the sidebar, then New map, and name it
Storm Drains. - Open the map, click Layers, then + Add layer, and choose Storm Drains.
Now open the same map on your phone, walk to a drain, and record it:
- Tap Edit, then Add.
- Tap Use My Location to drop the point where you are standing, or tap the map to place it by hand.
- Fill in the form, with today as the Last inspected date.
- Open the Attachments tab and take a photo of the grate.
- Tap Add at the bottom of the form, then Save All.
On the next visit, tap the drain while editing, update Condition, Blocked, and Last inspected, and tap Apply, then Save All. Add a new photo if anything changed.
Poor signal in the field? Install Rillium Maps on your phone from the profile menu. Drains and photos you add without signal are saved on the phone and sync when you are back in coverage. The background map itself needs a connection to load, so open the area once before you head out.
See which drains need attention
This is where the map earns its keep over the spreadsheet.
Color drains by condition
- In the Layers panel, click the gear icon on the Storm Drains layer.
- On the Symbology tab, set Renderer to Categorized and Field to Condition.
- Set Good to green, Fair to yellow, and Poor to red, then save the layer settings.
Every Poor drain in town now stands out without opening a single record.
Build a work list before a storm
- In the same layer editor, open the Filter tab.
- Add a condition: Blocked equals
Yes. The map now shows only the drains to clean. - For overdue drains, change the condition to Last inspected is before the start of this year, or whatever your schedule requires.
A filter for Last inspected is empty finds the drains nobody has inspected yet. Remove the filter when you are done to see every drain again.
Share it with your crew
An inventory stays accurate only if the people doing the inspections can update it. Invite your crew into a group, which controls what they see and change:
- Open Members & Groups, create a group such as
Field Crew, and give it access to the Storm Drains map and the Storm Drains layer. - Set its permission level. Edit lets the crew update any drain, which an inspection crew needs. Contribute lets them see every drain, add new ones, and add photos or notes to any of them, but change only the drains they added. Read is for people who only need to look.
- In the group, click Generate link under Invite to this group and send it to your crew. Anyone who joins with it lands in the group with its access.
Groups limit people who join as Members, which is what a group invite link makes them. Owners, admins, and org editors already see everything.
That is the loop: the crew updates drains on their phones, and the office sees every change on the same map.
Your data stays yours
Export the layer to CSV, GeoJSON, or Shapefile whenever you want, for your permit report, a consultant, or your own backup. You can also connect QGIS to the layer over the open OGC API and edit it there, with changes saving straight back to Rillium Maps.
Start your storm drain inventory
Free to start. 2 maps, 3 layers, 500 features. No credit card required.
Open Rillium Maps