topic Re: arcpy.Select_analysis - Multiple conditions for where_clause in Python Questions https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484225#M37794 <HTML><HEAD></HEAD><BODY><P>I guess 'And' is somehow correct <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" />, but I got failures without specifying a workspace first OR the full path to the source and destinations</P><PRE class="lia-code-sample line-numbers language-none"><CODE>arcpy<SPAN class="punctuation token">.</SPAN>analysis<SPAN class="punctuation token">.</SPAN>Select<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Git_Dan\npgeom\npgeom.gdb\Polygons"</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"C:\Git_Dan\npgeom\npGeo_1.gdb\x1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"A0 = 'A' And A1 = 'a'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 11 Dec 2021 21:21:36 GMT DanPatterson_Retired 2021-12-11T21:21:36Z arcpy.Select_analysis - Multiple conditions for where_clause https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484223#M37792 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>What is the proper syntax for where_clause when I have multiple conditions?</P><P></P><P>This is what I got when I exported from my model builder:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_, <BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out_feature_class = WGS_PIPE, <BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<STRONG>where_clause</STRONG> = "PIPE_DIAMETER &lt;=&nbsp;20 And SYS_ZONE &lt;&gt; 0 And OWNER = 'WDD' And USE_TYPE IN ('DIST', 'TRUNK', 'LSLATERAL', 'MANIFOLD') "</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</P></BLOCKQUOTE><P>The above returns&nbsp;me an error.</P><P></P><P>However, if I just do one condition such as the following below, it works...&nbsp;</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro" style="background: none #f6f6f6; border-left: 2px solid #cccccc; margin: 10px 0px; padding: 10px 20px;"><P>arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_,<SPAN>&nbsp;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>out_feature_class = WGS_PIPE,<SPAN>&nbsp;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<STRONG>where_clause&nbsp;</STRONG>= "PIPE_DIAMETER &lt;=&nbsp;20" )</P></BLOCKQUOTE><P></P><P>Can anyone please help? Thanks!&nbsp;</P></BODY></HTML> Wed, 06 Nov 2019 00:51:29 GMT https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484223#M37792 RayHardjadinata1 2019-11-06T00:51:29Z Re: arcpy.Select_analysis - Multiple conditions for where_clause https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484224#M37793 <HTML><HEAD></HEAD><BODY><P>'And' just looks plain wrong</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm" title="https://pro.arcgis.com/en/pro-app/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm">SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop</A>&nbsp;</P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #4c4c4c; font-family: 'Consolas','Andale Mono','Lucida Console','Monaco',monospace; font-size: 14.8px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-spacing: 0px;">"AREA" &gt; 1500 AND "GARAGE" &gt; 2</SPAN></P></BODY></HTML> Wed, 06 Nov 2019 01:03:58 GMT https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484224#M37793 DanPatterson_Retired 2019-11-06T01:03:58Z Re: arcpy.Select_analysis - Multiple conditions for where_clause https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484225#M37794 <HTML><HEAD></HEAD><BODY><P>I guess 'And' is somehow correct <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" />, but I got failures without specifying a workspace first OR the full path to the source and destinations</P><PRE class="lia-code-sample line-numbers language-none"><CODE>arcpy<SPAN class="punctuation token">.</SPAN>analysis<SPAN class="punctuation token">.</SPAN>Select<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Git_Dan\npgeom\npgeom.gdb\Polygons"</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"C:\Git_Dan\npgeom\npGeo_1.gdb\x1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"A0 = 'A' And A1 = 'a'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 11 Dec 2021 21:21:36 GMT https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484225#M37794 DanPatterson_Retired 2021-12-11T21:21:36Z Re: arcpy.Select_analysis - Multiple conditions for where_clause https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484226#M37795 <HTML><HEAD></HEAD><BODY><P>Thank you! This works</P></BODY></HTML> Wed, 06 Nov 2019 16:34:10 GMT https://community.esri.com/t5/python-questions/arcpy-select-analysis-multiple-conditions-for/m-p/484226#M37795 RayHardjadinata1 2019-11-06T16:34:10Z