topic Assigning water wells with producing geologic unit name/code in 3D Mapping Questions https://community.esri.com/t5/3d-mapping-questions/assigning-water-wells-with-producing-geologic-unit/m-p/827416#M493 <HTML><HEAD></HEAD><BODY><P>The overall objective of my work is to understand water quality of various aquifers. &nbsp;I have a large database of water wells (~60,000) and each well record comes with a drilled well depth but does not have a reported producing aquifer/geologic unit. &nbsp;I am relatively new to ArcMap/Scene but do have access to most extensions such as the 3D analyst.</P><P></P><P>The question would be: is there an efficient way to assign each of these 60,000 wells with the name or code of the aquifer that they are producing from? &nbsp;My thought was to have the well depth extracted as the well point's z-value and then have the various subsurface elevations of all of the aquifers&nbsp;also extracted as z-values. &nbsp;Could I use a type of script/code to do perform some nested if statements, something along the lines of: "if z-value &lt; 20 m ; Scollard ; if z-value &lt; 60 m Bearpaw ; Horseshoe"? &nbsp;<BR /><BR /></P><P>Looking for any thoughts/advice or to be steered in the right direction. &nbsp;Many thanks!</P></BODY></HTML> Wed, 14 Dec 2016 21:36:53 GMT LeahWilson 2016-12-14T21:36:53Z Assigning water wells with producing geologic unit name/code https://community.esri.com/t5/3d-mapping-questions/assigning-water-wells-with-producing-geologic-unit/m-p/827416#M493 <HTML><HEAD></HEAD><BODY><P>The overall objective of my work is to understand water quality of various aquifers. &nbsp;I have a large database of water wells (~60,000) and each well record comes with a drilled well depth but does not have a reported producing aquifer/geologic unit. &nbsp;I am relatively new to ArcMap/Scene but do have access to most extensions such as the 3D analyst.</P><P></P><P>The question would be: is there an efficient way to assign each of these 60,000 wells with the name or code of the aquifer that they are producing from? &nbsp;My thought was to have the well depth extracted as the well point's z-value and then have the various subsurface elevations of all of the aquifers&nbsp;also extracted as z-values. &nbsp;Could I use a type of script/code to do perform some nested if statements, something along the lines of: "if z-value &lt; 20 m ; Scollard ; if z-value &lt; 60 m Bearpaw ; Horseshoe"? &nbsp;<BR /><BR /></P><P>Looking for any thoughts/advice or to be steered in the right direction. &nbsp;Many thanks!</P></BODY></HTML> Wed, 14 Dec 2016 21:36:53 GMT https://community.esri.com/t5/3d-mapping-questions/assigning-water-wells-with-producing-geologic-unit/m-p/827416#M493 LeahWilson 2016-12-14T21:36:53Z