I was reviewing some data in Trimble Business Center Enterprise and missed a series of shots taken with a -3.35' vertical offset value that the PC forgot to clear after a down offset to a drop inlet culvert.
Using Trimble Business Center, is there a way to flag or in someway isolate all points that have a value other than zero in the vertical offset cell?
Also, is there a way to force Trimble Access to clear offsets after storing a point?
One thing I really liked about TGO versus the later TBC is that all of the data for TGO was in an Microsoft Access database format, so you could write queries to find just what you are looking for. I don't know why they decided to go with a proprietary format in TBC, other than just being Trimble.
Also, is there a way to force Trimble Access to clear offsets after storing a point?
Unfortunately, no. I think I've asked this periodically for the last 5-10 years. It would be pretty easy to implement as a custom setting in a survey style or the on-the-fly Options softkey.
I got used to just cycling through the offsets for each shot, but it would be handy to have the option to either clear them or not, since sometimes I do want to keep the values.
As far as isolating points with offsets...my preference is to use the Vector and Optical spreadsheets, and filter by either Observation Type (for total station) or GNSS Offset (RTK).
You'll want to filter the total station observations by the Observation Type column to "Distance Offset"; for RTK, just filter the GNSS Offset column by a "not equal to zero" equation.
Once that is done, you'll have the vectors/observations listed and you can either modify them from the spreadsheet, or if you want to select the points that correspond to them, select one or more vectors in th spreadsheet, right click and choose "select points by vector".
TGO that option was very nice. It was not hard to query for anything and get it out to excel for a custom type report or analysis for sure. I hope they keep adding more capabilities to select and search for all the data in TBC. It has so much information but getting to it sometimes is not the easiest. The TML way might be an option but I never got a lot of time to try and dive into that much. I imagine it can’t be to hard to figure out but usually repetitive task one gets those streamlined first. The odd ball stuff I was under the time crunch to do it at the time. I have a notebook full of I gotta do this stuff.
I did about the same as you going through the raw data. It only takes getting burned once before you truly pay attention to that stuff. I always took the points like that and made a selection set as part of my workflow. Helped me Ck the boxes as I qa/qc data. All offsets any form. So I could concentrate on those and pay attention when something didn’t seem right.
The vector and optical spreadsheets were exactly what I was looking for. Thank you!
