Skip to main content
  • EN

Hello,

 

for a 3D visualization I would like to assign contaminant data from soil samples from varying intervals (e. g. 0,5 m) into a smaller interval of choice, e. g. 0,1 m.

 

An example of my input/original data and the desired output with a densification interval of 0,1 m is shown here:

Input_Output_Data_Densification_v1In our recent example, we have around 350 samples. By now, this is easy to solve with Excel formulas, but takes some time to process .

 

As I am quite new to FME but also in terms of a future automation – is there a quick to do this in FME? Or would a Python script be more practicable in this case?

 

Thanks for any hints and suggestions!

 

Kind regards

Alex

Certainly!

One way is to use 'Adjacent Feature Attributes' functionality.

DensifyCreate features for every 0.1 meters between the minimum and maximum depths, add the known data to the features with the corresponding depth, and finally fill in the gaps.

This assumes every depth_from is the same as the previous depth_to.

See the attached example workspace.

Thanks a lot! Will give it a try :)

This is one of the things I love about FME, many ways to solve the same problem (@mark2atsafe​ )

 

Here's another solution

image

This is one of the things I love about FME, many ways to solve the same problem (@mark2atsafe​ )

 

Here's another solution

image

Absolutely. I think a Cloner is how I would set about it. But part of me wants to turn the spreadsheet into three-dimensional spatial features - maybe a DEM grid - and interpolate or densify.

 

You can't beat solving a non-spatial problem with spatial functionality!

Reply


Community Stats

30,169
Posts
114,531
Replies
37,828
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.