Query Layers

[LoganCaraway]

I have gone through the process and have validated my SQL for my query layer.  However it produces a standalone table. This does not work for me as i need a layer. It is my understanding that it produces a table when geometry and geography fields are missing from a table. The table in which im querying from resides on sde and is able to be drawn in arcmap. It has an ObjectID and a Shape(geometry) field. Do I need to configure anything else in order to get it to produce a a query layer and not a table?

[LoganCaraway]

Furthermore...

when I look at advanced options, everything is grayed out, I suppose this means it cannot find the spatial properties such as shape type, Spatial Reference, Geometry SRID, etc... This puzzles me as i would have assumed that since it is an sde feature class it would have those parameters included.

[Anonymous User]

Original User: vangelo

We're probably going to need more information to help you:

• What version of ArcGIS are you using?  What service pack?


• What database are you using (complete version).


• What does 'sdetable -o describe' (and/or a native SQL 'describe') report

on the table(s) involved?

• What does 'sdelayer -o describe_long' report on the geometry table(s)

A "query layer" isn't a table, it's a query against a table.  In order to be seen
as having a geometry column, the query must include a native or ST_GEOMETRY
column and a rowid (objectid).  It is not possible to create query layers against
SDEBINARY or SDELOB storage layers.

- V