## how to find XYZ coordinates for 3d graph from AZIMUTH,INCLINATION,MEASURED DEPTH in oil & gas domain

Occasional Contributor
Posts: 7

# how to find XYZ coordinates for 3d graph from AZIMUTH,INCLINATION,MEASURED DEPTH in oil & gas domain

Hi _ALL_

This is  vikram i am having trouble with converting geometric coordinates (AZIMUTH, MEASURED_DEPTH , INCLINATION ) into 3D (X,Y,Z) to represent into (3D) visualization graph, i need the formula for x ,y, z values using above parameters.

i got some information but i am not sure which one is right :http://images.pennwellnet.com/ogj/images/ogj2/95049101.gif

WELLOG

 DATE TIME MEASURED_DEPT INCLINATION AZIMUTH 7-Oct-13 10:25:41 5886.1 54.74 354.39 9-Oct-13 17:28:31 0 0 0 9-Oct-13 17:28:31 0 0 6.282 13-Oct-13 20:46:52 380.17 0.54 271.56 15-Oct-13 16:57:01 1089.18 0.06 259.93 26-Oct-13 21:57:56 419.07 0.0258 0.092 27-Oct-13 22:11:26 562.21 0.2204 0.095 28-Oct-13 18:21:51 648.08 0.34 0.008 29-Oct-13 9:19:00 677.15 0.3814 6.281 30-Oct-13 23:46:50 791.98 0.5241 6.256 31-Oct-13 21:36:29 849.38 0.518 6.191
Super User
Posts: 11,767

## Re: how to find XYZ coordinates for 3d graph from AZIMUTH,INCLINATION,MEASURED DEPTH in oil & gas domain

I think you may be assuming that everyone knows what/how you measure. The reference has text too small to read for me on a 24" monitor so hard to tell.

1) Is inclination measure to the top or bottom of the drilled hole?

2) Do you have an example of what the final graph is supposed to look like?

3) I think you may be missing a part of the needed data as an azimuth without a distance is very hard to turn into xy coordinate.

SAS Super FREQ
Posts: 3,831

## Re: how to find XYZ coordinates for 3d graph from AZIMUTH,INCLINATION,MEASURED DEPTH in oil & gas domain

These sound like spherical coordinates. How to convert to Euclidean coordinates depends on whether you are using a right- or left-hand coordinate system and where you put the axes, but the basic ideas are readily available with an internet search. Here is the Wikipedia page:

Spherical coordinate system - Wikipedia, the free encyclopedia

If you use the standard spherical coordinate system, the formulas are

$x=r \, \sin\theta \, \cos\varphi$

$y=r \, \sin\theta \, \sin\varphi$

$z=r \, \cos\theta$

You might want to let z --> -z if you are measuring under the surface of the earth. If you are using another system, you might need to change sines and cosines around.  Check the formulas with limiting cases such as "straight down" and "on the surface."

Discussion stats
• 2 replies
• 878 views
• 3 likes
• 3 in conversation