topic Summary Totals for Rain Gauges in Spatial Data Science Questions https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204053#M495 <HTML><HEAD></HEAD><BODY><P style="border: 0px; margin: 0px 0px 1em;">I have a table "SensorHistory" that has info pertaining to rain gauge data.</P><P style="border: 0px; margin: 0px 0px 1em;">My goal is to create summary information to eventually present rain gauge totals attributes such as 1 day, 7 day, 10 day, 24 day and YTD totals.</P><P style="border: 0px; margin: 0px 0px 1em;">I was wondering how to go about this in ArcMap or ArcPro so that I have 5 attributes with<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">site_id</STRONG>(see picture) and<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">receive time</STRONG><SPAN>&nbsp;</SPAN>for that day having the maximum rain gauge accumulation which would equal 11 in sensor_class?</P><P style="border: 0px; margin: 0px 0px 1em;">I assume I would have to query out the table for the given time periods and use the max statistic (receive_time) for that day to get the rain accumulation. Not quite sure how to query that either so any help is appreciated! I also would need a model builder for this so it can be easily replicated again or can be used for future readings.<SPAN>&nbsp;</SPAN></P><P><SPAN style="color: #242729; background-color: rgba(248, 248, 248, 0.6);">What I need is a summary value for each site_id listing the the max accumulations from the data_value field using on only the records that have 11 as the sensor_class value and the summary value derived based on four different date range record selections of received_time field values covering 1 day, 7 days, 24 days and all days in the given calendar year.</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 20:28:13 GMT ElisaA 2018-09-10T20:28:13Z Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204053#M495 <HTML><HEAD></HEAD><BODY><P style="border: 0px; margin: 0px 0px 1em;">I have a table "SensorHistory" that has info pertaining to rain gauge data.</P><P style="border: 0px; margin: 0px 0px 1em;">My goal is to create summary information to eventually present rain gauge totals attributes such as 1 day, 7 day, 10 day, 24 day and YTD totals.</P><P style="border: 0px; margin: 0px 0px 1em;">I was wondering how to go about this in ArcMap or ArcPro so that I have 5 attributes with<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">site_id</STRONG>(see picture) and<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">receive time</STRONG><SPAN>&nbsp;</SPAN>for that day having the maximum rain gauge accumulation which would equal 11 in sensor_class?</P><P style="border: 0px; margin: 0px 0px 1em;">I assume I would have to query out the table for the given time periods and use the max statistic (receive_time) for that day to get the rain accumulation. Not quite sure how to query that either so any help is appreciated! I also would need a model builder for this so it can be easily replicated again or can be used for future readings.<SPAN>&nbsp;</SPAN></P><P><SPAN style="color: #242729; background-color: rgba(248, 248, 248, 0.6);">What I need is a summary value for each site_id listing the the max accumulations from the data_value field using on only the records that have 11 as the sensor_class value and the summary value derived based on four different date range record selections of received_time field values covering 1 day, 7 days, 24 days and all days in the given calendar year.</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 20:28:13 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204053#M495 ElisaA 2018-09-10T20:28:13Z Re: Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204054#M496 <HTML><HEAD></HEAD><BODY><P>can you post a sample of the dataset as a *.csv file?</P></BODY></HTML> Mon, 10 Sep 2018 21:33:39 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204054#M496 DanPatterson_Retired 2018-09-10T21:33:39Z Re: Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204055#M497 <HTML><HEAD></HEAD><BODY><P>I'm not quite sure how to export a fraction as I have 200k records and excel only takes about 60k for conversion. I tried just selecting a couple hundred but it wont let me export the data as only by selected records.</P></BODY></HTML> Mon, 10 Sep 2018 22:03:42 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204055#M497 ElisaA 2018-09-10T22:03:42Z Re: Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204056#M498 <HTML><HEAD></HEAD><BODY><P>do it in ArcMap/Pro, make your selection, then Table to Excel tool, I can work from there</P></BODY></HTML> Mon, 10 Sep 2018 23:06:30 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204056#M498 DanPatterson_Retired 2018-09-10T23:06:30Z Re: Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204057#M499 <HTML><HEAD></HEAD><BODY><P>Here is a sample of my data</P></BODY></HTML> Tue, 11 Sep 2018 15:41:01 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204057#M499 ElisaA 2018-09-11T15:41:01Z Re: Summary Totals for Rain Gauges https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204058#M500 <HTML><HEAD></HEAD><BODY><P>Sharing with <A href="https://community.esri.com/space/2051">Analysis</A>‌</P></BODY></HTML> Tue, 11 Sep 2018 16:36:54 GMT https://community.esri.com/t5/spatial-data-science-questions/summary-totals-for-rain-gauges/m-p/204058#M500 JoshuaBixby 2018-09-11T16:36:54Z