Query Layers

521
2
05-24-2013 12:16 PM
Highlighted
New Contributor II
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?
Reply
0 Kudos
2 Replies
Highlighted
New Contributor II
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.
Reply
0 Kudos
Highlighted
by Anonymous User
Not applicable
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
Reply
0 Kudos