Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have an excel spreadsheet with header and survey drill data. Header data contains hole ID, and location coordinates, and the survey data contains related downhole survey with Distance, Azimuth and Dip values.

Since I know the hole location and surface elevation, I would like to be able to convert the survey table to XYZ coordinates as well. Does anyone has a function / procedure / example? (VB & ArcObjects)

Header Data:

Header Data

Survey Data:

enter image description here

share|improve this question
    
Couldn't you just use them as xyz coordinates anyways? I assume that dip has an origin of 0, doesn't it? –  Emily Aug 11 '11 at 19:17
1  
@Emily - Yes the first XYZ is given (X:425990,Y:5409010,Z:350). The dip value is 0 and the distance is 0. How do I calculate the XYZ for Distance:41, Azimuth: 359, Dip: -71? (At each survey point the direction and inclination will be different, resulting deviated and spiraling downholes) There is probably a simple formula... –  Jakub Aug 11 '11 at 19:44

2 Answers 2

up vote 9 down vote accepted

The question asks for conversion between spherical and cartesian coordinates. This spreadsheet lays out the formulas:

Spreadsheet screen shot

Blue lines are input, black are intermediate calculations, and red are output. Within the formulas, the values are referred to by the names in the [Parameter] column (assigned via the Insert|Name|Create operation).

They differ from those in most math/physics references because in geography, the azimuth is usually taken east of north rather than north of east. This makes the geographic azimuth the complement of the mathematical one (they sum to 90 degrees). Replacing an angle by its complement in any trig function interchanges it with its "co" partner: sine and cosine are interchanged, tangent and cotangent, secant and cosecant. Also, in many mathematical systems the "dip" is expressed as an angle from true vertical (a co-latitude) rather than as an angle from horizontal (a latitude), again causing an interchange of sine and cosine.

Edit 9/20/13

For a downhole distance you probably want to negate dZ.

share|improve this answer
    
Thanks. Looks good! Will have to confirm the azimuth type. How do I find the Radians in the formula? –  Jakub Aug 11 '11 at 20:19
    
Radians = Degrees / 180 * Pi –  whuber Aug 11 '11 at 20:20
    
Right on. Thanks. I was staring at the formula in the link above and scratching my head. Clear as a bell now. –  Jakub Aug 11 '11 at 20:37
    
@Jakub You are aware that this is a working, valid spreadsheet, right? You can type these formulas into Excel, name the cells in the [Value] column as indicated in the [Parameter] column to its left, and it will run. Blue text is input; black is intermediate calculations; and red is output. Once you're comfortable with it you can modify your second spreadsheet to do the computations for every entry. The only trick is in joining the (X0,Y0,Z0) coordinates from the first: do it with a database or by means of VLOOKUP(). –  whuber Aug 11 '11 at 20:41
    
I wasn't aware. Even better! So RADIANS is obviously an Excel function to which I am passing either Azimuth or dip. –  Jakub Aug 11 '11 at 20:52

In addition to the correct answer found here @whuber. the distance should be considered as geodetic distance. These programs may be too ancient to utilize easily.
But as I am not a programmer only a consumer of programs.
I will not pass judgement on the usability.
Noaa computation utilities

share|improve this answer
    
For drillholes, we're measuring distances directly, not across the surface of the earth, so geodetic distances don't appear to be relevant. The earth could be shaped like a bagel for all it matters... :-) –  whuber Aug 11 '11 at 20:15
    
@Bill - Affirmitive –  Jakub Aug 11 '11 at 20:33
    
@Brad - Bill provided the recipe now I just need to cook it. This should be pretty simple to write in VB. I will post it for QAQC when I am done. –  Jakub Aug 11 '11 at 20:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.