food infection case study
TRANSCRIPT
FOOD INFECTION CASE STUDY
Chapter 10
Problem Definition and Solution Approach
o There has been a flood in Pittsburgh
o Health officials need to inspect food establishments to prevent an outbreak of food infection or poisoning
o Food inspections must take place at locations in the flood zone and in the buffer zones of vulnerable populations
Data
o Data from Pittsburgh Department of City Planning, US Census Bureau TIGER, Allegheny County Health Department.
o Includes Pittsburgh buildings, neighborhoods, sidewalks, flood zone, and street center lines
o Study focus on bakeries, restaurants, grocery stores, and convenient stores
Methodology
o Geocode Pghfoodsources to create food establishment layers
o Intersect flood zone layer with each food establishment layer
o Intersect buffer layers with block centroids
Results
Total Population Age Under5 Age 65 and over
Convenience Stores 48541 2433 7841
Total Population Age under 5 Age 65 and over
Restaurants 129219 6655 21288
Total Population Age under 5 Age 65 and over
Bakeries 10301 604 1751
Bakeries
Convenience Stores
Restaurants
Discussion
o Health officials should focus on restaurants in the flood zone
o Approximately 130,000 people can possibly be affected
o Over 16% are over the age of 65