Looking for ideas on how to no longer have a point visible on a map once it has a related record...
I have web mapping app that allows dispatchers to add point features whenever a natural gas problem is reported (damage, leak, smell of gas, low pressure, etc.). Once the crew arrives on scene, the dispatcher edits the point's "on-scene" time. If the incident involves a gas leak, the dispatcher also edits the point's "gas off" time, so we can calculate how long the gas leaked.
Once the crew adds a related investigation record to the point, I'd like for the point to disappear from the dispatchers map, since they really don't have anything else to do with the incident at that point.
I've thought about doing some filtering based on report type, on-scene times and/or gas off times (not being null), but there are too many variables for me to do that - a report of "low pressure" could be because someone cut your service, which would have a "gas off" timestamp; or, the low pressure could be because your appliance is messed up, so there wouldn't be a "gas off" timestamp captured since no gas was leaking.
Best I can come up with is to filter the points on the map based on a time duration (only show points with a creation date/time within the last X hours).