Recently I had the pleasure of building a clinical search program for the BC Persons with Aids Society. It utilizes the Google maps API to assist in location searches.
A volunteer receives a phone call, clicks the Search menu and input’s the caller’s city. The map then readjusts to the Latitude and Longitude of the City which allows the volunteer to then visually locate the nearest Clinic or Clinician accepting Aids patients. This method has greatly increased the volunteer’s ability to help people in a timely manner over the phone. It has also eliminated the need for additional volunteer training in BC geography as the search keyword search is very forgiving.
In addition to this I also update their application to include the new version of the application framework which includes;
- A major security update. Better screen locking. Each menu item is individually secured as Private or Public with Security groups. I also removed a SQL injection bug and cleaned up the login process.
- Update to the messaging system
- Update to the form editing and data grid. This includes better look-up drop downs.
- Implemented new report to excel file feature.
- Implemented Database duplication for con current backups and load balancing
- Overall performance enhancements

Search screen on the BC Persons with Aids Society's HIV Care Registry





Boy Genius Report
CBC Spark
EcoGeek.org
TVO Search Engine
Y Combinator – Hacker News