Hello,
I have imported to watercad elevation nodes and pipes from an autocad file.
Now I would like to import the demands of each node as well
In the autocad file, next to each node, it is written in text format the demand (population wise) of the closest node.
My question is, the watercad can read the text or the only way is uploading the dxf as background and typing each demand manually?
Suggestions?
Thank you
Hello Dima,
WaterCAD cannot dynamically read the text annotation from a CAD file via ModelBuilder. The information contained in the annotation is stored as CAD entities which are not intelligent attributes of the element. For example in your case, if you have the demand data as annotation next to a junction then that annotation is not associated or linked to the junction in any way other than it is situated next to it in your CAD drawing. If however, this was done in a GIS platform then attributes are associated to the elements and can be available for import via ModelBuilder.
As you correctly said, one of the ways you can do this is by attaching the DXF as a background and manually entering it. Please see if there is any way to export this data from AutoCAD into a format such as a spreadsheet (MS Excel) which can be imported via ModelBuilder.
See the article below which discusses in detail the process of importing a CAD file via ModelBuilder for your reference;
Importing an AutoCAD or MicroStation CAD file using ModelBuilder
Hope this helps.
Regards,
Yashodhan Joshi
Answer Verified By: Dima Gerlyants
With the help of extract data on autocad, I converted the coordinates of the points with the value to an excel sheet file
Then I uploaded to watercad using model builder customer meter and after load builder for customer meter to nearest node.
Should this work? Is there any step missing after this? (I still get 0 in the demand)
thank you
This data that you extracted would be the geometrical properties associated with the CAD entities. I think you have performed DATA EXTRACTION from AutoCAD. This will give you the X, Y and Z coordinates and elevations for the polylines, points (CAD entities) for your drawing. However, this would not extract the annotation contents of the annotations. If you can manually copy the data into an Excel file then you can use this in ModelBuilder to import demands.
The value column of the picture I sent, that is the content that I want to import as demand population to watercad. The coordinates are the location of each point
The only thing I don't have is the label name because the names are different from the watercad file and the autocad file. That's the reason I want to try to import the content with the coordinates to the closest junction
is that possible? I have almost 700 junctions to edit, so I'm trying to see if there is a solution before I start editing manually
Thanks
You can try the "spatial join" option in ModelBuilder. This will help you map to the closest geometry.
See the "Specify Additional Options" section in the article below for importing data using ModelBuilder;
Using ModelBuilder to Import External Data