Latest Contributions by MikeSweeney

What does the number 1209600000 represent and how did you come up with the value?  I think it somehow represents 14 days, but I don't know what system it is in? Thank you! if(today() - ${DateTimeCamUpdate} > 1209600000,concat('<font color="red"><i><b>',${toponym},'</b></i></font>'),concat('<font color="blue"><i><b>',${toponym},'</b></i></font>')) ... View more

A little more detail just to explain how this is set up.  As mentioned above by Mike Dagle an attribute join was done between the  Reporting Areas hosted polygon feature layer and a table named Cases based on the common value for name to create the hosted view Current Cases.   The join always returns the latest record from the Cases table because when the view was created they specified that the latest record should be joined. Here is what the Reporting Areas attribute table looks like.  It really just has a Name field. Here is what the Cases table looks like.  It has the Name field and multiple records for the reported cases (maybe one for each day, or perhaps, multiples per day).  I only ever want the latest data to be joined to the Reporting Areas to display in the Current Cases view. Here is how they created the view for Current Cases  Analysis > Summarize Data > Join Features Notice that they checked the box for  Create results as hosted feature layer view ... View more

If you mean the Cases_current hosted layer read only view that is created when deploying the COVID-19 solution, it is pointing to the Cases editable hosted feature layer that was also was created at the same time. From the Settings tab The Cases_current is used to present a read only view to the public and is used by the Community Impact Dashboard web map which is used in turn by the Community Impact Dashboard operations dashboard. In a graphic it looks like this: ... View more

Did you clone the the Python Package environment installed with ArcGIS Pro 2.5? Make the clone active and then install GeoPandas? You cannot modify the Python Package environment installed with Pro, you have to clone it and modify the clone.  That way you can always revert back to the original environment. Python Package Manager—ArcPy Get Started | Documentation  ... View more

Bernie Thanks for compiling this useful list of resources into a single source.  I will be sharing this blog post! Mike Sweeney ... View more