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 ...
Geoprocessing Service Stops Working
Error message: "The specified file does not contain a valid ArcMap document or it was saved in a newer version of ArcGIS." I'm running 10.5 - Any ideas??
Why won't my Georeferenced JPGs draw online?
Calculating Each Cell's Area in a Raster
Connect to external secure services failing