Subscribe to this thread
Home - General / All posts - Valve Throttling Schedule
sour

126 post(s)
#20-Oct-20 05:10

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

atrushwo108 post(s)
#20-Oct-20 14:58

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

sour

126 post(s)
#21-Oct-20 07:33

Hi sir this work selecting valves in the map. It works.

thanks!

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.