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; } } }

Dictionary issue

CCWeedcontrol

I have the following script and the issues I am having is that the PermitNum can have multiple Par (par field) numbers but my current script will only populate the Parel field with just one Par attribute, it doesn't transfer each parcel that corresponds with each permit number. How can I adjust my current code to transfer each parcel number?

fc_dest = "D:/Temp/Cases"

sourceFC = "D:/Temp/Casestableview"
  
#Use Dictionary to update fc fileds.
sourceFieldsList = ['PermitNum','Par','AppS','AppT', 'SubT','Desc', 'MainApp', 'PA', 'Status', 'AppStatus', 'DecDate',]#,'ProjectInfo', 'Contractor', 'Subdivision', 'TwnRngSec', 'LivingSpace', 'TotalSqFt', 'Value_', 'Valuation', 'Status']  
  
# Use list comprehension to build a dictionary from a da SearchCursor  
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}  

  
updateFieldsList = ['PermitNum','Par','AppS','AppT', 'SubT','Descr', 'MainApp', 'PA', 'Status', 'AppStatus', 'DecDate']  
  
with arcpy.da.UpdateCursor(fc_dest, updateFieldsList) as updateRows:  
    for updateRow in updateRows:  
        # store the Join value of the row being updated in a keyValue variable  
        keyValue = updateRow[0]  
        # verify that the keyValue is in the Dictionary  
        if keyValue in valueDict:  
            # transfer the values stored under the keyValue from the dictionary to the updated fields.  
            for n in range (1,len(sourceFieldsList)):  
                updateRow[n] = valueDict[keyValue][n-1]  
            updateRows.updateRow(updateRow) 
  
del valueDict

Book4 - Excel.png

Encontre mais publicações marcadas com

Accepted answers

All comments

DonMorrison1

True - but you need a unique value that allows you to link a record in the table with a record in the feature class. In database terminology it is a foreign key. It can't be PermitNum since there are duplicates, so it has to be PermitNum plus something else.

CCWeedcontrol

Jeffk, thank you very much for the help and my apologies for the corrupt data. I have attached new data and have verified that it should work.

I have changed the TablesView field name from 'Par' to 'Parcel_1' and the feature classes field name'Par' to 'Parcel' as it was getting confusing.

I have the following based on you provided but the 'Parcel' field is being populated in the Case_lyr feature class.

The valueDict prints- 'CR2021-0006R2957001100': 1, 'OR2021-0008R3014800000'

The concatenatedKey - prints CR2022-0001R3301700000
CR2022-0001R3301901000

sourceFC = "C:/Temp/Cases.gdb/Table_View"

valueDict = {}
with arcpy.da.SearchCursor(sourceFC, ['OBJECTID', 'PermitNum','Parcel_1']) as sCur:
    for row in sCur:
        # str(row[sCur.fields.index('AppS')]).replace('/', '') <- use this to convert the dates in the App fields to strings
        concatenatedKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Parcel_1')])
        if concatenatedKey in valueDict.keys():
            print(f'duplicate concatenation: {concatenatedKey}')
        else:
            valueDict[concatenatedKey] = row[sCur.fields.index('OBJECTID')]

fc_dest = "C:/Temp/Cases.gdb/Cases_lyr"

with arcpy.da.UpdateCursor(fc_dest, ['OBJECTID', 'PermitNum','Parcel']) as uCur:
    for row in uCur:
        if row[2] is None:
            lookupKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Parcel')])
            if lookupKey in valueDict.keys():
                print(f'{lookupKey} found, setting Par to: {valueDict.get(lookupKey)}')
                uCur.updateRow(row)

PermitsTestData1.zip

Anonymous User

It wont let me open the sample shapefile but it let me view the Permits_view so I built an example using its 3 fields. Same concept for the shapefile- you just have to find a combination of fields to create the 'key' in your dictionary. You can add more fields to the concatenation if needed/available until you get unique keys.

This is an image of the code at work so you can see the values in the dictionary:

valueDict = {}
with arcpy.da.SearchCursor(sourceFC, ['OBJECTID', 'PermitNum', 'Par']) as sCur:
    for row in sCur:
        # str(row[sCur.fields.index('AppS')]).replace('/', '') <- use this to convert the dates in the App fields to strings
        concatenatedKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Par')])
        if concatenatedKey in valueDict.keys():
            print(f'duplicate concatenation: {concatenatedKey}')
        else:
            valueDict[concatenatedKey] = row[sCur.fields.index('OBJECTID')]

Then once the 'source' dictionary is built, you concatenate the same fields in the target shapefile and use it to lookup the valuesDict.

with arcpy.da.UpdateCursor(sourceFC, ['OBJECTID', 'PermitNum', 'Par']) as uCur:
    for row in uCur:
        if row[2] is None:
            lookupKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Par')])
            if lookupKey in valueDict.keys():
                print(f'{lookupKey} found, setting Par to: {valueDict.get(lookupKey)}')
                uCur.updateRow(row)

CCWeedcontrol

Jeffk. Thank you for the reply. I would like to being all values but I didn't want to type them all out in my example. I guess I am not sure how to proceed with the construction of the code as I am not familiar with "keys" on how your example is showing them. Is there a complete example of the process you are describing?

Anonymous User

dicts in 3.7+ preserve the order now, but I see and think you can do it by creating a more unique key by concatenating the PermNum and Apps.

key = row[sCur.fields.index['PermNum']] + str(row[sCur.fields.index['app']]).replace('/','')

and then in your update cursor, if the Par is empty for the row combine the PermNum and App in the same manner to get the key.

edit to add example using cursor: (it's not tested but should provide a good starting point. I only assigned the Par as value since that is the field you are after, no purpose bringing over any of the others?)

valueDict = {}
with arcpy.da.SearchCursor(sourceFC, sourceFieldsList) as sCur:
    for row in sCur:
        valueDict[row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('AppS')]).replace('/', '')] = row[sCur.fields.index('Par')]

CCWeedcontrol

Below is what prints out.

valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} 

{'2021-0006': ('2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, None, '', None, 'address', 'Active', 'In Progress', None), '2021-0032': ('2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, 'Preliminary Plat', '', None, 'address', 'Active', 'In Progress', None,),


valueDict = {(r[0],r[1]): r for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}

{('2021-0006', '2957001100'): ('2021-0006', '2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, None, '', None, 'address', 'Active', 'In Progress', None), ('2021-0032', '2957001100'): ('2021-0032', '2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, 'Preliminary Plat', '', None, 'address', 'Active', 'In Progress', None),

Anonymous User

I think that @DonMorrison1 is right in that it is overwriting the key's values with data instead of appending it to a list for the key. Printing out the dictionary will give us a better idea of what to suggest for a fix. Starting with that and then seeing how the dictionary is structured would help determine the code needed for updating. If you find it is overwriting the values, you'll have to test for a keys existence and either set or append for each row's data in that SearchCursor to get that key: [item, item, item] structure.

CCWeedcontrol

ok, based on what you are describing I think that is my problem. I guess I am not sure how to iterating loop over the vale sets that match. Do you have an example?

CCWeedcontrol

PermitNum should be the unique identifier but as you can see PermitNum has duplicates because I don't have no other Unique Identifier.

Anonymous User

Based on your description your structure looks something like: { PermtNum : (Par, 'AppS','AppT', 'SubT','Descr', 'MainApp', 'PA', 'Status', 'AppStatus'), ...} ?

If it is only adding one, it is because it is stopping at the first matched key and using the first set of values. You need to have a loop iterating over the value sets of that matched key.

I find it helpful to print out the dictionary and paste some of it as a code comment so you can refer to it visually while you are coding. Give it a try-it also helps those troubleshooting with visualizing the data since we can't debug.

I'd also suggest using just row in your cursor so your not using the same name as the updateRow method.

updateRows.updateRow(updateRow)

DonMorrison1

I think your dict is being built with "PermitNum" as the key - and since that field is not unique the dictionary entry is being overwritten.

Just curious - in your "I need the following" graphic, how do you know which values to put in the 'Par' column? Since 'PermitNum' is not unique you must be using some other piece of information (I assumed it was the date field but it appears that is wrong).

CCWeedcontrol

I thought that's what line 9 was doing?

My unique identifers are PermtNum and Par fields, the Apps field is just a date field. Unless I am not understanding the dictionary correctly...?

valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}

DonMorrison1

You need to figure out how to uniquely identify each record and make that your dict key. From you example it looks like a combination of 'PermitNum' and 'Apps' is unique. In that case I would make my dict look like this:

valueDict = {(r[0],r[2]): r for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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