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: 

Compare Points Perpindicular to Surface

54 REPLIES 54
SOLVED
Reply
Message 1 of 55
andrew.normore
5288 Views, 54 Replies

Compare Points Perpindicular to Surface

Hi All,

 

Just wondering if anybody has a solution to my problem. I am working on drawings where we create dtm's from surfaces, use the dtm for layout, shoot the asbuilt of the final surface, and then compare hundreds of shots to the surface to develop an as-build report.

 

I want to be able to select a mass of points, compare the perpindicular difference in elevation to the surface, and have an excel spread sheet generated from the results.

 

My coworkers are able to do this in Terramodel but I am on a mission to eliminate Terramodel from my day to day work.

 

Just hoping somebody may have come across this before and can shed some light as to what commands or add-ons are availbable. I've never worked with a LISP but i am certainly open to suggestions at this point.

 

 

Windows 7 x 64
Dell Precision M6600 Mobile Workstation
16 GB Ram
i7 @ 2.5 ghz
Civil 3D 2012 SP 1
Civil 3D 2011
Autodesk Inventor 2011
AutoCad Map 3D 2011
54 REPLIES 54
Message 21 of 55
Jeff_M
in reply to: andrew.normore


@andrew.normore wrote:

 I would much rather see a solution that is specifically designed to produce these results without creating extra points or surfaces.

 



This is what the SincpacC3D Display Points does.....select points in drawing, or by Point Group, choose the surface, Print to File.....fast, simple.

Display Points.png

 

and the results in Excel:

csv in Excel.png

 

 

Jeff_M, also a frequent Swamper
EESignature
Message 22 of 55
Joe-Bouza
in reply to: Jeff_M

Agreed. Reporting would be better

Thank you

Joseph D. Bouza, P.E. (one of 'THOSE' People)

HP Z210 Workstation
Intel Xeon CPU E31240 @ 3.30 Hz
12 GB Ram


Note: Its all Resistentialism, so keep calm and carry on

64 Bit Win10 OS
Message 23 of 55
andrew.normore
in reply to: Jeff_M

That is exactly. I will look into this!

Windows 7 x 64
Dell Precision M6600 Mobile Workstation
16 GB Ram
i7 @ 2.5 ghz
Civil 3D 2012 SP 1
Civil 3D 2011
Autodesk Inventor 2011
AutoCad Map 3D 2011
Message 24 of 55
Sinc
in reply to: Jeff_M

Oh, and the reason we don't round off values in the report to Excel is because you can do that easily in Excel, via cell formatting...  When I wrote that routine, I knew people might want to export that data to Excel, then use it for further calculations (such as slopes, etc...) so I wrote it so that it does NOT honor the format settings in your drawing, and dumps the data out in full-precision.  That lets you take this data and further-manipulate it in Excel, should you choose.

 

This seems to work better for those "****" types (mainly people in Government reviewing agencies, who don't seem to understand "rounding error"....).  Smiley Surprised

Sinc
Message 25 of 55
Sinc
in reply to: Sinc


@Sinc wrote:

This seems to work better for those "****" types



Really...?  The anatomically-accurate word for the nether-region of all our bodies gets censored on this forum....??

Sinc
Message 26 of 55
neilyj666
in reply to: Sinc

LOL - I'm glad about that.....unnaturally precise work otherwise......!!!!!

neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature


AEC Collection 2024 UKIE (mainly Civil 3D UKIE and IW)
Win 11 Pro x64, 1Tb Primary SSD, 1Tb Secondary SSD
64Gb RAM Intel(R) Xeon(R) W-11855M CPU @ 3.2GHz
NVIDIA RTX A5000 16Gb, Dual 27" Monitor, Dell Inspiron 7760
Message 27 of 55
Sinc
in reply to: Jeff_M

I suppose I should also point out that the screen shot that Jeff posted has the Northing and Easting rounded because he didn't stretch the columns in Excel prior to creating the screen shot...  The actual output has the full Northing and Easting, and is not rounded.... The rounding is an artifact of Excel.

Sinc
Message 28 of 55
dilsmails
in reply to: andrew.normore

hai friends 

I created a urface and alignment. now i wand to create interpolated  points and abels perpenticular to the aligenment.

(The attached image had shown what I need exactly. It is just I created manually as a ref sketch .if  there is any way to make it automatically )

any budy can help me please

perpenticular.png

Message 29 of 55
tcorey
in reply to: dilsmails

Spoiler
 

Hello Dilsmails,

 

You have changed the subject of this thread. You will likely find a response if you make yours a new thread. Not as many readers read the last post in a thread as read the first!

 

Best regards,

 

Tim

 



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Message 30 of 55
dilsmails
in reply to: tcorey

how to make a new thread. can ypo p;ease tell me

Message 31 of 55
BrianHailey
in reply to: dilsmails

Message 32 of 55
HansSMS
in reply to: andrew.normore

Hi Andrew,

 

I created a new User-Defined Property called As-built elevation. Then created an input fromat called As-Builts, where the elevation gets read into this user defined property instead of the point elevations.

 

Them I elevate all points to the design surface. This fills in the point elevation column, and I can using another defined format export both elevations to a csv and into a spreadsheet, converting that to any report I want.

 

I've also created an expression which is the As-built elevation minus Point elevation. Then used that expression in a label, this labels up all my points with the elevation difference and I get a nice conformance check plot.

 

Easy peasy.

 

Pity one can't created "calculated" User Defined properties, i.e. one whose value is calulated from one or more point properties.

Hans Moller
Surveying & Management Services
Gladstone Australia
Metabox 16GB, Intel i7-9700K 3.6Ghz, 500GB SSD, 2TB HDD Nvidia GTX 1060
AutoCAD Civil 3D 2018
Message 33 of 55
mcardo99
in reply to: andrew.normore

Thanks for the tip!!!

 

 

If terramodel has it... why doesn't civil 3D? Is somebody slacking off, throwing rubber bands at the wall at autodesk???

I'd like to see a POINTS to SURFACE elevation deviation report choice. Surveying has been in need of this since the beginning of days. Need to hand a CUT/FILL report to contractors for road construction, parking lot paving, etc...  Need this feature.

Message 34 of 55
strsi681
in reply to: mcardo99

I agree, I have been using 12d for the past 6 months and it has an inbuilt function that generates a report detailing differences between points and DTMs (either vertically or perpendicular to the surface). Is this function still not available on civil 3d?
Message 35 of 55
tcorey
in reply to: strsi681

One of the beauties of Civil 3D is that it includes a programmer interface, making it easy to solve small issues like the one presented in this thread. The following code is an example. If it works for you, you are welcome to use it as-is or change it so it does work for you.

 

;copyright (c)2014 by Timothy Corey
;Delta Engineering Systems, Redding, CA
;Autodesk Authorized Value-Added Reseller
;permission is hereby granted for free use of this program as-is
;or modified to your specifications.
;This program or any portion may not be sold or combined with any
;for-sale software.
;It is the responsibility of the user to debug the software
;to determine its usability and accuracy.

;This program will ask for a reference surface object and a selection set of Civil 3D Points
;a report will then be written, c:\PointDepth.txt, which will list PointNumber, PointElevation,
;SurfaceElevation and DistanceToSurface. Change the file location and name to your specifications.

(defun c:go ( / srf vsrf fl pts len ctr p vp pno x y elv srfz depth elvx srfzx output)

  (setq srf (car (entsel "\nSelect reference surface: "))
	vsrf (vlax-ename->vla-object srf)
	)
  (setq fl (open "c:\\PointDepth.txt" "w"))
  (write-line "PointNumber, PointElevation, SurfaceElevation, DistanceToSurface" fl)
  (prompt "\nSelect points to report: ")
  
  
  (setq pts (ssget)
	len (sslength pts)
	ctr 0)

  (while (< ctr len)

    (setq p (ssname pts ctr))

    (if (= (cdr (assoc 0 (entget p))) "AECC_COGO_POINT")
      (progn
	(setq vp (vlax-ename->vla-object p)
	      pno (itoa (vlax-get-property vp 'Number))
	      x (vlax-get-property vp 'Easting)
	      y (vlax-get-property vp 'Northing)
	      elv (vlax-get-property vp 'Elevation)
	      )
	(setq srfz (vlax-invoke-method vsrf 'FindElevationAtXY x y))
	(setq depth (rtos (- srfz elv) 2 2))
	(setq elvx (rtos elv 2 2)
	      srfzx (rtos srfz 2 2)
	      
	      )
	(setq output (strcat pno "," elvx "," srfzx "," depth))
	(write-line output fl)
	
	)
      
      )
    (setq ctr (1+ ctr))
    )
  (close fl)
  (princ)
  )
	
	
	
	
 
  

 Best regards,

 

Tim



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Message 36 of 55
kkrawat
in reply to: JeffPaulsen

Thanku very much,

its correct way to find defference between two surface

 

Message 37 of 55
jarnold5BJKD
in reply to: tcorey

Hi Tim,

 

I came accross this thread and would like to know how to use this code.  Do I need to program this in using VB.net?

 

Thanks,

 

John

Message 38 of 55
AllenJessup
in reply to: jarnold5BJKD

Welcome to the forums @jarnold5BJKD. That's a LISP program. Copy the code and paste in to notepad. Save with a .lsp extension in a folder in your support path. Then use Appload to load the file.



Allen Jessup
Engineering Specialist / CAD Manager

Message 39 of 55
doni49
in reply to: jarnold5BJKD

I didn't read the entire thread so please excuse me if this has already been covered.

 

If you're looking to have your points tell you the elevation differences between existing and proposed, then create a surface from the points, save a snapshot of the surface, create a VOLUME SURFACE that compares this new surface to the EG surface.  Now tell your points to take their elevations from the new surface.  The "Elevation" will actually be the DIFFERENCE between EG & FG.  Export your points to Excel and done.



Don Ireland
Engineering Design Technician




If a reply solves your issue, please remember to click on "Accept as Solution". This will help other users looking to solve a similar issue. Thank you.


Please do not send a PM asking for assistance. That's what the forums are for. This allows everyone to benefit from the question asked and the answers given.

Message 40 of 55
tcorey
in reply to: doni49

If I remember correctly, the OP was asking for a report. That's what the lisp routine does.



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut

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

Post to forums  

Rail Community


Autodesk Design & Make Report