Latest Contributions by DougBrowning

All layers and tables are from the same Feature Service.  The URL is working if I paste it in the browser just load will not take it. Thanks! ... View more

Well I spoke too soon.  This is working for Feature Classes but it is giving an error on all tables. This line gapLayer.load(q_response.url) gives this error Traceback (most recent call last):  line 226, in <module>     gapLayer.load(q_response.url)   File "C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcPy\arcpy\arcobjects\arcobjects.py", line 175, in load     return convertArcObjectToPythonObject(self._arc_object.Load(*gp_fixargs(args))) RuntimeError: RecordSetObject: Cannot open table for Load I tied changing gapLayer = arcpy.FeatureSet() to gapLayer = arcpy.RecordSet() but I get the same error. (I was guessing it was due to not being a FC).  I also tried taking out the returnGeometry=true part but still the same error. The JSON all looks good just the load function is not happy. Any ideas? Thanks ... View more

We have a guy here that wrote all the SAML stuff.  I worked with him on this one and he ended up updating his code to get it to work - but we did get it to work. He has it on GitHub if you want to check it out.  https://github.com/DOI-BLM/requests-arcgis-auth Simple code was import os from uuid import uuid4 import requests import arcpy import requests from requests_arcgis_auth import ArcGISPortalSAMLAuth # Setup Parameters & Authentication url = r'https://yourorg.maps.arcgis.com/sharing/rest'  # change me client_id = r'jkahfkashdf'   # change me item_id_to_query = r'sampleitemid'  # change me s = requests.session() s.auth = ArcGISPortalSAMLAuth(client_id) # Make a request to the item & obtain the feature service endpoint response = s.post(url+"/content/items/{}?f=json".format(item_id_to_query)) fs_endpoint = response.json().get('url') print ("Item ID {} feature service is hosted at {}".format(item_id_to_query,fs_endpoint)) # Query the end-point. #   Keep in mind, this only works because the service is 'federated' with the portal. #   This would not work for ANY service (including public/anonymous) as it will attach the token, and this token is only good for the specific portal we are working with q_response = s.get(fs_endpoint + "/0/query?f=json&where=1=1&outFields=*&returnGeometry=true") features = q_response.json().get('features') print ("Found {} records on layer 0 of the fs endpoint".format(len(features))) # Load to a 'feature set' #   Keep in mind, this works because the 'token' is present in the HTTP GET URL. #   May not be supported if it needs to be a POST or the parameters end up in the body of the request fs = arcpy.FeatureSet() fs.load(q_response.url) with arcpy.da.SearchCursor(fs,"*") as cursor:         for row in cursor:             print(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I am not tested my full script yet that has several SearchCursors but I am hopeful.  Will report back. Thanks again! ... View more

Awsome!  I wrote it up then hit the next issue though - logging in.  I have some code the grabs our SAML logins to do something with AGO but I am not sure how to blend the two.  I will let you know how it goes unless you have any ideas. Thanks a lot ... View more

Search Cursor would not work though right?  I was hoping to have one code stack that works for gdb, sde, or a HFS URL. Thanks ... View more

Since there is a URL to the HFS in the call does the call work offline?  Going from Collector to Survey123 does work offline - but from Survey123 to Collector I am not sure if it just uses the URL to figure out the right layer or if it is going out to the net for something? Thanks ... View more

I tested and using just SHAPE@ works just fine.  That means this code should work for any type of FC. Thanks ... View more

I did this exact thing (Plots to forms) but I did it with Relationship Classes.  Worked out great. See my post on the very last page of this topic for more info https://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-scheme?messageTarget=all&start=150&mode=comments Hope it helps. ... View more

I just want to copy the geometry from A to B.  Not change it in any way. thanks ... View more

Thanks a lot Joshua - great code.  It took a minute because of a different issue.  If you look close at my post I had the old Insert and missed the new .da part!  Duh.  That fixed a lot. I did change your code slightly to ask the outgoing FC its projection and then use that.  This way it will work even if the SR is different that the hardcoded wkid.  Works but if this is an issue let me know.     sr = arcpy.Describe(terraFC).spatialReference     fields = ["SHAPE@XY"]     whereClause = "PlotKey = '" + plot + "'"   # only want completed plots from above     with arcpy.da.SearchCursor(plotLayer, fields, whereClause, spatial_reference=sr) as cursor:         for row in cursor:             dataValues.append(row[0]) for eachData in allDataValues:     with arcpy.da.InsertCursor(terraFC, insertFields) as inCursor:             inCursor.insertRow(eachData) I also wonder if you did  fields = ["SHAPE@"] if it would work for any geometry type? It all works!  Thanks again to everyone. ... View more

I can email but not sure I can post due to company policy.  My email is in my profile.  My question is really not having a compound statement in one filter it is that I want to use more than one column in 2 different choice filters. Thanks a lot! ... View more

Are you sure you can use two different columns in the lookup?  I was testing this all day yesterday and for sure mine will only use one column.  In fact the column must be one set name. My detailed post is here https://community.esri.com/message/762088-can-externalchoices-use-more-than-one-lookup-column-and-query-speed Thanks ... View more