Making surface from attribute with multi elevations

[Anonymous]

Hello Everybody,

I got information from survey- attributes, with two data tags – 'Altitude', which is the main tag elevation of the point, and 'Demical', with is the tag presented the elevation after the demical point.

Now, if I have Altitude= -27, and Demical=80, I want Civi 3D will understand it mean elevation -27.80 in order to make a surface.

The command 'Move Blocks to Attribute Elevation' doesn't work since it select only one attribute tag- Altitude OR Demical, so If I have attribute with -27 and Demical=80, the CIVIL 3D with translate it to -27.00 which is not enough for me.

Also tried to use EATTEXT command to extrude the attribute to COGO file and then edit it using some kind of option called formula- which calculate- [Altitude]+0.01*[Demical]. The problem is that works only in elevation below ZERO elevation, and not below.

So, for conclusion, can you help?

Thanks.

Noam

[Jeew-m]

Dear Friend,

Is it possible to upload a sample drawing.?

Thanks

[Anonymous]

Sure. Here is Dwg file, with Attribute of elevation with two tags. I would like to make a C3D surface from that data.

[Jeew-m]

I think you can go with the data extraction and extract only the attributes and Northing, Easting to an excel sheet. Then the data will come in two excel columns. You can use excel options to combine these two columns in to one with decimal places.

[Anonymous]

ok,  thanks. Following your answer, I just made my points in EXCEL file, how do I export this format to C3D format?

[Anonymous]

I just tried to save the Excel file as *.txt or *.csv file, and use 'Add point file' at the Add Data in Surface Tab, it doesn't work at all, I have a message saying "No point file format match found" when I click + and chose niether the texr or csv file.

Why is that?

[rl_jackson]

Seeing that the blocks that are in the drawing at the correct z value. I'm curious why you wouldn't just add the blocks to the surface definition.

[Anonymous]

Only in the blocks in the north, look at the south..

[Ranjit_Singh2]

You can try the following. No error traps and minimal testing . It will elevate all blocks to the right elevation.

(defun c:somefunc  (/ alt dec ent etdata)
 (mapcar '(lambda (x)
           (and (zerop (cadddr (assoc 10 (setq etdata (entget x)))))
                (setq alt (cdr (assoc 1 (entget (setq ent (entnext x)))))
                      dec (cdr (assoc 1 (entget (entnext ent)))))
                (entmod (subst (reverse (cons (read (strcat alt "." dec)) (cdr (reverse (assoc 10 etdata)))))
                               (assoc 10 etdata)
                               etdata))))
         (vl-remove-if 'listp (mapcar 'cadr (ssnamex (ssget '((0 . "insert") (66 . 1)))))))
 (princ))

and from there you can build a surface using the blocks.

[Jeew-m]

Delete the top row of your excel and save it as csv with comma delimited. 

When adding point file use PENZ format.

For your reference I have attached the file as csv.

[Anonymous]

Ranjit you are amazing, thanks a lot!

[Joe-Bouza]

the file saved as csv MUST have the column format expected

ex: PNEZD

point#,North,East<elvation,description

no header line or extraneous junk in cols to the side.., Pure and simple is what it wants