POST
|
That is what i thought you meant but just making sure. having nothing selected i still get the error "Runtime error Traceback (most recent call last): File "<string>", line 18, in <module> NameError: name 'rows' is not defined" import arcpy
#populate selected feature
APT = "TEST"
fc1 = "CCAP"
workspace = r"C:\GIS\CCAP\CCAP.mdb"
arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
rows = arcpy.UpdateCursor(APT)
for row in rows:
if int(arcpy.GetCount_management(APT).getOutput(0)) > 0:
row.FacltyType = ("Single Family Home")
row.StructType = ("Primary, Private")
row.Verified = ("Yes, GRM, TA")
row.Status = ("Active")
row.StructCat = ("Residential")
row.APA_CODE = ("1110")
rows.updateRow(row)
arcpy.Append_management(APT, fc1, "NO_TEST")
del row, rows
elif int(arcpy.GetCount_management(APT).getOutput(0)) == 0:
print "There are no features selected"
Am i not doing something correct? Am i going about this the best way?
... View more
06-12-2015
01:54 PM
|
0
|
3
|
1029
|
POST
|
after adjusting the indents and when nothing is select and run the code i get the following error on line 18 Runtime error Traceback (most recent call last): File "<string>", line 18, in <module> NameError: name 'rows' is not defined import arcpy
#populate selected feature
APT = "TEST"
fc1 = "CCAP"
workspace = r"C:\GIS\CCAP\CCAP.mdb"
arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
if int(arcpy.GetCount_management(APT).getOutput(0)) > 0:
rows = arcpy.UpdateCursor(APT)
for row in rows:
row.FacltyType = ("Single Family Home")
row.StructType = ("Primary, Private")
row.Verified = ("Yes, GRM, TA")
row.Status = ("Active")
row.StructCat = ("Residential")
row.APA_CODE = ("1110")
rows.updateRow(row)
arcpy.Append_management(APT, fc1, "NO_TEST")
del row, rows
elif int(arcpy.GetCount_management(APT).getOutput(0)) == 0:
print "There are no features selected"
With a point selected i don't get any error. The "TEST" point that is selected does the fields updated but nothing is copied to the "CCAP" feature class.
... View more
06-12-2015
11:41 AM
|
0
|
7
|
1029
|
POST
|
I am getting an error on elif int(arcpy.GetCount_management(APT).getOutput(0)) == 0: Parsing error SyntaxError: invalid syntax (line 21)
... View more
06-12-2015
09:41 AM
|
0
|
9
|
1029
|
POST
|
I am working on creating a addon button to update some address points and copy that updated feature. The first part of the code does what it is suppose to do (only update the selected feature) but the second part of the code doesn't do what it is suppose to do and that is copy "only" the selected feature to the file geodatbase feature class. The code runs fine i don't get any errors but the second part of the codes doesn't copy the selected feature. I would also like to an an "if" statement. if there is no feature selected i want it to do nothing or tell me there is nothing selected. if there is something selected i want it to only updates the selected feature and only copy the selected feature. Any ideas? import arcpy, time
import pythonaddins
import os
#populate selected feature
APT = "TEST"
arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
if int(arcpy.GetCount_management(APT).getOutput(0)) > 0:
rows = arcpy.UpdateCursor(APT)
for row in rows:
row.FacltyType = ("Single Family Home")
row.StructType = ("Primary, Private")
row.Verified = ("Yes, GRM, TA")
row.Status = ("Active")
row.StructCat = ("Residential")
row.APA_CODE = ("1110")
rows.updateRow(row)
del row, rows
#Copies address point to backup address points in filegeodatabase
fc1 = "CCAP"
#Database
workspace = r"C:\GIS\CCAP\CCAP.mdb"
arcpy.env.overwriteOutput = True
# Start an edit session. Must provide the worksapce.
edit = arcpy.da.Editor(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()
if int(arcpy.GetCount_management(APT).getOutput(0)) > 0:
arcpy.Append_management(APT, fc1, "NO_TEST")
# Stop the edit operation.
edit.stopOperation()
# Stop the edit session and save the changes
edit.stopEditing(True)
arcpy.RefreshActiveView()
... View more
06-11-2015
08:23 AM
|
0
|
34
|
6585
|
POST
|
The lyr.definitionQuery worked but after running the script to search for "Quail" the features were not highlight and i noticed that when i open the Sub layer attributes only those attributes in the table, what happened to the rest of the subdivision features? How do you rest the Sub layer to show all of the subdivision in the attribute table. I would like to keep all the subdivision features and only select the features that i search for.
... View more
05-20-2015
01:32 PM
|
0
|
1
|
1062
|
POST
|
I wasn't sure if this was the best way to do the search, if there is a better FASTER way please let me know. The reason i had that the arcpy.SelectLayerByAttribute_management was to actually make the selection on the Layer, I ran the code that you posted and it took me to the area but did not highlight the sub that i searched for. Once i added the arcpy.SelectLayerByAttribute_management back it zoomed to the location and the search sub was highlighted. I do noticed something strange with the zoom though, if i search by Quail it selects the subs with Quail but zooms to each one, one by one. I would like to just zoom to all of them one time. is this a function of how the arcpy.da.SearchCursor works?
... View more
05-20-2015
11:48 AM
|
0
|
3
|
1062
|
POST
|
I made the following adjustments, When i type in Rolling Hills #3, i get the following error. Traceback (most recent call last): File "C:\GIS\Python Scripts\ZoomToParcelScript6Eb.py", line 9, in <module> for row in cursor: RuntimeError: Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'HILLS'.] [vector.DBO.Subdivision_boundaries] Failed to execute (ZoomToSubScript). If i type in just Rolling i get this error. Traceback (most recent call last): File "C:\GIS\Python Scripts\ZoomToParcelScript6Eb.py", line 9, in <module> for row in cursor: RuntimeError: Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ')'.] [vector.DBO.Subdivision_boundaries] Failed to execute (ZoomToSubScript). here is the current code with your suggestions. i am assuming that the syntax is incorrect still. I am lost... import arcpy
mxd = arcpy.mapping.MapDocument('CURRENT')
df = arcpy.mapping.ListDataFrames(mxd, "Layers") [0]
lyr = arcpy.mapping.ListLayers(mxd, "Subdivision Boundaries")[0]
whereClause = arcpy.GetParameterAsText(0)
with arcpy.da.SearchCursor(lyr, ("PLAT_NAME"), whereClause) as cursor:
for row in cursor:
query_str = "PLAT_NAME LIKE '%" + whereClause + "%'"
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", query_str)
df.extent = row[0].extent
df.scale = df.scale * 5
arcpy.RefreshActiveView()
#arcpy.mapping.ExportToPDF(mxd, "C:/test/" + fc + "_" + str(row[1]) + "_" + str(row[2]) + ".pdf")
... View more
05-20-2015
11:05 AM
|
0
|
5
|
1062
|
POST
|
I am trying to create a script tool to do a search but i am having a little trouble putting it together and i am not sure if i am going about it the right way. I would like to have a script tool that can search for a subdivision name inside arcmap in the toolbox. I have attached my python code i have and working with, one other thing i would like this script to do is use a wildcard. For example say a subdivision that i am searching for attribute is "County Side Estates" but I would like to just enter "County" and select all subs with "County" but i am not sure how to accomplish this. Any help would be gratefully appreciated. Thanks. The error i am getting with my current code. Traceback (most recent call last): File "C:\GIS\Python Scripts\ZoomToParcelScript6Eb.py", line 9, in <module> for row in cursor: RuntimeError: Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'ACRES'.] [vector.DBO.Subdivision_boundaries] Failed to execute (ZoomToSubScript). import arcpy
mxd = arcpy.mapping.MapDocument('CURRENT')
df = arcpy.mapping.ListDataFrames(mxd, "Layers") [0]
lyr = arcpy.mapping.ListLayers(mxd, "Subdivision Boundaries")[0]
whereClause = arcpy.GetParameterAsText(0)
with arcpy.da.SearchCursor(lyr, ("PLAT_NAME"), whereClause) as cursor:
for row in cursor:
query_str = whereClause #= '{0}'.format(row[1])
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", query_str)
df.extent = row[0].extent
df.scale = df.scale * 5
arcpy.RefreshActiveView()
#arcpy.mapping.ExportToPDF(mxd, "C:/test/" + fc + "_" + str(row[1]) + "_" + str(row[2]) + ".pdf")
Here are my script parameters.
... View more
05-20-2015
07:57 AM
|
0
|
9
|
4633
|
DOC
|
Larry, nice widget. In your preview site I like the way parcel is highlighted when you move your mouse arrow over it and how it show's a few attributes fields and if you click on the parcel for more info you get the popup. I like the way how each attribute has a box around the attribute makes it easy to read. I would really like to see these awesome features in an add on to Web Appbuilder. Fantastic work!
... View more
05-14-2015
07:59 AM
|
0
|
0
|
7240
|
DOC
|
I love this widget Robert! One thing that would be nice would be the ability to change the order of the results when you have "All Layers" in the Identify from in the widget. The issue i have is if i have 5 layers turned on and i do an Identify it displays the results in a set random order, i would like to be able to set the most important layer results first, I currently have to scroll down a ways to look at the layer that has the highest importance. I see that i can select the layer from the "Identify from" but it would only show me just one layer. Thanks.
... View more
05-07-2015
02:57 PM
|
0
|
0
|
5030
|
DOC
|
Interesting, it works fine today, i didn't change anything I just verified that i had ServiceURL...
... View more
05-04-2015
03:53 PM
|
0
|
0
|
12362
|
DOC
|
I am using Projected Coordinates. Thanks for the follow up.
... View more
05-04-2015
02:14 PM
|
0
|
0
|
12362
|
DOC
|
Error: Unable to complete operation. {code: 400, message: "Unable to complete operation.", details: Array[1], log: undefined, httpCode: 400…} x @ init.js:192 (anonymous function) @ init.js:191 c @ init.js:76 d @ init.js:76 b.Deferred.resolve.callback @ init.js:77 c @ init.js:76 d @ init.js:76 b.Deferred.resolve.callback @ init.js:77 c @ init.js:76 d @ init.js:76 b.Deferred.resolve.callback @ init.js:77 c @ init.js:76 d @ init.js:76 b.Deferred.resolve.callback @ init.js:77 (anonymous function) @ init.js:195 k @ init.js:199 m @ init.js:199 f.resolve @ init.js:201 a @ init.js:200 k @ init.js:200 m @ init.js:199 f.resolve @ init.js:201 a @ init.js:200 k @ init.js:200 m @ init.js:199 f.resolve @ init.js:201 a @ init.js:200 k @ init.js:200 m @ init.js:199 f.resolve @ init.js:201 q @ init.js:160 f @ init.js:164 PrintPlus.js:1348 Error: Unable to complete operation. {code: 400, message: "Unable to complete operation.", details: Array[1], log: undefined, httpCode: 400…}_ssl: undefinedcode: 400details: Array[1]httpCode: 400log: undefinedmessage: "Unable to complete operation."stack: (...)get stack: function () { [native code] }set stack: function () { [native code] }__proto__: d
... View more
05-01-2015
10:45 AM
|
0
|
0
|
12361
|
DOC
|
I currently don't have in on a server. the app is just on my PC iis.
... View more
04-30-2015
10:26 AM
|
0
|
0
|
12361
|
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 |
Online Status |
Offline
|
Date Last Visited |
3 weeks ago
|