Skip to content

City Hall: Reporting

Jump to bottom
Todd Glover edited this page Jun 8, 2023 · 3 revisions

Reports for City

Notes based on

  • Teams meeting with City May 2023
  • email from City (below)
  • on-site meeting with City (SW) 2023-06-08 [SW, LJ, JH, TG]

Single day (reports from TagTracker)

  • text file accessible by URL
  • made up of
    • day-end summary
    • fullness report
    • pretty much everything else
  • maybe csv files as well? One each for
    • tags (ie Visits)
    • Blocks
    • Events

Multi-day (reports from database)

  • (daily summary)
  • weekly summary, week-over-week
  • monthly summary
  • yearly summary
  • csv dumps of above
  • SW might need help connecting excel to db

Other

  • email (e.g. at 10AM) if previous day
    • broke a record for #of transactions
    • reached 95% of estimated capacity
      • est capacity currently 150
      • SW said alert at 140, which is 93.3%, so ... something
        • email below said 80% so perhaps 90% as a start

Design (& implementation) issues

  • where will DB live such that SW can (ideally) do an ODBC connect
  • maintain sanctity of the db as a persistent object
  • email:
    • cronjob from laptop
    • 10am as valet is open, and probably there's wifi ###cron jobs
  • yes could do from laptop but ... yikes
  • can we wget or curl to get the db from google drive onto a friendly neighbourhood server (e.g. grundoon), where can do cron etc etc?
    • exciting!: can grab raw text file from google drive with (e.g.) wget --no-check-certificate 'https://docs.google.com/uc?export=download&id=110ViAddQyshfESFTRaXfs2wuscJW4EAo' -O audit.txt
    • (this from stackexchange posts here and here)

Older email from City

Email from City:

From: SW (@ city)
Date: Tue, May 23, 2023 at 11:50 AM
Subject: RE: Bike valet data: confidentiality
To: TG, JP
Cc: 2 folks @ city

Hi,

Here is our dashboard /data at a glance wishlist:

For daily dashboard:
    Number of bikes parked today
    Running total of number of bikes
    Running total of bikes registered
    Running total of oversized vs regular bikes
    Wishlist: time graph of bikes coming in and out

Monthly summary:
    Total number of bikes parked per month
    Total number of bikes registered
    Total number/% oversize vs regular
    Busiest day(s) of the month- number
    Busiest days of the week on average and weekend vs weekday comparison
    How frequently/which days did we almost reach at capacity at one time? Threshold of 80%.
    How much utilization first and last hour of operation per day?

Let us know if you have any questions/want any clarification.

Thanks
Clone this wiki locally