I'm in the process of developing a script that will allow me to show the extent of flooding (contours that have been turned into polygons) based on the current water table elevation found at a dam. The polygons were created in one feature class, the elevation data is coming from NOAA using their Map Server which is updated hourly.
I don't know if it's possible or not but what I'd like it to do is basically the same thing as a definition query where it only shows a feature if the "contours" attribute in my flooding feature is the same or greater than the "observed" attribute for that dam in the NOAA feature.
Am I on to something or do I need to find a workaround and do a query that simply highlights the current stage but still shows all stages?
Thanks,
Jessica