dbTalk Databases Forums  

Re: sdo_geom.sdo_area gives negative areas

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Re: sdo_geom.sdo_area gives negative areas in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Shakespeare
 
Posts: n/a

Default Re: sdo_geom.sdo_area gives negative areas - 05-09-2008 , 01:40 AM







"Jens Müller" <usenet-11-2007 (AT) tessarakt (DOT) de> schreef in bericht
news:68gehsF2sp00uU1 (AT) mid (DOT) individual.net...
Quote:
Hi,

I used the sdo_geom.sdo_area function on some polygons in my database.

The result is a negative number, the absolute value seems to be right.

At a first glance, I did not find anything on this in the docs. Is this
maybe due to a wrong direction (clockwise vs. counter-clockwise) of the
points?

If so, is this "bad" apart from the negative area values?
Yes, wrong direction is is bad. When your geometry is in the wrong
direction, it is a 'hole' or a 'donut'. You will encounter problems
calculating overlaps etc. About the negative area: I can't recall this has
anything to do with the direction. What tolerance do you use?

Shakespeare




Reply With Quote
  #2  
Old   
Shakespeare
 
Posts: n/a

Default Re: sdo_geom.sdo_area gives negative areas - 05-09-2008 , 01:40 AM







"Jens Müller" <usenet-11-2007 (AT) tessarakt (DOT) de> schreef in bericht
news:68gehsF2sp00uU1 (AT) mid (DOT) individual.net...
Quote:
Hi,

I used the sdo_geom.sdo_area function on some polygons in my database.

The result is a negative number, the absolute value seems to be right.

At a first glance, I did not find anything on this in the docs. Is this
maybe due to a wrong direction (clockwise vs. counter-clockwise) of the
points?

If so, is this "bad" apart from the negative area values?
Yes, wrong direction is is bad. When your geometry is in the wrong
direction, it is a 'hole' or a 'donut'. You will encounter problems
calculating overlaps etc. About the negative area: I can't recall this has
anything to do with the direction. What tolerance do you use?

Shakespeare




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.