topic Re: Updating a Point Shapefile Field via a &quot;Select by Location&quot; Query in Renewable Energy Questions https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658665#M93 <HTML><HEAD></HEAD><BODY><P>Thank you very much!&nbsp; I should have known it was already solved.&nbsp; I'm going to hide my grad degree...&nbsp; LOL.</P></BODY></HTML> Wed, 18 Mar 2015 11:34:46 GMT Tracy-PaulWarrington 2015-03-18T11:34:46Z Updating a Point Shapefile Field via a "Select by Location" Query https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658661#M89 <HTML><HEAD></HEAD><BODY><P>Howdy Y'all,</P><P></P><P>I'm a research analyst with a bit of a problem:</P><P></P><P>I have a point shape file with wild animal sightings.&nbsp; It has the usual location, date, time, species, alive/dead, activity, etc.&nbsp; I had to add a new text field that indicates the county of the sighting.&nbsp; I have over 22,000 records covering the entire state of Texas.</P><P></P><P>I have a polygon shape file of all the counties in the state.</P><P></P><P>--&gt;&gt;What I want to do is update the county field in the wild animal shape file, with the formal name of the county from the corresponding county polygon shape file.</P><P></P><P>I'd like to use a SQL query-type update process; along the lines of a "Select by Location" process under the 'Selection' menu bar item. </P><P></P><P>I'm using ArcGIS Desktop version 10.2, with Spatial Analyst 10.2.&nbsp; I have a 64-bit Windows workstation, 8-core mother board and 98G of RAM.</P><P></P><P>Full Disclosure:&nbsp; I'm embarrassed to add that I actually have a graduate degree in GIS/Remote Sensing; but even while sober I haven't been able to find the right Google search combination to solve my problem.&nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Any suggestions or references to any technique would be greatly appreciated.&nbsp; Be gentle...</P></BODY></HTML> Wed, 18 Mar 2015 00:51:36 GMT https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658661#M89 Tracy-PaulWarrington 2015-03-18T00:51:36Z Re: Updating a Point Shapefile Field via a "Select by Location" Query https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658662#M90 <HTML><HEAD></HEAD><BODY><P>I believe you seek <A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Spatial_Join/00080000000q000000/">Spatial Join</A>, which will create a new point file with county attributes appended.</P></BODY></HTML> Wed, 18 Mar 2015 01:00:43 GMT https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658662#M90 DarrenWiens2 2015-03-18T01:00:43Z Re: Updating a Point Shapefile Field via a "Select by Location" Query https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658663#M91 <HTML><HEAD></HEAD><BODY><P>Check out the <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00080000000q000000">Spatial Join</A> tool. It should be exactly what you are after.</P></BODY></HTML> Wed, 18 Mar 2015 01:02:43 GMT https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658663#M91 OwenEarley 2015-03-18T01:02:43Z Re: Updating a Point Shapefile Field via a "Select by Location" Query https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658664#M92 <HTML><HEAD></HEAD><BODY><P>Thank you very much.&nbsp; It took less time to do the @#$%! spatial join than it did to write out the problem.&nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 18 Mar 2015 11:33:04 GMT https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658664#M92 Tracy-PaulWarrington 2015-03-18T11:33:04Z Re: Updating a Point Shapefile Field via a "Select by Location" Query https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658665#M93 <HTML><HEAD></HEAD><BODY><P>Thank you very much!&nbsp; I should have known it was already solved.&nbsp; I'm going to hide my grad degree...&nbsp; LOL.</P></BODY></HTML> Wed, 18 Mar 2015 11:34:46 GMT https://community.esri.com/t5/renewable-energy-questions/updating-a-point-shapefile-field-via-a-quot-select/m-p/658665#M93 Tracy-PaulWarrington 2015-03-18T11:34:46Z