Site hosted by Angelfire.com: Build your free website today!

Crisis Navigator


Crisis Navigator is a tool for quickly identifying the providers of crisis services (emergency food, clothing, shelter) in the DC Metro area.

 

Barry Hale is developing it to help navigate through the maze of emergency services in this area and to “help the next guy” to help others who are in crisis to quickly find the services that they need. Click on Service Providers for the telephone numbers of the providers in the data base.

 

Barry describes Crisis Navigator as "an Access database with service data and client population information  in several tables":

 

Accommodation (number of beds, apartments)

ClientIntake (walk-in, by appointment, by referral, etc.)

ClientPopCircumstance (gender, age, ethnicity, homeless, low income, addict, etc.)

ClientPopLocality (service area of facility: DC Metro, Bethesda, etc.)

ClientService (services provided: emergency food, shelter, clothing, etc.)

Facility (name, address, phone, e-mail, URL)

Fee (type of fees charged)

HandicapAccess (handicap or wheelchair access)

Language (languages interpreted, translated)

 

These tables are “joined” to produce new tables of information for persons in particular circumstances.

 


EXAMPLE

 

Barry inputed his own personal circumstances (adult PG County Maryland resident with elder care, emergency food, and utility cut-off issues) into the following query

 

SELECT DISTINCT ClientPopLocality.Name, Locality

FROM Facility

INNER JOIN (ClientPopLocality

INNER JOIN (ClientService

INNER JOIN (ClientPopCircumstance

INNER JOIN (ClientIntake

ON ClientPopCircumstance.FacilityNum = ClientIntake.FacilityNum)

ON ClientService.FacilityNum = ClientPopCircumstance.FacilityNum)

ON ClientPopLocality.FacilityNum = ClientService.FacilityNum)

ON Facility.FacilityNum = ClientPopLocality.FacilityNum

WHERE ((ServiceLocalityScope < 4) OR (ServiceLocality = "PG County"))

AND

((Locality = "PG County") OR (Locality = "DC NW") OR (Locality = "DC NE") OR (Locality = "DC SW") OR (Locality = "DC SE") OR (Locality = "Montgomery County"))

AND

((ServiceLocalityScope <> 8) OR (ServiceLocalityZip = "20782"))

AND

((ServiceLocalityScope <> 7) OR (ServiceLocalityCity = "Hyattsville"))

AND

ServiceLocalityPriority = 1

AND

ServiceCategory <> "Referral"

AND

((ServiceCategoryCode = 3)

OR ((ServiceCategoryCode = 4) AND ((ServiceType = "General") OR (ServiceType = "Mental Health") OR ServiceType Is Null))

OR (ServiceCategoryCode = 8) OR (ServiceCategoryCode = 9) OR (ServiceCategoryCode = 11) OR (ServiceCategoryCode = 14) OR ((ServiceCategoryCode = 21)

AND ((ServiceType = "Social Worker") OR (ServiceType = "Crisis Intervention"))))

AND

((CircumstanceCode = 6) OR (CircumstanceCode = 20) OR (CircumstanceCode = 39) OR (CircumstanceCode = 42)

OR (CircumstanceCode = 62) OR (CircumstanceCode = 63) OR (CircumstanceCode = 64))

AND

((MinAge > 21) OR MinAge Is Null)

AND

((Gender = "M") OR (Gender = "U"))

AND

FamilyRelationship = "Individual"

AND

((AgeCategory = "All") OR (AgeCategory = "Adult") )

AND

((MaritalStatus = "Single") OR (MaritalStatus = "All"))

AND

EthnicityNationality = "All"

AND

ImmigrationStatus = "All"

AND

((IntakeMethod = "Walk-In") OR (IntakeMethod = "Appointment"))

ORDER BY Locality, ClientPopLocality.Name;

 

 

with the result

 

Calvary's Food Bank                             DC NE                  

10th Street Baptist Church                      DC NW                   

3rd Street Church of God                        DC NW                  

6th Presbyterian Church                         DC NW                  

Action for Peace Through Prayer & Aid           DC NW                  

Berean Baptist Church                           DC NW                  

Church of the Pilgrims                          DC NW                  

Foggy Bottom Food Pantry                        DC NW                  

Food For All Program                            DC NW                   

Gospel Rescue Ministries                        DC NW                  

Greater Washington Urban League                 DC NW                  

Loaves and Fishes                               DC NW                  

Lutheran Social Services                        DC NW                  

McKenna's Wagon                                 DC NW                  

Metropolitan Baptist Church                     DC NW                  

Miriam's Kitchen                                DC NW                   

Reach Out and Touch Ministries, Inc.            DC NW                  

Saint John United Baptist Church                DC NW                  

Saint Mary's Court                              DC NW                  

Salvation Army                                  DC NW                  

Shiloh Baptist Church                           DC NW                  

Comprehensive Psychiatric Emergency Program     DC SE                  

Missionaries of Charity                         DC SE                  

Salvation Army                                  DC SE                  

Washington City Church of the Brethren          DC SE                  

Adventist Community Services                    Montgomery County      

Gaithersburg Community Soup Kitchen             Montgomery County      

Islamic American Zakat Foundation, Inc.         Montgomery County      

Mobile Medical Care, Inc.                       Montgomery County      

Community Ministry of Prince George's County    PG County              

First New Horizon Food Bank                     PG County              

House on the Hill                               PG County              

Jesus Over You Ministries, Inc.                 PG County              

Martha's Closet, Inc                            PG County              

Mission of Love, Inc.                           PG County              

Patricia E. Brown Sharing Fund                  PG County              

Refreshing Spring Church of God in Christ       PG County              

Salvation Army of Prince George's County        PG County              

SHABACH! Community Service Corp.                PG County              

Sylvan Vista Baptist Church                     PG County              

United Communities Against Poverty, Inc.        PG County              

Walker Mill Community Development Corporation   PG County              

 

As indicated by the complexity of the query above much more detailed results can be obtained, such as listings of facilities serving Hispanic immigrants, or pregnant, addicted females, etc.