Latest Contributions by MikeMacRae

Hello all, I have had a script for a number of years that has always worked in python 2/ArcGIS Desktop and I have decided to bring it into the python 3/ArcGIS Pro environment. As part of the script, I use the arcpy.da.SearchCursor function to read an excel file. This has always worked in the Desktop environment, yet I am getting the following error: with arcpy.da.SearchCursor(r"C:\MASTER.xls\'Test$'", '*') as cursor: RuntimeError: cannot open 'C:\MASTER.xls\'Test$'' My code is:   with arcpy.da.SearchCursor(r"C:\MASTER.xls\'Test$'", '*') as cursor: for row in cursor: print(row[0])   I tested a few things to eliminate any issues: Moved the spreadsheet to different locations on different drives on my LAN. Same error each time Changed the spreadsheet from xls to xlsx. Same error. Set the spreadsheet as the workspace and tried iterating over the sheet. Same error. Changed the UNC path to a map drive. Same error. Tested on a feature class in a geodatabase. No issues. The code runs. Tested again in Desktop 10.6. No issues. The code runs. Is there any chance that ESRI has discontinued support for the cursor on spreadsheets or is there a different approach? ... View more

Hello, I am trying to update an existing hosted feature layer in ArcGIS Online. The hosted feature layer was created from a geodatabase that contained 3 feature classes. I now want to update the hosted feature layer to include the original 3 feature classes and then add another (and possibly more in the future). I have tried to overwrite both the hosted feature layer and the underlying geodatabase in ArcGIS Online, but it won't add any new feature classes. Is this possible?   Thanks ... View more

I have a simple web map with one polygon layer in it. I wanted to add a field to the popup window to show area in hectares for this layer. I use the following Arcade expression:   var hecs = Area($feature, 'hectares') return round(hecs, 2)     The expression runs successfully. When I go to look at the value for each feature in the layer from the popup window, the areas are way off. I attached an image. Within the image, you will see 3 fields: FEATURE_AREA_SQM: This is our system generated area field, much like Shape_Area. It calculates, on the fly, the area of each feature in square metres. AREA_IN_HECTARES: Same as above, but calcultaes hectares as opposed to square metres Hectares: This is the field I created using the arcade expression above. Notice how off it is compared to the other field values. I did a further check to see if our system values were calculating correctly by making a copy of the data in ArcMap, adding a field for Hectares and Calculated geometry for hectares. Our system values are correct. I would have thought that this could be a projection issue, but the values are so grossly off, I don't think that's the issue. But, for the record, the layer is a hosted feature layer that was added to ArcGIS online in the native projection that AGOL uses: WGS_1984_Web_Mercator_Auxiliary_Sphere WKID: 3857 Finally, I tested on some other layers and am getting the same issue. I tried different area values (i.e. square metres, square kilometres) and they are all way off. Can anyone suggest what is wrong with these areas? ... View more

I am just starting to develop in Arcade in ArcGIS Online. I am testing the clip function and can't seem to get the syntax right. Using the example: var envelope = Extent({ ... }); Area(Clip($feature, envelope), 'square-miles');   I created a simple web map and added 2 layers. 'Area of Interest' and 'Parcels'. I want to clip the parcels by the Area of Interest. So, I set my code like this: var aoi = Extent(FeatureSetByName($map, "Area of Interest")) var clp = Clip($feature, aoi) return Round(Area(clp, 'hectare'), 2);   Yet, I keep getting an error: Execution Error:JSON.parse: unexpected character at line 1 column 2 of the JSON data   I've googled around, and changed syntax in various ways, but I can't seem to get it to work. Can anyone suggest what is going wrong? What is the proper syntax to clip one layer by another? Thanks ... View more

I am trying to script some behavior into the ArcGIS Toolbox validator class. Specifically, I am creating a dropdown parameter so the user can choose a predefined option and then a second parameter will update a list of items. The issue I am having is, when I change the option in the first parameter, I can get the options to change in the second parameter, but when I toggle the 'Unselect All' button in the second parameter, the items will not uncheck (they remained checked). I have a feeling it has to do with my script in the Validator. Here are the details (see image below as well): First parameter is a string type. It is required, Input Direction, Has a default value. Multivalue = No and uses a value list so that I can have a dropdown with 3 options to choose from Second parameter is a string type. It is required. Contains Default values. Multivalue = Yes and uses a value list so that the items populated in this parameter (a list of items) can be toggled on or off. So, in the Validator, my script is as follows. Can anyone see something obvious I ma misisng here to get the 'Select All' and 'Unselect All' buttons to work? import arcpy class ToolValidator(object):   """Class for validating a tool's parameter values and controlling   the behavior of the tool's dialog."""   def __init__(self):     """Setup arcpy and the list of tool parameters."""     self.params = arcpy.GetParameterInfo()   def initializeParameters(self):     """Refine the properties of a tool's parameters.  This method is     called when the tool is opened."""     self.params[1].filter.list = [1,2,3,4]     self.params[1].values = self.params[1].filter.list         return   def updateParameters(self):     """Modify the values and properties of parameters before internal     validation is performed.  This method is called whenever a parameter     has been changed."""     if self.params[0].altered == True:       if self.params[0].value == 'Option 1':              self.params[1].filter.list = [1,2,3,4]         self.params[1].values = self.params[1].filter.list       elif self.params[0].value == 'Option 2':           self.params[1].filter.list = ['a', 'b', 'c']         self.params[1].values = self.params[1].filter.list       elif self.params[0].value == 'Option 3':           self.params[1].filter.list = ['dr', 'bht', 'cjjjyy']         self.params[1].values = self.params[1].filter.list          return   def updateMessages(self):     """Modify the messages created by internal validation for each tool     parameter.  This method is called after internal validation."""     return ... View more