topic Re: Query Layer in Python Questions https://community.esri.com/t5/python-questions/query-layer/m-p/553233#M43177 <HTML><HEAD></HEAD><BODY><SPAN>Try the MakeQueryTable tool in ArcToolbox. The 'Expression' parameter is where you would put all the SQL. I haven't tested it using any SQL spatial stuff though - just tabular stuff I use to make pseudo spatial views. Be sure to return the Shape field in the query, else you only get a table view back (and not a feature layer).</SPAN></BODY></HTML> Wed, 09 Mar 2011 20:50:45 GMT ChrisSnyder 2011-03-09T20:50:45Z Query Layer https://community.esri.com/t5/python-questions/query-layer/m-p/553232#M43176 <HTML><HEAD></HEAD><BODY><SPAN>At 10, ArcMap, under File &gt; Add Data &gt; Add Query Layer, allows the user the interact directly with the underlying RDMS, i.e. SQL 2008 Spatial.</SPAN><BR /><BR /><SPAN>This function DOES allow for spatial queries, i.e. STIntersects, etc. against the RDMS.</SPAN><BR /><BR /><SPAN>Has anyone found a way to access the properties, methods, etc. of this function in Python?</SPAN><BR /><BR /><SPAN>Want to send spatial queries to SQL through geoprocessing service that is consumed in Javascript API web map app.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Wed, 09 Mar 2011 20:03:43 GMT https://community.esri.com/t5/python-questions/query-layer/m-p/553232#M43176 KeithSandell 2011-03-09T20:03:43Z Re: Query Layer https://community.esri.com/t5/python-questions/query-layer/m-p/553233#M43177 <HTML><HEAD></HEAD><BODY><SPAN>Try the MakeQueryTable tool in ArcToolbox. The 'Expression' parameter is where you would put all the SQL. I haven't tested it using any SQL spatial stuff though - just tabular stuff I use to make pseudo spatial views. Be sure to return the Shape field in the query, else you only get a table view back (and not a feature layer).</SPAN></BODY></HTML> Wed, 09 Mar 2011 20:50:45 GMT https://community.esri.com/t5/python-questions/query-layer/m-p/553233#M43177 ChrisSnyder 2011-03-09T20:50:45Z