look into Open Referral standard

[derekeder]

To help share the data behind this project, let's look into outputting it in a format compatible with Open Referral

Here's some resources from @greggish:

• Table of elements and definitions: https://github.com/codeforamerica/OpenReferral/blob/master/Human%20Services%20Data%20Specification%20%20v1.0.md#vocabulary
• Elements and definitions in a spreadsheet: https://docs.google.com/spreadsheets/d/1u3aj5scZ6qCaTLW7Z99QokiBOw8vcPlyGGxNde2K4oA/edit#gid=0
• a 'flat' version that might be useful: https://docs.google.com/spreadsheets/d/1sqHXoPHfAQZsEFYaemYq5reaf0TWtWz2pG1cK2wbn2s/edit#gid=1867626204
• an example of CSVs for loading into the Ohana API: https://docs.google.com/spreadsheets/d/1qkysLj5MAAvaysuac_9H0hOvTAb1aJEMhUVJAECmj2c/edit#gid=595985385

[fgregg]

Hrmm...

Is there any tooling around this? Validators?

It would be attractive if there some django models that we could use to
enter the data and then bake out.

On Thu, Sep 1, 2016 at 2:46 PM Derek Eder notifications@github.com wrote:

To help share the data behind this project, let's look into outputting it
in a format compatible with Open Referral https://openreferral.org/

Here's some resources from @greggish https://github.com/greggish:

• Table of elements and definitions:
  https://github.com/codeforamerica/OpenReferral/blob/master/Human%20Services%20Data%20Specification%20%20v1.0.md#vocabulary
• Elements and definitions in a spreadsheet:
  https://docs.google.com/spreadsheets/d/1u3aj5scZ6qCaTLW7Z99QokiBOw8vcPlyGGxNde2K4oA/edit#gid=0
• a 'flat' version that might be useful:
  https://docs.google.com/spreadsheets/d/1sqHXoPHfAQZsEFYaemYq5reaf0TWtWz2pG1cK2wbn2s/edit#gid=1867626204
• an example of CSVs for loading into the Ohana API:
  https://docs.google.com/spreadsheets/d/1qkysLj5MAAvaysuac_9H0hOvTAb1aJEMhUVJAECmj2c/edit#gid=595985385

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#46, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AAgxbX16TanOV2OPuzV-GmHXOX2U84Dlks5qlyuEgaJpZM4JzD1H
.

[derekeder]

Great question.

@greggish, do there exist any validators for Oepn Referral? if not, we'd be happy to talk about helping you build some.

[greggish]

One of our volunteers, @niveditc, built a validator for an earlier version of HSDS, and i think she might be working on one for v1.0.

We're about to start an upgrade cycle to v1.1, and it's also on our agenda for that. That said, @derekeder i'd be glad to talk more...

[derekeder]

Open Referral released a new flat-file version of their spec that we should look into: https://openreferral.org/introducing-the-humanitarian-service-data-model/

If we can find a good way to translate our spreadsheet, or at least export it in this format, it would be a good step to take

[greggish]

It's experimental and as-yet-untested, I'm sure you could offer suggestions for improvements. I believe this is the actual spreadsheet template here.

cc'ing @devinbalkind

[devinbalkind]

Yes the HSDM sheet on that sheet is where we go to.

What is interesting to you about the flat sheet? Is it the single-table-ness or just the general simplicity. If you just like the simplicity and don't need everything in one table then you should also check out AirTable.com because we could make this into a 3-5 table AirTable that could have the best of both worlds.

[reginafcompton]

@derekeder

I am working on a way to make the PRM spreadsheet into OpenReferral-friendly data: https://github.com/datamade/probation-resources-open-referral

Soon, we'll want to just parse the Google doc itself....https://developers.google.com/sheets/api/quickstart/python