Author Topic: Cartesian XYZ to Survex A->B  (Read 430 times)

Offline Rob

  • forum hero
  • *****
  • Posts: 2284
  • The Eldon
    • My Photos
Cartesian XYZ to Survex A->B
« on: February 16, 2018, 12:30:51 pm »
Does anyone know of a way to easily convert XYZ survey data into the more standard "from to distance bearing clino" for survex input?

Format currently is:
Station    X Y Z
153   414429.77   382147.24   199.88
DS1   414428.65   382157.08   199.88
DS2   414439.07   382161.81   199.08
DS3   414450.92   382166.02   197.97
DS4   414463.60   382169.96   197.16

(I realise there is a way to input these directly into Survex, but i don't want them as fixed points.)
The end is where we start....

Offline prahja

  • player
  • **
  • Posts: 107
Re: Cartesian XYZ to Survex A->B
« Reply #1 on: February 16, 2018, 01:37:33 pm »
If you cant find a simple app, then I would just do it in Excel with trigonometry.

Offline prahja

  • player
  • **
  • Posts: 107
Re: Cartesian XYZ to Survex A->B
« Reply #2 on: February 16, 2018, 01:40:13 pm »
I should add it will likely need some manual input as you will need to know the sequence of stations. (Hope this helps and isnt too basic)

Offline Duncan Price

  • forum star
  • ****
  • Posts: 587
Re: Cartesian XYZ to Survex A->B
« Reply #3 on: February 16, 2018, 04:31:31 pm »
The CARTESIAN function in SURVEX allows you to specify dx, dy, dz between survey stations rather than having to use fixed points.  therefore your data is

*data cartesian from to northing easting altitude
153      DS1      -1.12           9.84   0
DS1      DS2      10.42   4.73   -0.8
DS2      DS3      11.85   4.21   -1.11
DS3      DS4      12.68   3.94   -0.81

Offline Rob

  • forum hero
  • *****
  • Posts: 2284
  • The Eldon
    • My Photos
Re: Cartesian XYZ to Survex A->B
« Reply #4 on: February 16, 2018, 04:44:09 pm »
Perfect, thanks Duncan.  :beer2:
The end is where we start....