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