Jump to content


Sharescale

Elevation Model from CSV file

Recommended Posts


Hey there, I was doing a quick search and funnily enough you've already asked this question before with the only difference being the file extension. The data has the same structure so the solution should be the same.

 

Share this post


Link to post
Share on other sites

Then again after looking at most solutions online, none of them will give an accurate result assuming they take the data as XYZ instead of Long Lat Alt.

Edit: I added an index column to be able to import the data into the structure tab correctly but that doesn't solve your issue. The math required to calculate the actual positions correctly based on latlong isn't a complicated concept but definitely beyond my python skills.

CSV import.jpg

Corrected Path.csv

  • Like 1

Share this post


Link to post
Share on other sites
On 1/12/2019 at 2:41 PM, Sharescale said:

how can we create elevation model in C4D form a CSV file having Lat Lon and Alt data.

CSV file is attached 

appreciate the help in this regard

Untitled Path.csv

I used the equation from this post to get the XYZ data so it should be easy for you to replicate.

I broke down the equation for you in excel:
The yellow columns are your Lat Long Alt. 
The red columns are the calculated variables for the equations.
The Green columns are the XYZ coord.

be sure when you do this later on to format your CSV as follows:
#,X,Y,Z

 

example:
0,100,200,150

1,125,200,150
etc...

CSV.xlsx

CSV XYZ.jpg

CSV - xyz.csv

  • Like 1

Share this post


Link to post
Share on other sites

I typed the 1st co-ord in the csv into Google Earth, and it's Abbottabad - where Mr O.B. Laden used to live.

Share this post


Link to post
Share on other sites
16 minutes ago, jed said:

I typed the 1st co-ord in the csv into Google Earth, and it's Abbottabad - where Mr O.B. Laden used to live.

So? What the data is and what they do with it is their problem..

Share this post


Link to post
Share on other sites
  • Topic Author
  • On 1/13/2019 at 9:41 PM, AZacha said:

    I used the equation from this post to get the XYZ data so it should be easy for you to replicate.

    I broke down the equation for you in excel:
    The yellow columns are your Lat Long Alt. 
    The red columns are the calculated variables for the equations.
    The Green columns are the XYZ coord.

    be sure when you do this later on to format your CSV as follows:
    #,X,Y,Z

     

    example:
    0,100,200,150

    1,125,200,150
    etc...

    CSV.xlsx

    CSV XYZ.jpg

    CSV - xyz.csv

    Nice, but how you project the CSV data in C4D to draw these coordinates?

    Share this post


    Link to post
    Share on other sites
  • Topic Author
  • On 1/13/2019 at 9:51 PM, jed said:

    I typed the 1st co-ord in the csv into Google Earth, and it's Abbottabad - where Mr O.B. Laden used to live.

    hahahah yes you are right.

    Share this post


    Link to post
    Share on other sites
  • Topic Author
  • 1 hour ago, AZacha said:

    Create an empty polygon object and then in the structure tab, import the csv data.

    now i import the csv file you have provided in the structure manager but it is not making any structure. 

    data is like this

    1 1525235 5058308 3563423
    2 1525329 5058293 3563400
    3 1525491 5058273 3563369
    4 1525656 5058263 3563314

    Share this post


    Link to post
    Share on other sites

    It is, the position is really far though. Also, points are not visible unless you're in point mode.

    What you'd want to do is center the axis to the object and then set it's coordinates to  0 0 0 so that you can navigate around it more easily.

    After that you can connect the dots together.

    Share this post


    Link to post
    Share on other sites
  • Topic Author
  • 9 hours ago, AndreasZ said:

    It is, the position is really far though. Also, points are not visible unless you're in point mode.

    What you'd want to do is center the axis to the object and then set it's coordinates to  0 0 0 so that you can navigate around it more easily.

    After that you can connect the dots together.

    it is working like this, but not spreading the points according to the coordinates position. i checked the  coordinates from Alaska, but it is just creating a long line of points.

    Share this post


    Link to post
    Share on other sites

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

    • Recently Browsing   0 members

      No registered users viewing this page.

    ×