Latest Contributions by CCWeedcontrol

‎06-12-2015

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?

‎06-12-2015

interesting i am not sure i follow into line 8.5?

‎06-12-2015

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.

‎06-12-2015

I am getting an error on elif int(arcpy.GetCount_management(APT).getOutput(0)) == 0: Parsing error SyntaxError: invalid syntax (line 21)

‎06-11-2015

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()

‎05-20-2015

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.

‎05-20-2015

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?

‎05-20-2015

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")

‎05-20-2015

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.

‎05-14-2015

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!

‎05-07-2015

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.

‎05-04-2015

Interesting, it works fine today, i didn't change anything I just verified that i had ServiceURL...

‎05-04-2015

I am using Projected Coordinates. Thanks for the follow up.

‎05-01-2015

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

‎04-30-2015

I currently don't have in on a server. the app is just on my PC iis.

Online Status	Offline
Date Last Visited	‎09-10-2024 10:42 AM

My Ideas

Latest Contributions by CCWeedcontrol

Re: Copy selected features to geodatabase feature class

Re: Copy selected features to geodatabase feature class

Re: Copy selected features to geodatabase feature class

Re: Copy selected features to geodatabase feature class

Copy selected features to geodatabase feature class

Re: Create a search with user GetParameterAsText using arcpy.da.SearchCursor

Re: Create a search with user GetParameterAsText using arcpy.da.SearchCursor

Re: Create a search with user GetParameterAsText using arcpy.da.SearchCursor

Create a search with user GetParameterAsText using arcpy.da.SearchCursor

Re: Zoom Prev Next Widget Version 1.1.1 May 13, 2015

Re: Identify Widget Version 2.15 - 6/16/2020

Re: Print Plus Widget Version 1.1.6 July 12, 2015

Re: Print Plus Widget Version 1.1.6 July 12, 2015

Re: Print Plus Widget Version 1.1.6 July 12, 2015

Re: Print Plus Widget Version 1.1.6 July 12, 2015

Re: Model Builder Schedule Not Working

Re: Make feature layer from selected features

Re: Create dictionary and assign values

Re: arcpy FindReplace Data Sources

Split Polylines at certain increments