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. LUresult.json.zip

Try: fs = arcpy . AsShape ( jsonResult , True )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

FeatureSet() .load Cannot open table for Load

JamesCrandall

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 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'https://SomeAGSurl/MapServer/0/query'</SPAN>

qryLandUseParams <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'geometryType'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'esriGeometryPolygon'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">:</SPAN> inGeometry<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'spatialRel'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'esriSpatialRelIntersects'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'outFields'</SPAN><SPAN class="punctuation token">:</SPAN> flds<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'returnGeometry'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'true'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>

qryLandUseReq <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>qryLandUseURL<SPAN class="punctuation token">,</SPAN> qryLandUseParams<SPAN class="punctuation token">)</SPAN>

response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>qryLandUseReq<SPAN class="punctuation token">)</SPAN>
jsonResult <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>

fs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FeatureSet<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fs<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>jsonResult<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

rquery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"?where={}&outFields={}&returnGeometry=true&f=json"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>rwhere<SPAN class="punctuation token">,</SPAN> rflds<SPAN class="punctuation token">)</SPAN>
rqueryfsURL <SPAN class="operator token">=</SPAN> rtaburl <SPAN class="operator token">+</SPAN> rquery
rfs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FeatureSet<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
rfs<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>rqueryfsURL<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

LUresult.json.zip

Encuentra más publicaciones etiquetadas con

Accepted answers

bixb0012

Try:

fs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AsShape<SPAN class="punctuation token">(</SPAN>jsonResult<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

JamesCrandall

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')

bixb0012

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

JamesCrandall

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 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AsShape<SPAN class="punctuation token">(</SPAN>jsonResult<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>rfs<SPAN class="punctuation token">,</SPAN>landuseFL<SPAN class="punctuation token">)</SPAN>
resultlfl <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>landuseFL<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

Full def:

qryLandUseURL <SPAN class="operator token">=</SPAN> <SPAN class="string token">'https://myAGSsite/MapServer/0/query'</SPAN>
qryLandUseParams <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN>
                                           <SPAN class="string token">'geometryType'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'esriGeometryPolygon'</SPAN><SPAN class="punctuation token">,</SPAN>
                                           <SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">:</SPAN> inGeometry<SPAN class="punctuation token">,</SPAN>
                                           <SPAN class="string token">'spatialRel'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'esriSpatialRelIntersects'</SPAN><SPAN class="punctuation token">,</SPAN>
                                           <SPAN class="string token">'outFields'</SPAN><SPAN class="punctuation token">:</SPAN> outFlds<SPAN class="punctuation token">,</SPAN>
                                           <SPAN class="string token">'returnGeometry'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'true'</SPAN>
                                           <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>

qryLandUseReq <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>qryLandUseURL<SPAN class="punctuation token">,</SPAN> qryLandUseParams<SPAN class="punctuation token">)</SPAN>
response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>qryLandUseReq<SPAN class="punctuation token">)</SPAN>
jsonResult <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>
rfs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AsShape<SPAN class="punctuation token">(</SPAN>jsonResult<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

landuseFL <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'in_memory'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'flLanduse'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>rfs<SPAN class="punctuation token">,</SPAN>landuseFL<SPAN class="punctuation token">)</SPAN>
resultlfl <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>landuseFL<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesCrandall

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

bixb0012

Try:

fs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AsShape<SPAN class="punctuation token">(</SPAN>jsonResult<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.