topic Re: Spatial join and statistics in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/spatial-join-and-statistics/m-p/127741#M4433 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hello,<BR /><BR />I have&nbsp; tried several ways but can't find a solution to my problem and would be grateful for help:<BR />I have polygon features (houses). Inside every house I have points which represent the inhabitants. Each of the points has different attributes (e.g. age). What I want to do is assign a value (like average age, which needs to be calculated first from each person's age) to each house.<BR />Since this is supposed to be done for several areas I am using Model Builder, but I cant find any function that helps me solve the problem. <BR /><BR />Thank you!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Spatial Join has a Mean option which would average the ages of the points associated with a house if you used the One To One option with Mean as the Merge rule in the field mapping area (right click Age and access its join properties).&nbsp; You should be able to get a count from the Spatial Join also.&nbsp; Youmight have to do rounding if you want whole numbers if the age field is a double, but it should be a whole number if the age field is already a long.&nbsp; Change its type if you want fractions or don't want fractions.</SPAN></BODY></HTML> Wed, 19 Jun 2013 17:46:14 GMT RichardFairhurst 2013-06-19T17:46:14Z Spatial join and statistics https://community.esri.com/t5/geoprocessing-questions/spatial-join-and-statistics/m-p/127740#M4432 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I have&nbsp; tried several ways but can't find a solution to my problem and would be grateful for help:</SPAN><BR /><SPAN>I have polygon features (houses). Inside every house I have points which represent the inhabitants. Each of the points has different attributes (e.g. age). What I want to do is assign a value (like average age, which needs to be calculated first from each person's age) to each house.</SPAN><BR /><SPAN>Since this is supposed to be done for several areas I am using Model Builder, but I cant find any function that helps me solve the problem. </SPAN><BR /><BR /><SPAN>Thank you!</SPAN></BODY></HTML> Wed, 19 Jun 2013 17:36:25 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-and-statistics/m-p/127740#M4432 JohannaHutter 2013-06-19T17:36:25Z Re: Spatial join and statistics https://community.esri.com/t5/geoprocessing-questions/spatial-join-and-statistics/m-p/127741#M4433 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hello,<BR /><BR />I have&nbsp; tried several ways but can't find a solution to my problem and would be grateful for help:<BR />I have polygon features (houses). Inside every house I have points which represent the inhabitants. Each of the points has different attributes (e.g. age). What I want to do is assign a value (like average age, which needs to be calculated first from each person's age) to each house.<BR />Since this is supposed to be done for several areas I am using Model Builder, but I cant find any function that helps me solve the problem. <BR /><BR />Thank you!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Spatial Join has a Mean option which would average the ages of the points associated with a house if you used the One To One option with Mean as the Merge rule in the field mapping area (right click Age and access its join properties).&nbsp; You should be able to get a count from the Spatial Join also.&nbsp; Youmight have to do rounding if you want whole numbers if the age field is a double, but it should be a whole number if the age field is already a long.&nbsp; Change its type if you want fractions or don't want fractions.</SPAN></BODY></HTML> Wed, 19 Jun 2013 17:46:14 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-and-statistics/m-p/127741#M4433 RichardFairhurst 2013-06-19T17:46:14Z