New York Academy of Medicine
New York Academy of Medicine (NYAM) is an exciting organization that works
to enhance the health of the public. NYAM has a very active community outreach
program called the Center
for Urban Epidemiologic Studies (CUES). As their web site states:
CUES is a
research consortium established by the New York Academy of Medicine in
partnership with the
New York City Department of Health , and in cooperation with multiple
collaborating institutions .
To support its work, CUES relies on databases that describe social service
programs such as health care, drug treatment, etc., that operate in the
neighborhoods in which CUES operates. For
example, United Way of New York City has compiled
detailed information in a database called CARES on over 2,500
agencies and 15,100 social service
A subset of the CARES database is available on the Web (see http://www.uwnyc.org/640/f.html
but not with Netscape 6).
CUES was established
to conduct collaborative, multi-disciplinary, population-based research,
with a special focus on low-income, disadvantaged populations, in order
to bring about a better understanding of diseases and other threats to
health concentrated in urban areas.
A better understanding
of diseases and other threats to health in urban areas is essential for
the development of interventions to control urban epidemics of substance
abuse, HIV and other infections, asthma, and other illnesses. Because social,
environmental, and biological influences on health status have become increasingly
more complex, the need for a cooperative effort to understand these complexities
is greater than ever.
Proposal: An Improved Social Service Program Database
In Spring 2002 a Projects team reorganized the CUES database and built
a web site to access
it (at http://126.96.36.199/jsp/nyam/cover.htm). The site enables
social service case-workers to rapidly select the the appropriate program
and facility for people in need. In particular, a search can locate
all social services for a person with multiple problems, such as a woman
who is "pregnant, a drug user, suffers from domestic violence, and needs
This project's goal is to improve the look, content, and functionality
of the web-site. Below are the main features desired:
Specified the functionality of the user interface and possible extensions.
Evaluated the database schemas of the existing provider databases, and
combined and revised the database schema to be normalized for easier access
and flexibility and re-entered most of the data into the new schema.
Prototyped a user interface which includes search capability, advanced
search capability, and new entry capability by CUES.
Built the system with an Apache HTTP Server, Tomcat JSP Server Version
4.0.2, JSP, JavaBeans and JDBC.
Develop code and security controls that would give providers the right
to update their program's information
Develop a means to allow the database to search across all 5 categories
of service at once rather than searching for services under one particular
Develop an application that would allow CUES to post free-form comments
Make all functions more uniform and create a new look for the interface
that includes graphic art.
The New York Academy of Medicine, 1216 Fifth Avenue at 103rd Street.
Company Web site
David Vlahov, Ph.D., Director, Center for Urban Epidemiologic Studies,
(212) 822-7382, firstname.lastname@example.org
Sandro Galea, MD, MPH, Center for Urban Epidemiologic Studies, (212)
Maxine L. Rockoff, Ph.D., Director, Division of Information Management,
New York Academy of Medicine, (212) 822-7373, MRockoff@nyam.org
Princess Fortin, Research Assistant, CUES, (212) 822-7388,
Resources that will be made available to students
Access to any relevant data, code and information.