City Hall: Data Flow - ironwoodcall/TagTracker GitHub Wiki

#Possible data flow at City Hall

Current proposal

Diagram 2023-06-16 on Google Docs

Old version

[optional: gsheet --> csvc2tracker --> tt_datafile --+ ]
                                                     |
    +------------------------------------------------+
    |
    V
  tagtracker
    |
    +---> csv extracts---------------------------------------------------------------------+
    +---> visits datafile-------------------------------------------------+                |
    +---> day-end summary information --------+                           |                |
                                              |                           |                |
                                              |                           |                |
                                              V                           V                |
manual day-end info (e.g. registrations) --> google day-end form----???-->|                |
                                                                          |                |
                                                                          V                |
                                                                    visits db on Drive     |
                                                                          |                |
                                                                    make csv extracts      |
                                                                          |                |
                                                                          V                V
                                                                     various csv extracts on Drive
                                                                     (or static html if required?)
                                                                          |                |
                                                                          |                |
                                                                          V                V
                                                                    audit info           city hall
                                                                    info for             staff access
                                                                    ipad at valet        to data