Archive for category Disaster Recovery

Downloading Membership Data CSV

Due to unfortunate abuse, the Church has generally disabled the ability to download membership data in CSV (Excel) format. Church technical support will tell you that this feature is completely disabled. That’s not quite true. Stake clerks (and ONLY stake clerks) have this ability. Here is how to download Membership data in CSV, after you have received authorization from your Stake President.

1. Log in to

Hopefully you know how to do this step.

2. Go to the Directory

Click Directory, then choose the ward you wish to export, then click the “Export Households” link.

Only Stake Clerks will see the “Export Households” function.

3. You Must Download Each Ward Separately

The church makes it really hard to export data, and you must export each ward individually. Clicking on “Stake Information” will give you no membership data. If you have 10 units, you will need to do 10 downloads.

4. Yes, I will Use it Only as Directed

I care about privacy a lot (I’m a privacy attorney). I will use the data only as directed, and destroy it after about a month. Someday I’d really like to build a Crisis Caller API so that zero membership data ever leaves church servers, and you view the map through But I can’t do that today.

Be sure to get authorization from your Stake President before doing this. Call me at (202) 669-2969 with questions/ concerns.

5. Save the Files. Do not Open.

You will be prompted to either save or open the file. Click “Save” or “Save as…,” depending on your browser. Be sure to save the files in a place you know; do not open them. Warning: The files might automatically download to a default folder, such as your “downloads” folder.

6. Email to aaron [at]

Attach the files to an email, and put the name of the stake in the subject line.

No Comments

Crisis Caller: Example Script

Here is the script your members will hear when they pick up the phone:

  1. On behalf of your stake president of The Church of Jesus Christ of Latter-day Saints, we are calling to see how the hurricane has affected you. We may not be able to help, but we will try. The information you give will be shared with church and civic leaders. If you are having an emergency, hang up and dial 911.
  2. If you are safe and have no damage, press 0.
  3. If your power is out, press 1.
    • How much stress is the power outage causing? On a scale from 0-9, press 0 if you have no stress or complications, and 9 if you have extreme stress or complications.
  4. If you have evacuated, press 2.
    • Be sure to leave a message with your location. On a scale from 1-9, where 1 means “safe,” and 9 is “very unsafe,” how safe are you?
  5. If your home is flooding, press 3.
    • How many feet of water are in your home? Press the number on your phone.
  6. If you have downed trees, press 4.
    • How many trees are down? Press the number on your phone.
  7. If you have other damage, press 5.
    • On a scale from 1-9, how much damage have you experienced, where 1 is minor damage and 9 is extreme damage?
  8. To hear this message again, press star.
  9. [After entering data] Your entry has been recorded. If you would like to leave a public message with more details, press 1. If not, you may hang up. Thank you, and please stay safe.
    • Press 1 to accept your message. Press 2 to listen to it. Press 3 to re-record it. Thank you for sharing this important information with us. Please stay safe. Goodbye.

No Comments

Recovery Website

At the request of Elder Jeffery Olson, Area Seventy for The Church of Jesus Christ of Latter-day Saints, I recently created a hurricane recovery website for church, which digests disaster recovery principles, tactical guidelines, checklists, and frequently asked questions for stake presidents, bishops, recovery leaders, visiting stakes, and volunteers.

This information was shared with Salt Lake, and will be used as the basis for church-wide disaster preparedness and recovery materials.

I’m looking for volunteers to help translate the material to Spanish and Mandarin.

No Comments

The Paradox of non-Profit Innovation

Cross-posted here.

Are we there yet?

As Project Manager for Crisis Cleanup, the most frequently asked questions I receive are, “When will it be done?” or “How much money do you need to finish Crisis Cleanup?” A variation on this is, “Well, it works, right? Why do you need more money if it works?”

That’s the problem with innovating (especially non-profit innovation). If you simply explain the idea, nobody takes you seriously. You just have to execute and show everybody a “finished” product. Only then do they see how amazing your idea was. But then you’re in a catch-22. After all, if you built your idea without any help, why do you need help to keep going?

I feel a bit like I just built the Model-T Ford in a world of horse and buggies. Most people could not have conceived of the automobile until they saw it for the first time. Everyone is amazed at the technological marvel, and it is received gratefully and with congratulations. But they don’t understand that they really need an airplane or a rocket. I’m trying to build a rocket, not a Model-T Ford. But to people who are still figuring out how to dismount their horse and use a clutch, a rocket is inconceivable.

Thus, the paradox of innovation continues: Lack of vision and inertia perpetuates inefficiency, which stifles vision.

Quit Whining and Get some Funding

I am do-gooder number 14,000,001 who has thought, “all I need is some funding, and I can really change the world.” Sigh.

In a free market, for-profit ventures can attract funding and resources once you write a compelling business plan. There is at least one consistent pattern to all business plans: You create value for customers, and extract value from those customers—making a profit in the process.

But free markets don’t do very well at helping victims or survivors. First, you can’t treat victms as customers, because extracting value directly from victims (e.g. victims of natural disasters, victims of identity theft, victims of crime, etc.) is unseemly, unethical, or illegal. As a result, interested third parties such as the government or philanthropic organizations must provide the value on behalf of the victims and survivors. But because we live in a liberty-preserving society, these interested third parties are not permitted to make a profit off victims, with the possible exception of lending institutions.

Principles of insurance and market pressures dictate that victims are restored to the minimum degree necessary to prevent (costly) social disorder. Under no circumstance are they, or the people who help them, ever made completely whole or come out ahead.

This reality stands in contrast to the business world, where I can negotiate a high salary if I can make the business even more. But natural downward pressures on do-gooders’ salaries means that nobody (honest) gets rich from just helping victims. As a result, most people who help survivors aren’t driven by money (which is OK with me, because it means that the disaster recovery community is filled with some of the best people on earth).

Tilting Against Windmills

I’ve learned that competing for grant money is a bloodsport. I’m not saying that a grant is impossible, I’m just saying that for me, holding down a full-time job, raising a family (number 6 will arrive in September), church service, while managing the development and deployment of Crisis Cleanup is enough to keep me occupied without tilting against grant-writing windmills as well. I was turned down by the Robin Hood Foundation; dealing with the American Red Cross was perhaps the most Kafkaesque experience of my life, and I have yet to hear a peep from the Knight Foundation.

And that brings me back to the paradox of innovation. Poor vision and inertia perpetuates inefficiency. Unfortunately, most grant-writing organizations aren’t exactly known as bastions of innovative vision. I hope there are some out there, among all of those windmills.

So, if somebody finds a cutting-edge innovative government agency or philanthropic organization with extra grant money that will pay more than they have to on behalf of survivors (now that’s a compound oxymoron if I’ve ever seen one), let me know. In the meantime, I’ll be in my basement tinkering with rocket parts.

No Comments

Disaster Recovery Collaborative Work Order System

Update 24 Mar 2013: I have Finally launched the Official Crisis Cleanup Blog, including a more up-to-date version of this post.

Over the past several months a few developers and I have created a Collaborative Work Order System for disaster recovery (now at, Twitter: @CrisisCleanup). The project is open source under the Apache 2.0 License, and is a gift to the community. The system is now being used to manage recovery efforts in Connecticut, New York, New Jersey, Mississippi, and Georgia. The National VOAD will formally adopt/assume the project in May at the National VOAD conference. Many thanks to the dedicated work of Andy Gimma, Jeremy Pack, Chris Wood and dozens of others who have made this volunteer effort more successful than I could have ever imagined at the outset.

The platform implements a “Craigslist” philosophy to recovery efforts—organizations that are aware of work orders enter them into the system, and organizations with capacity to help can claim and perform the work without interference from any centralized organization. This minimizes duplication and maximizes communication, coordination, and efficiency.

No single organization can guarantee that any of the individuals in the system will be served. However, using the same system will permit inter-agency coordination, situational awareness, and help participating organizations prioritize their limited resources. And sharing work order information among dozens of organizations maximizes the chances that a client will receive help.

As of right now, more than 90 relief organizations and agencies with more than 30,000 combined volunteers are using the system to coordinate Hurricane Sandy relief efforts. The system is managing more than 4,900 homes in need of gutting and rebuilding from Connecticut, Long Island, New York, New Jersey, Mississippi and Georgia.

There are three requirements for an organization to participate in the system:

  1. An organization must have a physical presence in the disaster area.
  2. An organization must either perform home assessments and/or perform gutting, mucking-out, debris removal, mold abatement, or rebuilding.
  3. An organization must be reputable. This generally means that the organization must be non-profit, or a member of National VOAD, a state VOAD, a County VOAD/COAD, a local government agency, or come recommended by a VOAD member or government agency.

The current implementation requires a password. However, I have posted a training video that explains how the system works. I’ve also included screenshots below.

Philosophy Behind and Limits to the Collaborative Work Order System

The system is based upon a few foundational philosophies:

  • Retired Admiral Thad Allen observed that in the military, they operate under a “Unity of Command,” but in private sector disaster recovery, the best you can hope for us “Unity of Effort.” This tool facilitates Unity of Effort without striving for the mirage of private sector Unity of Command.
  • I don’t want to be in charge of your organization’s activities, or tell you what to do.
  • The system should enable, not interfere with your existing business processes.
  • No single organization should be in charge of others without their consent.
  • The system should make collaboration and communication not only convenient, but required.
  • This is not the “One App to Rule them All.” Do not stray too far from the system’s strengths.
  • The system is open (but not public), and should therefore not contain sensitive personal information.

App Development Philosophy

There are two approaches to app development. The first is to create a mammoth, fully-integrated system that tries to be all things to all people. Sahana is a great example of this approach. However, even the most successful of these apps can be overwhelming and tend to be a jack of all trades but master of none.

The second approach is to try and create a relatively lightweight app that does only one thing very well. These apps are generally far more user-friendly; but their success comes with a cost. Without careful curation, these apps can be highjacked, forced to do things outside their core competency, and grow into unwieldy mammoths.

The Collaborative Work Order System definitely falls into category 2. There is no such thing as “The One App to Rule Them All,” and this is no exception. The Collaborative Work Order System excels at coordinating tens or hundreds of thousands of volunteers from multiple organizations, to thousands or tens of thousands of work order sites across a large geographic area; improving communication, and improving inter-organization coordination. But there are certain things for which it should never be used.

For example, because the system is open (but not public—there is an important difference), it is inappropriate to use the system to store sensitive personal information. The system’s power to coordinate and facilitate communication comes from its openness; but some things were not meant to be shared, such as confidential case management information, volunteer details, etc. The Collaborative Work Order System is not, and can never be, all things to all people. The Collaborative Work Order System should never be used to store sensitive personal or case management information.

Why a Collaborative Work Order System Hasn’t Been Developed Before

In the disaster recovery community, we talk a good deal about VOAD’s 4Cs: Cooperation, Communication, Coordination, and Collaboration. One reason these ideals are so difficult to achieve is because, even though we don’t like to admit it, most disaster recovery organizations are essentially competitors. Of course, we all get along in the field, forging deep and lasting friendships while we labor side-by-side in the service of our fellows in distress. But almost all relief organizations (with exceptions like Mormon Helping Hands and Occupy Sandy) rely upon grants to fund their operations.

Passive competition for scarce grant resources means that every organization wants to be in charge. In an effort to qualify for the next grant, each organization strives to direct the work of other organizations and, most importantly, each organization wants to control the flow of information. These tensions create natural barriers to the 4Cs.

In addition, organizations with employees have a tendency to perpetuate inefficiency. Even though efficiency saves the organization money, efficiency may also eliminate jobs. Therefore, most bureaucracies are suspicious of or downright hostile towards new or efficient technologies.

In short, a collaborative work order system hasn’t been developed until now because: 1. Everybody wants to be in charge; and 2. Internal bureaucratic interests run counter to efficiency.

My Unique Opportunity

First, allow me to start with a disclaimer: The Collaborative Work Order System is neither developed nor formally endorsed by The Church of Jesus Christ of Latter-day Saints/ Mormon Helping Hands, and this blog post represents my own opinion and not the official position of the Church. In my role as New Jersey VOAD representative for the Church, I have had a wonderful opportunity to tackle these difficult problems during Hurricane Irene, the June 2012 derecho storms, and Hurricane Sandy. First, because Mormon Helping Hands relief efforts do not rely on government grants, it has no economic incentive to be “in charge” of other organizations. We just want to help everyone get the job done.

As a result, I designed the system so that no single organization is capable of controlling the information or governing other organizations without consent. The technology permits, but does not require oversight. Who is in charge? The answer to that question is the same as this question: “Who is in charge of Craigslist?”

This non-threatening approach is designed to facilitate an organization’s existing business processes, rather than impose new processes. As Joseph Smith taught, people can “govern themselves” when they operate according to correct principles. And based upon the participation of more than 90 organizations, the approach works.

Second, unlike most other relief organizations, Mormon Helping Hands relies exclusively on volunteers with families and full-time jobs. Unlike employees, volunteers have a natural inclination to work efficiently, and are therefore more open to adopting disruptive or efficient technologies. Mormon Helping Hands volunteers (as well as Occupy volunteers) don’t get paid, and if they’re anything like me, they must hold down a full-time job make time to see their wife and five cute kids. Volunteering efficiently improves my personal bottom line.

Real Innovation

The Collaborative Work Order System’s technology is not new or particularly innovative. Due to the great work of developers like Jeremy Pack, the user interface is great, but not groundbreaking. In fact, if I leave you with the impression that the Collaborative Work Order System is just a cool technology, then I have failed. This system does not evangelize technology; it evangelizes a philosophy.

The real innovation of this system is the ability to coordinate tens of thousands of volunteers from dozens of organizations to thousands of sites after a disaster. The Collaborative Work Order System proves that it is possible to create a near frictionless technological platform where inter-organization Cooperation, Communication, Coordination, and Collaboration is not only convenient, but required.

Next Steps for Development

Since launching, the mostly volunter-driven project has received a lot of attention from FEMA, and VOADs across the country. If all goes well, I intend to give long-term stewardship of the project to National VOAD, which will be in a better position to evangelize and maintain the project long-term.

In the meantime, we’re working on some big upgrades. Well, they won’t look big to end users, but they require some heavy lifting in the database. Here is a current list of development priorities:

  1. Create a new Incident on the fly
  2. Streamline joining, and allow organizations across the country to join during peacetime.
  3. Adapt the tool for Long-Term Recovery (LTR) including Rebuilding and Refurbishing.
  4. Import Work Orders
  5. Public-facing, de-identified and blurred map
  6. Duplicate work order detection and merging
  7. Fully-functional administrative back-end
  8. Create a Mobile interface
  9. Manage Spontaneous Unaffiliated Volunteers (SUVs) and connect SUVs with volunteer organizations
  10. Enable a separate “Canvassing” map that will allow others to see which areas have been canvassed, and which have been ignored
  11. Send Text Messages to Team Leaders with Work Order Information
  12. More easily contact other organizations in the field
    1. As you can see, we have a long list of high priorities. We’re making slow progress, but hopefully we’ll be able to get some funding to continue development.

      Participating Organizations

      The following organizations are or have participated in the Collaborative Work Order System:

      Adopt A House MHH-Philadelphia PA Stake
      All Hands Volunteers MHH-Plainview NY Stake
      American Baptist Men USA MHH-Queens NY Stake
      AmeriCorps St. Louis MHH-Scotch Plains NJ Stake
      Americorps VRC MHH-Valley Forge PA Stake
      Bergen County VOAD MHH-Westchester NY Stake
      Carolina Baptist Relief MHH-Williamsport PA Stake
      Catholic Charities, Diocese of Camden MHH-Wilmington DE Stake
      Christian Aid Ministries MHH-York PA Stake
      Convoy of Hope MHH-Yorktown CT Stake
      Durand Masonic Lodge Nassau County Office of Emergency Management
      Friends of Rockaway-World Bank NECHAMA
      GNJAC Methodist ERT Never Alone, Never Afraid Inc.
      GNJUMC – Methodist ERT New York Cares
      Habitat for Humanity of Bergen County NJ 211
      Habitat for Humanity, Westchester County Chapter NYAC United Methodist Church
      Health and Welfare Council of Long Island Oceanport NJ OEM
      ICNA Relief Poured-out
      Inc. Village of Patchogue Presbyter of Elizabeth Disaster Recovery Team
      Islamic Relief USA Rebuilding Together Bergen County
      Jersey Cares Rebuilding Together NYC
      Lamb’s Chapel Regional Catastrophic Planning Team
      Lindy Manpower Respond and Rebuild
      Long Island Volunteer Center Samaritan’s Purse
      Lutheran Disaster Response Sayville Chamber
      Lutheran Social Ministries of NJ-Lutheran Disaster Response Staten Island Council of Churches
      Mastic Shirley COAD Team Rubicon
      Mennonite Disaster Service Tennessee Baptist Disaster Relief
      MHH-Brooklyn NY Stake The Bonner Center
      MHH-Buffalo NY Stake The Salvation Army – Suffolk
      MHH-Caldwell NJ Stake UMCOR
      MHH-Centreville VA Stake United Methodist Church
      MHH-Cherry Hill NJ Stake United Way 2-1-1 Hudson Valley
      MHH-Columbia MD Stake United Way of Central Jersey
      MHH-Dover DE Stake United Way of Monmouth County
      MHH-East Brunswick NJ Stake United Way of Northern NJ
      MHH-Frederick MD Stake Virtua
      MHH-Lynbrook NY District Volunteer Army Foundation
      MHH-Morristown NJ Stake Washington State Conservation Corps
      MHH-New Haven CT Stake World Cares Center
      MHH-New York NY Mission World Renew Disaster Response
      MHH-New York NY Stake Zakat Foundation of America
      MHH-Paterson NJ District  


      1. Scope of Project: The system is primarily focused on the assessment, gutting, and rebuilding phases of recovery. It does NOT handle case management, inventory control, or volunteer management, etc. However, it will track volunteer hours.
      2. Can the system be adapted outside of the New York/ New Jersey area? Yes. The system is geographically agnostic.
      3. How much does the system cost? I don’t charge (and don’t plan on charging) organizations to use the system. In addition, the code is free to download, adapt, and install. It is open source, provided under the Apache 2.0 license, and was created by volunteers. Although the code is free, hosting and programming is not. Hosting costs vary from $50-$200 per month, depending upon usage. Ongoing programming support will also require funding. Right now a generous volunteer is paying for the hosting out of his own pocket, and volunteer programmers have created the system. I will probably need a long-term funding source.
      4. Have you considered crowdsourced funding? Yes, I’ve considered everything, including crowdsourced funding. But I only have so many hours in each day, and when I’m not cleaning up a hurricane or being a dad, I have a pesky full-time job to maintain. If you’d like to help get funding, drop me a line.
      5. Can I install a version for myself? Yes, but I wouldn’t recommend that right now. You’ll need your own developer, and because the system is being improved, you’ll have to manually install all new patches as they come out. Instead, the system will be designed to handle any number of new incidents as they arise. You will be able to create a new incident in the existing system, any time.
      6. What if a disaster happened tomorrow in my state? Could we use this system? Short answer: Yes. Long answer: Right now it will take 6-12 hours to set up a new incident in the system. We’re making programming improvements that should turn around that time to near zero.
      7. What are the long-term plans for the system? The code will always be open source and available to anyone who wants it. I hope to be able to offer the service for free to any voluntary organization who needs to use it, also. But I’m making this up as I go along, and I feel like I’ve been constructing an airplane while in free-fall, writing the owner’s manual and giving status updates for the past 2 1/2 months.
      8. Will the system do case management? No. Because of the open nature of the system, it is not appropriate to store or track confidential case management information using this system. The system is primarily focused on the assessment, gutting, cleanup, and rebuilding phases of recovery. It does NOT handle case management, inventory control, volunteer management, etc. However, it will track volunteer hours.
      9. Will the system adapt for long term recovery? Yes, with limits. We are adapting the system to do long term recovery for property, but not other aspects of LTR, such as case management.
      10. What does the system do best? The system is designed to organize and coordinate tens or hundreds of thousands of volunteers from multiple organizations, to thousands or tens of thousands of work order sites across a large geographic area; improve communication, and improve inter-organization coordination. It has been successfully used to deploy more than 30,000 volunteers during Hurricane Sandy, and manage more than 4,600 work order sites.
      11. Will this system manage Spontaneous Unaffiliated Volunteers (SUVs)? No, not really. Because the system includes location and contact information for clients, it would not be prudent to allow the entire public to access the system. Consequently, SUVs must first affiliate with an organization before using the system.
      12. This system is great! Can you make it do something else?: Yes! If you give me a programmer (or a grant), it will be done tomorrow. Until then, the answer is probably “not for a while,” but there is probably a workaround that will get the job done for now.
      13. Bugs: We’ll fix bugs as volunteer programmers have time.
      14. How do I…? I cannot provide technical support. I have found that the training video answers 95% of questions. Please watch it. If you figure out how to do something, chances are someone else would like to hear about it. PLEASE email me your how-to, and I will include it in the knowledge base.
      15. Will you give me a report? No. I’ll probably give you a username and password and let you pull your own reports.
      16. Information for Programmers: The source code is released under a Apache 2.0 License. Here is a list of open issues. Please grab a bug, submit a patch, and start working!
      17. Programmer Skill Set: Python, Javascript, with Google Maps familiarity. Familiarity with is beneficial. I also need help developing the database schema, and laying a good foundation for others to build upon.

      I’m in desperate need of volunteer programmers. I feel like I’ve been constructing an airplane while in freefall, writing the owners manual and giving hourly status reports for the last 1 1/2 months. We’re now gliding, but I need help building the rudder, landing gear, and gas gauges. Please comment below if you’re interested in helping out. Thanks!


1 Comment