Notifications
Clear all

Manipulating CSV Data

11 Posts
8 Users
0 Reactions
251 Views
Matt C
(@matt-c)
Posts: 3
Member
Topic starter
 

Hello,

I tried to look for this topic, but wasn't able to find anything... so forgive me if I am repeating a thread.

I have shot a brick wall using my trimble S6 using reflector-less EDM. I have the points into CAD but I am not sure how I am going to display the information. I need to show that the brick is 'bowing' out from the wall outside of the allowed tolerances. Ideally I would be able to make a heat map, similar to the surfaces I made for our concrete slabs. I need to manipulate the coordinates so that the plan view goes from looking down on the wall to looking at the wall (but still in plan view).

Cheers,
Matt

 
Posted : April 12, 2016 3:07 pm
scott-zelenak
(@scott-zelenak)
Posts: 601
Member
 

In excel swap columns for elevation with the column for the north.
Assuming north is perpendicular to wall.
Works better if your coordinates are station and offset along the wall.

 
Posted : April 12, 2016 3:36 pm
scott-zelenak
(@scott-zelenak)
Posts: 601
Member
 

Um just to clarify...
Using my method you'll be in elevation view.

 
Posted : April 12, 2016 5:51 pm
BajaOR
(@bajaor)
Posts: 368
Member
 

Haven't done this but it seems this should work:

  1. Rotate points such that wall or wall section bears east and the face is "looking south".
  2. Export points.
  3. Exchange elevations for northings.
  4. Change sign of all new "elevations".
  5. Find lowest valued "new elevation" and boot all points such that that elev is zero.
  6. Import points.
  7. Hit the contour button. Contours are true bow (positive) or depression (neg.) of wall face.
  8. Post a pic when you're done.
 
Posted : April 12, 2016 6:29 pm
jacob-wall
(@jacob-wall)
Posts: 132
Member
 

I once was in the same situation, and I wrote a LISP program to do this, see the attached file. NOTE: I had to change to TXT extension to upload, just rename to LSP and then APPLOAD into CAD.

This is how to use it:
1. Type vtface in the command line
2. Select entities to transform, automatically filters for POINTS
3. Pick two points for projection baseline orientation
4. Pick a depth reference point
5. Pick a location in the drawing for the plan view drawing
6. Points are flipped and drawn in plan view

From there it's just regular surface build procedure. The routine also draws a rectangle encompassing the limits of the point "cloud".

Attached files

vtface.txt (2.7 KB) 

 
Posted : April 12, 2016 7:23 pm

Matt C
(@matt-c)
Posts: 3
Member
Topic starter
 

I've been trying to get this into my CAD file, but I don't think my version of CAD supports LISP files for some reason. I'm running embeddedCAD 2014.

I've also tried to move the points in CAD, I've been able to move them visually, and export. When I compare the original CSV to the newly exported CSV I have not seen new numbers.

This is frustrating to say the least!

Thank you for all your replies. Much appreciated.

Matt

 
Posted : April 13, 2016 7:47 am
drakej6
(@drakej6)
Posts: 21
Member
 

If you are running Carlson you can change the coordinate order when importing a text file to swap the northings and elevations without having to actually adjust the file. Just make sure you set it back after you are done.

 
Posted : April 13, 2016 8:05 am
Matt C
(@matt-c)
Posts: 3
Member
Topic starter
 

I think I got it. I'd post photos but I am to new to be allowed to post any links.

I rotated the points so they are east-west in plan view, updated the csv and swapped the Z & Y... I thought I tried this already but apparently not.

Thanks everyone!

 
Posted : April 13, 2016 8:10 am
Rusty
(@rusty)
Posts: 12
Member
 

If I have to do this I simply select all the points in CAD and use the '3DROTATE' command.

Best to do it in an isometric view. Pick a base point and rotate 90 degrees on the appropriate axis.

Job done.

 
Posted : April 15, 2016 7:15 am
spledeus
(@spledeus)
Posts: 2772
Member
 

How many points do you have?

 
Posted : April 15, 2016 4:37 pm

Dan Patterson
(@dan-patterson)
Posts: 1272
Member
 

Just like the others said.....rotate the points so the wall is in a cardinal direction then switch the direction of the bow (north and south or east and west) with elevation. You Should be able to plot it like a a surface looking down onto the face of the wall and "contour" it or use elevation banding colors to show relief.

 
Posted : April 15, 2016 5:45 pm