Latest Contributions by JoshuaSharp-Heward

No worries! I did a little playing because I was curious and it also seems quite important for you (COVID and all). If in AGOL content you go Create->Feature Layer->From URL and put in the url to the JHU service, it should create an exact replica but empty. Then I've written a little script using the ArcGIS API for Python that should update the data for you as long as the schemas match; if you have access to either ArcGIS Notebooks or ArcGIS Pro then the following should work to update the data for you: from arcgis.gis import GIS #gis = GIS("home") uncomment this if you run it from notebook in AGOL #gis = GIS("pro")uncomment this if running from pro id1 = "" #AGOL ItemID of JHU service item id2 = "" #AGOL ItemID of your replica service item1 = gis.content.get(id1) item2 = gis.content.get(id2) flayer1 = item1.layers[0] # assuming there is only one layer in the service? flayer2 = item2.layers[0] print("Querying JHU feature service") fset = flayer1.query(where="1=1", out_fields="*", return_all_records=True) print("{} features returned".format(len(fset.features)) print("Deleting features in replica JHU service") flayer2.delete_features(where="1=1") # clearing out previous data print("Adding features to replica JHU service") flayer2.edit_features(adds=fset) # adding new data This is very rudimentary and also not the most sensible way to solve it, as I'm nuking and appending all data instead of just taking changes from the last day etc., but it should do the trick. ... View more

Hi Anna, Have you looked into the "Join Features" analysis tool in ArcGIS Online? Join Features—ArcGIS Online Help | Documentation  I believe it makes a view layer joining two hosted feature services, and if you create the join based on a shared attribute (instead of a spatial join) then it will automatically update as changes are made to the two underlying services.  Create results as hosted feature layer view allows the data to stay up to date as the source data changes. Hosted feature layer views containing joins will be read-only and do not consume credits for analysis and storage. If statistics are included as part of the output, the hosted feature layer view will contain an extra table layer in the view with the statistics. Attachments on the target layer will be preserved if the target layer has attachments enabled and a GlobalID field. For more information on hosted feature layer views, see Limitations. Might very well be the best solution in this case. ... View more

Glad to help out!  ... View more

Easy then! from arcgis.gis import GIS from arcgis.mapping import WebMap gis = GIS('pro')# if running this from Notebook for ArcGIS in AGOL/Enterprise, replace this line with gis = GIS('home') wmItemId = "" #put the id of the webmap in here wmItem = gis.content.get(wmItemId) wm = WebMap(wmItem) for lyr in wm.layers: print(lyr.title)‍‍‍‍‍‍‍‍ I wrote that to be run from the Python window in Pro, but see my note in line 3 about using it in ArcGIS Notebook. Just put the ID of the web map item into line 4 and it should print out all the layers for the given webmap. ... View more

Do you have access to ArcGIS Pro or ArcGIS Notebook (in AGOL or enterprise)? If so this can be done using the ArcGIS API for Python pretty easily! ... View more

I realise that should be "NADR_GID" not "NADR_ID", where are you putting that line of code? It should be in the box below the code block, and the code block should be empty! If that fails, I'd be happy to take another look at the error message it gives. Also I realised in your previous screenshot it's running as Python9.3, try the above line or my original solution with "Python" as the expression type just in case! ... View more

That really should run fine, I don't see how that's giving a syntax error, unless it doesn't like the indentation. In any case I defer to Dan's solution which is running the same thing but in one line: !NADR_ID! if !NADR_ID! in !ABOVE! else None ... View more

Can you post another picture of what you ran this time? ... View more

So in the original code I sent through, leave the field1 and field2 as they are (don't replace with your fields)! When you run myfunct(!NADR_GID!, !ABOVE!) that's substituting those values in there. ... View more

This shouldn't be an issue from my understanding, the multiple numbers in the second column are all just strings joined by ";"s, so if the number from the first column is anywhere in the second column it will return it. Have you tried running it? If so maybe you can show me where it has returned a value that you didn't want? ... View more

Hi Kristyna, I've done something quite similar to this in the past! In this case you don't actually need to use cursors, just the field calculator using Python will do! If you right click on the third field (BELOW) and go to "calculate field", select "python" for the expression type, put the following code in the code block: def myfunc(field1, field2): if str(field1) in field2: return field1 else: return None‍‍‍‍‍ Then in the box above the codeblock, put the following line my_func(!NADR_GID!, !ABOVE!)‍‍ It should do exactly what you're hoping for it to do. Basically taking the first number, converting it to a string, looking for that sequence in the second field, then returning the first field's value if there is a match! ... View more

Parfait! I should have added an if statement to check whether that category is in the dictionary anyway, see line 3 below. with arcpy.da.UpdateCursor(fc, fields) as cursor: for row in cursor: if row[1] in description_dict: row[0] = description_dict[row[1]] cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍ Then it should just skip over those values! ... View more