PROBLEM

Querying a spatial view in ArcGIS Desktop returns inconsistent results

Last Published: April 25, 2020

Description

Selecting or displaying records in ArcMap or ArcCatalog from a spatial view with one-to-many cardinality returns inconsistent results.Operations like Identify may only return the first related record, rather than all related records.

Cause

ArcGIS Desktop requires ObjectID values be unique per record. If a spatial view joins one record in the feature class to several records in another table (a one-to-many join), the ObjectID values are no longer unique per record. This is not supported in ArcGIS Desktop.

Solution or Workaround

Use a relationship class or a RELATE function to join the feature class with the associated attribute table in ArcGIS Desktop.

    Article ID:000010415

    Software:
    • ArcMap

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback