Can't get correct Z value for points

[cadman33619]

Hi all,

i have a survey with existing grade shots but they are just single line text objects. I need to make them into the correct points with the correct z value. I then need to add proposed grades with correct z values. the ultimate goal is to try and create a surface showing existing and proposed so that i can figure out cut/fill calculations. File attached for reference. 

I've tried the MOVE TEXT TO ELEVATION feature with no luck. is this possible?

using C3D 2016

[TerryDotson]

Use the FIND command to replace "x=" (no quotes) with nothing and again with "'" (foot mark).  Then the MOVETEXTTOELEVATION tool will work.  Keep in mind the quality of this surface is compromised.

[Ranjit_Singh]

There maybe some option in Civil3D to do this. Here is a LISP.

;;Ranjit Singh
;;06/16/17
(defun c:somefunc  (/ el etdata)
 (mapcar '(lambda (x)
           (setq el (read (substr (cdr (assoc 1 (setq etdata (entget x)))) 3)))
           (entmod
            (subst (cons 10 (reverse (cons el (cdr (reverse (cdr (assoc 10 etdata))))))) (assoc 10 etdata) etdata)))
         (mapcar 'cadr (ssnamex (ssget "_x" '((0 . "text") (1 . "x=*"))))))
 (princ))

[cadman33619]

Thanks Terry. that did the trick.

also gonna try the lisp from Ranjit... much appreciated.

now that the text is at the correct elev, can i create points for a surface (since i removed the x for each)?

my apologies, I'm a little new to surfaces

[Ranjit_Singh]

My LISP will not work if you edited the text in anyway. I had made the LISP to be used without any changes to the text. Anyways, once you get the text elevated to correct elevations, create a surface from toolspace and add drawing objects

[AllenJessup]

I think you have one more problem. From examining shots on hard objects it looks like the point position is supposed to be the intersection of the X rather than the insertion point of the text. So that would offset the points by about half a foot.

If you can come op with a standard vector for the shift of all the points. You can copy the original text, Eliminate the X= and foot mark (') in the copied text then move the text along that vector and use move text to elevation.

[cadman33619]

not sure what i'm doing wrong here... i was able to create a surface and i added the drawing objects.... now i'm trying to follow steps to create a wireframe surface but its not working out for me. Is there a good tutorial that will show me how to create a surface from these existing grades, and allow me to add proposed grades?

[cadman33619]

thanks Allen... i did notice that and saw that they would be off a little. I've been trying to compensate for it but so far i have not. once i figure out how to make a surface from this, i'll explore how to fix that issue. 

[AllenJessup]

You could try THIS. Which are the existing grades and which are the proposed?

[cadman33619]

the existing grades are the ones shown... i have not yet added the proposed grades. i have the CDs completed for this job with the building, parking, etc which shows the proposed grades. I was thinking that after i get the surface with existing grades, i could somehow bring in the proposed grades and then create a surface for them. i need to be able to see both to figure out cut/fill.

thanks for the link... gonna head there now. 

[AllenJessup]

This is a good youtube  video. It assumes the insertion point of the text is the point. I asked about existing and proposed since the drawing also contains contours.

https://www.youtube.com/watch?v=EtMWQ55mwvM

[AllenJessup]

Once you have both Surface you can create a Volume Surface which will calc the cut/fill.

[cadman33619]

sorry... forgot to mention the contours...they are existing as well. 

this surveyor apparently does not use traditional survey data or z values. 

[cadman33619]

whoa... that would be perfect.

now i have a new goal - creating a volume surface!

[Ranjit_Singh]

Good point brought up by @AllenJessup. I modified the LISP to accommodate for the shift.

;;Ranjit Singh
;;06/16/17
(defun c:somefunc  (/ el etdata)
 (mapcar '(lambda (x)
           (setq el (read (substr (cdr (assoc 1 (setq etdata (entget x)))) 3)))
           (entmod
            (subst (cons 1 (strcat (rtos el 2 2) "'"))
                   (assoc 1 etdata)
                   (subst (cons 10 (reverse (cons el (cdr (reverse (polar (cdr (assoc 10 etdata)) 1.58168 0.558008))))))
                          (assoc 10 etdata)
                          etdata))))
         (mapcar 'cadr (ssnamex (ssget "_x" '((0 . "text") (1 . "x=*"))))))
 (princ))

[Joe-Bouza]

OOTB tools
DATAEXTRACTION the text selecting X,Y, value (might be contents)

Then import the xyz file

[Joe-Bouza]

In excel remove the x

[cadman33619]

Ranjit.Singh,

thanks so much for the Lisp.

to make sure i understand... your lisp will remove the X= and compensate for that insertion point, then move the text up the the correct elevation?

[cadman33619]

actually, i'm getting an error when trying to run the lisp. Did I miss something?

[cadman33619]

Not sure what i'm missing here. I've got the text at the correct elevations and i created a surface in the Prospector (i tried it 3 times. named them: EX CONDITIONS, TEST, TEST SURFACE) but my surface is not showing up. I need to see the actual surface of the grades. I've attached the file again. hopefully someone can show me what i did wrong.

Note that all other layers are frozen.

thanks so much