turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- how to find XYZ coordinates for 3d graph from AZIM...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-08-2014 12:33 PM

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

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 |

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-09-2014 11:55 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-09-2014 02:26 PM

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