Vjylku

What information about me do stores get via my credit card?

The variadic template constructor of my class cannot modify my class members, why is that so?

Can smartphones with the same camera sensor have different image quality?

Road tyres vs "Street" tyres for charity ride on MTB Tandem

What's the point in a preamp?

How does ice melt when immersed in water?

What do you call a plan that's an alternative plan in case your initial plan fails?

Is there a writing software that you can sort scenes like slides in PowerPoint?

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

Did God make two great lights or did He make the great light two?

Mortgage adviser recommends a longer term than necessary combined with overpayments

rotate text in posterbox

Why does the Event Horizon Telescope (EHT) not include telescopes from Africa, Asia or Australia?

How can I define good in a religion that claims no moral authority?

When did F become S in typeography, and why?

Is there a trick to getting spices to fix to nuts?

Can a novice safely splice in wire to lengthen 5V charging cable?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

What LEGO pieces have "real-world" functionality?

Make it rain characters

Can a 1st-level character have an ability score above 18?

Wall plug outlet change

Did the new image of black hole confirm the general theory of relativity?

Can the prologue be the backstory of your main character?

Implementing an UpdateCursor?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I am writing a script assigning the ADMINAREA value to the empty LOCALITY fields from TWB_Suburbs to TWB_Property layer. I am getting:

ValueError: need more than 1 value to unpack

Is anyone able to help out?

import arcpy

# set overwrite true so that if data already exists it overwrite

arcpy.env.OVERWRITE = True

arcpy.env.overwriteOutput = True



# make query for empty LOCALITY values

query = '"LOCALITY" = ' ''



# assign workspace

arcpy.env.workspace = "C:Usersdata"



# make feature layer from property shape file, apply empty locality values query

arcpy.MakeFeatureLayer_management("TWB_Property.shp", "TWB_Property_Layer", query)



# make feature layer for suburbs shape file

arcpy.MakeFeatureLayer_management("TWB_Suburbs.shp", "TWB_Suburbs_Layer")



# Select empty properties in Properties layer WITHIN Suburbs layer

arcpy.SelectLayerByLocation_management ("TWB_Property_Layer", "WITHIN", "TWB_Suburbs_Layer")



#create empty list

suburbList = []



# iterate over admin layer field values, to get it's value

with arcpy.da.SearchCursor("TWB_Suburbs_Layer",["ADMINAREA"]) as rows:

    for row in rows:

        suburbList.append(row[0])

        print (row[0])



#get the number of selected land parcels

numberSuburbs = len(suburbList)



print(row[0])



# Create Update Cursor to update missing LOCALITY fields in property layer

for parcel in range (0, numberSuburbs):        

    with arcpy.da.UpdateCursor("TWB_Property_Layer", "LOCALITY") as initialRows:

        for initialRow, rowTwo in initialRows:

                print(initialRow)

                print(rowTwo[0])

                rowTwo[0] = row[0]

                initialRows.updateRow(initialRow)



# Print number of fields updated for each suburb           

    print ('Suburb, Number of updated properties' .format(row[0], row[1]))

    print ("{row}" + str(numberSuburbs) +

           .format(row[0], row[1]))



    #report success message

    arcpy.AddMessage("Well done!")

cursor update

share

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

add a comment | 

0

I am writing a script assigning the ADMINAREA value to the empty LOCALITY fields from TWB_Suburbs to TWB_Property layer. I am getting:

ValueError: need more than 1 value to unpack

Is anyone able to help out?

import arcpy

# set overwrite true so that if data already exists it overwrite

arcpy.env.OVERWRITE = True

arcpy.env.overwriteOutput = True



# make query for empty LOCALITY values

query = '"LOCALITY" = ' ''



# assign workspace

arcpy.env.workspace = "C:Usersdata"



# make feature layer from property shape file, apply empty locality values query

arcpy.MakeFeatureLayer_management("TWB_Property.shp", "TWB_Property_Layer", query)



# make feature layer for suburbs shape file

arcpy.MakeFeatureLayer_management("TWB_Suburbs.shp", "TWB_Suburbs_Layer")



# Select empty properties in Properties layer WITHIN Suburbs layer

arcpy.SelectLayerByLocation_management ("TWB_Property_Layer", "WITHIN", "TWB_Suburbs_Layer")



#create empty list

suburbList = []



# iterate over admin layer field values, to get it's value

with arcpy.da.SearchCursor("TWB_Suburbs_Layer",["ADMINAREA"]) as rows:

    for row in rows:

        suburbList.append(row[0])

        print (row[0])



#get the number of selected land parcels

numberSuburbs = len(suburbList)



print(row[0])



# Create Update Cursor to update missing LOCALITY fields in property layer

for parcel in range (0, numberSuburbs):        

    with arcpy.da.UpdateCursor("TWB_Property_Layer", "LOCALITY") as initialRows:

        for initialRow, rowTwo in initialRows:

                print(initialRow)

                print(rowTwo[0])

                rowTwo[0] = row[0]

                initialRows.updateRow(initialRow)



# Print number of fields updated for each suburb           

    print ('Suburb, Number of updated properties' .format(row[0], row[1]))

    print ("{row}" + str(numberSuburbs) +

           .format(row[0], row[1]))



    #report success message

    arcpy.AddMessage("Well done!")

cursor update

share

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

add a comment | 

I am writing a script assigning the ADMINAREA value to the empty LOCALITY fields from TWB_Suburbs to TWB_Property layer. I am getting:

ValueError: need more than 1 value to unpack

Is anyone able to help out?

import arcpy

# set overwrite true so that if data already exists it overwrite

arcpy.env.OVERWRITE = True

arcpy.env.overwriteOutput = True



# make query for empty LOCALITY values

query = '"LOCALITY" = ' ''



# assign workspace

arcpy.env.workspace = "C:Usersdata"



# make feature layer from property shape file, apply empty locality values query

arcpy.MakeFeatureLayer_management("TWB_Property.shp", "TWB_Property_Layer", query)



# make feature layer for suburbs shape file

arcpy.MakeFeatureLayer_management("TWB_Suburbs.shp", "TWB_Suburbs_Layer")



# Select empty properties in Properties layer WITHIN Suburbs layer

arcpy.SelectLayerByLocation_management ("TWB_Property_Layer", "WITHIN", "TWB_Suburbs_Layer")



#create empty list

suburbList = []



# iterate over admin layer field values, to get it's value

with arcpy.da.SearchCursor("TWB_Suburbs_Layer",["ADMINAREA"]) as rows:

    for row in rows:

        suburbList.append(row[0])

        print (row[0])



#get the number of selected land parcels

numberSuburbs = len(suburbList)



print(row[0])



# Create Update Cursor to update missing LOCALITY fields in property layer

for parcel in range (0, numberSuburbs):        

    with arcpy.da.UpdateCursor("TWB_Property_Layer", "LOCALITY") as initialRows:

        for initialRow, rowTwo in initialRows:

                print(initialRow)

                print(rowTwo[0])

                rowTwo[0] = row[0]

                initialRows.updateRow(initialRow)



# Print number of fields updated for each suburb           

    print ('Suburb, Number of updated properties' .format(row[0], row[1]))

    print ("{row}" + str(numberSuburbs) +

           .format(row[0], row[1]))



    #report success message

    arcpy.AddMessage("Well done!")

cursor update

share

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

import arcpy

# set overwrite true so that if data already exists it overwrite

arcpy.env.OVERWRITE = True

arcpy.env.overwriteOutput = True



# make query for empty LOCALITY values

query = '"LOCALITY" = ' ''



# assign workspace

arcpy.env.workspace = "C:Usersdata"



# make feature layer from property shape file, apply empty locality values query

arcpy.MakeFeatureLayer_management("TWB_Property.shp", "TWB_Property_Layer", query)



# make feature layer for suburbs shape file

arcpy.MakeFeatureLayer_management("TWB_Suburbs.shp", "TWB_Suburbs_Layer")



# Select empty properties in Properties layer WITHIN Suburbs layer

arcpy.SelectLayerByLocation_management ("TWB_Property_Layer", "WITHIN", "TWB_Suburbs_Layer")



#create empty list

suburbList = []



# iterate over admin layer field values, to get it's value

with arcpy.da.SearchCursor("TWB_Suburbs_Layer",["ADMINAREA"]) as rows:

    for row in rows:

        suburbList.append(row[0])

        print (row[0])



#get the number of selected land parcels

numberSuburbs = len(suburbList)



print(row[0])



# Create Update Cursor to update missing LOCALITY fields in property layer

for parcel in range (0, numberSuburbs):        

    with arcpy.da.UpdateCursor("TWB_Property_Layer", "LOCALITY") as initialRows:

        for initialRow, rowTwo in initialRows:

                print(initialRow)

                print(rowTwo[0])

                rowTwo[0] = row[0]

                initialRows.updateRow(initialRow)



# Print number of fields updated for each suburb           

    print ('Suburb, Number of updated properties' .format(row[0], row[1]))

    print ("{row}" + str(numberSuburbs) +

           .format(row[0], row[1]))



    #report success message

    arcpy.AddMessage("Well done!")

share

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

share

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

edited 1 min ago

PolyGeo♦

53.9k1782246

edited 1 min ago

PolyGeo♦

53.9k1782246

asked 9 mins ago

Alex HunterAlex Hunter

193

asked 9 mins ago

Alex HunterAlex Hunter

193