Search:

Type: Posts; User: Rui Daniel Pina

Search: Search took 0.01 seconds.

  1. The following SQL counts the number of links that...

    The following SQL counts the number of links that are US of a node and add it to the User Number 2:

    LIST $nodeID STRING;
    SELECT SELECTED DISTINCT node_id INTO $nodeID FROM [All Nodes];

    LET...
  2. The following SQL select nodes with higher...

    The following SQL select nodes with higher chamber_floor level in the current scenario than in the base scenario:
    466

    The code is:
    DESELECT ALL;
    UPDATE IN BASE SCENARIO SET $x = chamber_floor;...
  3. This SQL renames cross sections in river reaches....

    This SQL renames cross sections in river reaches. Just create a new stored query with Object type "River reach" with the following code:

    LIST $listRivers string;
    SELECT DISTINCT oid INTO...
  4. Replies
    3
    Views
    3,008

    Hi Gearoid, Thanks for posting this question....

    Hi Gearoid,

    Thanks for posting this question.
    Observed / Predicted Reports allows you to do verification in links. Try to plot the US or DS levels of links connected to that node, instead of the...
  5. This is to add multiple lateral links to...

    This is to add multiple lateral links to subcatchments:

    1. Run this spatial SQL to find the links inside subcatchments:
    446
    code:
    set user_text_1= spatial.subcatchment_id


    2. Run this SQL...
  6. This SQL sums all the population in US...

    This SQL sums all the population in US sucatchments of selected nodes and store it in the user_number_1. Set the object type as "All Nodes" and use the following code:

    LIST $nodeID STRING;
    SELECT...
  7. Please check the "Tracing tools" in the "Geoplan"...

    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...
  8. This is an SQL to update Head Discharge Curves....

    This is an SQL to update Head Discharge Curves.
    You can add the curve to a txt file and run the script to update the curve automatically. The SQL will prompt what curve ID to update and do all the...
  9. Hi Eva, Thanks for the post. The volume...

    Hi Eva,

    Thanks for the post.

    The volume correction only applies to the nodes connected to conduits. If the corrected area is lower than the defined “Minimum Plan Area at Nodes” in the...
  10. SQL can also be a powerful for themes in the...

    SQL can also be a powerful for themes in the Geoplan. In the example below, the SQL compares the 2D water depth of two simulations and shows the difference if higher than a treshold (0.1):
    ...
  11. This is an example of spatial analysis with SQL....

    This is an example of spatial analysis with SQL. The following code selects all links and nodes inside a polygon:

    LIST $PolygonID STRING;
    SELECT DISTINCT polygon_id INTO $PolygonID;

    PROMPT...
  12. This SQL selects upstream links of selected...

    This SQL selects upstream links of selected nodes:

    LIST $nodeID STRING;
    SELECT SELECTED DISTINCT node_id INTO $nodeID;

    DESELECT ALL;

    LET $i=1;
    WHILE $i<=LEN($nodeID);
    SELECT FROM [All...
  13. Replies
    4
    Views
    5,295

    To add information to the post from Patrick: The...

    To add information to the post from Patrick:
    The profile can be edited under its properties and several options to display links length can be selected.
    To reduce the gap in intersections of river...
Results 1 to 13 of 13