Latest Contributions by LindsayRaabe_FPCWA

Thanks for info @DanPatterson and @sjones_esriau . We didn't have the plan 'Area' option in our drop downs, so couldn't compare the planimetric and geodesic calcs, but I think I'm satisfied with the differing results. The only doubt left in my mind is around the difference between Zones 50 and 51. Wouldn't this still cause a difference in errors as the features when calculated in a zone that they don't fall within are further from the intended use area, and thus distorted? Or will geodesic fix this too? (in which case, are zones rendered pointless going forwards?)   ... View more

@KoryKramer Thanks. I've had a good read of those articles previously. The logic behind skipping (which I don't agree with) is to let other orgs find the bugs and have them fixed by 3.1, though as we all know, new bugs sneak in with all releases, so seems kinda pointless (especially considering I'm yet to find any bugs in 3.0 that have impacted our workflows.).  Anyways, nearly there with 3.1 so I'm happy to wait another week! ... View more

@KoryKramer Awesome. Thanks! Been hanging out for this one as our org refused to upgrade to 3.0 which is where I've been doing all my development.  ... View more

@RussellBrennan Great news! I look forward to trying it out. Do you have an ETA on 3.1 release date?  Enterprise isn't something we use so won't get that benefit, but imagine many others will! ... View more

I tried this out yesterday for the first time only to discover that integers weren't an option. Made it useless in that scenario, but could still be useful in others in its current format. Seems a bit short sighted. ... View more

@RobertEisler glad it worked for you and your needs. Always good when you can find exactly what you're looking for. I find I'm usually cobbling together bits and pieces from all over the place to achieve an outcome. Slowly learning what works better as I find other examples of things I've been doing a certain easy for a while.  ... View more

@RobertEisler I have modified the script as per below to include input and output parameters (Lines 10-12 & 144) which have replaced the variables that you edit at the beginning of the script. (NOTE: I have also implemented the use of keyring to parse the login details for ArcGIS Online which means I don't need to store our password in the script: Lines 28-30)   import arcpy, os, time, uuid from zipfile import ZipFile from arcgis.gis import GIS import arcgis.features # Overwrite Output arcpy.env.overwriteOutput = True # Parameters infc = arcpy.GetParameter(0) outfsID = arcpy.GetParameter(1) sublayerID = arcpy.GetParameter(2) # Variables fc = str(infc) # Path to Feature Class fsItemId = outfsID # Feature Service Item ID to update featureService = True # True if updating a Feature Service, False if updating a Hosted Table hostedTable = False # True is updating a Hosted Table, False if updating a Feature Service layerIndex = sublayerID # Layer Index disableSync = True # True to disable sync, and then re-enable sync after append, False to not disable sync. Set to True if sync is not enabled # Start Timer startTime = time.time() # Create GIS object print("Connecting to AGOL") ### Access the stored password with keyring and sign into the GIS # https://community.esri.com/t5/arcgis-online-blog/connect-to-the-gis-in-python-scripts-without/ba-p/889867 import keyring pw = keyring.get_password("ArcGISOnline", "Username") gis = GIS("https://fpcwa.maps.arcgis.com", "Username", pw) print("Connected to the GIS") # Create UUID variable for GDB gdbId = str(uuid.uuid1()) # Function to Zip FGD def zipDir(dirPath, zipPath): '''Zip File Geodatabase''' zipf = ZipFile(zipPath , mode='w') gdb = os.path.basename(dirPath) for root, _ , files in os.walk(dirPath): for file in files: if 'lock' not in file: filePath = os.path.join(root, file) zipf.write(filePath , os.path.join(gdb, file)) zipf.close() print("Creating temporary File Geodatabase") gdb = arcpy.CreateFileGDB_management(arcpy.env.scratchFolder, gdbId)[0] # Export featureService classes to temporary File Geodatabase fcName = os.path.basename(fc) fcName = fcName.split('.')[-1] print(f"Exporting {fcName} to temp FGD") if featureService == True: arcpy.conversion.FeatureClassToFeatureClass(fc, gdb, fcName) elif hostedTable == True: arcpy.conversion.TableToTable(fc, gdb, fcName) # Zip temp FGD print("Zipping temp FGD") zipDir(gdb, gdb + ".zip") # Upload zipped File Geodatabase print("Uploading File Geodatabase") fgd_properties={'title':gdbId, 'tags':'temp file geodatabase', 'type':'File Geodatabase'} fgd_item = gis.content.add(item_properties=fgd_properties, data=gdb + ".zip") # Get featureService/hostedTable layer serviceLayer = gis.content.get(fsItemId) if featureService == True: fLyr = serviceLayer.layers[layerIndex] elif hostedTable == True: fLyr = serviceLayer.tables[layerIndex] # Truncate Feature Service # If views exist, or disableSync = False use delete_features. OBJECTIDs will not reset flc = arcgis.features.FeatureLayerCollection(serviceLayer.url, gis) try: if flc.properties.hasViews == True: print("Feature Service has view(s)") hasViews = True except: hasViews = False if hasViews == True or disableSync == False: # Get Min OBJECTID minOID = fLyr.query(out_statistics=[{"statisticType": "MIN", "onStatisticField": "OBJECTID", "outStatisticFieldName": "MINOID"}]) minOBJECTID = minOID.features[0].attributes['MINOID'] # Get Max OBJECTID maxOID = fLyr.query(out_statistics=[{"statisticType": "MAX", "onStatisticField": "OBJECTID", "outStatisticFieldName": "MAXOID"}]) maxOBJECTID = maxOID.features[0].attributes['MAXOID'] # If more than 2,000 features, delete in 2000 increments print("Deleting features") if (maxOBJECTID - minOBJECTID) > 2000: x = minOBJECTID y = x + 1999 while x < maxOBJECTID: query = f"OBJECTID >= {x} AND OBJECTID <= {y}" fLyr.delete_features(where=query) x += 2000 y += 2000 # Else if less than 2,000 features, delete all else: print("Deleting features") fLyr.delete_features(where="1=1") # If no views and disableSync is True: disable Sync, truncate, and then re-enable Sync. OBJECTIDs will reset elif hasViews == False and disableSync == True: if flc.properties.syncEnabled == True: print("Disabling Sync") properties = flc.properties.capabilities updateDict = {"capabilities": "Query", "syncEnabled": False} flc.manager.update_definition(updateDict) print("Truncating Feature Service") fLyr.manager.truncate() print("Enabling Sync") updateDict = {"capabilities": properties, "syncEnabled": True} flc.manager.update_definition(updateDict) else: print("Truncating Feature Service") fLyr.manager.truncate() # Append features from featureService class/hostedTable print("Appending features") fLyr.append(item_id=fgd_item.id, upload_format="filegdb", upsert=False, field_mappings=[]) # Delete Uploaded File Geodatabase print("Deleting uploaded File Geodatabase") fgd_item.delete() # Delete temporary File Geodatabase and zip file print("Deleting temporary FGD and zip file") arcpy.Delete_management(gdb) os.remove(gdb + ".zip") endTime = time.time() elapsedTime = round((endTime - startTime) / 60, 2) print("Script finished in {0} minutes".format(elapsedTime)) CompleteVariable = "Complete" arcpy.SetParameter(3, CompleteVariable)   By doing this, I can then save the script as a Python Script Tool in a Toolbox which you can load into a Model and parse data in as required (feature class, feature service ID, sub layer ID) and get a "Complete" variable output (Line 144) so you know when it's done (can use as a precondition for further steps). This means you can also use the same script over and over as per my demo below.    ... View more

My testing yesterday with ESRI Australia Support found the same results regarding the shared update group allowing the tool to work as expected for non-Administrators. We too couldn't add "Data Editors" to it though. They had to be a "User" type. Hopefully this bug can be addressed soon, as it surely is a bug! ... View more

Not yet - still working on the issue with ESRI tech support. They might be interested in looking at your data too so will make sure they know you're having trouble too.  ... View more

Just looked into this - it's still in the Product Plan. Wish they would fix it already! My Esri | Bug Details ... View more

As an addition to this idea, it could be expanded to include a similar option for additional views in floating windows.    ... View more

I've just opened an ESRI Support case for this issue: 03192745. Will post back with the outcome.  ... View more