Community
Civil 3D Forum
Welcome to Autodesk’s Civil 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Civil 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Batch change polylines elevations

81 REPLIES 81
Reply
Message 1 of 82
hrast
7366 Views, 81 Replies

Batch change polylines elevations

Hi there,
I have a certain task I need to do and trying to figure out the fastest way to do it. Lets say I have several dozen polylines and I need to add certain elevation to each one. I would use them as contours in the next step for creating surface. Trouble is that I will have to change elevations to the whole set of polylines dozen of times. Is there way to get some sort of table which would list all of my polylines with column stating their elevation and where I would be able to change elevation to whole set of polylines by copy/pasting column with values from excel for instance?
Thanks in advance !
81 REPLIES 81
Message 61 of 82
hrast
in reply to: hrast

That was a good notice. I missed that. I wonder why it has picked different data table by default. "Import" is name of .mdb file. And when I drag and drop .mdb file into the task it shows as data source called same as database. "rs" is the name of the ODBC acess driver I created. Anyway, I attached data source called "rs" as you said and there is a progress, Elevations now do show , but when I ran a query it didn`t assign elevations to polylines. They remained zero.
I am attaching the screenshot.
Message 62 of 82
hrast
in reply to: hrast

I just rerun the query and it did work. Wooo hooo !
Thank you guys a lot. And most thanks to Neil. That was really a huge help I got from you !
Message 63 of 82
Anonymous
in reply to: hrast

It looks like you have the query set up properly. Could you please erase all
the polylines that you queried and re-run the query and see if the newly
imported polylines have the correct elevations after?

FYI, when you close the query dwg the queried polylines lose their
association to the source dwg and will no longer update when you re-open and
run the query. You will have to erase them and re-run the query each time
you re-open the query dwg. If you don't erase them, the query will import
more polylines from the source and you will have duplicates. We need to make
sure that is not happening.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5155 (20100530) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
Message 64 of 82
Anonymous
in reply to: hrast

I'm happy to hear you got this working. It was a lot of work but it should
pay off as you do more projects.

One more thing to consider: I suggested earlier that you should not save
your queried polylines back to the source drawing. However, now I see a
better work flow. What you could do is create your cross section surface in
the source file using the cross section polylines. Then use the query
drawing to update the elevations of the polylines and SAVEBACK to the source
dwg. This will update the elevations of the cross section polylines that are
used in your surface in the source dwg and the surface will update in turn.
The caveat is you will have to close the source drawing before you can run
the query since you can't have the source drawing open simultaneously.
However, thanks to C3D's multi document mode it is a minor inconvenience. As
long as you keep the query dwg open you can update the polylines without
erasing them as often as you like as it won't duplicate them. Just query and
save back, then reopen the source drawing to see the updated surface. You
will have to deactivate the attached source drawing in the query drawing
before opening the source drawing.

I think this should work but I haven't tested it. Let me know how it goes.

Thank you for the help Murph. Your advice is more than welcome.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5155 (20100530) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
Message 65 of 82
hrast
in reply to: hrast

Thanks. I will try that and let you know. One more question... For the testing purposes I tried to do this whole workflow for just 5 contours. Out of 69. When assigning the ID value to each contour I have to click on one at the time, and one by one fill in the field in the properties window, right?
Message 66 of 82
Anonymous
in reply to: hrast

You will have to assign the ID numbers one at a time, but there area couple
of ways to do it. As you see, it can be done via the properties dialogue.
You can also use the Attach/Detach Object data tool on the Create tab of the
Ribbon in the Toolbased workspace. Open the tool, pick the ID field, give it
a value and attach it to a polyline. To save some typing you can copy and
paste the values from one of your output files, but again, it will only do
one at a time.

There are ways to automatically assign values from text elements and block
attributes to object data but it doesn't work on linear elements like
polylines.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5155 (20100530) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
Message 67 of 82
hrast
in reply to: hrast

Thanks. No problem to assign those manually. They will be integers anyway.
Much easier to do that just once than to update elevations manually several dozen times - for different hydraulic calculations. That would have been my destiny if I haven`t gotten help from you, LOL !
Message 68 of 82
Anonymous
in reply to: hrast

BTW, you may be able to devise a workflow using data shortcuts or references
to get around having to open and close files.
Message 69 of 82
Anonymous
in reply to: hrast

Looks like HEC-RAS cross-sections....why not use the HEC-RAS Extension
to import the cross-section data?

Matthew Anderson, PE


On 6/1/2010 9:51 AM, neilw wrote:
> BTW, you may be able to devise a workflow using data shortcuts or references
> to get around having to open and close files.
>
Message 70 of 82
Anonymous
in reply to: hrast

Can the HEC-RAS extension import data from MIKE 11?
Message 71 of 82
hrast
in reply to: hrast

Because calculation was done in Mike 11. Cross sections are cut with HEC-RAS extension but then they were transfered from HEC-RAS to Mike 11 because that is where calculation was done.
Message 72 of 82
hrast
in reply to: hrast

Not that I know of.
Message 73 of 82
Anonymous
in reply to: hrast

AFAIK C3D will import an SDF that is generated by HEC-RAS GIS output
function. Unless MIKE 11 can output to SDF, I don't know how else to get
it's output into C3D. What did you have in mind Matt?
Message 74 of 82
Anonymous
in reply to: hrast

I would assume that MIKE11 might be able to export to the Corp's SDF
format if it can import...

I hadn't seen a reference to MIKE11 in prior posts until today...

MIKE11 appears to have a free CAD Plugin for MIKE.

The other options might be to use a Point Cloud to pull in the x,y,z
values of the results. [Just brainstorming...I need to download MIKE11
to see what is possible...]

Matthew Anderson, PE


On 6/1/2010 12:06 PM, neilw wrote:
> AFAIK C3D will import an SDF that is generated by HEC-RAS GIS output
> function. Unless MIKE 11 can output to SDF, I don't know how else to get
> it's output into C3D. What did you have in mind Matt?
>
Message 75 of 82
Anonymous
in reply to: hrast

my mistake, just read the post about about Mike...must have skipped that
one...

Matthew Anderson, PE


On 6/1/2010 1:12 PM, Matt.Anderson wrote:
> I would assume that MIKE11 might be able to export to the Corp's SDF
> format if it can import...
>
> I hadn't seen a reference to MIKE11 in prior posts until today...
>
> MIKE11 appears to have a free CAD Plugin for MIKE.
>
> The other options might be to use a Point Cloud to pull in the x,y,z
> values of the results. [Just brainstorming...I need to download MIKE11
> to see what is possible...]
>
> Matthew Anderson, PE
>
>
> On 6/1/2010 12:06 PM, neilw wrote:
>
>> AFAIK C3D will import an SDF that is generated by HEC-RAS GIS output
>> function. Unless MIKE 11 can output to SDF, I don't know how else to get
>> it's output into C3D. What did you have in mind Matt?
>>
>>
Message 76 of 82
Anonymous
in reply to: hrast

Don't blame you for missing it..it's a long thread. See the reply by hrast
on 5/16. If there is a tool to convert the output to CAD then we might have
a better solution.
Message 77 of 82
hrast
in reply to: hrast

Indeed MIKE11 has a free CAD Plugin for MIKE, but all it does is that it draws profiles in CAD. It doesn`t do flood lines.
And yes there is a way to get cross sections back from Mike 11 to HEC-RAS, but it doesn`t transfer back calculated water levels - just geometry.
Message 78 of 82
Anonymous
in reply to: hrast

what other options for export does MIKE11 provide?

Matthew Anderson, PE


On 6/1/2010 1:23 PM, hrast wrote:
> Indeed MIKE11 has a free CAD Plugin for MIKE, but all it does is that it draws profiles in CAD. It doesn`t do flood lines.
> And yes there is a way to get cross sections back from Mike 11 to HEC-RAS, but it doesn`t transfer back calculated water levels - just geometry.
>
Message 79 of 82
Anonymous
in reply to: hrast

I downloaded Mike last night, but can't seem to get it installed...

Matthew Anderson, PE


On 6/1/2010 1:54 PM, Matt.Anderson wrote:
> what other options for export does MIKE11 provide?
>
> Matthew Anderson, PE
>
>
> On 6/1/2010 1:23 PM, hrast wrote:
>
>> Indeed MIKE11 has a free CAD Plugin for MIKE, but all it does is that it draws profiles in CAD. It doesn`t do flood lines.
>> And yes there is a way to get cross sections back from Mike 11 to HEC-RAS, but it doesn`t transfer back calculated water levels - just geometry.
>>
>>
Message 80 of 82
hrast
in reply to: hrast

Where is the problem?

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Rail Community


Autodesk Design & Make Report