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

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

vickram — Mon, 08 Dec 2014 17:33:54 GMT

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

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

ballardw — Tue, 09 Dec 2014 16:55:06 GMT

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.

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

Rick_SAS — Tue, 09 Dec 2014 19:26:33 GMT

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

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."