STLCityRoute

STLCityRoute

CITY OF ST. LOUIS

MON
➕ Add Stop
Scan preview
Stops
0
📍
NO STOPS YET
Add an address above, paste a list, scan a photo, or upload a spreadsheet.
📡 GPS auto-detected on optimize
💡 To start from a specific stop, tap the 📌 pin button on that stop before optimizing.
🛣️
ADD STOPS FIRST
Go to Stops tab, then optimize here
Visual Route
🔴 Service Req🔵 Inspection🟡 Other📡 You
CITY OF ST. LOUIS
FIELD INSPECTOR
🏛️
Department · Division · Scope
TAP TO EXPAND ›
📊 Field Data & Metrics
RANGE
Today
📍 Stop Activity
📋 By Stop Type
🕐 Session Log
📧 Auto-Send Daily Summary
Recipients
Opens your email app with a pre-filled CSV summary. Recipients receive a copy of your daily field data.
💾 Stored History
🗺️
YourCityRoute
FIELD WORKER GUIDE
🧭 What is YourCityRoute?
YourCityRoute is a mobile route planner built for field workers who visit multiple addresses in a single shift — city inspectors, code enforcement officers, pest control techs, utility workers, property managers, and anyone else working a stop list.

No login. No server. All data stays on your device. Works offline once loaded. Install it to your home screen for the best experience.
🚀 Getting Started (5 minutes)
1. Set up your profile — Tap ⚙️ (top right) → enter your name, title, division, department, and contact info. This appears on your ID card and in all exports.

2. Select your position — In the same Settings screen, choose your role from the "Select Your Position" dropdown. This auto-fills your profile and pre-loads your Roles, Ordinances, and Summary pages.

3. Add your first stop — Go to the STOPS tab, type an address, and tap ADD. The app will geocode it and add it to your list.

4. Optimize your route — Go to the ROUTE tab and tap ⚡ OPTIMIZE. The app uses your GPS location and a nearest-neighbor algorithm to sort stops for minimum driving time.

5. Clock in — Tap ⏱ IN at the top of the screen when your shift starts. This enables shift tracking, break time, and accurate metrics.
📋 STOPS Tab
Adding stops:
· Type an address in the input field and tap ADD (or press Enter)
· 🎤 Voice — speak addresses one at a time; pause between each
· 📷 Photo scan — photograph a printed route sheet; AI reads the addresses (requires Anthropic API key in Settings)
· 📋 Paste — copy a list of addresses from any source and paste it
· 📊 Spreadsheet — upload a CSV or Excel file with addresses in the first column

Stop types: Tap the color badge on any stop to cycle through Inspection · Service Request · Work Order · General.

Stop buttons (left to right):
· 📝 Notes — add or view field notes for this stop
· 🔍 Property search — opens City property lookup for this address
· CSB — copies address and opens the Citizens Service Bureau request form
· 📍 ARRIVE — tap when you pull up to the stop; starts a dwell timer
· ✓ CLOSE — mark the stop complete; prompts for completion notes
· 🧭 (round, right) — navigate to this address via Google Maps

Completed stops collapse to a separate "Completed" section at the bottom. Use ↩ to restore or 🗑 to delete permanently.

Duplicate detection: Adding an address already on the list shows a prompt — tap to confirm or cancel.
🛣️ ROUTE Tab
⚡ Optimize Route Order — Sorts your pending stops using your current GPS location + nearest-neighbor + 2-opt improvement. A drive time estimate appears after.

📌 Pin a start — Tap 📌 on any stop to lock it as your first stop regardless of optimization.

↺ Reset Order — Returns stops to the order they were added.

▲▼ Reorder — Tap the arrows on any route card to manually bump a stop up or down in priority.

Route AI Narrative — After optimizing, if you have an Anthropic API key set, the app generates a brief plain-English description of the route sequence.

Navigate all — Tap 🗺️ in the route tab header to open the full multi-stop route in Google Maps (up to 10 waypoints).
🗺️ MAP Tab
Shows all pending stops as numbered pins on an interactive map. Tap a pin to see the address and access Navigate, Property Search, and Close from the map popup.

The map auto-fits to your stops when it first loads. Pinch to zoom, drag to pan. Completed stops are hidden; active stops show in route order.

If your stops are geocoded (most are), they appear immediately. Stops added by address alone may take a moment to place while the app looks up coordinates.
🪪 INFO Tab
ID Card — Your digital business card. Shows your name, title, division, department, scope, email, and phone. Tap it to show a fullscreen version. Upload an ID photo via ⚙️ Settings.

❓ Questions & Follow-Up — Contact information for departments you selected in Settings. CSB is always first. One-tap dialing.

⚖️ Roles & Authority — Three panels (Roles, Summary, Ordinance) loaded from your saved position. Use the position selector to preview any other role without changing your profile. Navigate away and your saved default restores automatically.

📄 Reference Documents — Upload and store images (maps, forms, permit templates, reference sheets) for quick in-field lookup.

📊 Data & Metrics — Your shift data, stop history, and export tools.

❓ Help & Guide — This page.

⚙️ Settings — Profile, photo, position, email, phone, API key, app install, and share link.
⏱ Clock & Shift Metrics
Clock In/Out — Tap ⏱ IN at the start of your shift. The elapsed work time appears below the button. Tap ⏱ OUT to end the shift.

☕ Break — While clocked in, a BREAK button appears. Tap it to pause the work timer. Your break time is tracked separately. Tap RESUME to continue.

Metrics tracked per shift:
· Stops completed and close rate
· Stops per hour and average minutes per stop
· First and last stop times
· Dwell time at stops (from ARRIVE → CLOSE)
· Return visits (same address visited more than once)
· Unique streets covered
· Overtime flag (shift > 8 hours worked)

All shift data is stored locally and included in your exports. Open the DATA tab to view and export.
📊 Data & Exports
Open the DATA tab from the INFO screen to see today's metrics and your shift history.

Date ranges: Today · 7 Days · 30 Days · All Time · Custom.

Export formats:
· CSV Spreadsheet — One row per stop. Columns: #, Inspector, Address, Type, Status, AddedAt, CompletedAt, DurationMins, Lat, Lng, Notes. Opens in Excel or Google Sheets.
· Text Summary — Three-section plain-text report (Field Worker, Manager, Geographic). Good for email.
· Push to Sheets — Sends data directly to a Google Sheet you control. Requires one-time Apps Script setup (see below).

Auto-send: Enable in the DATA tab to have a daily summary emailed automatically at a time you set.
📈 Google Sheets Setup
One-time setup — takes about 5 minutes:

1. Open a new Google Sheet at sheets.google.com
2. Click Extensions → Apps Script
3. Delete the existing code and paste the script below
4. Click Deploy → New deployment → Web app
5. Set "Who has access" to Anyone
6. Click Deploy and copy the Web App URL
7. In this app, tap Export → Push to Sheets → paste the URL

After setup, every time you tap "Push to Sheets" your latest stops and metrics are appended to your sheet automatically.
function doPost(e) {
  var data = JSON.parse(e.postData.contents);
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName('Stops') || ss.insertSheet('Stops');
  if (sh.getLastRow() === 0)
    sh.appendRow(['Date','Address','Type','Notes','Done','DurationMins','Lat','Lng','Inspector']);
  (data.stops || []).forEach(s => sh.appendRow([
    data.exportedAt, s.address, s.type,
    s.notes||'', s.done, s.durationMins||'',
    s.lat||'', s.lng||'', data.inspector
  ]));
  return ContentService.createTextOutput('ok');
}
🔧 Toolbar Buttons
These appear at the top of every screen:

· ⚖️ CASE — Opens Missouri Case.net (22nd Judicial Circuit) for municipal court case lookups
· 📞 CSB — Opens the Citizens Service Bureau. Copies the current stop's address to clipboard first if one is active
· 🔍 Search — City of St. Louis property lookup by address
· 📋 RESOURCES — Local contacts, city departments, wildlife rescue, property lookup tools, pest control, and more
· ⚙️ (top right) — Opens your Settings / profile editor
🤖 AI Features (Optional)
Three features unlock when you add a free Anthropic API key in Settings:

· 📷 Photo scan — Photograph a printed route sheet, dispatch list, or whiteboard. AI reads the addresses and adds them to your stop list.
· Address assist — Fuzzy address completion when typing stops manually.
· Route narrative — Plain-English description of your optimized route.

To get an API key: visit console.anthropic.com, create a free account, and generate a key. Paste it into Settings → Anthropic API Key. Your key is encrypted on-device with a PIN you set — it never leaves your phone unencrypted.
💡 Tips & Best Practices
· Clock in before adding stops so your shift metrics are accurate from the first address.
· Tap 📍 ARRIVE when you pull up to a stop — this starts a dwell timer so you know how long each visit took.
· Add notes at close — the CLOSE dialog has a notes field. Use it for condition observations, owner contact attempts, or case numbers.
· Pin your first stop on the ROUTE tab if you know you need to start at a specific address (e.g., a scheduled appointment).
· Install the app to your home screen via Settings → App Install for offline access and a faster experience.
· The map auto-updates when you switch to it after making changes — no need to refresh.
· Completed stops save permanently until you clear them. Your history is available under "All Time" in the DATA tab.
📬 Contact & Support
Questions, feedback, bug reports, or partnership inquiries — reach us directly.
✉️ Email Support
support@yourcityroute.com
YourCityRoute · v${APP_VERSION}
♿ Accessibility
Changes apply instantly and persist across sessions.
Text Size
High Contrast
Sharper colors, bolder borders
Reduced Motion
Stop animations and transitions