Programming the statistical procedures from SAS

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

Reply
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

DATETIMEMEASURED_DEPTINCLINATIONAZIMUTH
7-Oct-1310:25:415886.154.74354.39
9-Oct-1317:28:31000
9-Oct-1317:28:31006.282
13-Oct-1320:46:52380.170.54271.56
15-Oct-1316:57:011089.180.06259.93
26-Oct-1321:57:56419.070.02580.092
27-Oct-1322:11:26562.210.22040.095
28-Oct-1318:21:51648.080.340.008
29-Oct-139:19:00677.150.38146.281
30-Oct-1323:46:50791.980.52416.256
31-Oct-1321:36:29849.380.5186.191
Grand Advisor
Posts: 10,043

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,307

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

Ask a Question
Discussion stats
  • 2 replies
  • 680 views
  • 3 likes
  • 3 in conversation