Latest Contributions by TanuHoque

thanks @DominicReed for answering my questions here is what I'd do: create a feature class and a table in your enterprise database the feature class is for your weather stations the table is for your time series data of course, you need to have some ID field e.g. weather-station-id in both feature class and table create a by-ref feature service with the time-series table point your geoevent process to feed data to your newly created by-ref feature service in ArcGIS Pro, create a query layer using a SQL using aggregated function and joins e.g. SELECT s.*, r.Total_Rainfall FROM RAINFALL_STATIONS s INNER JOIN (SELECT site_no, SUM(rainfall_inch) AS Total_Rainfall FROM RAINFALL_TIMESERIES GROUP BY site_no) r ON s.site_no = r.site_no now you have a layer that shows weather stations with total rainfall for each stations.  you can symbolize feature appropriately share it as a map service (aka map image layer) this blog might give you a bit more details information about the later half of instructions from above. https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/dynamic-spatiotemporal-exploratory-analysis-with-aggregated-results-using-time-series-data-in-arcgis/    please let me know if you have any questions ... View more