Huge tree table in Excel, how can I get this into Revit


#1

Hi There,

I am very new to Dynamo and think it will be of great benifit.

I have a table from a surveyor who has completed a Tree survey for us but think 4oo trees will take too long to put in maually.

If someone can help me Id really appreciate it. I would have so many uses for this as I receive coordinates all the time and usually use points to place from a CAD link.

Anyway my list is here in meters.

List has

Point number

Easting

Northing

Tree Spread

Tree height

and trunk Diameter.

sample tree list

Can dynamo make this work? Just with any generic tree.

I only have 3 trees in this one.

Thanks and I look forward to learning more about dynamo.

Cheers

Allan

 


#2

Hi Allan

Yes it can.

However, you would need to work through how the properties in the spreadsheet relate to Revit objects:
For example

  • is the diameter an instance parameter, or a type parameter
  • Is the 'height' the height of the tree above ground, or the elevation above a datum (level)
  • What is the elevation of the base of the tree ?
  • Is the point column meant as the tree number or a 'mark'
 

Andrew


#3

Gday Andrew,

Many thanks for your reply, its much appreciated. I will try and answer your questions.

I am obviously new at this so apologies for anything that I don’t understand. I usually create a surface using Civil3d (triangulated) and CAD link in the file to datum rl0.0 using that layer “Triangles”.

This way the surface is at the correct Australia Height Datum. So the height of the tree should sit at the correct height.

The elevation of the tree is at ground level (where the trunk meets the ground). We can forget about the tree number I guess, its relevant in Civil3d (Tree table but probably not for REVIT).

I am not sure about what you meant by this…??? is the diameter an instance parameter, or a type parameter ???

What would be awesome would be to have the tree (see attached) to come in with all the aboveto say this generic tree. 3D Tree - Ellipse (AUS)

I Have also attached a pdf of the tree I want to place, as you can see properties that I would like the tree to adopt from the excel file.

Again Andrew your help…any…is much appreciated. Thanks Allan

tree doc


#4

Hi Allan

Instance parameters can be different for each instance- easiest to do all your tree parameters as instance.
I suggest reading up on this- someone else can explain it better than me.

Refer attached for a 5 minute try

Basic steps are:

  1. Read in data

  2. Split into columns

  3. Feed into data into family

It would need an hour or two to finesse.

You can see I have set the elevation (Z) of all trees to zero- you might need another column for this and put it into the ‘offset’ parameter

I have also fixed up the units in the spreadsheet to mm

 

Andrew

sample-tree-list

tree importer

sample-tree-list

 


#5

Thanks Andrew,

This is great. Do you have the dynamo screenshot I can have a look at?

Or you can send me?

Thanks again for you time on this its much appreciated.

Cheers

Allan


#6

sorry, I meant to attach the dyn file, not the excel file twice

tree importer v1

tree importer v1

It looks more complicated than it is

 


#7

Thanks Mate.

Legend!

Cheers

Allan


#8

Hi Andrew,

I have managed to get the trees working for position, Tree height and spread.

BUT one thing I cant for the life work out is to get the trees to associate to the elevation (RL) in row G? the “Z” value.

CMS-tree-importer-v1 sample-tree-list

Any ideas, sorry to be a pain, no worries if not…

Regards

Allan

 


#9

Refer attached CMS-tree-importer-v2

You had got the columns mixed up- by adding an extra column- you need to take every 7th item, not 6th (in the green sections)

There is probably a more graceful way to split up the columns

(The trunk diameter column in the spreadsheet also needs to be corrected)

 

 

Andrew


#10

Andrew,

I owe you a beer!

Thanks so much you have saved me so much time.

Cheers

Allan