My recent assignment is to model a multi-user geodatabase for the whole world using the ESRI platform. This geodatabase contains administrative layers and topographic layers. The schema is to be designed in such a way that users can update different countries simultaneously.
My first problem is that every country has different administrative structures. For example, Country A has 2 administrative levels, Country B has 3 administrative levels and Country C has again 2 administrative levels.
Now when I merge each set of admin levels into layers (i.e. all level 1 areas in one layer, level 2 in a second layer and level 3 in a third layer) and establish a topology there is a gap between Country C and Countries A and B in admin level 3 because that level is not available in Countries A and B. The goal is for the topology to not have a gap.
Am I organizing this data in the wrong way?
Any ideas on this will be highly appreciated.