Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About CCWeedcontrol
CCWeedcontrol
Frequent Contributor
since
07-04-2014
09-10-2024
729
Posts created
154
Kudos given
4
Solutions
60
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by CCWeedcontrol
|
POST
|
I am not sure i follow, add MakeFeatureLayer_management (in_features, out_layer, "Field" > '') in between lines 20 & 21?
... View more
01-07-2016
11:47 AM
|
0
|
2
|
3056
|
|
POST
|
I need help setting up an if-than-else within a if-else statement. I need the code i need to check if selected features has any text inside the AddressID field if it does have any text inside the field i need it to by pass the with arcpy.da.SearchCursor and the with arcpy.da.UpdateCursor and move on to the next process. if doesn't have any text inside the field i need it to preform the with arcpy.da.SearchCursor and the with arcpy.da.UpdateCursor. I would appreciate any help. import arcpy, os from arcpy import env env.workspace = r"C:\temp\python\test.gdb" arcpy.env.qualifiedFieldNames = False arcpy.env.overwriteOutput = True BldSelection = "BuildingFootprints" Bld = arcpy.env.workspace + os.sep + "BuildingFootprints" #target point feature class BldCount = int(arcpy.GetCount_management(Bld).getOutput(0)) dsc = arcpy.Describe(BldSelection) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif BldCount >= 1: #Gets the highest AddressID and calculates new point to assign new highest AddressID Bld_list = [] with arcpy.da.SearchCursor(Bld, ["Bld_ID"]) as cursor: for row in cursor: try: if "Bld" in row[0]: Bld_list.append(int(row[0].strip("Bld"))) except TypeError: pass del cursor print Bld_list Bld_list.sort() Bld_ID = Bld_list[-1] + 1 with arcpy.da.UpdateCursor(BldSelection, "Bld_ID") as rows: for row in rows: row[0] = 'Bld' + str(Bld_ID) Bld_ID += 1 rows.updateRow(row) del row del rows
... View more
01-07-2016
11:11 AM
|
0
|
16
|
7027
|
|
POST
|
my apologies for not understand correctly. I have been trying to put a print statement for the values but i am not having much success. print set([u'CT'])
SiteStreet_1 StreetType_1
... View more
12-24-2015
08:46 AM
|
0
|
1
|
2016
|
|
POST
|
correct on line 62. my bad line 36 should be 'StreetType_1. After making the change and re-running the print out reads. the print out reads. set([u'Rd'])
... View more
12-23-2015
10:54 AM
|
0
|
3
|
2016
|
|
POST
|
I have the following code, the code runs without errors but the problem i am have is that i need to populate the "StreetName" field with two other fields, "SiteStreet" & "StreetType". So the "StreetName" Field would update with "Galloway Rd". Currently only the "SiteStreet" populates the "StreetName", the "StreetType" doesn't get added to the "StreetName" Field. I thought i had this working previously but i am having a hard time figuring out why it won't populate. Any ideas on what's going on? I have checked that the StreetType_1 field exists in the spatial join with the following field = 'StreetType'
values = [row[0] for row in arcpy.da.SearchCursor(sjpoints, (field))]
uniqueValues = set(values)
print(uniqueValues) the print out reads. set([u'Rd']) # Import arcpy module
import arcpy
from arcpy import env
# Allow overwrite
arcpy.env.overwriteOutput = True
# Script user input parameters
polygonLayer = "DSD.DBO.TaxParcels1" #Taxparcels
pointLayer = "TESTCCAP.DBO.CCAP1" #Point Layer
arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TESTCCAP (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)"
poly = "ACCOUNT_1"
Pnt = "Account"
sjpoints = "In_memory\sjpoints"
parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
dsc = arcpy.Describe(pointLayer)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
#Run the Spatial Join tool, using the defaults for the join operation and join type
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)
# define the field list from the spatial join
sourceFieldsList = ['TARGET_FID', poly,'SiteAddress','SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1', 'Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1','StreetType_1'] #,'StreetType_1'
# define the field list to the original points
updateFieldsList = ['OID@', Pnt,'SiteAddres', 'SiteNum', 'StreetName', 'SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName','StreetType'] #, 'StreetType'
field = 'StreetType'
values = [row[0] for row in arcpy.da.SearchCursor(sjpoints, (field))]
uniqueValues = set(values)
print(uniqueValues)
# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(arcpy.env.workspace)
# Edit session is started without an undo/redo stack for versioned data
# (for second argument, use False for unversioned data)
edit.startEditing(True)
# Start an edit operation
edit.startOperation()
manualFields = ['FacltyType','GIS_STEW', 'StructType', 'Verified', 'Status', 'StructCat', 'APA_CODE','StreetName'] #,'StreetName'
with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows:
for row in rows:
row[0] = ("Single Family Home")
row[1] = ("Canyon")
row[2] = ("Primary, Private")
row[3] = ("Yes, GRM, TA")
row[4] = ("Active")
row[5] = ("Residential")
row[6] = ("1110")
row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12])
rows.updateRow(row)
del row
del rows
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
updateRows.updateRow(updateRow)
del updateRows
del updateRow
#Update feature attributes to proper case
fields1 = ['StreetName', 'SiteStreet','SiteAddres','OwnerName','StreetType']
with arcpy.da.UpdateCursor(pointLayer, fields1) as cursor:
for row in cursor:
row[0] = row[0].title()
row[1] = row[1].title()
row[2] = row[2].title()
row[3] = row[3].title()
row[4] = row[4].title()
cursor.updateRow(row)
# Stop the edit operation.
edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
#arcpy.Delete_management(sjpoints)
... View more
12-23-2015
09:02 AM
|
1
|
5
|
4465
|
|
POST
|
The following code # Import arcpy module
import arcpy
from arcpy import env
# Allow overwrite
arcpy.env.overwriteOutput = True
# Script user input parameters
polygonLayer = "DSD.DBO.TaxParcels1" #Taxparcels
pointLayer = "CCAPTEST.DBO.CCAP5" #Point Layer
arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\CCAPTEST (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)"
poly = "ACCOUNT_1"
Pnt = "Account"
sjpoints = "In_memory\sjpoints"
parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
dsc = arcpy.Describe(pointLayer)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
#Run the Spatial Join tool, using the defaults for the join operation and join type
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)
# define the field list from the spatial join
sourceFieldsList = ['TARGET_FID', poly,'SiteAddress','SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1', 'Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1','StreetType_1'] #,'StreetType_1'
# define the field list to the original points
updateFieldsList = ['OID@', Pnt,'SiteAddres', 'SiteNum', 'StreetName', 'SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName','StreetType'] #, 'StreetType'
field = 'StreetType'
values = [row[0] for row in arcpy.da.SearchCursor(pointLayer, (field))]
uniqueValues = set(values)
print(uniqueValues)
# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(arcpy.env.workspace)
# Edit session is started without an undo/redo stack for versioned data
# (for second argument, use False for unversioned data)
edit.startEditing(True)
# Start an edit operation
edit.startOperation()
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
print("key value".format(keyValue))
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
print("key value".format(keyValue))
updateRows.updateRow(updateRow)
del updateRows
del updateRow
manualFields = ['FacltyType','GIS_STEW', 'StructType', 'Verified', 'Status', 'StructCat', 'APA_CODE','StreetName'] #,'StreetName'
with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows:
for row in rows:
row[0] = ("Single Family Home")
row[1] = ("Canyon")
row[2] = ("Primary, Private")
row[3] = ("Yes, GRM, TA")
row[4] = ("Active")
row[5] = ("Residential")
row[6] = ("1110")
row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12])
rows.updateRow(row)
del row
del rows
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
print("key value {}".format(keyValue))
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
updateRows.updateRow(updateRow)
del updateRows
del updateRow
#Update feature attributes to proper case
fields1 = ['StreetName', 'SiteStreet','SiteAddres','OwnerName','StreetName']
with arcpy.da.UpdateCursor(pointLayer, fields1) as cursor:
for row in cursor:
row[0] = row[0].title()
row[1] = row[1].title()
row[2] = row[2].title()
row[3] = row[3].title()
row[4] = row[4].title()
cursor.updateRow(row)
# Stop the edit operation.
edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
#arcpy.Delete_management(sjpoints)
Give me set([None])
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value 6408
6408 is the points features ObjectID that i have selected to update. After removing the spaces the code runs without an error but the only other issue is that the StreetName field is not being populated with line row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12]). So i guess i am still having issues with the StreetType except for the fact that it doesn't give an error?
... View more
12-22-2015
08:54 AM
|
0
|
1
|
3218
|
|
POST
|
Looks like the problem was that the tax parcels "StreetType" field had 5 spaces after the text (Rd). by putting in the print statement. field = 'StreetType'
values = [row[0] for row in arcpy.da.SearchCursor(pointLayer, (field))]
uniqueValues = set(values)
print(uniqueValues) it printed set([u'RD ']) After removing the spaces the code runs without an error but the only other issue is that the StreetName field is not being populated with line row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12])
... View more
12-22-2015
08:49 AM
|
1
|
0
|
3218
|
|
POST
|
Ya i knew it wasn't clean, been messing with it for a bit. i cleaned her up. Still not able to get past the Invalid column value [StreetType] Thanks.
... View more
12-22-2015
07:57 AM
|
0
|
4
|
3218
|
|
POST
|
To try to narrow it down i scaled the code down just to the spatial join. I ran the following code and got this. set([u'RD '])
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
key value
Runtime error
Traceback (most recent call last):
File "<string>", line 69, in <module>
RuntimeError: Invalid column value [StreetType]
Code: # Import arcpy module
import arcpy
from arcpy import env
# Allow overwrite
arcpy.env.overwriteOutput = True
# Script user input parameters
polygonLayer = "DSD.DBO.TaxParcels1" #Taxparcels
pointLayer = "CCAPTEST.DBO.CCAP5" #Point Layer
arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\CCAPTEST (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)"
poly = "ACCOUNT_1"
Pnt = "Account"
sjpoints = "In_memory\sjpoints"
parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
dsc = arcpy.Describe(pointLayer)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
#Run the Spatial Join tool, using the defaults for the join operation and join type
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)
# define the field list from the spatial join
sourceFieldsList = ['TARGET_FID', poly,'SiteAddress','SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1', 'Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1','StreetType_1'] #,'StreetType_1'
# define the field list to the original points
updateFieldsList = ['OID@', Pnt,'SiteAddres', 'SiteNum', 'StreetName', 'SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName','StreetType'] #, 'StreetType'
field = 'StreetType'
values = [row[0] for row in arcpy.da.SearchCursor(pointLayer, (field))]
uniqueValues = set(values)
print(uniqueValues)
# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(arcpy.env.workspace)
# Edit session is started without an undo/redo stack for versioned data
# (for second argument, use False for unversioned data)
edit.startEditing(True)
# Start an edit operation
edit.startOperation()
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
print("key value".format(keyValue))
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
print("key value".format(keyValue))
updateRows.updateRow(updateRow)
del updateRows
del updateRow
# Stop the edit operation.
#edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
#arcpy.Delete_management(sjpoints)
... View more
12-22-2015
07:56 AM
|
0
|
0
|
3218
|
|
POST
|
I get the following error Runtime error Traceback (most recent call last): File "<string>", line 74, in <module> SystemError: error return without exception set With the following code I also attached some data in case anyone wants to look at it. # Import arcpy module
import arcpy
from arcpy import env
# Allow overwrite
arcpy.env.overwriteOutput = True
# Script user input parameters
polygonLayer = "DSD.DBO.TaxParcels1" #Taxparcels
pointLayer = "CCAPTEST.DBO.CCAP5" #Point Layer
arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\CCAPTEST (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)"
poly = "ACCOUNT_1"
Pnt = "Account"
sjpoints = "In_memory\sjpoints"
parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
dsc = arcpy.Describe(pointLayer)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
#Run the Spatial Join tool, using the defaults for the join operation and join type
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)
# define the field list from the spatial join
sourceFieldsList = ["TARGET_FID", poly,"SiteAddress",'SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1','Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1', 'StreetType_1'] #,'StreetType_1'
# define the field list to the original points
updateFieldsList = ["OID@", Pnt,"SiteAddres", 'SiteNum', 'StreetName','SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName', 'StreetType'] #, 'StreetType'
# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(arcpy.env.workspace)
# Edit session is started without an undo/redo stack for versioned data
# (for second argument, use False for unversioned data)
edit.startEditing(True)
# Start an edit operation
edit.startOperation()
manualFields = ["FacltyType","GIS_STEW", "StructType", "Verified", "Status", "StructCat", "APA_CODE",'StreetName'] #,'StreetName'
with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows:
for row in rows:
row[0] = ("Single Family Home")
row[1] = ("Canyon")
row[2] = ("Primary, Private")
row[3] = ("Yes, GRM, TA")
row[4] = ("Active")
row[5] = ("Residential")
row[6] = ("1110")
row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12])
rows.updateRow(row)
del row
del rows
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
updateRows.updateRow(updateRow)
del updateRows
del updateRow
# Stop the edit operation.
edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
#arcpy.Delete_management(sjpoints)
... View more
12-21-2015
03:50 PM
|
0
|
8
|
3218
|
|
POST
|
I have never been able to get Editor to work without commenting out commenting out the stopOperation.
... View more
12-21-2015
11:44 AM
|
0
|
10
|
3218
|
|
POST
|
Thanks for the replay, i have looked at the through the filed and they are populated with "Ave", "Rd" etc... there are blank/nulls attributes as well. I do see "NULL" and ' ' in some of the attributes. If i replace all the "Null" with " " the code doesn't populate any fields but if i replace all the ' ' with "NULL" the field "StreetName" gets populated but only with the SiteStreet_1. So i am thinking this row[7] = (updateFieldsList[4] + " " + updateFieldsList[12]) is the problem, some how it's not concatenating both fields together. I have been trying to incorporate the print statements but have been unsuccessful.
... View more
12-21-2015
10:26 AM
|
0
|
0
|
5378
|
|
POST
|
It is string(length 4), I have tried adding the print but i am getting this error at for row in cursor: error RuntimeError: Invalid column value [StreetType] #Update feature attributes to proper case
fields1 = ["StreetName", "SiteStreet","SiteAddres","OwnerName","StreetType"]#,'StreetType'
with arcpy.da.UpdateCursor(pointLayer, fields1) as cursor:
for row in cursor:
print row[4]
row[0] = row[0].title()
row[1] = row[1].title()
row[2] = row[2].title()
row[3] = row[3].title()
row[4] = row[4].title()
cursor.updateRow(row) I also tried adding the arcpy.da.SearchCursor before the arcpy.da.UpdateCursor and was given the same error. # Import arcpy module
import arcpy
from arcpy import env
# Allow overwrite
arcpy.env.overwriteOutput = True
# Script user input parameters
polygonLayer = "DSD.DBO.TaxParcels1" #Taxparcels
pointLayer = "CCAPTEST.DBO.CCAP8" #Point Layer
arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\CCAPTEST (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)"
poly = "ACCOUNT_1"
Pnt = "Account"
sjpoints = "In_memory\sjpoints"
parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
dsc = arcpy.Describe(pointLayer)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
#Run the Spatial Join tool, using the defaults for the join operation and join type
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)
# define the field list from the spatial join
sourceFieldsList = ["TARGET_FID", poly,"SiteAddress",'SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1','Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1', 'StreetType_1'] #,'StreetType_1'
# define the field list to the original points
updateFieldsList = ["OID@", Pnt,"SiteAddres", 'SiteNum', 'StreetName','SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName', 'StreetType'] #, 'StreetType'
# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(arcpy.env.workspace)
# Edit session is started without an undo/redo stack for versioned data
# (for second argument, use False for unversioned data)
edit.startEditing(True)
# Start an edit operation
edit.startOperation()
manualFields = ["FacltyType","GIS_STEW", "StructType", "Verified", "Status", "StructCat", "APA_CODE",'StreetName'] #,'StreetName'
with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows:
for row in rows:
row[0] = ("Single Family Home")
row[1] = ("Canyon")
row[2] = ("Primary, Private")
row[3] = ("Yes, GRM, TA")
row[4] = ("Active")
row[5] = ("Residential")
row[6] = ("1110")
row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12])
rows.updateRow(row)
del row
del rows
# populate the dictionary from the polygon
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}
with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:
for updateRow in updateRows:
keyValue = updateRow[0]
if keyValue in valueDict:
for n in range (1,len(sourceFieldsList)):
updateRow = valueDict[keyValue][n-1]
updateRows.updateRow(updateRow)
del updateRows
del updateRow
fields1a = ["StreetName", "SiteStreet","SiteAddres","OwnerName","StreetType"]#,'StreetType'
with arcpy.da.SearchCursor(pointLayer, fields1a) as cursor:
for row in cursor:
print row[4]
# Stop the edit operation.
#edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
#arcpy.Delete_management(sjpoints)
Runtime error Traceback (most recent call last): File "<string>", line 82, in <module> RuntimeError: Invalid column value [StreetType] Am i adding the 'print' correctly?
... View more
12-18-2015
01:46 PM
|
0
|
2
|
5378
|
|
POST
|
oh ya that would be helpful, my bad Error Runtime error Traceback (most recent call last): File "<string>", line 76, in <module> RuntimeError: Invalid column value [StreetType] After i get the error i also get ArcMap Drawing Errors: CCAPTEST.DBO.CCAP8: Invalid column value [StreetType]
... View more
12-18-2015
10:16 AM
|
0
|
4
|
5378
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-27-2022 11:37 AM | |
| 1 | 10-31-2023 10:16 AM | |
| 1 | 02-16-2023 01:50 PM | |
| 1 | 08-11-2021 11:13 AM | |
| 1 | 01-06-2021 10:45 AM |
Activity Feed
- Posted Re: Creating line segments on Python Questions. 08-07-2024 03:17 PM
- Posted Re: Creating line segments on Python Questions. 08-06-2024 02:14 PM
- Posted Creating line segments on Python Questions. 08-06-2024 11:15 AM
- Got a Kudo for Re: Model Builder Schedule Not Working. 03-27-2024 09:55 AM
- Posted Re: Select by location, have their center in on ArcGIS Pro Questions. 01-17-2024 01:49 PM
- Posted Select by location, have their center in on ArcGIS Pro Questions. 01-16-2024 03:48 PM
- Posted Re: Join one to many issue on Python Questions. 01-11-2024 04:02 PM
- Kudoed Re: Remove prefixes for MErikReedAugusta. 01-09-2024 08:01 AM
- Kudoed Re: Remove prefixes for JoshuaBixby. 01-09-2024 08:01 AM
- Posted Re: Join one to many issue on Python Questions. 01-09-2024 08:00 AM
- Posted Re: Join one to many issue on Python Questions. 01-08-2024 02:55 PM
- Posted Join one to many issue on Python Questions. 01-08-2024 02:42 PM
- Kudoed Re: how to get the hightlighted layers in TOC ? for StaticK. 11-08-2023 10:30 AM
- Got a Kudo for Re: Make feature layer from selected features. 11-03-2023 10:13 AM
- Posted Re: Make feature layer from selected features on Python Questions. 10-31-2023 10:16 AM
- Kudoed Re: Make feature layer from selected features for HaydenWelch. 10-31-2023 10:16 AM
- Posted Make feature layer from selected features on Python Questions. 10-25-2023 03:28 PM
- Posted Select features by attribute, IS NOT NULL on Python Questions. 07-17-2023 03:15 PM
- Posted Re: Create feature class in project folder directory on Python Questions. 06-15-2023 08:31 AM
- Posted Re: Create feature class in project folder directory on Python Questions. 06-14-2023 11:58 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
09-10-2024
10:42 AM
|