Latest Contributions by KellyTaylor

Hi Mappers, I've written a script that periodically overwrites the feature classes housed on our server with feature layers from our ArcGIS Online account. It works well except with one of the layers titled CustomerEndpoint. I get this warning: This geodatabase does not support this client or operation [This geodatabase does not support this client or operation [This geodatabase does not support this client or operation][CustomerEndpoint.objectid_12]] The resulting feature class is missing several fields, and the ObjectID and GlobalID fields have different names than those on our AGOL account (no features seems to be missing though). It's obvious that there is an issue with the unique ID fields but I don't know what that issue is. Any brainy mappy thoughts/suggestions would be appreciated. Script below with any sensitive info edited out... def backup_weblayers_to_server(): ## info for logging doc logging.basicConfig(filename='update_log.log', level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s') ## connect to AGOL gis = GIS('home') ## filepath to server db connection DB_CONNECTION = filepath to db connection ## item IDs for each web layer to be backed up D_VALVES_ID = agol item id ENDPOINT_ID = agol item id D_LINE_ID = agol item id T_LINE_ID = agol item id T_VALVES_ID = agol item id S_LINES_ID = agol item id IDS = [D_VALVES_ID, ENDPOINT_ID, D_LINE_ID, T_LINE_ID, T_VALVES_ID, S_LINES_ID] for id in IDS: msg = f"Accessing web layer..." print(msg) logging.info(msg) item = gis.content.get(id) # AGOL item msg =f"Converting {item.title} web layer to feature set..." print(msg) logging.info(msg) feat_set = item.layers[0].query(as_df = True) # feature set of web layer msg = f"{item.title} feature set contains {len(feat_set)} records." print(msg) logging.info(msg) # # establish dataset in which to save feature set if "Transmission" in item.title: dataset = 'Transmission_Dataset' elif item.title == 'Distribution Valves': dataset = 'Distribution_Assets' else: dataset = 'Distribution_Network' # clean up title to be used for feature class name fc_name = item.title.replace(" ","_") # complete file path where to save the feature class location = os.path.join(DB_CONNECTION,dataset, fc_name) msg = f"Overwriting {fc_name} feature class on server..." print(msg) logging.info(msg) try: # convert feature set to a spatially enabled dataframe # and save it as a feature class in the db on the server feat_set.spatial.to_featureclass(location = location, overwrite=True) msg = f"{item.title} successfully backed up on server. Path: {os.path.join(dataset, fc_name)}\n" print(msg) logging.info(msg) except Exception as e: msg = f"{item.title} not able to be backed up. Moving to next layer See Exception below:\n{e}" print(msg) logging.info(msg) continue return backup_weblayers_to_server()   ... View more

The title says is all. I'd appreciate being able to maintain null values when converting a SeDF to a featureclass in a gdb. I've used pandas.fillna() with fillers like a space before, but sometimes a null value is there for a reason, and I'd prefer to leave it null. ... View more

I would love to be able to resize the map (or maybe even the entire survey area) for geo questions in the web app for Survey123. Another option would be to allow the user to make the map full screen, like a popup. Right now, my geoshape question is pretty inaccessible to my end users, many of whom are older and/or have bad eyes and/or aren't the most tech savvy.  Look how teeny tiny that map is (screenshot below)! It's barely accessible to me, and I'm a map & tech professional.     ... View more

Hey all, I'm trying to automatically change the filter on a layer on a web map based on the date. For example, I only want points collected in January to show up, but starting in February I only want points collected in February, etc. I thought about scheduling a notebook, but I don't think you can manipulate an online map with python the way you can with the mapping module in Pro. I also wrote an attribute expression that returns true if the month of my 'location_timestamp' field is equal to the current month, but I don't see a way to incorporate attribute expressions into a filter. I assumed that was an option, which is why I wrote the expression. This is obviously not a huge deal but I love a clutter-free map and I love automating things (I picked the right profession!) so I'd love to hear your thoughts! ... View more

Hello, I'm looking for the most efficient way to convert a stand-alone table to a pandas data frame. This table will ultimately be geocoded and saved as a feature class, but I need to manipulate the data and fields quite a bit before that. I find pandas to the easiest and most efficient way to do the data manipulation. Currently, I am using arcpy.conversion.TableToTable() to first convert the table to a csv file, and then pandas.read_csv() to convert to a data frame. The table has roughly 63,000 records and it is taking over an hour to do the TableToTable portion of the conversion.  Is there a better way to do this? Pandas is so quick so read the csv and I so wish I could read the table directly into pandas without the intermediate of a csv. Many Thanks ... View more

Hello, I'm looking for the most efficient way to convert a stand-alone table to a pandas data frame. This table will ultimately be geocoded and saved as a feature class, but I need to manipulate the data and fields quite a bit before that. I find pandas to the easiest and most efficient way to do the data manipulation. Currently, I am using arcpy.conversion.TableToTable() to first convert the table to a csv file, and then pandas.read_csv() to convert to a data frame. The table has roughly 63,000 records and it is taking over an hour to do the TableToTable portion of the conversion.  Is there a better way to do this? Pandas is so quick so read the csv and I so wish I could read the table directly into pandas without the intermediate of a csv. Many Thanks ... View more

Hey all, I'm trying to figure out how to allow only digits (0-9) and a separator (preferably commas) in a text field in Survey123. It would ideally also show up as a number pad even though it's a text field. I've previously set the appearance to numbers but this only allows for integers or decimals, aka no commas or spaces. Thanks! ... View more

Hi all, I am trying to format a legend in ArcGIS Pro to look like a table. Essentially, all I need is to add lines between each item and between the items and their descriptions. This is a template for a map that will change frequently so I want the table to adjust size when the descriptions for the items change. If it was static I would simply draw the lines in. This is the table I'm trying to approximately replicate:   This is as close as I have been able to get so far: Any help would be appreciated. Thanks! ... View more