We are trying to create a system to evaluate the performance of existing bus transit routes in a city. As a sample, we can consider the following case:
The bus goes from A to B to C and Returns from C to B to A 2 times every day. Our field workers will be sitting in the bus and monitoring the number of passengers who climb aboard and exit at each stop using field maps, as shown the following table:
This table is related to the points marked in the map. At the same time, we also have another table that is related to the lines, containing data about the time taken for each trip and number of passengers on each trip. The blank table is shown below:
So what we would like to do is that every time data is added to the table related to the points (i.e. information about the bus stops) a new record should get generated in the table about the bus routes. So when the field workers sitting in the bus add information about how many people got in and out at stop B, and the start and stop times, this table should automatically generate a record of the information for the path between A and B.
Do you need the route table updated immediately (real-time) when the data is entered into the stop table or can it it be updated at regular intervals (5 minutes, 1 hour, nightly, etc)?
@BlakeTerhuneThe thing is, we need to collect data through field maps, since the field teams are going to be using mobile devices. I am not sure that it would be possible for them to operate the webapp on the phones
If you're using an enterprise geodatabase (on an RDBMS), you could create a database trigger on the stop table to automatically insert the records into the route table. These are a bit clunky but it should work.
We are working on ArcGIS online. The relationship structures are made in arcgis pro and uploaded to the online organization, where data collection is happening on Field Maps. Can you guide me to any literature on whether these database triggers can work in this type of system?
Thanks a lot for taking the time out to reply!
It's possible to run a Python script triggered by an action in ArcGIS Online, like when a new record is created.
Instead of sending an email, maybe you could have the Python script insert a new row into your related table.