Create topography/nurbs/surface based on filtered Excel data (x,y,z,soil type)

[dynamoz]

Hi all,

I’m going through an exercise to create a series of solids to visualize soil borings taken from a site. I have two questions but would also appreciate feedback/comment if there is a better way to do this. I’m new to Dynamo and have been searching posts discussing point clouds, nurbs, or surface creation. this post seems to be the most promising so far

1. How do you filter and create new lists from a sublist? For each boring I have the boring diameter, Northing, Easting, Z-Start, Z-Stop, and classification (ex. fill, sand, bedrock). I want to filter out each type of strata and create a solid based on the northing, easting, and z-start and stop. I’ve tried a combination of List.ContainsItem and List.FilterByBoolMask but don’t know how to get it to work.

Here’s where I’ve gotten before getting stuck.

1. Get the Excel data, drop the first row.
   

   

2. Filter each boring into one of two groups: {X-Coord, Y-Coord, Z-top} and {X-Coord, Y-Coord, Z-bottom}
   

   

Once I did that I realized I had to delete all duplicate xy entries to create topography. I’m learning how to do that.

[MSibaii]

Hello Mathew @dynamoz ,

I am a beginner at Dynamo and I was trying to do the exact same thing… wondering if you figured it out and where able to succeed in modeling earth strata using borehole information from excel sheet.

I was trying to model the layers using only the top of surface value and modeling it as different layers of “topography” but i think you have a better approach at this.

Thanks