The Esri Community
Services & Programs
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 ...
Uninstall 9.x License Manager
Where is the install for License Manager 10.3?
Seeking help with arcpy.Merge_management
Tips for Compressing with Existing Geodatabase Replicas
Licenses not authorizing/available