topic Choosing a feature and selecting by attributes using arcpy in Python Questions https://community.esri.com/t5/python-questions/choosing-a-feature-and-selecting-by-attributes/m-p/759982#M58626 <HTML><HEAD></HEAD><BODY><P>Hey All- Let's says I have a list of state Names in a Python script:</P><P>stateNames =&nbsp;['Alabama', 'California', 'Colorado', ...]</P><P>I also have a gdb called states.gdb, that has a feature for each state: Alaska, Alabama, California, etc...</P><P>I also have an attribute value that I want to use to select certain features by attribute. Lets say its 'Fips_code' = 01007.</P><P>Using an item from my stateNames list, lets use stateNames[0] or Alabama, I want to get the Alabama feature from my states.gdb and select all of the records that have have Fips_code = 01007. Any suggestions on where to begin?</P></BODY></HTML> Wed, 01 Aug 2018 20:54:47 GMT JustinBridwell2 2018-08-01T20:54:47Z Choosing a feature and selecting by attributes using arcpy https://community.esri.com/t5/python-questions/choosing-a-feature-and-selecting-by-attributes/m-p/759982#M58626 <HTML><HEAD></HEAD><BODY><P>Hey All- Let's says I have a list of state Names in a Python script:</P><P>stateNames =&nbsp;['Alabama', 'California', 'Colorado', ...]</P><P>I also have a gdb called states.gdb, that has a feature for each state: Alaska, Alabama, California, etc...</P><P>I also have an attribute value that I want to use to select certain features by attribute. Lets say its 'Fips_code' = 01007.</P><P>Using an item from my stateNames list, lets use stateNames[0] or Alabama, I want to get the Alabama feature from my states.gdb and select all of the records that have have Fips_code = 01007. Any suggestions on where to begin?</P></BODY></HTML> Wed, 01 Aug 2018 20:54:47 GMT https://community.esri.com/t5/python-questions/choosing-a-feature-and-selecting-by-attributes/m-p/759982#M58626 JustinBridwell2 2018-08-01T20:54:47Z Re: Choosing a feature and selecting by attributes using arcpy https://community.esri.com/t5/python-questions/choosing-a-feature-and-selecting-by-attributes/m-p/759983#M58627 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/select-layer-by-attribute.htm" title="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/select-layer-by-attribute.htm">Select Layer By Attribute—Data Management toolbox | ArcGIS Desktop</A>&nbsp;</P><P>You can do it manually and save the expression, then use it by modifying the code snippet in the help.</P><P>In your case, query the states field for Alabama 'And' the FIP's field equal to your value</P></BODY></HTML> Wed, 01 Aug 2018 21:14:59 GMT https://community.esri.com/t5/python-questions/choosing-a-feature-and-selecting-by-attributes/m-p/759983#M58627 DanPatterson_Retired 2018-08-01T21:14:59Z