BookmarkSubscribeRSS Feed
vickram
Calcite | Level 5

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
2 REPLIES 2
ballardw
Super User

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.

Rick_SAS
SAS Super FREQ

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

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