Presenting ORServices 3.0: a Complete Laravel-based Open Referral Directory Solution

I’m happy to announce that Sarapis is releasing a Laravel-based Open Referral Directory Solution (ORServices) as open source code!

This software enables anyone to create their own community resource directory information system — with a level of design and functionality that is comparable to proprietary resource directory software systems that are available on the market.

ORServices offers a mobile-friendly, geo-aware directory software with search and granular filters built with Open Referral’s Human Service Data Standard (HSDS) compliant data model. By leveraging HSDS, this system can also establish interoperability with other standardized systems, so that resource directory data can be shared among them.

Continue reading

Continue reading


Delivering Open Referral Solutions with Airtable

In 2018, with a small grant provided by the Alliance of Information and Referral Systems to the Sahana Software Foundation, Sarapis developed an Airtable template of a community resource database using Open Referral’s Human Services Data Specification (HSDS). This project responded to a need articulated by many in our community for a lightweight, easy-to-use resource database for the management of complex service directory data.

With the functionality of a basic database, and the user interface of a common spreadsheet, we hypothesized that an Airtable template could provide a workable solution for organizations and projects with very limited funding.

Continue reading

Continue reading


Stone Souping Social Service Information with Airtable

The Sahana Software Foundation makes high quality, open source information management systems for emergency preparedness, response, recovery and resilience. We were recently awarded a microgrant by Open Referral (using funding from Stanford’s Digital Impact program, with fiscal sponsorship from the Alliance of Information and Referral Services) to develop and deploy an open source system for managing community resource data in the popular AirTable platform and making it accessible via Open Referral’s Human Services Data API. Continue reading

Continue reading


Introducing the Humanitarian Service Data Model

Immediately after a disaster, information managers collect information about who is doing what, and where, and then turn this information into “3W Reports.”

While some groups have custom software for collecting this information, the most widespread tool for this work is the spreadsheet. (Indeed, the spreadsheet is still the “lingua franca” of the humanitarian aid community, which is why UNOCHA’s Humanitarian Data Exchange project is designed around the exchange of ‘flat’ spreadsheet-based data.)

During the ongoing migrant crisis facing Europe, a number of volunteer technical communities (VTCs)  in the Digital Humanitarian Network have engaged in the work of managing data about these humanitarian services. They quickly realized they needed to come up with a shared template for this information so they could more easily merge data with their peers, and also so that during the next disaster, they didn’t have to reinvent the wheel all over again. …
Continue reading

Continue reading


Preparing for the Worst, Hoping for the Best: Data Standards, Superstorm Sandy, and our Resilient Future

In the wake of Superstorm Sandy, many residents of New York City were left struggling.

Though a broad array of supportive services are available to survivors — from home rebuilding funds to mental health treatment — it’s often hard for people to know what’s available and how to access it. New York City lacks any kind of centralized system of information about non-profit health and human services. Given the centrality that non-profit organizations play in disaster relief and recovery in the United States, this information scarcity means that, for many NYC residents, recovery from Sandy never quite happened… Continue reading

Continue reading