Yard lights in our subdivision are the only means of illumination and residents are required by the covenants to keep working. As chairman of the architectural committee, one of my volunteer efforts includes driving around twice a year and record any address with a non-working light. Next step is to associate those addresses with a name on our membership list. Once that is completed, the list (excel spreadsheet) is uploaded to a service who mails a postcard to each address. With 435 potential addresses, this is a semi-annual burden.
With all the modern technology and Experts available, I am confident there must be a way to help automate this project.