Latest Contributions by JamesCrandall

‎05-28-2024

Thank you. I didn't mention that the Oracle db is non-spatial/sde that is being queried. I looked at the actual Sql in the original script and it's quite extensive.

‎05-28-2024

Hi all, Was provided an old Python 2.7 script that imported cx_Oracle for submitting SQL against an Oracle db. Just curious if there's any replacement for this using the default py libraries that come installed with ArcGIS Pro 3.1.2 (or some version of such)?

‎03-27-2024

The input geometry attribute is expecting a string of coordinate pairs. I was simply passing in the geom object of the result from another query/response of the point layer: 'geometry': geom Simply putting this into a string solves the issue: 'geometry': '{},{}'.format(geom['x'],geom['y'])

‎03-26-2024

When attempting to use point geometry as inputGeometry to query our Parcels REST service, it doesn't fail but it does return all parcels when I'm expecting only 1 parcel to be in the result. Also, successfully doing a similar spatial query using polygon geometry so not sure why we're seeing a different result using point feature as the inputGeometry. Using the "geometry" values in the example below as the input directly in the REST query interface returns the correct result. Example input payload to the request: { "f": "json", "geometryType": "esriGeometryPoint", "geometry": { "x": 952887.1388473287, "y": 830228.6453575715, "spatialReference": { "wkid": 2881 } }, "spatialRel": "esriSpatialRelIntersects", "distance": 0, "units": "esriSRUnit_Foot", "inSR": 2881, "where": "1=1", "outFields": "PARNO", "returnGeometry": "false", "returnCountOnly": "true", "featureEncoding": "esriDefault", "token": "validtoken" } This is being run via Python 3.x using the requests library (again, successfully with other geometry types). In this code sample below the "geom" variable is as described in the "geometry" attribute above. queryURL_parcels = 'https://{}/ourdevserver/rest/services/LandOwnershipAndInterests/NormalizedParcels/FeatureServer/0/query'.format(portalUrlBase) params = {'f': 'json', 'geometryType': 'esriGeometryPoint', 'geometry': geom, 'spatialRel': 'esriSpatialRelIntersects', 'distance': 0.0, 'units': 'esriSRUnit_Foot', 'inSR': 2881, 'where': '1=1', 'outFields': 'PARNO', 'returnGeometry': 'false', 'returnCountOnly': 'true', 'token': tok} print(json.dumps(params)) r = requests.post(queryURL_parcels, data = params, verify=False) response = json.loads(r.content) print(response) Since the returnCountOnly param is true then we get back all 4million parcels in the layer, expecting only 1 feature in the count/result. Hopefully someone can spot what I'm missing because I've attempted all combinations of geometry formats.

‎02-16-2024

If nothing evaluates from the query and the result is [] sdf then there is no spatial reference and nothing to join. It must be that I get a result from 1 of the portal items and the other i do not!

‎02-16-2024

We're doing a simple query of 2 portal feature layers and performing a spatial join on the 2 sdf representations. It looks like the error complains "Difference Spatial References, aborting operation" when a Left/Right join is attempted, so I checked each sr for each sdf and sure enough one of them is []! This issue appears to only occur on 1 of our enterprise portals (we have a test and prod version of each site). When I check the item properties it does show the correct spatref so I'm not sure where to check next! Code executed on it's comparable items across both portals produces what we expect: {'wkid': 2881, 'latestWkid': 2881} The other portal produces: [] targetFSet = scratchLayer.query(where=qryStr,out_sr=2881) targetDF = targetFSet.sdf df1SR = targetDF.spatial.sr print(df1SR)

‎01-05-2024

Hey there David! Great to hear from you again. The directory levels all look correct, there's no duplication on the deployed resources. This issue only appears when we navigate to the index.html of the deployed app. I'm wondering if this is an IIS/domain setting thing? We ran into this issue a couple of years ago but didn't document the fix and just re-investigating.

‎01-05-2024

We have developed an ExB with Developer edition v1.12 and seeing 404 error when attempting to navigate to the index.html of the deployed ExB. From the dev tools console (header tab): Index.html Request URL: https://ourdomain.com/somefoldername/index.html Status Code: 200 Ok init.js Request URL: https://ourdomain.com/somefoldername/cdn/1/cdn/1/jimu-core/init.js Status Code: 404 JamesCrandall_1-1704470542926.png

‎11-09-2023

Sounds like your portal is connected to your active directory accounts maybe? If that's the case, what we do is create a new portal account that doesn't use AD to authenticate and this is the account used for authentication within any scripting. Also: if you have ArcGIS Pro open and you are logged into the portal, does your script run successfully then to create the GIS object?

‎09-25-2023

Hi Katherine! What is the output parameter of your GP tool? I'm unsure what the application is expecting to render it as or what would be appropriate. I think my comments above to the original post were more about generating an output of a zipped up kml that would end up in a the user's downloads folder. If that's the case, your python script source would need to execute the "Layer To KML" tool then implement code to zip that up and send via the output parameter.

‎08-14-2023

Oh. the updates parameter is supposed to be a list in edit_features() method: edit_result = layer.edit_features(updates=[editFeature])

‎08-14-2023

This is supposed to be simple but running into issues attempting to submit updates to a feature service layer. Forever I have simply used the REST api (ie. "applyEdits") on a service layer and always works as expected but now I'm converting some of that code over to the python API to work directly on the portal items themselves. Anyway, this is somewhat close to THIS example but getting this error "object of type 'Feature' has no len()" on the edit_features() method. #set layer portalItem = gis.content.get('9cb6469e3d3e43379551abbb1b74a284') for layer in portalItem.layers: if "Final" in layer.properties.name: #check if there is a matching appId checkSet = layer.query(where='objectid={}'.format(oid), return_count_only=True) if checkSet == 1: #get the row to edit using the oid value fset = layer.query(where='objectid={}'.format(oid)) editFeature = [f for f in fset.features if f.attributes['OBJECTID']==oid][0] editFeature.attributes['PERMIT_ID'] = inputPermitId editFeature.attributes['PERMIT_NO'] = inputPermitId edit_result = layer.edit_features(updates=editFeature)

‎08-11-2023

If you go the gp service route and implement python api to I guess access a FeatureLayerCollection, there may be something there to go at it in one shot but I'm not sure what is under the hood behind that operation (ie, maybe it just makes all 100 requests too). Also, this seems overly complex for such a simple request to get feature counts! Anyway -- sorry no real good answer for you just a quick comment and will get notified of any other answers you may get, I am curious myself!

‎07-13-2023

Printing params value and sending same exact request/post using Postman succeeds.

‎07-12-2023

I have had a py 2.7 script running for years that makes requests to the ESRI route service at https://route.arcgis.com/arcgis/rest/services/World/Route/NAServer/Route_World/solve Converting to requests library. It supplies a token and pre-built input params and makes the post request: {'f': 'json', 'stops': {'features': [{'geometry': {'x': 863532.1692919674, 'y': 1030860.3483306282, 'spatialReference': {'wkid': 2881}}, 'attributes': {'CurbApproach': 'null', 'TimeWindowStart': 'null', 'TimeWindowEnd': 'null', 'Attr_Minutes': 0, 'Attr_TravelTime': 0, 'Attr_Miles': 0, 'Attr_Kilometers': 0, 'Attr_TimeAt1KPH': 0, 'Attr_WalkTime': 0, 'Attr_TruckMinutes': 0, 'Attr_TruckTravelTime': 0, 'Name': 'permitAppBoundary'}}, {'geometry': {'x': 623453.099237, 'y': 136924.166006, 'spatialReference': {'wkid': 2881}}, 'attributes': {'CurbApproach': 'null', 'TimeWindowStart': 'null', 'TimeWindowEnd': 'null', 'Name': 'MARATHON FS'}}]}, 'token': '7a6sZjdk8Xiit1VUsERtOGf4tEHskFAyZky3_LP8J1yggoKtkpp2cvFFDo5WP3bg6imUNra7cLZZ2B9yyKhJTnRl-fe0qxcD73vL_58lLSytF00nfhoXM6K0mbp7Vt2OISbhzTfjLlpa3Y2tI5K2j17Qq5o-JXO16Bcmx7KKlgpyhDlfxnhX34umWPIi2hEr', 'returnDirections': 'false'} Same request made in Postman successful. I am running into a new error with the input above: {'error': {'code': 400, 'extendedCode': -2147024809, 'message': 'Invalid or missing input parameters.', 'details': ['Invalid input coordinates [features].']}} Only difference is that now all input coordinates you see above are in WKID 2881 (whereas before all were supplied in 102100 Complete def: def routeRequest(permitX, permitY, scX, scY, serviceCenter): routeQueryURL = 'https://route.arcgis.com/arcgis/rest/services/World/Route/NAServer/Route_World/solve' params = {'f':'json', 'stops':{'features':[{ 'geometry':{ 'x':permitX, 'y':permitY, 'spatialReference':{ 'wkid':2881 } }, 'attributes':{ 'CurbApproach':'null', 'TimeWindowStart':'null', 'TimeWindowEnd':'null', 'Attr_Minutes':0, 'Attr_TravelTime':0, 'Attr_Miles':0, 'Attr_Kilometers':0, 'Attr_TimeAt1KPH':0, 'Attr_WalkTime':0, 'Attr_TruckMinutes':0, 'Attr_TruckTravelTime':0, 'Name':'permitAppBoundary' } }, { 'geometry':{ 'x':scX, 'y':scY, 'spatialReference':{ 'wkid':2881 } }, 'attributes':{ 'CurbApproach':'null', 'TimeWindowStart':'null', 'TimeWindowEnd':'null', 'Name':serviceCenter } } ]}, 'token':tokAGO, 'returnDirections':'false'} r = requests.post(routeQueryURL, data = params, verify=False) dataM = json.loads(r.content) print (dataM) stopName = dataM['routes']['features'][0]['attributes']['Name'] miles = dataM['routes']['features'][0]['attributes']['Total_Miles'] driveTime = dataM['routes']['features'][0]['attributes']['Total_TravelTime'] return miles, driveTime, stopName

Online Status	Offline
Date Last Visited	‎01-22-2025 02:28 PM

My Ideas

Latest Contributions by JamesCrandall

Re: cx_oracle for py 3.x?

cx_oracle for py 3.x?

Re: Input geometry point spatial query

Input geometry point spatial query

Re: sdf spatial reference is empty []

sdf spatial reference is empty []

Re: Deployed ExB duplicating folder index

Deployed ExB duplicating folder index

Re: Best way to authenticate?

Re: Export to KML Widget

Re: Python API to update attributes on feature layer

Python API to update attributes on feature layer

Re: Get the feature count of all layers in a Map service using a single HTTP request

Re: Arcgis.com Route Service Invalid input coordinates

Arcgis.com Route Service Invalid input coordinates

Re: Proper REST query for epoch

iterate hosted (AGOL) table attributes

Re: Export to KML Widget

Re: Security model approaches

Re: Python API to update attributes on feature lay...

Experience Builder Custom Widgets

Web AppBuilder Custom Widgets