Latest Contributions by JoshuaSharp-Heward

Hi, Depending on your version of Portal, have you looked into item reports? They output item id's and urls for feature services, and it's a good way of getting an inventory without having to write any code. https://doc.arcgis.com/en/arcgis-online/reference/report-fields.htm Then in your experience builder app if you want to be able to open or view each of the items, you could basically concatenate the url for your portal with the itemid using Arcade, to allow you to view the relevant item page. ... View more

Hi Jonathan, Have you looked into joined hosted feature layer views in AGOL, detailed on this page? https://doc.arcgis.com/en/arcgis-online/manage-data/create-hosted-views.htm They work in the way you describe - the table would have to be in AGOL though. ... View more

Hi Leslie, Field maps allows calculated expressions https://doc.arcgis.com/en/field-maps/android/help/configure-the-form.htm so if you had associated values for each school (things like district, size etc.) you could definitely configure it so that when a school is selected multiple other fields populate automatically. You'd essentially create a lookup table that had associated values for each school in each of the calculated fields, either using a "dictionary" or the Arcade "Decode" function https://doc.arcgis.com/en/field-maps/android/help/configure-the-form.htm . Depending on the number of schools this could be unwieldy to configure all of the matchings yourself, in which case you could store the lookup table values in table in ArcGIS Online and essentially query that table to find the associated values, if you're not planning on using Field Maps in online mode. Hope this helps! Kind regards, Josh ... View more

Ahh okay that makes sense! FeatureSetByRelationshipName will return a feature set, and in your above code you're not pulling out a record from it (which will only be 1 record), so wrapping the FeatureSetByRelationship in the First() function should fix that. That being said it isn't running on my machine, possibly due to me having an older version of ArcGIS Pro? Worth a go anyway. Also what back end process are you using to calculate the ProjectID on the parent table? It might be easier to include this process as a part of that to reduce the amount of manual work. A solid alternative is also using a Joined Hosted Feature Layer view to bring together all of the parent and child info into a flat table, which would mean you wouldn't have to calculate it into the table for the related record, depending on what you want to use it for. ... View more

Hi Laila, Why are you wanting to field calculate the ID? Is it for when you're creating a new feature in the related table? Because if so you shouldn't have to be scripting that via arcade or Python, if you're creating the related record in Field Maps or via the "Add new to relationship" (https://pro.arcgis.com/en/pro-app/latest/help/editing/edit-feature-relationships.htm) in ArcGIS Pro it should be automatically populating the GUID field. ... View more

Well I've learned two things today then! I didn't realise the "Save" method existed for feature sets in the ArcGIS API for Python, that seems very useful! Glad you've managed to find a solution 🙂 ... View more

Hi Lindsay, I didn't think that you could use a feature service as an input to the Export Table geoprocessing tool? In the documentation https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/export-table.htm it doesn't indicate that you can do that I have managed to do something similar by having the web service in a map in an arcgis pro project before, and accessing the layer via ArcPy. ... View more

Hi, No worries, glad I could help so far! Presuming you are mainly dealing with ESRI Rest services, you should be able to query each layer in a "try" and "except" clause as a proxy for finding whether the web service for the layer is accessible or not. Fair warning: I haven't tried or tested this, but I think it would work in theory.   for layer in layers: try: layer.query(return_count_only=True) print("query successful") except: print("query unsuccessful")   Probably printing the layer name and web map so you can find which ones aren't working. Note I'm using return_count_only=True as I think it will be faster as it doesn't have to return all the feature info. It'd be great to use "where="OBJECTID = 1" but It's not always a given that a feature service will have a feature with OID =1 if it's updated regularly. ... View more

Hi, A few comments! First of all, you don't need to use content.search when just accessing a single web map, do: webmap = gis.content.get(itemid) Although if you want to do it for all your maps you would do it like that: webmaps = gis.content.search(query="", item_type="Web Map", max_items=10000) And you don't need to use get_data to pull out the layers, as there are .layers and .basemap properties that store that info without having to pull it from the dictionary returned by get_data. I'd do something like this: for web_map in webmaps: print(web_map.title) for layer in web_map.layers: print(layer.name) print(web_map.basemap_title) If you want to extract all the layers in the basemap I think web_map.basemap returns these as a list that you can iterate over too. As for checking the loading status of the layer, do you mean whether the layer is broken or not? ... View more

Hi, I've just taken a look and from my end it's showing it as owned by ESRI, not the Western Confluence group, so it must just be a visual bug!     ... View more

Hi, Well your problem is that your newfile name is ending up as "C:\Users\Brubisgeo\Downloads\teste_1\intersected_C:\Users\Brubisgeo\Downloads\clipar tudo\BR_Municipios_2021\BR_Municipios_2021.shp" which seems to have joined your input on the end of your output to make a broken path, although from looking at your code I can't really tell why. I would recommend adding an arcpy.AddMessage() statement for your rename_shp and newfile to see what values they have before they're input into your intersect. It looks like the fc variable in the "intersectedo_{}".format(fc)" part is somehow putting the whole shapefile file path in there. ... View more

Hi, It sounds like the field name you're using as the input doesn't match any fields in your input table. I'd try commenting the field calculator out and putting fields = [f.name for f in arcpy.ListFields(OutputfeatureClass)] for field in fields: print(field)  as a way of double checking the names of each of your fields post-join and making sure that the names match exactly, and also working out whether the spatial join is running as you intend it to. ... View more

Hi Frank, It worked for me in the desktop publishing space! Would you be able to post the survey123 form or at least the relevant part from the repeat so I can take a look? Here's how mine looked:     ... View more