OraFAQ Forum: Spatial » query to find out whether it is point,line or polygon feature

Home » Server Options » Spatial » query to find out whether it is point,line or polygon feature

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query to find out whether it is point,line or polygon feature [message #488390]

Fri, 07 January 2011 00:30

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............

Report message to a moderator

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

Barbara Boehmer
Messages: 9105
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

Report message to a moderator

Previous Topic:	Different WKB values
Next Topic:	Spatial Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 14:23:47 CDT 2025