topic Help, Interpolation????? in Mapping Questions https://community.esri.com/t5/mapping-questions/help-interpolation/m-p/420008#M4544 <HTML><HEAD></HEAD><BODY><SPAN>Dear everyone,</SPAN><BR /><BR /><SPAN> I have the following problem: I need to calculate an average precipitation amount on a catchment using an IDW and Kriggiing interpolation. The interpolation is performed in a loop since each precipitation station contains several years of daily measurements (10000 and more interpolations). I have managed to solve this problem by overwriting precipitation value in attribute table of the station shapefile using</SPAN><BR /><BR /><SPAN>My database is described as look like: </SPAN><BR /><BR /><STRONG>Sheet1</STRONG><SPAN> is look like: column1 column2&nbsp; column3 column4 column5</SPAN><BR /><BR /><SPAN>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lon&nbsp;&nbsp;&nbsp; elevation</SPAN><BR /><BR /><SPAN> 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station1&nbsp;&nbsp; 20.1&nbsp;&nbsp; 106.5&nbsp;&nbsp;&nbsp; 34</SPAN><BR /><BR /><SPAN>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station2&nbsp;&nbsp; 20.3&nbsp;&nbsp;&nbsp; 106.8&nbsp;&nbsp;&nbsp;&nbsp; 13</SPAN><BR /><SPAN>.....</SPAN><BR /><SPAN>n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationN.....</SPAN><BR /><BR /><STRONG>Sheet2</STRONG><SPAN> is look like: column1 .... columnN</SPAN><BR /><BR /><SPAN>date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station1&nbsp;&nbsp; station2&nbsp; station3 ....stationN</SPAN><BR /><BR /><SPAN>1/1/1981&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.5&nbsp; </SPAN><BR /><SPAN>......</SPAN><BR /><BR /><SPAN>31/12/2000&nbsp;&nbsp;&nbsp; 0.9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... .&nbsp;&nbsp; 1.4</SPAN><BR /><BR /><BR /><BR /><SPAN>Thank you very much indeed.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 15 Jan 2014 15:45:41 GMT thanhnguyen_tien 2014-01-15T15:45:41Z Help, Interpolation????? https://community.esri.com/t5/mapping-questions/help-interpolation/m-p/420008#M4544 <HTML><HEAD></HEAD><BODY><SPAN>Dear everyone,</SPAN><BR /><BR /><SPAN> I have the following problem: I need to calculate an average precipitation amount on a catchment using an IDW and Kriggiing interpolation. The interpolation is performed in a loop since each precipitation station contains several years of daily measurements (10000 and more interpolations). I have managed to solve this problem by overwriting precipitation value in attribute table of the station shapefile using</SPAN><BR /><BR /><SPAN>My database is described as look like: </SPAN><BR /><BR /><STRONG>Sheet1</STRONG><SPAN> is look like: column1 column2&nbsp; column3 column4 column5</SPAN><BR /><BR /><SPAN>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lon&nbsp;&nbsp;&nbsp; elevation</SPAN><BR /><BR /><SPAN> 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station1&nbsp;&nbsp; 20.1&nbsp;&nbsp; 106.5&nbsp;&nbsp;&nbsp; 34</SPAN><BR /><BR /><SPAN>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station2&nbsp;&nbsp; 20.3&nbsp;&nbsp;&nbsp; 106.8&nbsp;&nbsp;&nbsp;&nbsp; 13</SPAN><BR /><SPAN>.....</SPAN><BR /><SPAN>n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationN.....</SPAN><BR /><BR /><STRONG>Sheet2</STRONG><SPAN> is look like: column1 .... columnN</SPAN><BR /><BR /><SPAN>date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station1&nbsp;&nbsp; station2&nbsp; station3 ....stationN</SPAN><BR /><BR /><SPAN>1/1/1981&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.5&nbsp; </SPAN><BR /><SPAN>......</SPAN><BR /><BR /><SPAN>31/12/2000&nbsp;&nbsp;&nbsp; 0.9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... .&nbsp;&nbsp; 1.4</SPAN><BR /><BR /><BR /><BR /><SPAN>Thank you very much indeed.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 15 Jan 2014 15:45:41 GMT https://community.esri.com/t5/mapping-questions/help-interpolation/m-p/420008#M4544 thanhnguyen_tien 2014-01-15T15:45:41Z