Improve access and quality of data on development finance
The objective of the PLAID project (Project Level Aid Database) was to improve the transparency, completeness, historical accuracy, and timeliness of data on development finance. The goal was to create a highly usable tool making data available to the international development community.
Creating an accurate display of project-level aid data
2Paths defined and implemented a scalable database model, extensible web-based data entry, analysis, visualization and reporting system. The project compiled the various disparate pieces of information from multiple organizations to create an accurate display of project-level aid around the globe. As part of this, we designed and developed APIs that allow access to PLAID data. Both an internal and external interface was developed to allow different types of users to access data based upon their respective needs.
The internal interface addressed the needs of PLAID administrators and employees whereas the public interface allows any external body to access the data in a read-only fashion. A RESTful API was developed to allow third parties to search and retrieve the existing data without making use of the public user interface.
The internal interface provided a workflow to allow data entry by PLAID staff of detailed financial, operational and location information for 1.5 million foreign assistance and development projects.
Java / Grails / Groovy
MogileFS
PostgreSQL