Honoring our Heroes: Military Banner Program

The City of Elk Grove launched a Military Street Banner Program honoring veterans who reside in the City or resided in the City and are now deceased. The City designated 75 poles for the program. 

Interwest GIS solved the following needs for the City:  

Provide the contractor installing banners location information
Interwest created a web map of each banner's location to assist the contractor in installing the banners. 

Provide City staff a way to track the installation date of each banner with workflow reminders 
Each banner is installed for a 12 month period after which the banner is removed a new banner is printed and installed in its place. City staff needed a way to track the installation date of the banners with workflow reminders of when a banner needed to be removed so the staff could order the printing of a new banner and schedule the installation. Interwest's GIS Team created a SharePoint list that integrates with the GIS streetlight data to feed the installation map for the contractor and the public map. 

The SharePoint list contains all streetlights. Each evening an SSIS package runs and imports the data from the SharePoint list into an SDE table. A spatial view is used in the map to join the table to the streetlights layer. A script is also run nightly to update the data in ArcGIS Online so the public map is up-to-date. 

Provide the public a way to find the location of their veteran's banner
Until a custom banner has been purchased, banners honoring all veterans are displayed on the poles. A public web app was created to assist the public in searching for and locating their veterans banner. A story map was also created showing the veterans photo, name, branch, and rank.