topic Re: FeatureSet() .load Cannot open table for Load in Python Questions

FeatureSet() .load Cannot open table for Load

JamesCrandall — Sat, 11 Dec 2021 20:05:53 GMT

I've got the results of a map service query urlib2.Request setup as

jsonResult = json.load(response)

From this I am attempting to setup an in_memory FeatureSet() but it is failing when fs.load(jsronResult) with "RuntimeError: RecordSetObject: Cannot open table for Load".

The odd thing is this works if I write the jsonResult to a local .json file and then issue arcpy.JSONToFeatures_conversion() with the same exact contents as the jsonResult payload.

Anyone have similar scenario? Must be something simple I'm missing here.

Thanks!

qryLandUseURL = 'https://SomeAGSurl/MapServer/0/query'

qryLandUseParams = urllib.urlencode({'f': 'pjson','geometryType': 'esriGeometryPolygon','geometry': inGeometry,'spatialRel': 'esriSpatialRelIntersects','outFields': flds,'returnGeometry': 'true'})

qryLandUseReq = urllib2.Request(qryLandUseURL, qryLandUseParams)

response = urllib2.urlopen(qryLandUseReq)
jsonResult = json.load(response)

fs = arcpy.FeatureSet()
fs.load(jsonResult)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Edit: my original implementation works when I set the fs.load() to the url of the map service like this:

rquery = "?where={}&outFields={}&returnGeometry=true&f=json".format(rwhere, rflds)
rqueryfsURL = rtaburl + rquery
rfs = arcpy.FeatureSet()
rfs.load(rqueryfsURL)‍‍‍‍

But I need it to have an input geometry and spatialRel type instead of a simple WHERE clause.

Re: FeatureSet() .load Cannot open table for Load

JoshuaBixby — Thu, 18 Jul 2019 19:16:51 GMT

Try:

fs = arcpy.AsShape(jsonResult, True) ‍

Re: FeatureSet() .load Cannot open table for Load

JamesCrandall — Thu, 18 Jul 2019 21:19:55 GMT

Huge amt of thank you on this one. I was way off track for a good workaround, saved me bigtime.

Re: FeatureSet() .load Cannot open table for Load

JamesCrandall — Sat, 11 Dec 2021 20:05:55 GMT

Odd. The script works when I step thru it. Fails if I simply run it from start-to-finish. When stepping thru the code in the IDE, it correctly sets:

rfs = arcpy.AsShape(jsonResult, True)‍

And the feature layer that is generated contains features (resultfl > 0):

arcpy.MakeFeatureLayer_management(rfs,landuseFL)
resultlfl = arcpy.GetCount_management(landuseFL)‍‍

However, when I simply execute the script, the resultfl count = 0

Full def:

qryLandUseURL = 'https://myAGSsite/MapServer/0/query'
qryLandUseParams = urllib.urlencode({'f': 'pjson',
                                           'geometryType': 'esriGeometryPolygon',
                                           'geometry': inGeometry,
                                           'spatialRel': 'esriSpatialRelIntersects',
                                           'outFields': outFlds,
                                           'returnGeometry': 'true'
                                           })

qryLandUseReq = urllib2.Request(qryLandUseURL, qryLandUseParams)
response = urllib2.urlopen(qryLandUseReq)
jsonResult = json.load(response)
rfs = arcpy.AsShape(jsonResult, True)

landuseFL = os.path.join('in_memory','flLanduse')
arcpy.MakeFeatureLayer_management(rfs,landuseFL)
resultlfl = arcpy.GetCount_management(landuseFL)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: FeatureSet() .load Cannot open table for Load

JoshuaBixby — Fri, 19 Jul 2019 16:07:16 GMT

Put some print statements to see which step is messing up.

Re: FeatureSet() .load Cannot open table for Load

JamesCrandall — Fri, 19 Jul 2019 17:00:12 GMT

Instead of creating FeatureLayer from the AsShape result, I specified it in a CopyFeatures_management and output to in_memory instead and it likes it.

jsonResult = json.load(response)

rfs = arcpy.AsShape(jsonResult, True)

fc = arcpy.CopyFeatures_management(rfs, r'in_memory\flLanduse')