Re: What does it mean ?

The documentation for SDO_UTIL.BEARING_TILT_FOR_POINTS is here: http://docs.oracle.com/database/121/SPATL/sdo_util.htm#SPATL1222

For the output values it states:

bearing

Number of radians, measured clockwise from North. tilt

Number of radians, measured from the normal.

Radians are another way of measuring degrees of a circle: http://en.wikipedia.org/wiki/Radian

Where you might measure degrees as 0 to 360 degrees, radians for the same would be 0 to 2 * π.

So your bearing values:

0 = 0 degrees = North

0.5 * π = 90 degrees = East
1.0 * π = 180 degrees = South
1.5 * π = 270 degrees = West

So if you are more comfortable measuring bearing and tilt in degrees instead of radians, you can just do degrees = radians * 180 / π

Hope that helps :-)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Thu, Mar 19, 2015 at 3:12 AM, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:

> Hi,
>
> I have a doubt related this resource.
> I got this code and would like to know what does it mean ?
> The coords -49, -12 are the same in four blocks,
> I changed others, that are in the north, south , east and west of the
> coord -49, -12.
>
> How to analize the result ?
> What are the numbers in the result ?
>
>
> DECLARE
> bearing NUMBER;
> tilt NUMBER;
> BEGIN
> SDO_UTIL.BEARING_TILT_FOR_POINTS(
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -12, 0), NULL, NULL), -- start_point
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -4, 5000), NULL, NULL), -- end_point
> 0.05, --tolerance
> bearing,
> tilt);
> DBMS_OUTPUT.PUT_LINE('Bearing = ' || bearing);
> DBMS_OUTPUT.PUT_LINE('Tilt = ' || tilt);
> END;
> /
> Bearing = .000000000000000798346493672419
> Tilt = .005651061152948927719815920474808513661231
>
>
>
> DECLARE
> bearing NUMBER;
> tilt NUMBER;
> BEGIN
> SDO_UTIL.BEARING_TILT_FOR_POINTS(
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -12, 0), NULL, NULL), -- start_point
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -24, 5000), NULL, NULL), -- end_point
> 0.05, --tolerance
> bearing,
> tilt);
> DBMS_OUTPUT.PUT_LINE('Bearing = ' || bearing);
> DBMS_OUTPUT.PUT_LINE('Tilt = ' || tilt);
> END;
> /
> Bearing = 3.14159265358979
> Tilt = .003764463662853474911130313640967686694478
>
>
> DECLARE
> bearing NUMBER;
> tilt NUMBER;
> BEGIN
> SDO_UTIL.BEARING_TILT_FOR_POINTS(
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -12, 0), NULL, NULL), -- start_point
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-59, -12, 5000), NULL, NULL), -- end_point
> 0.05, --tolerance
> bearing,
> tilt);
> DBMS_OUTPUT.PUT_LINE('Bearing = ' || bearing);
> DBMS_OUTPUT.PUT_LINE('Tilt = ' || tilt);
> END;
> /
> Bearing = 4.69420078448763
> Tilt = .004591476845011205890864575078291479016976
>
>
> DECLARE
> bearing NUMBER;
> tilt NUMBER;
> BEGIN
> SDO_UTIL.BEARING_TILT_FOR_POINTS(
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-49, -12, 0), NULL, NULL), -- start_point
> SDO_GEOMETRY(2001, 8307,
> SDO_POINT_TYPE(-41, -11, 5000), NULL, NULL), -- end_point
> 0.05, --tolerance
> bearing,
> tilt);
> DBMS_OUTPUT.PUT_LINE('Bearing = ' || bearing);
> DBMS_OUTPUT.PUT_LINE('Tilt = ' || tilt);
> END;
> /
> Bearing = 1.45887432965594
> Tilt = .005683464806961181817171102451150621779018
>
> Regards
> Eriovaldo
>
>

--
http://www.freelists.org/webpage/oracle-l