topic Query Layers in Data Management Questions

Query Layers

LoganCaraway — Fri, 24 May 2013 19:16:40 GMT

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?

Re: Query Layers

LoganCaraway — Fri, 24 May 2013 19:41:46 GMT

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.

Re: Query Layers

Anonymous User — Fri, 24 May 2013 19:57:49 GMT

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

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