I have a linear referencing event layer that was created using the
Make Route Event Layer geo-processing tool.
Input Route Featuresare in a standard feature class, but the
Input Event Tableis a database view (both from the same Oracle geodatabase).
Event Typeis set to
POINT, and the
Measure Fielduses the
MIDPOINTfield in the database view.
I've used the
database view as the
Input Event Table so that I can symbolize a point at the midpoint of my linear referencing events.
--ENG.EVENTS_MIDPOINT_VW --Calculates the midpoint measure between the from and to measures. SELECT ROAD_ID ,FROM_MEAS ,TO_MEAS ,(TO_MEAS-FROM_MEAS)/2 AS MIDPOINT FROM ENG.EVENTS
When I make edits to the underlying table, they are not reflected in the linear referencing event layer, even after refreshing the map. The only way I've found to get the linear referencing event layer to refresh, is to restart ArcMap. This is not ideal.
Oddly, the attribute table of the database view (not the linear referencing event layer) does refresh just fine in ArcMap, after edits are made to the underlying table. But, for some reason, the linear referencing event layer doesn't reflect the edits.
How can I get a linear referencing event layer that's based on a database view to reflect edits made in the underlying table?