I have a road network table in a PostgreSQL database. The table has a level
attribute which marks if a road is on the surface or if it is an under- or overpass. I would like to check the topology of this network and filter out the marked fictional (different level) intersections, and the not marked but real (same level) intersections. (Detailed in pictures below.)
Now I know that I can do this in PostgreSQL, but can it be done in ArcGIS Desktop?
So far for topology checks I never needed this kind of rule, and I cannot find an option to make a topology rule based on an attribute value. Currently I don't have acces to ArcGIS Data Reviewer, but maybe that could solve my problem.
The illustration of my problem:
The colours and the numbers represent the level of the road. I would like to find the following errors:
- Either two roads with the same level value intersect each other but don't have an intersection point
- or they do have an intersection point, but shouldn't, because they don't have the same level value.
level
values, still I don't know if they were rightfully intersected in the first place or not.