Arcmap 10.7 and RFID Reads.

01-13-2020 02:48 PM
New Contributor

I am trying to learn if there is a tool that could be used to auto-populate an attribute table field based off of location and readings. The master attribute table is garbage totes. Within that table is customer info, latitude, longitude, etc. What I am looking to fill is the RFID Reads column. To fill that column, I have a list of RFID Reads based off of GPS location, time of day and day. What I wish to know is if there is a tool that would compare my manually typed garbage tote table to the uploaded RFID Read list. Also, these RFID Reads are based off of truck readings from WISTAR ONE. There is  about 1600 totes currently issued. Thanks!!

First Image is a sample table of a single day of RFID Reads.

Second Image is master data table.

1 Reply
by Esri Contributor
Esri Contributor

You could use ArcMap or ArcGIS Pro to perform a join on the two datasets. Through a common field, known as a key, you can associate records in one table with records in another table. The result is temporary, but can be exported and made permanent.

Overview of Joins & Relates

Is that close to what you were asking?

If you need this to be done on the fly with a mobile device, you would share the data to ArcGIS Online and set up related tables.

0 Kudos