Home » Server Options » Spatial » query to find out whether it is point,line or polygon feature
query to find out whether it is point,line or polygon feature [message #488390] Fri, 07 January 2011 00:30 Go to next message
swapnabpnn
Messages: 96
Registered: December 2010
Member
Hi All,
I would like to write a query to find out which are all the tables in the database has point features,polygon and line feature.

Please help me out in writing the query.

Thanks............
Re: query to find out whether it is point,line or polygon feature [message #488524 is a reply to message #488390] Sat, 08 January 2011 13:24 Go to previous message
Barbara Boehmer
Messages: 8024
Registered: November 2002
Location: California, USA
Senior Member
You can query the sdo_gtype. The table at the following link lists what value corresponds to point, line, polygon, and so forth.

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/sdo_objrelschema.htm#g1013735
Previous Topic: Different WKB values
Next Topic: Spatial Question
Goto Forum:
  


Current Time: Thu Dec 18 17:50:59 CST 2014

Total time taken to generate the page: 0.10534 seconds