Jump to content

source data text file


minotto

Recommended Posts

I have a text file with latitude, longitude and elevation coordinates separated by commas.  I'd like to create a site model from this by converting the information into 3d loci or stakes

 

After selecting AEC > Survey Input > Import Survey File,  I tried to selecting various options but the elevations of the 3d loci all end up on top of one another, that is the lat. and long. coordinates aren't recognized.

 

What am i doing wrong?

Link to comment

@minottoHi, I don't think your data is correct as when you look at the data the first and second is usually a co-ordinate and third a height.

The spacing doesn't seem  far enough apart and heights are too high. Possibly the horizontal scale is different to the vertical scale of the survey data.

I put the data into an Excel document.

 

The attached image is the way it should look, first column is the survey point number (I think), then Easting & Northings (or Viseversa) then the level. last are codes that you have to drop off.

You basically use Column B, C & D.

 

Book1.xlsx

Capture.JPG

Edited by Alan Woodwell
Link to comment

Thanks Alan and Jonathan for the suggestions.  

 

But i'm a bit confused.  Vectorworks can read latitude and longitude but it just has to be formatted according to Alan's example?

 

 Or VWs doesn't read latitude and longitude? 

If so, is there an easy way to convert latitude and longitude to a datum?

Link to comment

In Allan's image of the spreadsheet can you identify the columns? It looks like the first one is data point and then LAT and LON with elevation and description. If this is the case then delete the first column and last and you should be cooking with gas! The only issue you will have is the conversion to you current site coordinates.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...