Hi there
I am currently working on a project which involves digitising streets in the UK ans I am using ArcMap 10.0.5 with the data hosted in a 9.3.1 SDE Geodatabase located in an Oracle 10g environment. Each street has a unique street reference number [USRN] and a name. However some streets are also classified as A or B roads.
Until recently their were no USRNs for A and B road numbers but these have now been introduced. Could anyone tell me what would be the best way to group the roads into their A and B classifications, whilst still keeping them separate at their bottom level within the SDE geodatabase environment.
I'm looking for an object object oriented model. So A roads / B roads / unclassified would be the parents and below them would be each road, which would inherit the properties of the parents but be separate entities in their own right. I've come at this from the bottom up because until recently their were no USRNs for A and B roads.
Kind regards
Tim
