The Esri Community
GeoNet Resource Hub
to create and rate content, and to follow, bookmark, and share content with other members.
rolling month sum - air emissions
Discussion created by
on Dec 20, 2013
on Dec 23, 2013 by mdenil
Show 0 Likes
Has anyone calculated air emissions using rolling month average?
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Dec 23, 2013 8:58 AM
Run a search cursor through your table, and
create a dictionary keyed on each unique date.
class datetime.timedelta([days[, seconds[, microseconds[, milliseconds[, minutes[, hours[, weeks]]]]]]])
d = timedelta(days=-30)
(quick and dirty rounding all months to 30 days)
to calculate the date one month previous to that date
and use that as the dictionary entry for the key date.
Next run through the dictionary keys
selecting date <= key date and > dictionary value date (the date 1 month earlier).
on each selection
calculate the sum for the emmissions:
save it in a new dictionary (for updating the source table) or a new table.
Show 0 Likes
Retrieving data ...
Hosting Custom Widget and Adding it to Portal 10.6
Using the Explorer tool to get coordinates?
Problem encountered when exploreing the coordinate of a point in LAS file
How do I add a custom widget to a Web AppBuilder
download ArcGIS 10.4.1