Do you use SQL queries to build your model or analyse your simulation results?

To start viewing messages,
select the forum that you want to visit from the selection below.
You will need to to register
before you can post: click the register link above to proceed.
If this is your first visit, be sure to
check out the FAQ by clicking the
link above.

Please check the "Tracing tools" in the "Geoplan" menu. You can use the "Intermediate paths" to select all the links in paths between two selected nodes. I also recommend you to have a look to the tools "Connectivity" and "Proximity trace".

Hello Rui, and thanks for your response. However, I tried using the tracing tools as you suggested and the operation never completed. The two selected manholes were approx. 75m apart, in a model of 33,000 nodes.

The dialogue "Intermediate Path Tracing ..." got to 15% and never went any further. I set the process going last night roughly 12 hours ago.Connectivity_Progress.JPG

So, we're still where I started with my initial request. Is there anything else I can try?
Thanks

EDIT: as far as I can see, the suggested approach only works if you know the two nodes where there might be a more than a single direct link between two manholes - but I'm after an approach that finds all examples within a network.

I'm trying to select all nodes ending in "c2", using
node_id LIKE '%c2'
This is however not working. Any idea why? I've also used node_id LIKE '%c2%'.
the Like operator in general doesnt seem to be working, at least not for node_id selection

If you open a set of results, and then open another set of results as alternate for comparison, the following query will create a table of the link id, sim1 max surcharge state, sim2 max surcharge state, differences between the 2 surcharge states.

Select oid As Link_ID, sim.max_Surcharge AS Base_Scenario, sim2.max_Surcharge As Post_Development_Scenario, sim.max_Surcharge-sim2.max_Surcharge AS Absolute_Difference;
The table columns are presented as Link_ID, Base_Scenario, Post_Development_Scenario, Absolute_Difference. This can be done for other result parameters and network objects.

For example I want to find every manhole where the incoming invert level does not equal the outgoing invert level; however, the difference between the two is within 1mm. This seems to have occurred where the modeller has input values to 3dp rather than the all the decimal places calculated using standard inference tools in ICM.

Yes, you can use the logic operator, 'AND' to do something similar to the following:-conduit_width>100 AND conduit_width<250

to select conduit with a width between 100 and 250mm.

However, I don't think you'll need to do that in your instance. I assume you want to select manholes where the difference between the US Link DS Invert level and the DS Link US Invert Level is greater than 0.001m, or:-