Data is missing in the layer output from a join by location (spatial join)

Last Published: April 25, 2020


This problem is addressed in ArcGIS 8.1 Service Pack 1. See the Related Information section to download this pack.

When performing a join by location, only some of the features that should be in the output are added to the output layer.


This is caused when there are empty shapes in the layers involved in the join. Empty shapes can be common in layers created from route event sources.

Solution or Workaround

If possible, find the records with the empty shapes and remove them. Another option is to export to a new layer without the empty shapes.

You can use the select features tool to select records with nonempty shapes. To do this, drag a rectangle over all features in the layer. Only the nonempty features are selected.

Article ID:000003943

  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options