Spatial View help needed

[SteveMacLean]

Hi everyone,

I have a feature class that I want to join to a database view that contains related business data for the features on the map. I want to expose this join as a feature service and dynamic map service in ArcGIS Server.

I have tried creating a query layer based on a database view I created that joins the featureclass with the business table. This seems to work fine in ArcMAP, however, when I expose the new feature in ArcGIS Server it doesn't seem to work. I can add the new ArcGIS Server service to the map and it will display the features but when I do an identify on the features it doesn't come back with any data. Additionally, when I try and utilize the new service in the ArcGIS Server Javascript API as a feature class it doesn't load any data at all. It works fine when i access the web service that is hitting the raw feature class but not with the query layer.

I have also tried creating a MXD that does a regular JOIN to the business table. However, doing it this way does not expose the attributes that should be included from the join.

There must be a way to do this and link to business tables to spatial tables.


I am using Oracle 11g Enterprise and ArcGIS Sever 10.2

Any help would be appreciated.

[JeffPace]

nliu is correct, you need to be able to identify in ArcMAP.  I just tested my spatial view and it identifies fine in arcmap

You should be doing a spatial view, or a query layer, but not both.

[SteveMacLean]

I was able to create the spatial view using the sdetable -o create_view command.   Everything works fine including the identify.  I was not able to create the view like they recommend in 10.2 using the standard Oracle create view command and include objectid, and the shape.  When you bring the feature into ArcMAP doing it that way it automatically creates a query layer.  Using SDETable everything works perfectly.

Thanks everyone for your help.

Steve

[JeffPace]

I really hope someone from esri seems this.

This is exactly what I have been very vocal about them NOT taking away our commandline tools for SDE.  Query layers just dont have the complete functionality we need yet.

Glad you got it working

-Jeff