Hello,
Especially for smaller/small utilities – like city water companies, there is a phenomenon present, that the input feature layer contains different types of data - from structural and logical network or cross several asset groups - at once. While it could work for plain data model with just feature layers (point and polylines), this is not enough for Utility Network data model (in my case for Water Data Management UN Solution).
This approach leads to two situations:
1) The layer contains both – for example points of System Valves (Water Device -> System Valve -> System) and points of Valve Box (Structure Junctions -> Pipe Box -> Valve Box).
For this situation I have two solutions:
a) Separate features to standalone layers for Structure Junctions and Water devices. And then load it in standard way
b) Make the separation via query in DataReference excel file
With that in mind – are there any samples documentation for DataReference queries? Some tip and tricks? Or would you recommend some third way?
2) The second use case is more tricky – it coming from situation when the one point layer mapped to – for example Water device layer – contains assets cross several Asset groups – for example System Valves (Water Device -> System Valve -> System) and Fire Hydrant (Water Device -> Fire Hydrant -> Fire Hydrant) or Pressure Reducing Valve (Water Device -> pressure Valve -> Pressure Reducing).
How to solve this situations – I think separation on the layer level is possible, but I assume that this could be done in the Mapping Workbooks as well – but can´t find any sample/documentation how – with some Lookup, or Query? I also heard that expression input could consist more values, but how it works? What´s the best practices how to solve this situation in the Mapping Workbook xlsx?
For the beginners there is outstanding learn.arcgis.com lesson from @RobertKrisher, but these situations are not covered here.
I will be happy for any tips!
Thank you.
