Workflows - Relating a Featureset of a non-ssptial database to a Spatial Layer

Permanently deleted user

March 13, 2019 19:35

Hello,

 

I am trying to relate a selected set (FeatureSet) of records from a sql query in a non-spatial database to a spatial layer that has a common key. I am trying to do this using the ArcGIs Server tool "Relationship Query Task" but there doesn't sem to be an incorporation of a non-spatial table into builfing the 1:1 realtionship using this tool. Is there another way to do this in workflows? Or is there something I'm missing in the Relationship Query Task tool? Thanks! 

0

• 

  Berend Veldkamp

  March 19, 2019 14:22

  The Relationship Query Task can only be used if both source and destination tables are served through an ArcGIS MapService (or FeatureService). The underlying SDE database should have relationshipclasses defined for those tables. If that is what you have, you should use a QueryTask to get records from the source table, and pass the featureset's ObjectIDs to the RelationshipQueryTask.

   

  If you do not have a relationshipclass, or one of the tables is not served in an ArcGIS Service, you can still use a QueryTask or SQL Query to 'manually' query the destination table, e.g. use 'OBJECTID IN (1,2,3)' in the QueryTask's Where clause.

  0

Please sign in to leave a comment.