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: 9077
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 Mar 28 09:26:00 CDT 2024