When the Compartment Is Empty and the Call Is Live
You pull Engine 3621 out of the bay at 0200, and somewhere between the Station 36 apron and the structure fire on Ridgecrest, someone asks where the portable pump is. Not which apparatus it's on — where on the apparatus. L6? R4? Lashed to the front bumper? Nobody wrote it down after the last drill, and the guy who would know is already in gear and on air.
That single gap — location without sub-location — is where fire station inventories collapse. Most departments have some version of a master equipment list. What they don't have is a live, queryable record that knows the difference between "on Rescue 3661" and "in the Med Locker on Rescue 3661." That distinction sounds pedantic until you're trying to find the C-Spine kit in the dark.
This template was built by someone who'd clearly worked actual apparatus. The Location field covers fourteen options spanning three stations, five engines, the WT 3651, Rescue 3661, the MKU, Special Ops Trailer, Felton, and the vendor — plus "Issued to FF" and "Other" for the edge cases. That's a real operational map, not a generic dropdown.
The Sub-Location Architecture Is the Whole Point
Thirty-seven sub-location options. L1 through L7, R1 through R7, C1 and C2, FB, RC, HB, OH, LHB, RHB. Then station-specific options: Inner Office, Training Bay, App Bay, Outer Office, Mezzanine, Bathroom, Ops Locker, Med Locker, CERT Locker, Special Ops, MKU, PL, PR, Kit, and Other.
That's not an accident — that's someone who mapped every compartment on every piece of apparatus in the district and encoded it once so nobody ever has to say "I think it's in a compartment on the right side" again.
The pairing of Location + Sub Location is what makes the system actually functional. An item tagged Engine 3622 / R3 can be found by any FF who knows the apparatus, on any shift, without a verbal handoff. When you pull up a filter on the Trauma Bag contents and every item shows Rescue 3661 / Med Locker, you can do a compartment check in under four minutes because you know exactly where to look and exactly what should be there.
The Category field — 21 options from Apparatus to Wildland to Haz Mat to MVA to Consumable — gives you the second axis. Cross-filter Location with Category, and you have a shelf-accurate compartment map. Filter on Out of Service in Condition, and you have your maintenance queue. Filter on Consumable with a low Quantity, and you have your reorder list before anyone has to do a physical walk.
Barcode Accountability Under Load
The Barcode field is the one that separates this from a spreadsheet. In a high-turnover environment with multi-shift operations and mutual aid apparatus moving between stations, the serial number field can catch most discrepancies — but serial numbers require someone to crouch down and read a stamped plate in bad lighting. A barcode scan takes two seconds.
The Online Manual URL field is the other underrated piece. PPE certification cycles, SCBA manufacturer specs, tool calibration procedures — they're all one tap away from the item record. No more hunting for a binder in the inner office because someone needs the maintenance interval on the Hurst cutter.
The kit taxonomy covers eleven options including the LARRO Red, LARRO Blue, Burn Kit, C-Spine, Trauma Bag, Command Bag, Litter, and Portable Water Tank. Any item that belongs to a kit gets tagged to that kit. When you pull the Trauma Bag for a refill after an MCI, you filter on Trauma Bag in the kit field and get every component that should be in it, with its last-known sub-location and condition rating. The repack becomes a checklist instead of a guess.
The Issued to field covers twenty-two names. When a piece of PPE or electronics is signed out to a specific FF, it lives in the database under their name. When that FF transfers or leaves the department, you filter on their name, pull every issued item, and process the return. No more gear floating in limbo because nobody tracked the handoff.
The Cost of Item and Date Acquired fields quietly handle the asset management side — insurance audits, grant documentation, replacement budgeting. One export, sorted by acquisition date, gives you everything a district manager needs for a capital equipment review.