DIY Databases are Coming

“The software revolution has given people access to countless specialized apps, but there’s one fundamental tool that almost all apps use that still remains out of reach of most non-programmers — the database.” AirTable.com on CrunchBase

Database technology is boring but immensely important. If you have ever been working on a spreadsheet and wanted to be able to click on the contents of a cell to get to another table of data (maybe the cell has a person’s name and you want to be able to click it to see their phone #, photo, email, etc), then you’ve wished for a DIY database.

I’ve been waiting for this technology for many years and am happy to report that it’s nearly arrived. Two startups are taking on the DIY database challenge from different sides:

Screenshot from 2016-01-20 18:20:27
If you can make a spreadsheet you can make a map with Awesome-Table.


Awesome-Table is a quick and easy tool for creating visualizations of data inside Google Sheets. It offers a variety of searchable, sortable, filterable views including tables, cards, maps and charts. They’re easy to embed so they are great for creating and embedding directory data onto websites. Here’s an awesome table visualization of
worker coops in NYC.


AirTable is a quick and easy way to create tables that connect to and reference each other. This allows for multi-faceted systems you can travel through by clicking on entities. For example, you can define people in one table, organizations in another, and offices in a third, and then connect them all together so a user can browse a list of people, click on an individual’s organization, and then see all that organization’s information, including its many offices. Pretty useful!

The progress of these two startups leads me to believe we’re less than a year or two away from truly lightweight, easy to use, free of cost, DIY database building systems, and an open source one not too long after that.

The increasing accessibility of database technology has a lot of implications. The most obvious one is that it will enable people to build their own information management systems for common use cases like contact directories, CRM systems and other applications that just can’t be done with existing spreadsheet technology. This will make a wide variety of solutions more accessible to people – so if you want to start or run a business, manage common information resource, or just organize personal information better, you’ll enjoy DIY databases very much.

More interesting to me is the implication that they can have for people trying to reform and democratize institutions.

If you spend time in the type of information management systems used by institutions big and small – whether it’s government agencies like the sanitation department or educational ones like high schools or universities, you’ll quickly notice that many of their most useful and critical tools are nothing more than a set of data tables (directories) and visualizations of the data contained therein (search/filterable tables, cards and maps of that data.)

Screenshot from 2016-01-20 18:19:07
Turn spreadsheets into searchable/filterable directories with Awesome-Table.

These very rudimentary but widely used internal software systems not only define the information people within that institution can access and share, but also limits them to very specific workflows that are implicitly or explicitly defined in the software. Since workflows define the work people actually do, the people who control the workflow are also people who control the workers.

If you want to change how an institution does things, you have to be able to change its information management systems. Since current database technology requires specialized software coding skills, changing these systems often turns into a bureaucratic nightmare filled with bottlenecks. First, a specific group of pre-approved people need to agree to design and fund a change, then another specific group of people need to program and implement the change, and yet another group is often tasked with training and supporting users who then have to use the updated system. That creates a lot of potential bottlenecks: executives who don’t know a change is needed or don’t care enough to fund the work; managers who don’t want to get innovated out of a job or don’t know how to design good software; technologists who don’t have the time to implement a change or don’t have the motivation to do the job right. With all those potential bottlenecks it’s easy to see why so many well funded institutions have such crappy software and archaic workflows.

When people try to improve institutions, they are often trying to improve workflows so more can get done with less time and resources. Unfortunately, the people who actually know what changes need to be made are rarely in a position to control the architecture of the databases they use to get things done.

With DIY databases, people within institutions can circumvent all these bottlenecks simply by making superior systems themselves. This can change a lot more than simply the type of information people have access to – it allows them to explore news ways of being productive.  What they’ll inevitably discover, particularly if they’re in an institution that spends a lot of time managing information, is that they can do a better job managing information than many of their bosses.

DIY databases are enabling the type of horizontal and bottom-up innovation essential not just for better functioning institutions, but also more democratic ones. Databases are the “means of production” for many information workers. When they can build and own their own ones, they’ll be able to achieve more ownership of their own work and take another big step towards being able to manage themselves.

Of course, as technology improves and creating you own databases becomes easy, the hard part will certainly become getting peers to use them.  That’s a topic for another day.

FLO Disaster Relief Software – Recommendations for NVOAD

Three and a half months ago, I attended the National Voluntary Organizations Active in Disasters (NVOAD) Convening in Elizabeth, NJ. It was a fantastic event in which people from over 50 nonprofit, mostly religious, organizations came together to network, troubleshoot the ways they were providing Sandy disaster relief, and discuss how they might better tackle disaster relief challenges in the future. The need for better information-sharing tools and techniques was obvious in every event session.

I scribbled notes and promised myself that I’d write a blog post about how the VOAD community could adopt a comprehensive information management strategy using free/libre/open-source software. The post grew in length and complexity, quickly ballooning into multiple posts, and launching Sarapis into a new knowledge management project. Three and a half months later, we have a 100+ page (and growing) wiki at DisasterRelief.FLOsolutions.org that catalogs some of the best practices for community-led disaster relief that we’ve encountered. Please check out the wiki, send us feedback and let us know if there is some information you’d like to see covered or you want to contribute.

 

The National Convening

The NVOAD national convening was organized by National VOAD (NVOAD), which is led by volunteers and staff from its 108 member organizations. There is a VOAD in every state (ex. NYVOAD) and often in large cities as well (ex. NYCVOAD) — each of which is member-run and organized using a structure similar to that of the National VOAD.

The VOAD meetings that I’ve attended have consisted of representatives of member organizations engaging in a facilitated conversation about how to overcome disaster-related issues, and then breaking out into working groups or committees to tackle specific challenges. While it was clear that the larger, better-funded organizations within the VOADs such as the Red Cross have more influence than the other organizations, there was — at least to me — a sense of horizontality and a genuine desire among participants to coordinate and collaborate with each other. Indeed, the VOAD structures reminded me more of “spokes councils” than they did traditional nonprofit organizations — which is pretty cool.

VOADs help groups “active in disasters” coordinate better. From what I’ve seen, discussions center around a range of topics, from food distribution or rebuilding homes to performing case management or analyzing policy issues. Somehow, though, they all seem to end in the same place: with a discussion about how member organizations can better share information.

In general, VOAD conversations are open, inclusive and generative: people recognize the expertise that they and others have gained from on-the-ground relief work, and eagerly share knowledge and information derived from those experiences. However, when the topic turns to software and data, the tone changes. People seem to imagine software and data to be obscure, complicated topics best left to experts — and they don’t imagine those experts to be the people in their network or the room.

Many of the VOAD members I spoke with didn’t know what software they use, told me they don’t feel empowered to make changes to their websites or software systems, and don’t think they can have a software system that meets their needs without someone spending hundreds of thousands of dollars.

It doesn’t have to be this way.

 

Go with the FLO!

The VOAD community takes pride in its DIY character. Rebuilding a house? No problem! Feeding ten thousand people a day? We’re on it!  But when it comes to websites, databases and information management systems, people become overwhelmed. Yes, databases were extremely difficult and expensive to set up 10 years ago — but things have changed. There has been rapid and sustained progress in software technology, making most common technical challenges easy to overcome with relatively simple FLO (free/libre/open-source) software.

For folks who don’t know what FLO is, a brief explanation is in order. FLO software is free (no-cost), libre (without restriction), and open (you can use, edit, modify and share its source code). Linux, Firefox, WordPress and Wikipedia are just a few of the tens of thousands of extremely popular FLO software packages being used by people everyday. FLO software, like VOADs, are developed by communities of people who work together to build systems that help people help each other. To learn more about FLO software, read this brief explanation and the “free and open source software” page on Wikipedia.

I’m confident that the more VOADs learn about FLO, the more they’ll realize how FLO solutions can help them overcome many of the information management, communication and coordination challenges they face during disasters.

Preliminary Recommendations

Through a three-pronged strategy of trainings, support group cultivation and technical strategy, VOADs can transform their approach to information management.

Software trainings: There is a tremendous need within the VOAD community for training in basic web-based software tools — especially WordPress, CiviCRM, LibreOffice and free (but not libre and open source) Gmail, Google Groups, Google Drive, Facebook, Twitter and YouTube web applications.

Data trainings: There is also a massive need for education in basic data management and sharing techniques. The VOAD community needs to create a set of standard templates for common tasks such as canvassing, volunteer intake, work order management and sharing different types of data among organizations.

Technology Support Group: The VOAD community should form a technology support working group where people can organize skill shares about various technologies useful to the community. If that goes well, such a group could also work with stakeholders to co-create a software development roadmap for local, state and national VOAD groups.

You can see a list of tools referenced throughout this blog post in the tools section of the FLO Solutions for Disaster Relief wiki.

 

Attractive, Easy-to-Use Website

Your organization should have an attractive website that is easy for anyone who knows how to use basic office applications to maintain. The technology that makes this possible is called a content management system (aka CMS).

Recommendation: WordPress
wordpress-logo-notext-rgb

WordPress

There are a number of FLO CMS systems. Our favorite is WordPress, which makes it extremely easy to create web pages, blog/news posts, photo galleries, videos, events calendars, custom forms you can use to collect email addresses, contact info, surveys, process donations, and more. Hosting a WordPress website costs between $5-$50/month depending on how much traffic the website receives.

Bottom Line

Even if your organization isn’t interested in upgrading its website, building a WordPress site is cheap and easy enough that it might be worth creating one for your own team or for a specific disaster.

 

Contact and Case Management

The one piece of technology the VOADs do “share” is the Coordinated Assistance Network system (aka CAN). CAN is a disaster case management system owned and operated by the Red Cross and developed by VisionLink, a for-profit corporation that has also built the National VOAD website and the database systems that powers many of the nation’s 211 “human service” directories. While many organizations in the VOAD community can access CAN, access is often difficult to obtain and limited in scope. Moreover, there are no readily-apparent opportunities for the community to contribute to the system’s development.

The general sentiment about CAN at the NVOAD event was that it’s a terrible piece of software, but it’s the best thing the community’s got. Even still, few organizations use it and it’s widely cited as one of the largest bottlenecks to effective disaster case management.

Some of the problems with CAN articulated during the event include:

  • It takes days, sometimes weeks, to be granted access to CAN; and many grassroots relief groups and some VOAD member groups simply don’t qualify for access. Many groups waste time and energy trying to access CAN when they could be using those resources to develop and deploy CRM systems that meet their own unique set of needs.
  • All data that goes into CAN becomes the property of the Red Cross under terms that are difficult to question or change.
  • Only CAN employees and CAN partners can perform import and export functions.
  • No one but VisionLink can modify the CAN software.

One of the first things that becomes evident to people providing disaster relief is that they need a system to manage contacts and document their interactions with at least four types of people:

  • volunteers who want to give their time
  • donors who want to give their money
  • survivors who need assistance
  • human service providers who can help people in need

CRM (customer/constituent relationship management) systems are designed to help a large and physically dispersed group of people collect information about individuals and groups, record interactions and document outcomes.

This type of tool is being used very successfully by a few VOAD member groups that I spoke with — but, by and large, the VOAD community isn’t using CRMs. Instead, most VOAD members I spoke with were either using spreadsheets or desktop-based database systems to track and manage their relationships. The few organizations that were using the CAN system for disaster case management and human services directory functionality lacked a solution for the CRM functions CAN doesn’t provide, such as volunteer and donor management.

Recommendation: CiviCRM
civilogo_triangles_only

CiviCRM

CiviCRM is a fantastic FLO case management solution, and also happens to be the world’s most popular FLO CRM system for nonprofits. A standard CiviCRM installation package can do donor, volunteer and case management, send out e-newsletters, process donations, generate event pages and maintain a directory of service providers to the public. Since CiviCRM is FLO, organizations can run it on their own servers or they can pay around $300/year for a CiviCRM specialist to install and host the software for them.

CiviCRM makes it extremely easy to build a content-based website around it since it is a component of the three most popular FLO content management systems (WordPress, Drupal and Joomla). Indeed, if your organization is already using one of these CMSs, adding CiviCRM can be extremely simple. CiviCRM can be useful for any nonprofit organization that needs to send out email newsletters, process online donations and collect contact information — so even if your organization is happy with CAN’s case management functionality, you might nevertheless want to consider CiviCRM for other common nonprofit functions.

CiviCRM could become a fantastic disaster contact and case management solution that any VOAD could use for itself and in partnership with others. And since the solution would be FLO, any organization wanting to become active in disaster relief would be able to “spin up” their own system and keep ownership over their own data. At the very least, the existence of a CiviCRM powered alternative to CAN will encourage VisionLink to be more responsive to the community of VOADs who use CAN. Of course, CiviCRM can play well with CAN by being configured to export and share data using CAN-compliant format and standards. Compliance with Federal requirements and standards is something that could also be built into a CiviCRM component, as could a basic reporting mechanism that would enable each disaster case management deployments to share basic identity information about clients to ensure that people aren’t enrolled in more than one case management system to get “double benefits”.

Bottom Line

If your organization or local VOAD group doesn’t currently have a CRM system for its basic operations such as sending our email newsletters, collecting online donations and tracking donors, then it should consider getting a CiviCRM.

National VOAD and larger VOAD groups should come together to ensure CiviCRM works well for disaster relief. I recommend pursuing the following course of activity:

  • Develop a case management template (in XML) that could be imported into any CiviCRM to turn it into a disaster case management system. Estimated cost: under $10,000.

  • Fund the development of a user interface for CiviCase configuration. There is a fundraising campaign currently underway to raise $30,000 to create a user interface that would make it much easier for people to customize CiviCase.

  • Develop capacity within the NVOAD network for managing CiviCRM hosting, either by hiring a CiviCRM expert or contracting with a provider like CiviHosting.com.

  • Run database management trainings so VOADs learn how databases can be used to solve a wide range of challenges they encounter.

 

Human Services and Referral Directories

During a disaster, relief providers need good information about where to refer victims for “human-services” assistance such as homeless shelters, mental health counselling and food pantries. Unlike local business information, which was made readily available via the internet over a decade ago, “human service” information sits locked up in proprietary database systems that not even most VOADs — let alone disaster survivors — can access.

This means disaster relief providers often have to direct people who need assistance to call their local 211 system operator and speak to a call center worker to access critical human services information. This can lead to confusion and wasted time for survivors. It also creates a problem for relief providers who want to ensure that survivors receive high-quality information and access to critical services.

VisionLink, the company that makes CAN software, is also the nation’s leading provider of proprietary 211 software — making the inaccessibility of human services information inexplicable.

Recommendations: Drupal, CiviCRM or Sahana EDEN
sandydirectory2

Directory powered by Sahana

Directory software isn’t particularly complicated. Indeed, there are a number of FLO software packages that could be used to organize and display 211 information to the public, as well as provide additional functionality like granular “agency-by-agency” permissions, calendaring, volunteer management, document management and other solutions touted by VisionLink as “what makes CommunityOS different.” Drupal and CiviCRM could both power 211 directories, as could Sahana EDEN and the Knight Foundation-funded Open211 software development project.

Of course, software is just one part of the challenge. The other critical piece is a taxonomy for organizing 211 information. Fortunately, the Open Eligibility Project has produced a FLO taxonomy for 211 information that anyone can use to organize 211 data.

With FLO software and data taxonomies available, the time is right for a group of organizations to come together to set up open 211 systems around the country. Such an effort presents an amazing opportunity for the VOADs — not only to increase information accessible to disaster relief providers, but to make “human services” information easier for everyone to access.

Bottom Line

National VOAD should ensure that 211 information is accessible during a disaster. This means having an easy-to-deploy FLO 211 directory software solution ready for when disaster strikes. This solution could be offered to state and city based VOADs immediately. A FLO 211 directory software solution could be built with CiviCRM and Drupal or with Sahana..

 

Data and Knowledge Repository

Each stage of a disaster presents a tremendous information challenge. People might disagree about what, when, where and how to share disaster related information, but it’s hard to imagine anyone will argue against better tools for data and information sharing.

Recommendation: OwnCloud and/or CKAN
ckan

CKAN Data Repository

At the most basic level, VOADs should have access to a dropbox-like file sharing system which can host both public and private files and folder systems. OwnCloud is an easy-to-deploy, easy-to-use system that could meet this need.

If a VOAD network wants to make it easy for its member organizations to benefit from the open data revolution, they can set up a CKAN “data repository”, which provides groups with the ability to upload, describe, preview, download, host and stream a wide variety of data formats. It can be used to host and organize PDFs, turn CSVs (spreadsheets) into interactive maps and serve dynamic data streams in real time to other software applications. For the more technically ambitious, it can also wrap data in an API that software developers can use to create applications, produce visualizations and build semantic information resources.

VOADs could use a data repository to share a wide variety of data and knowledge information, including:

  • information about affected areas, such as demographics, geography/geology, environmental reports, important places, and mapping layers
  • canvassing data related to individual and neighborhood needs for things like food, shelter, and health care
  • raw data about who is providing disaster relief and which populations they are serving
  • templates for managing inventory, work sites, damage assessment surveys, volunteer registration forms and other tools for disaster relief groups
  • how-to’s and trainings guides about everything from killing mold to anonymizing and responsibly sharing data

Data repositories allow users to upload both public data that can be shared with everyone, and private data that can be managed by particular users without anyone else seeing it. To prevent confidential information from being made public, the system can be configured such that all public data uploads are moderated, and only approved data sets are made public. In such a configuration, when users find incorrect data or data that shouldn’t be shared on the system, they can flag it as inappropriate so it can be taken offline. Of course, with more data tools available, it would be incumbent on the VOAD community to learn more about how to use data and data tools to improve their operations.

Bottom Line

The VOAD community needs a place to share files. The first step is to set up an OwnCloud system (which would cost well under $1,000/year) and start giving VOAD members accounts and providing trainings that show people how to use widely-accessible online tools to collect, use, analyze, permission and share data. As people become more comfortable using this file sharing system, it might make sense to set up a CKAN data repository for the VOAD community. This is the same software used by data.gov and enables much deeper data utilization functionality.

 

Inventory and Logistics Tools

Before, during and after a disaster, many VOAD member organizations turn into logistics groups with a specific set of needs that FLO software solutions can meet:

  • requesting and receiving inventory items
  • tracking inventory through multiple spaces
  • distributing inventory to people in need
  • generating reports about their activities
  • sharing up-to-date inventory information with stakeholders such as government agencies such as FEMA, nonprofit and community groups, donors and the general public
  • developing an awareness of the other relief providers in the area

Without a software tool set to help organizations meet these needs, groups are often left using spreadsheets and personal relationships to make sense of the disaster logistics environment. Many people suffer and many resources are wasted because a coordinated disaster logistics network doesn’t exist — and it very well could.

Recommendation: Sahana EDEN
sahanaedenlogo

Sahana Foundation Logo

Sahana EDEN is a FLO “disaster management system” with robust logistics functionality that can be used by participating organizations to manage their own inventory, ship and receive inventory items, track assets (like vehicles and generators), build reports for various groups, and create maps. EDEN has robust directory functionality, for individuals, organizations, facilities, victims, volunteers, projects and more, making it a great tool for organizing information within a geographic area before disaster strikes. When disaster does strike, people can find the information they need in order to be effective in the aftermath.

Bottom Line

The National VOAD should work with Sahana EDEN developers to create a generic configuration that could be deployed by its chapter organizations, and/or in response to specific disasters. Sarapis has begun this work by helping to create an EDEN system for Long-Term Recovery Organizations in NYC. We will need assistance from the VOAD community, financial and otherwise, in order to see this project through.

 

Collaborative Work Order System

When disaster creates damage over a wide area, one of the biggest challenges is coordinating the (often volunteer) work crews to clean things up. This task requires a massive amount of information sharing: from the canvassing that results in comprehensive neighborhood damage assessments, to the assignment (or self-assignment) of work teams and the tracking of work statuses so the entire network knows what has been done and where.

Recommendation: CrisisCleanup
crisiscleanup

CrisisCleanup

A new tool called CrisisCleanup distinguished itself during Superstorm Sandy relief work as an amazing solution to this challenge. It was developed by Aaron Titus, a volunteer within the Mormon disaster response community. As a part-time software developer, he saw a need for a tool that “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.” The tool’s success during Sandy was stunning: CWOS was used by over 100 organizations to coordinate nearly 30,000 volunteers fixing over 5,000 homes. What began as one person’s passion project has grown into an effort involving nearly a half dozen volunteer software developers and designers — and it is already changing the way disasters cleanup is managed.

CrisisCleanup wasn’t developed by a software group inspired by building intellectual property for themselves or a high end consulting firm: it was made by passionate people who want to help people help each other. By embracing FLO solutions, the VOAD community can encourage more of this type of innovation from a global community of do-gooders.

Bottom Line

The team behind CrisisCleanup is enthusiastic to work with VOAD. NVOAD should encourage its members to take CrisisCleanup trainings before a disaster strikes and, when it does, push member organizations to sign up for that disaster’s CrisisCleanup instance.

 

FLO Solutions for Disaster Relief

crafty_penguin

“Tux” with a Toolbox

The FLO solutions I’ve described above have been and will be continue to be used during future disasters. Some were used extensively during Sandy relief efforts, including CiviCRM for volunteer management and case tracking; Sahana EDEN for request fulfillment, inventory management and assessment tracking; CrisisCleanUp for collaborative work order management; and WordPress for fast and easy-to-use content-based websites.

If the VOAD community were to bring these tools together to make them more accessible to member organization, the entire VOAD community would benefit greatly — and so too would all the future victims of disaster for whom they serve.

This could be done by pursuing the following activities:

  • creating configurations for disaster response use cases,
  • creating a more unified interface for these tools,
  • providing some training and support for their implementation, and
  • maintaining deployments of these solutions for when disaster strikes.

Over the last few months, we at Sarapis have built out a knowledge resource for the VOAD community cataloging FLO Solutions for Disaster Relief. We have also continued to help Long-Term Recovery Groups in the New York City area access FLO solutions using best practices in knowledge management. We’re now coordinating a technology development effort that will bring together numerous FLO software communities to integrate effective FLO solutions for disaster relief. This will create an even more comprehensive set of FLO Solutions for Disaster Relief.

We’re looking for support from the VOAD community — city, state and national — for our work. Please connect with us if this post is interesting to you.

If you want to receive updates about our progress with this initiative, please sign up for our newsletter on the top right corner of this page.

If you have any questions, feel free to write a comment on this post or contact us directly.

We’re currently accepting tax-free donations through our fiscal sponsor, On The Commons. Please support our work by donating today.

The post FLO Disaster Relief Software – Recommendations for NVOAD appeared first on Sarapis.

Occupy Sandy’s FLO Databases

Have you ever been working on a spreadsheet and found that you just couldn’t get all the information you wanted into it?  Have you ever looked at the horizontal and vertical cells and wished there were—somehow—a third dimension that gave you the ability to define more stuff?  Well, that’s what databases do: they provide you with a third dimension of information, making it possible for web applications to make data so useful.

Occupy Sandy is fortunate to have access to a number of incredible database software “solutions.” The three on which I’d like to focus in this post are:

  • Sahana EDEN (located at sandyrelief.sahanafoundation.org): a “humanitarian” platform designed to help NGOs and government agencies manage disaster responses.
  • CiviCRM (located at crm.interoccupy.net): a system used for sending email newsletters and collecting information about volunteers; and
  • ShareTribe (located at occupysandy.permabank.net): a sharing platform that enables folks to post, find and fulfill offers and requests for products, services and spaces.

All three of these software solutions are free/libre/open-source (FLO), meaning they’re free to use, they have no licensing restrictions, and their source code is accessible to anyone who wants to view, use and modify it. Sahana and CiviCRM are both supported by nonprofit organizations, and all three pieces of software are developed by horizontal, non-coercive FLO communities motivated by the desire to make great software—not the desire to make a lot of money.

Sahana, deployed at sandyrelief.sahanafoundation.org
Our Sahana system can help us manage a wide variety of tasks common to disaster relief, but we only use it for a few.

requestssandyreliefCurrently, people doing comms and dispatch use the system to record requests for supplies from sites. These requests usually come in via a phone call or email. Once a request is made, people check to see if the request can be fulfilled. If so, the system generates a “waybill,” which is a PDF that has the item names, their quantity, the intended destination and the driver on it. The PDF is printed out, taken to the inventory room where someone collects the items to be shipped, places them in their car and gives the driver the waybill to show him/her where to go. When the shipment is delivered, the hope is that the site that made the request will confirm their requests fulfillment with comms, but in practical use that rarely happens. Over 400 requests have gone through the system to date, with an average of six requests being registered per day since 2013 began.

sandyreliefmapRespond and Rebuild is using Sahana to track and map their work orders. When they assess a house, they record their findings in Sahana. Using the system, they’re currently tracking over 180 work orders, each with nearly 50 variables of information. Sahana also enables them to map each work order, letting them see on a map all the jobs they’re working on, the status of those jobs, and other useful information. The system could easily be configured to provide similar functionality for all the canvassing data that’s been collected by the Occupy Sandy relief effort, but so far that information hasn’t been made available to the Sahana team. If you’d like to connect with them, please email tech@nycga.net.

There are many more ways we could use Sahana to keep Occupy Sandy organized. Some of these ideas are currently underway, while others are just suggestions at this point:

  • Organization and location information: We can use Sahana to keep records of organizations that Occupy Sandy members encounter. In these records we could map out all the places where organizations maintain facilities, add the names and contact information for people at those organizations and facilities, write notes about our interactions with them and more. This could be useful for folks involved in the NYDIS organization information update project.
  • Warehouse inventory: One of Sahana’s main features is its ability to track inventory items through time and space. We can list all the inventory in a warehouse and make it accessible to everyone with access to the system. Then people can use the Sahana system to search for items they’re looking for. This could be useful for the Coney-Childs space.
  • Asset tracking: We share a lot of high value items in the Occupy Sandy network, such as vehicles and expensive tools. We can use Sahana to create a directory of the “assets” we share in the Occupy Sandy network and indicate whether those assets are available or in use, log who is using them (including when, where and for how long), and more. This could be useful for managing vehicles and tools.
  • Canvassing Information: People have been collecting a tremendous amount of information by canvassing neighborhoods to identify needs, gaps, potential health issues and more. Sahana could make all of this data searchable, mappable and (more) actionable. If someone needs help with mold, their record can be assigned a mold workflow in which their status would move from “needs assessment” to “pending work order” to “project underway” to “project completed”. If someone lacks heat, a workflow could be created that goes from “needs heat” to “complaint filed” to “heat fixed.”  Workflows can be created and modified as needed.

CiviCRM, deployed at crm.interoccupy.net
Occupy Wall Street has been using CiviCRM for over a year to send out big email blasts (such as Your Inbox:Occupied). When Sandy hit, the folks at InterOccupy quickly created volunteer intake forms using their CiviCRM. These forms collected a bunch of information about over 10,000 volunteers for Occupy Sandy NY and thousands more for Occupy Sandy NJ.

civicrmosnjEmail newsletters and alerts are sent out to different groups of volunteers depending on how they answered questions on their intake form. This has enabled us to mobilize a tremendous amount of volunteers via email. Now, a group has emerged within Occupy Sandy called “Volunteer Infrastructure,” which is organizing to call the over-8,000 volunteers who gave us their phone numbers in order to update their info and invite them to contribute more time to the cause. It’s a promising endeavour that could bring a tremendous number of people back into the Occupy Sandy fold.

Occupy Sandy NJ has gone one step further than Occupy Sandy NY in their use of CiviCRM. OSNJ fills out a Civi form every time they get a request for assistance from someone in NJ. That information then goes into a queue monitored by OSNJ volunteers who then commit to fulfilling the request. The volunteer reports back when the request is fulfilled and can then commit to fulfilling another one. The kind folks at OSNJ have served thousands using this system and have documented how they do it with this not-very-short video.

There are many more ways we could use CiviCRM in the relief effort: for case management, event pages and RSVPs, fundraising, membership management and more. I encourage folks to check out civicrm.org to see all the ways the system can be used. If you’d like to get involved with CiviCRM use in the Occupy Sandy operation, email tech@nycga.net.

ShareTribe, deployed at occupysandy.permabank.net
In the early days of Occupy Wall Street, a group of technology-oriented activists hatched a plan to create a web application that facilitates sharing among its users. During the first months of Occupy Sandy, we finally deployed a FLO software package with the appropriate features called ShareTribe. It’s built by a community of developers centered in Finland and their intention is to create “Wordpress for Sharing”—which I think is the right idea.

permabankosdbPermaBank provides users with the ability to post offers and request items, services, rides and spaces from each other; and provides a workflow that makes it easy to do real world exchanges with messaging, commenting, and a transaction workflow that enables folks to commit to fulfilling a request and certifying that their request was indeed fulfilled. Folks who find Sahana’s administrator-oriented request fulfillment system too heavy and “industrial” might find the PermaBank system more to their liking.

Conclusion
It goes without saying that all the technology in the world is worthless without the folks in affected areas doing relief work and practicing mutual aid. A database isn’t going to muck-out a house, deliver diapers or give people the experience of personal connection. But what it will do is organize information critical for all those tasks taking place.

Some people feel weird using systems like Sahana or CiviCRM to work with data. The systems can feel awkward, impersonal and clunky, especially when you compare them to the slick applications from Facebook, Twitter and Google. But don’t be fooled by polished web apps from massive corporations—they’re providing you with the digital equivalent of a McDonald’s hamburger or Starbucks Frappuccino.

Corporations provide you with “free” web applications because they make tons of money off of your data. They absolutely, positively do not want you to run free/libre/open-source (FLO) software such as Sahana and CiviCRM because FLO software empowers people to be producers instead of consumers.

More people using WordPress (ex. occupysandy.net) means more people producing grassroots media and consuming less mainstream media.

More people using CiviCRM means more people producing online fundraising and advocacy campaigns and consuming less corporate sponsored “clicktivism”.

More people using Sahana means more people producing effective resource and supply chain management systems and consuming fewer corporate products and services.

More people using PermaBank mean more people producing money-less exchanges and consuming fewer resources.

If you’re interested in getting more involved with the FLO technologies used by Occupy Sandy, email tech@nycga.net. We need as much help as we can get.