Trimble Business Center

Cross section topo points are usually taken slightly off station within a given tolerance say between 0' and 2' off station as an example, with some data sets being much worse. When these points are brought in to a surface and added to a corridor to be viewed as a cross section, the varying offset of stationing of the topo points can give a bad interpretation if no editing of the the data takes place. You have to options, either you have to add breaklines or linestrings connecting by feature code or shift the point perpendicular to the exact cross section station being cut. Each of these routines will kill the clock. Is there any short cuts or work around to these two options. Thought about creating stored cross sections, and tried to do it manually but again the clock fell on me.  

Henry

If you run the Pavement conformance report it will create you a list of points sorted Left to right and by Station to the tolerance that you specify. If you want to pull all the points onto specific stations you can use Excel to "ROund the data" or you can edit in Excel to create a clean Station, Offset, Elevation report that you can save as a CSV file in the format as follows

1st Line needs to read TBC Excel (Case Sensitive)

2nd and subsequent lines can read Sta, Off, Elev, Code or Point ID, Sta, Off, Elev, Code

Save as a CSV file with the name of the alignment to which they are associated e.g. HAL.csv

Then run Import command and browse for the file. You can import as Stored Cross Sections or as Points - it will create a surface also but you can delete that if you don't need it. When importing set the flag to Read a Point ID or not depending on whether you have an ID as the first field of data or not

Hope that this helps - raise this at the PUG conference this week and I will go over it - we have an exercise planned and I can likely incorporate it into what we have planned

Alan

In order to get the Station formatting removed for Excel, before you run the Pavement Conformance Report you should change the Project Settings - Units - Station from 10+00 to no formatting to get the stations as numbers.

In Excel use the =Round(Cell No, 0) where Cell no is the Cell that the Stations are in

Then you may need to Copy and Paste Special to make those rounded numbers real values, however I think if you write to CSV they may just get written as the rounded numbers anyhow.

Delete the columns and Rows that you dont need

Add the TBC Excel Header Row

The attached file is your data rounded by Station (not Offsets) - it took me ~2 minutes to process this and get it back into BC-HCE as you wanted.

Alan

Here is the link to your file

https://community.trimble.com/servlet/JiveServlet/downloadBody/31578-102-1-39546/Phylway%20Test%20Pts.csv.zip 

Alan

The Rounding formula in Excel to get all your points rounded to nearest 50' is =ROUND(Cell Ref/50,0)*50