nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Referencing a Table to populate a field with missing information

LarryAdgate

I would really appreciate some help on this to help solve a long term problem in our office.

We have 114 feature classes where one of the fields is void of information or is wrong. We also have a very large table with the corrected information and there is commonality between the Feature class and the table. As a solution but very time consuming , I can joint the feature class and the table and using the field calculator transfer the information. Provided is an attachment to Illustrate what needs to happen.

Once again, thank You for your help on this,

Larry

Capture3.JPG

Screen Shot 2012-08-26 at 4.50.11 PM.png

CMT-PHI.jpg

Find more posts tagged with

Accepted answers

All comments

LarryAdgate

Hi Clinton,

Can you show me what a python dictionary would look like, a production set preferably , and is the data stored in a table?

ClintonDow1

No problem, I have had to create similar scripts in the past. Feel free to ask here if you run into any issues since I'm subscribed to this thread now

LarryAdgate

Thank You for your thoughts, at least now I have some ideas how to solve the problem.

Larry

ClintonDow1

Instead of using the field calculator, it should be possible to use cursors in a Python script.

A script could consume the table and your set of feature classes. First, use an arcpy.da.SearchCursor to read the values from the table into a Python dictionary (key of the unique identifier, value of the correct data). Once the dictionary is populated, loop through the set of feature classes, and for each fc create an arcpy.da.UpdateCursor.

After creating the UpdateCursor for a feature class, loop through the rows - for each row, using the unique identifier again, check against the dictionary containing the correct values. If the value in your UpdateCursor for that row doesn't match the correct data in the dictionary, replace the value in the row.

You're essentially 'joining' the UpdateCursor representing each feature class to the dictionary representing the table one at a time, then the field calculation is done one row at a time as you loop through the Cursor and check its value against the correct one in the dictionary. This should allow you to compare an arbitrary number of feature classes against the field with one run of the script (assuming there is some common unique ID per feature between them and the table).

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.