codefordenver / projects

Tracking Code for Denver's projects
https://waffle.io/codefordenver/projects
11 stars 2 forks source link

Shift Data REST API #90

Open eemshi opened 6 years ago

eemshi commented 6 years ago

What is the idea

Shift operates a database that hosts data collected for internal research and feeding public facing applications, such as http://denvermetrodata.org/. The database uses Relational Database Service (RDS) Postgres Engine provided by Amazon Web Services. In order to share the data with external partners more efficiently, Shift desires to build a RESTful API on top of the RDS-Postgres Engine, which complies to Shift’s centralized security restriction.

Why

Shift Research Lab is known for conducting socioeconomic research and hosting vast amounts of data on related topics. As Shift has been advocating data democratization, with a RESTful API service, the community can access Shift’s open data inventory more efficiently, additionally as one of Shift's open data toolkit, it stitches other digital apps together, we would have more integrated data ecosystem.

Potential Partner(s)?

Shift Research Lab

Additional Background Context

Planning to begin work in September, attempt to finish by the end of 2018

Since Shift’s infrastructure is established in AWS cloud ecosystem, it’s desirable to continue leveraging services from AWS. After the initial evaluation, Lambda/API Gateway approach is highly recommended.

Must compatible with broader cloud architecture protocol where RDS reside in

Details

Champion: David Viramontes Repo: [To be filled out during exploration stage] Waffle Board: [To be filled out during exploration stage]

dviramontes commented 5 years ago

ref: https://openreferral.org/

dviramontes commented 5 years ago

Airtable template: https://airtable.com/universe/expTMdQFD5r9G6V9Y/open-referral-human-services-template

ZhuNikki commented 5 years ago

serverless.com

greggish commented 5 years ago

Hi folks, just chiming in to say that i'd be happy to chat about this if Open Referral seems relevant.

We have produced OpenAPI protocols for resource directory data that may be useful to you: http://docs.openreferral.org/en/latest/hsda/

ZhuNikki commented 5 years ago

join this waffle board https://waffle.io/codefordenver/shift-api