Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Spatial: calculate areas and number of polygon points

Oracle Spatial: calculate areas and number of polygon points

From: Robert Wehofer <wehofer_at_gisquadrat.com>
Date: Mon, 02 Dec 2002 14:21:54 GMT
Message-ID: <60KG9.239986$up.2374628@news.chello.at> 





Hello!



I've got Oracle 8i and I need a SQL statement for an Oracle Spatial
Relational Model, which is able to calculate the area and the number of
polygon points of each geometry object.



A result like this would be nice


SDO_GID  Area  NoPoints


 1     144.34    6



Has anyone an idea how define a proper SQL statement to solve my task?



Thanks in advance,


Robert
Received on Mon Dec 02 2002 - 08:21:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US