Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Topography in revit from excel file or text file

16 ANTWORTEN 16
Antworten
Nachricht 1 von 17
shershahbacha9
1645 Aufrufe, 16 Antworten

Topography in revit from excel file or text file

Hello !! 

I tried to create topography from excel file and .txt file but its not making. I am gonna share both files if you can help me whats wrong with it. 

i used the method massing and site > toposurface > create from import > specify points file

16 ANTWORTEN 16
Nachricht 2 von 17
shershahbacha9
als Antwort auf: shershahbacha9

sorry i just saw its making but very minute and irregular i dont know why . i took topography data from google earth. and by TCX Convertor gave it altitude and saved as excel file.

Nachricht 3 von 17
SteveKStafford
als Antwort auf: shershahbacha9

The values are points that are nearly the "same", they only vary in the 3rd-4th decimal point values. That's a pretty "small" site if those values are correct.


Steve Stafford
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

Nachricht 4 von 17
barthbradley
als Antwort auf: shershahbacha9

It's making it. All 239 points are placed. But your x and y values are all in the same relative position 50 and 11.  

 

Topocsv.png

Nachricht 5 von 17
barthbradley
als Antwort auf: SteveKStafford


@SteveKStafford wrote:

That's a pretty "small" site if those values are correct.


 

Pretty mountainous too. he,he. 

Nachricht 6 von 17
barthbradley
als Antwort auf: shershahbacha9

This look closer:

 

Topo2.png

Nachricht 7 von 17
shershahbacha9
als Antwort auf: SteveKStafford

yes its actually a very small site but still it should give a correct regular shape

Nachricht 8 von 17
shershahbacha9
als Antwort auf: barthbradley

yes its a small site but not too mountanious. how  to u get such shape as i get a long narrow shape and at both ends a little topography haha

Nachricht 9 von 17
shershahbacha9
als Antwort auf: barthbradley

What do u mean by same relative position ?

Nachricht 10 von 17
barthbradley
als Antwort auf: shershahbacha9

What I mean is that EVERY point coordinate is at x=50.964, y=11.331 (or 11.332), z=236. So basically, all the points are on top of each other. The point coordinates only differ from one another by 1/10,000ths of a "unit". Here's the resulting Toposurface if you remove those first 5 digits of every x and y coordinate in the point file. I'm not advocating you truncate each line; I'm just illustrating my "point". Pun intended. The resulting Toposurface has a Projected Surface Area of 428804.00 sq. "units".  Depending on the unit of measurement it could be a Continent or it could be a heel imprint in the mud.  Don't know. But it's definitely a Revit Toposurface. 

 

Toposurface from Point File.png

Nachricht 11 von 17
shershahbacha9
als Antwort auf: barthbradley

Actually i captured a small place around 270 square meter in google earth and produced this csv file using TCX Convertor . Is there any fault in my procedure of getting this excel file as all points are overlapping or Google earth is not giving accurate results.

Nachricht 12 von 17
shershahbacha9
als Antwort auf: barthbradley

hey i want to take any area from google earth pro and then convert its data in form of excel file and then use this excel file to  make topography in Revit . But as u know my points are somewhat coinciding  when making topography . is somewhat wrong with my method ? can u have a look

Nachricht 13 von 17
bin
Advisor
als Antwort auf: shershahbacha9

04112019.PNG

Is it here? I think they are longitude and latitude, and elevation in meters, maybe.

Nachricht 14 von 17
shershahbacha9
als Antwort auf: bin

yes here was the area i wanted to take data of. My revit file is in meters where i have to feed this topography . actually elevation data is important for me as i have to test which building out several could possibly fit on which topography

Nachricht 15 von 17
shershahbacha9
als Antwort auf: barthbradley

but i captured the area from google earth pro . i dont know how x and y values are almost same . is something wrong with my method ?

 

Nachricht 16 von 17
bin
Advisor
als Antwort auf: shershahbacha9

I think the x and y Are latitude and longitude. According to Wikipedia , 1 degree of latitude equals 110.6km and 1 degree of longitude equals 111.3km at sea level. 
https://en.m.wikipedia.org/wiki/Lat-lon 

So for example if there are 2 points share a same latitude and a difference of 0.000005 in longitude, the actual distance between will be about 0.000005*111300=0.5565m 

Just googled it. :leicht_lächelndes_Gesicht:

Nachricht 17 von 17
bin
Advisor
als Antwort auf: shershahbacha9

Try the Dynamaps maybe.  It can create the topography, buildings, roads etc. for you and the only thing you need to do is typing in the address. 

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report