AutoCAD Civil 3D

[#1]

I was given a file from a competetor (this is evil)

The file has  coordinates in feet (x, y) but elevations (Z) in meters.

I need the contours intact (cant explode block and scale) to create a surface from.

The other part is this is a big file so anything by hand would be rediculous.

I need the final file where the x,y has stayed the same but the z has been adjusted to the correct foot elevation (scaled)

Thanks in advance!

[#2]

export the points to a pnezd comma delimited file.    open with excel or other spreadsheet program.   convert the metric elevation to feet and store the values as numbers.   then replace the metric with the english elevations and save the file to a csv comma delimited file and reimport to C3D.

[#3]

Sorry, The data I have is contours, as polylines,  no points.  

[#4]

oh sorry i misread that.    for contours the map query functions might work to assign new elevations to the polylines based on a formula.   I know you can have map read gis data and assign elevations to polylines based on that data.  So why wouldn't it let you apply to a math formula to them.

[#5]

Can you just insert this drawing into another as a block?

Then you can set different scales for x, y, z.

I won't let you explode as part of the insert, but you can explode it afterwards.

[#6 · Accepted solution]

Sorry I dont want it exploded, When you scale only one direction it explodes your contours.

I did figure this out though,

First create a surface style that only displays your triangles.(display tab of suface style only triangles should be highlighted)

In the triangles tab of the surface styles menu, select  exagerate elevation) and change the scale factor from 1 to what ever you need to convert, (meters to ft) (if you are reducing the elevation use flatten elevations.

Now select the surface to get the surface ribbon,

Click extract data.

Make sure triangles are the only thing selected.

Create a new surface

Define the surface by 3d faces,

BAM your surface is scaled to the right vertical with out touching your horizontal.

Thanks everyone!