I have multiple layers that has dependency with each other. Such as: City; Courts; Lots; Front Lot; Buildings. The polygon's "block" depends on the polygon's "City." Example dependency: Buildings-> Front Lot -> Lots -> Blocks -> City.
On my server I have installed the Oracle SDE. He has the ESRI SDK. With the "spatial functions" for Oracle.
I thought I'd solve this with the "spatial functions." I think to check the intersection of the layers. As the example of the link:
In my future solution, when a building is in another district must update this value automatically. Maybe even cut off part of a neighborhood that is outside the city limits.
What better way to manage these dependencies layers? There is a ready tool? Or API? ADF/Python etc? Or another solution ready?