codefordenver/projects

Shift Data REST API

Opened this issue · 5 comments

eemshi commented

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]

ZhuNikki commented

serverless.com

greggish commented

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/