How do you select attributes from multiple shapefiles at once

Discussion created by desshelmerdine on Jul 16, 2013
Latest reply on Feb 12, 2018 by hakan.kocaman
Hi, I was hoping that someone might be able to help me with a problem I'm having.  I'm using ArcGIS10.1 for Desktop with an ArcView license.

I have two point shapefile datasets (I've called them 'long' and 'short') of ship positions for the month.  Each shapefile has the same fields but different amount of data.  The fields are more complete in the long shapefile but this only has positional data for every 15 minutes.  The short shapefile has positional information every 3 minutes but with fewer of the fields complete.  I want to use the short shapefile as there are more points over time but I have found out that there is some missing data points in the short shapefile (database issues which I have no control over!) which are in the long shapefile.  My first thought was merging the data but this also incorporated points occupying the same spatial and temporal area (identical ships).  I also tried selecting by location but this threw up problems with two points occupying the same spatial location on different days (I need to keep this information).

So, my question is; is it possible to select by location and attribute at the same time and for two shapefiles?

I was thinking something along the lines of select when two points are within the same source layer feature and the shipnames are identical and the timstamps are identical.

Any help would be greatly appreciated.

Kind regards,