I have a database that receives real-time data from alarms throughout the day, or on request.
I'd like to create a web map that displays the "bad" alarms.
My current idea is to create a Python script that queries the database every 15 minutes and gets a unique ID and a lat/long of the bad alarms. I will have a feature service setup and use the REST API (through Python) to add or delete alarms based on the previous query. I'll then have a basic web map set up to display this feature service with other related layers.
Is this a good approach? This data will only be viewed internally. I've never used the REST API before, but it seemed like a straightforward solution.
Thanks for any guidance.