| Product(s): | WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm | ||
| Version(s): | 08.XX.XX.XX and higher | ||
| Area: | Modeling |
After importing / creating a model (for example using Modelbuilder) I noticed that the model is in the wrong location or wrong scale (for example the wrong units were accidentally selected). Is there a way I can bulk change the model element coordinates or scale up / down and/or rotate the model?
Why does changing the scale under File > Options > Drawing not change the scaled pipe lengths?
This can also happen for example if the coordinate system / spatial reference of newly imported data is different from the source of the original model data.
When importing a model, it will appear using the units selected in the Modelbuilder wizard and the X and Y coordinates stored in the data source files. The "scale" seen in the Options dialog is only the plot scale. If you have a need to make a bulk change to the coordinate such as multiplying them all by a certain factor, moving the model at the same scale, or rotating it, there are two possible approaches:
If you have not added new elements or done significant work to the model since the initial import, and you find that the wrong unit had been selected when you first imported, you may be able to use ModelBuilder to correct this. First, consider deleting all elements (or start a new model), and re-import the existing ModelBuilder run (if you saved it) with the correct unit selected in the beginning step. Otherwise if matching elements exist in the model and can be linked by label, correct the unit in the existing ModelBuilder run in the ModelBuilder Manager, check only the box to "update existing objects" and choose to "sync in". This will update the geometry (lengths/locations) of the matching elements using the new unit.
If you own and have installed a compatible version of MicroStation, you can run the "<Storm or Water Product Name>... for MicroStation" shortcut, open the model file, then use native MicroStation commands to manipulate the location, scale or rotation of the model. The underlying model database will change accordingly, so once you save it, you can then open it back up in the Standalone version to see the new coordinates.
If you have a compatible version of AutoCAD and have AutoCAD integration licensed in your OpenFlows product, you can similarly run the "...for AutoCAD" shortcut and use native AutoCAD commands.
If the model was built wrong and you have a consistent error that can be fixed by multiplying, open the Pipe Flextable, copy the "Length (Scaled)" column to something like Excel, multiply by the correction factor, global edit the "Has User Defined Length Column" to "true" (checked) then paste the corrected value in to the user defined length field.
With this approach, you use Modelbuilder to export the X and Y coordinates to a spreadsheet, use Excel to manipulate them, then bring them back into the model to update the locations.
NOTE: this process assumes that you have little to no pipe bends. This process only updates node X and Y and the bends (vertexes) are stored in the pipe.
1) Set up a spreadsheet with worksheets for each of the node types used in the model (the ones that need their X and Y changed). Each worksheet should contain column headers for Label, X and Y
2) In the OpenFlows product, start Modelbuilder and connect to the spreadsheet. In the first step, select the correct coordinate unit and uncheck the box for "create nodes if non found...".
3) Click Next three times until you get to the Field Mapping step. In here, select the appropriate element type for each of the worksheets on the left side, select Label as the Key field (make sure your element labels are all unique) and select the X and Y fields.
4) Click Next, then choose "no" when asked if you'd like to build the model
5) Back in the Modelbuilder Manager, click the entry in the list corresponding to the Modelbuilder run you juts configured and click the "sync out" button at the top. This will send the label, X and Y to the spreadsheet
6) Open the spreadsheet in Excel, set up functions to modify the X and Y accordingly and save
7) Back in the model, open Modelbuilder, click the same entry again and click the Build Model button. Note that if you created new columns in step 6 to store the updated coordinates, you'll need to edit the Modelbuilder run and change the field mapping accordingly.
This process will work with pipe bends, but assumes that you have a separate application that can manipulate shapefiles to correct the coordinates. Use "sync in" and choose label as the key field, then "sync-in" with only the "update existing objects" box checked.
If you are importing new data into an existing model, or if the source data is in the wrong coordinate system, you may need to first reproject that data using an external application, before importing it with ModelBuilder. This can be done for example using ArcGIS or QGIS (see link below)
Building a model using Modelbuilder
Updating a model using Modelbuilder
Is it possible to reproject a model to a different coordinate system?