Home -
General /
All posts - Valve Throttling Schedule
sour126 post(s) |
Good day everyone! I have a query regarding on a water utility valve throttling activity. I have created a scenario: - DMA boundary – district meter area
- Valve – use to throttle pressure of a particular DMA
- Valve Schedule table - A separate table where all list of “DMA NO” are input and parallel to it particular “Valve ID” that throttles it.
Scenario: There are valve objects that throttle a single DMA there are also valve that throttle more than 1 DMA. Valve Schedule table is dynamic could be change from time to time. Question: is there a way in manifold when I select a valve ID in the “Valve Schedule” table, the affected in object in the “District Meter Area” layer will highlight or selected. Take note: - Map is not projected I use this for scenario only
- I’m using a Manifold 8.0.29.0
Thanks! Attachments: Valve throttle scenrio.map
|
|
Try this out. I wrote it to highlight the DMA based on a selection in the Valves Table. Your DMA and Valves table have a many to many join and require the Valve Schedule table to act as a junction table. Making the selection in the junction table isn't as intuitive. SELECT [3].[ID] FROM [VALVES] AS [1] INNER JOIN [Valve Schedule] AS [2] ON [1].[VALVE ID] = [2].[VALVE ID] INNER JOIN [DIstrict Meter Area] AS [3] ON [2].[DMA NO] = [3].[DMA NO] WHERE [1].[SELECTION (I)] IS TRUE
|
sour126 post(s) |
Hi sir this work selecting valves in the map. It works. thanks!
|