Hi,
I was wondering if it was possible to have more than one WaterGEMS layer in ArcMap for the same element. I would like to be able to simultaneously view the network pipes symbolized by two different fields.
I have tried to copy a WaterGEMS layer in ArcMap, but the link with WaterGEMS is lost.
Thanks
Danny
Hi Danny,
I have a few ideas, but if you could give me some more information using an example as to exactly what you're trying to do and why that will help me answer the question better for you. I'd also like to know what you mean by 'copying' the layer. There are a few different ways to accomplish a task in ArcMap for most things, so if I understood how you're copying they layer that might help too. Are you exporting the layer to a shapefile or feature class in a separate geodatabase and then adding it back to the project?
The first thing that I'm thinking in this case is that only one of the symbolized layers will be able to be shown at a time because they will both be laid directly on top of each other, which is part of why I asked for some more information. The second thing that I should mention is that each feature class in the WaterGEMS geodatabase is tied to that WaterGEMS project's database, which is either a .sqllite if you're on the latest version or .mdb file if you're on an older version. As far as I know that database is only designed to support one layer for each element, so the best option I can think of would just be to export out that layer to create a shapefile or feature class then add it back in. That should give you the two layers that you want of the same element and allow you to symbolized each differently and won't interfere with the WaterGEMs project database.
Regards,
Mark
Hi Mark,Thanks for the reply. Here's a screenshot of the behavior I was looking for. In one of the layers, the symbol is offset in order to help visualize both attributes at the same time :https://www.dropbox.com/s/ythdor10ldwcd4b/MultiLayer.jpg?dl=0
I would prefer both layers to be "live" (not a static copy). If this isn't built-in, can I create my own join using the Haestad ArcGIS OLE DB provider?
Danny,
I'm currently looking into finding out if there is a way to do what you are asking about.
From what I have learned you can make a connection to the OLE DB provider, but it will fail because nothing is actually lives there. Domain objects, like pipes, need to be supplied programmatically for them to be connected to the database and for it to work, so the best option would probably still be one of my workarounds listed above.
If you'd like I can put in a feature request for that functionality to be added to a future version of WaterGEMS for ArcMap.
Yes please, that feature would definitely help when we’re working with the hydraulic model in ArcMap.
We have already customized ArcMap programmatically in-house. If there’s a way that I could get the information on how to add a connection (in memory join) to WaterGEMS programmatically, we could add a custom button to ArcMap to handle the joins until the new feature is available.
From what I am being told what you're asking can't be done at this point because the way that we have WaterGEMS connected to the ArcMap interface is slightly different than most OLE DB providers and requires additional information and management that is done using our private API. In more general terms we would have to add the functionality to support this type of feature before what you're asking about can be implemented.
In the meantime you can try one of the other workarounds that I suggested above and I will certainly put in your feature request.
Answer Verified By: johda1
Just so you have it for your records this enhancement has been logged as number 132271.