[fdo-users] Number of geometry types in Oracle FeatureClass

hanko hana.jaborova at spatialtechnology.se
Thu Jun 10 02:57:56 EDT 2010


Hi,

I'm using OSGeo.KingOracle.3.5 provider.  
I wonder if it is possible to obtain information whitch  geometry types
exactly there is  in an Oracle FeatureClass and their number and, if it is
possible how?

Somenthig like:
select count(1) antal,t.MY_GEO_COLUMN.sdo_gtype from MY_TABLE t group by
t.MY_GEO_COLUMN.sdo_gtype;
or
select count(1)  from MY_TABLE t where t.MY_GEO_COLUMN.sdo_gtype in
(2001,3001,2005,3005); // Point, Multipoint

Thank in advance

Cheers 

Hanko 
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Number-of-geometry-types-in-Oracle-FeatureClass-tp5161882p5161882.html
Sent from the FDO Users mailing list archive at Nabble.com.


More information about the fdo-users mailing list