Back to Updates
Weekly Update

Week in Review: Route Reviews & Saved Views

January 19, 2025 CityCycle Team

This week CityCycle shipped 19 commits focused on route review infrastructure for SB 1383 contamination monitoring and major UX improvements for filtering sites.

Route Review System

The biggest feature this week is a complete Route Review system for SB 1383 three-bin contamination monitoring:

Data Models:

  • routes table for grouping sites by collection route
  • route_reviews table for site-level review records
  • container_inspections table tracking gray/blue/green bins separately
  • GeoJSON geometry support for route boundaries

Mobile & Web APIs:

  • Mobile API: list routes, get route details, sites for route, CRUD for reviews with container inspections
  • Web App: full route CRUD with GeoJSON import/export and auto-assign sites
  • RouteImportService for importing routes from GeoJSON with property mapping

IR Export Enhancements:

  • GPS coordinates in route reviews CSV (optional toggle)
  • Route_Reviews.geojson for review point locations
  • Routes.geojson for route boundary polygons
  • Route review and container inspection photo export
  • GPS coverage stats with auto-disable when coverage < 50%

Saved Views for Sites

A new modern saved views system replaces the old Sites filter UI:

  • SavedView model with personal/team/system visibility levels
  • SiteFilterService with 20+ filterable fields
  • Composable filter chips with filter builder modal
  • Save modal for naming and sharing views
  • Desk Audit converted to a system saved view
  • Sidebar simplified with direct links

Automated Waiver Notifications

New notification infrastructure for waiver expiration tracking:

  • Recipient types: site_contact (default), jurisdiction_admin (internal staff), specific_user
  • Monthly digest: WaiverExpirationDigestJob runs 1st of each month at 8am
  • Digest shows all expiring waivers grouped by week
  • Displays scheduled automated reminders
  • Satisfies Lake Forest RFP requirement for waiver expiration alerts

Admin Panel: Account Management

The admin panel now includes CityCycle Accounts management:

  • Account CRUD with search and delete protection
  • Inline jurisdiction management (add/remove)
  • User invitation with role, jurisdiction, and feature access controls
  • Team member and pending invitation display per account
  • SMS configuration status (read-only)

Documentation Updates

  • Dedicated waivers help section with notification documentation
  • Updated CSP to allow Mapbox, WebRTC, SignalWire, and Cloudflare

Questions or feedback? Contact us or schedule a demo call.

View all updates