[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