Skip to content
Cate S edited this page Jul 29, 2015 · 7 revisions

The Problem

LGBTQAI groups often want to provide lists of local references for businesses and healthcare organizations that are community allies. Currently, each group creates and maintains their own resource list. These lists are often cumbersome to maintain, and therefore are often out of date or poorly organized. Moreover, these groups often provide a simple list of references, without any evaluations as to how well these resources meet the needs of trans and queer individuals. Even if such evaluations are provided, it can put these community groups in an awkward spot, particularly when the evaluations are negative in tone.

The goal of this project is to create a central database that aggregates these different providers and supplements each provider with additional information that local community organizations may lack.

Individual users will be able to search and review these providers and submit suggestions for new providers in the database. Providers and their parent organizations will be able to suggest corrections to their information to ensure that is up to date, but will not have the ability to control the content of reviews that individuals have submitted.

The Solution

In short, we want to make an application that:

  • Uses curated (and easily-importable) resource lists sourced from community organizations, individuals, and resources themselves
  • Makes it searchable, tailored to an individual's
    • Location
    • Concerns
    • Insurance (including if a resource allows for sliding-scale payment)
    • And other factors
  • Makes it bookmarkable for future reference
  • Makes it reviewable
  • Makes it watchable (notifications when other individuals comment or review on it)

Administrators must have the ability to edit and update the data.

Components

There are several different components that comprise the overall functioning of RAD.

RAD Record Format - Specification used by all components

The RAD Record format is a set of data fields that outline the resource data we deal with. This format is used to transfer data between different components so that each module knows what data format to expect.

This data format is tracked in a separate repository, and the specific details of the format are described on the RAD Record Format wiki page.

External Data - CSVs and other data

RAD team members will be collecting data, often in the form of CSV files, spreadsheets, or PDFs. Team members will take this data, curate it, and assemble it into a CSV file structured according to the RAD Record format. Once a CSV file has been properly assembled, an administrator can upload this information into the main database and make any final adjustments as needed.

RAD Remedy - Web interface

This is the user-facing portion of the project. This project accepts data in the RAD Record format and extends it with supplementary information such as user accounts, categories, reviews, and geocoded location data.