Trimble Business Center

I have this file containing points logged at Random from Machine Control Sytem Blade edges.

Challenge is to get Two Surfaces  One Surface with the Topmost points in any Section and the Second with the Bottom most points in any section.

Is it possible? If yes, how.

Thanks.

This is not a Trimble machine data set I don't believe - our 3D systems log the data in TAG files and we use our VisionLink system production Server to do exactly this and we can extract Highest, Lowest, First and Last Pass as well as filter to closest to a design surface.

This type of data - all you have really is what looks like Date and Time which doesn't in itself really help you - you could open in Excel and sort by Date / Time and then by coordinate and Elevation - however that will I think be "Hit and Miss"

It would be possible to create a "processor" for this type of data that used the Date and Time field and read the data in against a User Defined Grid and when a new point gets added to a Grid Square update the values in the Grid and log the First, Last, Highest, Lowest etc values in each square so that you could extract something meaningful - do you have the source data and can you tell me what machine system this is coming from?

If solving this problem is critical for you, I can find a developer outside Trimble to look at solving this issue for you - let me know if that is of interest to you - it is likely a good application for a TML Macro for TBC.

Alan

Saif

Also without Time I dont think "Top" and "Bottom" is really what you need here - if you take a normal Cut / Fill scenario - Points in the Cut Area will start high and elevation will reduce over time and in a fill the points will start low and increase in elevation over time -so taking the Highest = Top and Lowest = Bottom is not going yo give you what you need

I pulled the data into Excel and could create a Pivot table that shows an XY Grid with Min Z or Max Z but I cannot think of a way to output that into a E,N,Z csv file easily

Still thinking here

Alan

We are looking into it .....

Alan

As a close out here, we have written a TBC Macro that searches through the imported Log files that have points with Date and Time stored on the Code / Description Field and can create a layer of points based on a Grid defined by an alignment (Straight Line or Curvilinear) (Station and Offset plus Start, Origin and Orientation). We can select Earliest, Latest, Highest, Lowest or Average Elevation (any or all of these options) and generate a point at the Grid Centroid with those elevations. The Points can then be used to create surfaces as needed. Each data type can be assigned its own layer as necessary.

Once we get feedback from this customer, we will make the macro available for others who may be doing the same thing.

This customer was using a legacy Leica Indicate Only system in this work.

Alan