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