Trimble Business Center

 View Only
Expand all | Collapse all

better way to enter series of points at certain line chainages?

  • 1.  better way to enter series of points at certain line chainages?

    Posted 05-13-2020 16:56

    I work since quite a few years with TBC but never had to do that specific task in TBC, only in Terramodel were it is no trouble at all.

    I did check the help but couldn't find anything better. But maybe I miss the forest for the trees.

     

    Does anybody have a better workflow to create a series of points at different chainages receiving the line elevation than:

    :1

    -create point

    -right click in coordinate field

    -scroll down to offset from line

    -select line

    -enter chainage and offset

    -right click into elevation field

    -scroll to along line snap

    -select line again

    -enter chainage again

    -click add point

    goto :1 and do it all over again

     

    compared to the GC65 in Terramodel that is a pain

    there you select the line once and just enter different chainages, hit enter and it's done



  • 2.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 17:26

     _Create Point by Station Offset macro by Trimble.

    Try "Create Dependent Points" option. Just love it.

     

     

    or

     

    Import Station Offset Point import format

    if you have all the points in CSV format



  • 3.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:19

    I did miss that one. But it still has the following draw backs for my purpose.

     

    1. the line needs to be converted into an alignment first

    2. the elevation is not taken from the alignment, needs to be entered

     

    Especially the second point critical. I don't have the elevation, it needs to be derived from the line at that station and maybe a vertical offset applied.

     

    I have to create points at certain chainages along, and 500 mm below the top line of several retaining walls.

     

    Since it's not that many points for now I might stick to my approach or even go to Terramodel for now.

     

    Like with entering a Line String we could use an option to use Station/Offset for points as well.

     although that one can be a bit painful as well since it is deleting the distance along field every time



  • 4.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:24

     

    Works on the linestrings and interpolates RL from the line.

     

    I want a second green star for that one!



  • 5.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:30

    Can't give you the star yet. I don't have regular intervals. And even if I had lets say 10 m interval the first point is usually at a random station, would have to break the line first. At lot of trouble to create offset points.



  • 6.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:41

    Grab your linestring, convert to an alignment. 

    Create corridor, create a single node with offset 0.00 using Table option for chainages.

    Generate surface.

    Explode Surface.

    You have vertices where you need them.

    Done.

     

    Star?

     



  • 7.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 20:55

    It's a solution but quite complicate for a simple thing like point at station, don't you think.

     

    I thought you meant the solved star. You definitely get the Helpful star. Never saw them before.



  • 8.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 21:01

    Ronny, one week of wet weather in Cairns and I am sure we will have it sorted using ironPhyton 

     

    I agree with you, its is unnecessarily quite complicated. Teramodel had a plethora of useful commands at our disposal. Imagine to migrate all commands from TML list into TBC TMLs. 



  • 9.  Re: better way to enter series of points at certain line chainages?

    Posted 05-14-2020 00:08

    when I am using your method:

     

    -create point

    -right click in coordinate field

    -scroll down to offset from line

    -select line

    -enter chainage and offset

    -right click into elevation field

    -scroll to along line snap

    -select line again

    -enter chainage again

    -click add point

    goto :1 and do it all over again

     

    my elevation is populated automatically. No need to "re click" on the same chainage...

     



  • 10.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:29

    I share your sentiment. #bringbackterramodel



  • 11.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:22

    Runny

    Marian is correct. You need to install all the TMLs if you don't have them - use TML Status from www.rockpilesolutions.com web page - use your Trimble ID to log in and that will let you download and install all the TMLs easily

     

    Let me know if you need help

     

    Alan



  • 12.  Re: better way to enter series of points at certain line chainages?

    Posted 05-13-2020 19:31

    Hi Alan,

    I did miss the macro. But see my comment above. It doesn't fit my purposes.



  • 13.  Re: better way to enter series of points at certain line chainages?

    Posted 05-14-2020 11:29

    TBC Help  

    Import Station, Offset, and Elevation Files (.csv)

    Import a text file (.csv) of station, offset, an elevation values to create points or stored cross-sections associated with an alignment in your project. You can then use the data to create a surface. To import a file, follow the instructions in Import Data.

    Note: Before selecting a Station/Offset/Elevation .csv file to import using the Import pane, right-click the file in the Select File(s) list and select the file type Station/Offset/Elevation.

    Rules for importing a station, offset, and elevation file:

    • The name of the .csv file must match the name of an alignment in your project, if you have more than one alignment. If you have only one alignment, the indicated .csv file will e imported with respect to that alignment. If you do not have an alignment, the importer will not work.
    • The header (first line) in the file must contain the phrase "TBC Excel" (in English). The header can contain other explanatory text beyond the above key phrase.
    • The second line in the file is expected to contain the first cross-section node data.
    • The order of the data fields associated with each cross-section node is Station,Offset,Elevation,Code.
    • Unless otherwise noted in the header line, the default delimiter between data fields is a comma. However, if the header line is found to contain a semicolon, that is an indication of the fact that the delimiter is expected instead to be a semicolon.

    Sample:

    • Alignment in project: First Street
    • File name: First Street.csv

    File data showing the header and first two cross-sections:

    TBC Excel - Station,Offset,Elevation,Code

    20,-8.89,59.36,TIEL

    20,-3.8,62.75,SHLDL

    20,-2.5,62.83,EOPL

    20,0,62.9,CL

    20,2.5,62.98,EOPR

    20,3.8,63.02,SHLDR

    20,8.65,59.78,TIER

    30,-8.89,59.36,TIEL

    30,-3.8,62.75,SHLDL

    30,-2.5,62.83,EOPL

    30,0,62.9,CL

    30,2.5,62.98,EOPR

    30,3.8,63.02,SHLDR

    30,8.65,59.78,TIER

    This is an easy way to blast 100's of points in quickly.

    I used to calculate entire projects in excel and then import them this way.

     

    Shea



  • 14.  Re: better way to enter series of points at certain line chainages?

    Posted 05-14-2020 16:41

    Hi Shea,

    thanks for that, but that doesn't fit my purpose.

    Especially that you have to enter the actual elevation. I need to get the elevation at that specific station from the line/alignment itself, and maybe an additional vertical offset.

    Also that you need to have alignments first is an extra step I'd like to avoid.

    Just pick a line, enter stations and offsets and be done.

     

    It wasn't that many points and I went with my procedure and am done with it for the time being. But we really could use a better point at station function. Especially one were we don't have to enter an actual elevation but a vertical offset from a line/alignment.



  • 15.  Re: better way to enter series of points at certain line chainages?

    Posted 05-15-2020 08:47

    Try using the Create Sideslope Command - that works with Alignments or Linestrings, You can enter all types of Station, Offset /  Station, Elevation / Station, Slope / Station, Delta Elevation, you can set a Start and End Station, You can define all of the Stations you want in a Table and you can create that in Excel and Copy and Paste into the table, you can do multiple offsets in one pass and it even works with Station Equations and it will tie to surfaces with complex sideslopes if you want. I use this all the time when I have something none standard. It also uses the source line vertical to compute the Elevations and the Source Lines can incorporate all Geometrical Elements - Vertical Curves (symmetrical and asymmetrical, Spirals, Arcs and Vertical Arcs. 

     

    Or you can use the Offset Slope Macro and that will allow you to pick a pair of lines, extend by an offset to Line and at a Slope based on the slope between the two lines. It also allows you to define an Interval and a Start and End point or you can use the source line interval. 

     

    Alan



  • 16.  Re: better way to enter series of points at certain line chainages?

    Posted 05-18-2020 16:11

    Hello Alan,

    thanks for the tip, the side slope command does actually do the job. 

    But that is no straight forward job, you also have to enter the stations twice, once in each table, or use Excel to create a table. And in the end you also have to explode the side slope and run the create from cad command to actually get the points and a coordinate list, CSV file. I might try it next time I have to do anything like that again and I have the right Edition available.

    It's only included in the Site Modeling Edition, I would expect to have a simple CAD point at station/offset in one of the lower editions.