ESRI 2005 Health GIS Conference Health Effects Near USEPA Toxic Release Inventory (TRI) Sites Presented By:
Allan C. Harris Harris-Brown & Associates
[email protected] October 25th, 2005 Harris-Brown & Associates Copyright July 31, 2005
[email protected] 1
Health Effects Near USEPA Toxic Release Inventory (TRI) Sites This study uses Remote Sensing and Geographic Information Systems with visualization algorithms for an innovative Land Use / Land Cover (LU/LC) computer model of the 2004-2005 U.S. EPA Environmental Justice Action Plans. The LU/LC computer model compares/analyzes environmental health-effects near toxic release sites with geographic, demographic, and socioeconomic data from the U.S. Census 2000, and community Sourcebook America data from ESRI Business Information Solution. This presentation extends President Clinton’s February 1994 Executive Order 12898 on Environmental Justice; the revised U.S. Environmental Protection Agency Environmental Justice Action Plans; the American Society for Testing and Materials (ASTM) Phase I Environmental Site Assessment requirements; and the United States Geological Survey (USGS) Land Use/Land Cover (LU/LC) classification system created to be& Associates used with satellite data. Harris-Brown Copyright July 31, 2005
[email protected] 2
Harris-Brown & Associates The U.S. Environmental Protection Agency (EPA) Toxic Release Inventory (TRI) Database and other databases used herein contain information used to derive health effects data derived from actual published information. The Author has manipulated the data and applied certain assumptions, however, assumptions applied and actual outcomes may vary between interpreters and analyst of similar data. The Author does not invite others to rely on this data and suggests using professional judgment when interpreting any results contained herein. Copyright July, 2005 Harris-Brown & Associates
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 3
REFERENCE DATABASE:
ESRI Free Demo Software: GIS Solutions for Health and Human Services
• The Demo Databases Major Diagnostic Category (MDC) for each U.S. Zip code show health demand estimates for 2002 and projections for 2007 for a sample data • Shows the expected number of circulatory conditions for the targeted years for each Zip Code MDC. Harris-Brown & Associates Copyright July 31, 2005
[email protected] 4
ESRI Free Demo: GIS Solutions for Health and Human Services Major Diagnostic Category (MDC) Data
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 5
ESRI Free Demo: GIS Solutions for Health and Human Services Major Diagnostic Category (MDC) Data
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 6
ESRI Free Demo: GIS Solutions for Health and Human Services Centers for Medicare and Medicaid Services (CMS) Data http://cms.hhs.gov
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 7
MODIFIED GIS ANALYSIS Major Diagnostic Criteria (MDC5) Data From ESRI Free Demo: GIS Solutions for Health and Human Services AND U.S. Environmental Protection Agency 2002 Toxic Release Inventory Database Harris-Brown & Associates Copyright July 31, 2005
[email protected] 8
MODIFIED GIS ANALYSIS Major Diagnostic Criteria (MDC) ESRI Free Demo GIS Solutions for Health and Human Services AND U.S. Environmental Protection Agency 2002 Toxic Release Inventory Database
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 9
MODIFIED GIS ANALYSIS Major Diagnostic Criteria (MDC) ESRI Free Demo GIS Solutions for Health and Human Services AND U.S. Environmental Protection Agency 2002 Toxic Release Inventory Database
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 10
MODIFIED GIS ANALYSIS Major Diagnostic Criteria (MDC) ESRI Free Demo GIS Solutions for Health and Human Services AND U.S. Environmental Protection Agency 2002 Toxic Release Inventory Database
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 11
Scorecard Databases – http://www.scorecard.com Health Effects - 15 Categories • • • • • • • • • • • • • • •
Gastrointestinal or Liver Toxicants Suspected Carcinogens Carcinogens Suspected Cardiovascular Toxicants Suspected Developmental Toxicants Developmental Toxicants Suspected Endocrine Toxicants Suspected Immunotoxicity Definitions Suspected Kidney Toxicants Neurotoxicants Suspected Reproductive Toxicants Reproductive Toxicants Suspected Respiratory Toxicants Skin or Sense Organ Toxicants Suspected Musculoskeletal Toxicants Suspected
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 12
Developmental Toxicants
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 13
Reproductive Toxicants
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 14
Carcinogen Toxicants
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 15
Lead and Lead Compounds
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 16
TRI Lead and Lead Compounds Percent African American
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 17
DATA ANALYSIS SITE SELECTION Pattern Recognition Statistical and Algebraic Analysis Model Building Etc. Harris-Brown & Associates Copyright July 31, 2005
[email protected] 18
(1) Percent Minority, (2) Mortality Rate, (3) Acute & Chronic Respiratory Rate (4) Malignant Cancer Rate 1
2
Percent Minority - Hamilton County, Ohio
Mortality Per 100 Persons - Cincinnati, Ohio 275
275
Ross
Ross 27
Pleasant Run
128
27
Sha ronville
75
Forest Park Gle ndale
Scale Legend 1
Fe atures Legend
Mount Healthy Heights
Gr e enhills
Evendale
Cities, OH
2
Northbrook
0.0 - 12.000 12.001 - 25.000
Mount Healthy
25.001 - 50.000
74
75.001 - 100.000
Dillonvale
275
Mount Healthy
Evendale
71
Linc oln Heights
W yoming
9.760 - 75.000
22
Re ading
75
Amberley
City lm, OH Z IP5, OH
275
71
The Village of I
Silverton 22 Madeira
Ohio
71
White Oak West
128
Elmwood Place
Dillonvale Kenwood
Finneytown Nor th College Hill
W hite Oak
Elmwood Place
74
Monfort Heights East
Monfort Heights East
Gr andview
St. Bernard Norwood
Monfor t Heights South
St. Bernard Norwood
Monfor t Heights South
75
75
Ma ck North Br idgetown North
50F
Fairfax
71
Ma ck North Br idgetown North
Cincinnati Newtown
50
50
Mack South Tur pin Hills
Tur pin Hills
Addyston
Covedale
Covedale 52
52
275
Acute & Chronic Respiratory Medical Visits Per 100 Persons Ross
27
Pleasant Run
128
Sha ronville
75
Forest Park Glendale
275
42
Mount Healthy Heights
2
Features Legend
275
Northbrook
Cities, OH Highw ays, OH
Mount Healthy
Trct_ham - RST_RATE 103.931 - 114.883
W hite Oak
158.689 - 169.640
Amberley
Ma ck North Br idgetown North
213.446 - 224.398 224.398 - 235.351
Silverton
Terrace
Evendale
Northbrook
W hite Oak
50F
22
Re ading
Dillonvale
Newtown
Kenwood
Finneytown Nor th College Hill
75
Amberley
The Village of Indian Hi Silverton
Madeira
71
White Oak West
Elmwood Place
74
0.629 - 0.686
Monfort Heights East
Gr andview 0.686 - 0.743
Terrace
St. Bernard Norwood
Monfor t Heights South 75
Z IP5, OH
Ma ck North Br idgetown North
Ohio
Cincinnati
Montgomery 71
Lincoln Heights
W yoming
22
City lm, OH
Fairfax
Blue Ash
Groesbeck
0.344 - 0.401 74 0.401 - 0.458
0.743 - 0.801
Norwood 71
Gr eenhills
Mount Healthy
0.458 - 0.515 275 0.515 - 0.572 128 - 0.629 0.572
Madeira
St. Bernard
City lm, OH Z IP5, OH
275
0.287 - 0.344
The Village of Indian Hi
75
202.495 - 213.446
275
42
Mount Healthy Heights
0.230 - 0.287
71
Monfor t Heights South
191.543 - 202.495
50
Dillonvale
Elmwood Place
Monfort Heights East
180.592 - 191.543
Glendale Features Legend
0.173 - 0.230
Kenwood 75
Sha ronville
75
Forest Park
Trct_ham - CSN7_RAT
74
Gr andview169.640 - 180.592
Pleasant Run
0.116 - 0.173
Finneytown Nor th College Hill
White Oak West
147.737 - 158.689
27
0.060 - 0.116
22
136.786 - 147.737
Ross
128
Highw ays, OH
22
Re ading
125.834 - 136.786 128
275
Malignant Cancer Cases Per 100 Persons - Hamilton Co., Ohio Cities, OH
Montgomery 71
Linc oln Heights
W yoming
114.883 - 125.834
275
Blue Ash
Groesbeck
92.980 - 103.931 74
Evendale
4
WINTON RD
1
Gr eenhills WINTON RD
Scale Legend 0
50F
Fairfax
71
Cincinnati Newtown
Mack South Addyston
3
Montgomery
Blue Ash
Groesbeck
9.210 - 9.750
74
Gr andview
Northbrook
7.510 - 9.200
74
The Village of I
Silverton 22 Madeira
Ohio
Gr e enhills
Highw ays, OH Trct_ham - MORT_RAT
74
White Oak West
Mount Healthy Heights
4.660 - 7.500
Amberley
Z IP5, OH 128
Fe atures Legend Cities, OH
2
Kenwood 75
City lm, OH
275
1
0.0 - 4.650
Finneytown Nor th College Hill
W hite Oak
0 22
Re ading
27
42
Scale Legend
Montgomery 71
Linc oln Heights
W yoming
Groesbeck
50.001 - 75.000 74
Gle ndale
WINTON RD
275
WINTON RD
Highw ays, OH Trct_ham - PER_MIN
Blue Ash
Sha ronville
75
Forest Park
27
42
0
Pleasant Run
128
Fairfax
71
50F
Cincinnati Newtown
50
Mack South
Mack South
Ohio
Addyston
Tur pin Hills
Addyston
Covedale 52
0
50
Harris-Brown & Associates Copyright July 31, 2005
[email protected] Tur pin Hills Covedale
Scale Legend 52
1
52
2 50
52
19
INTERPRETATION LogicTree Diagram (1) Percent Minority, (2) Mortality Rate, (3) Acute & Chronic Respiratory Rate (4) Malignant Cancer Rate (5) GIS Locations Cat. % n 12.00 - 25.00 %Minority 13.64 18 75.00 - 100.00 %Minority 4.55 6 Low 25.00 - 50.00 %Minority 13.64 18 0.00 - 12.00 %Minority 62.12 82 50.00 - 75.00 %Minority 6.06 8 Total (60.83) 132
Cat. % n 12.00 - 25.00 %Minority 14.75 32 75.00 - 100.00 %Minority 15.67 34 minority percent 25.00 - 50.00 %Minority 11.52 25 0.00 - 12.00 %Minority 51.15 111 50.00 - 75.00 %Minority 6.91 15 Total (100.00) 217
%Minority Root Node
mortality rate P-value=0.0000 Chi-square=61.8573 df=8
Acute & Chronic Respiratory Cat. % n Rate 12.00 - 25.00 %Minority 19.67 12 75.00 - 100.00 %Minority 21.31 13
High 25.00 - 50.00 %Minority 0.00 - 12.00 %Minority 50.00 - 75.00 %Minority Total
8.20 44.26 6.56 (28.11)
5 27 4 61
Cat. % 12.00 - 25.00 %Minority 8.33 75.00 - 100.00 %Minority 62.50 Very High;Very High;Very High 25.00 - 50.00 %Minority 8.33 0.00 - 12.00 %Minority 8.33 50.00 - 75.00 %Minority 12.50 Total (11.06)
n 2 15 2 2 3 24
Motality Rate Harris-Brown & Associates Copyright July 31, 2005
[email protected] Cat. % 12.00 - 25.00 %Minority 0.00 75.00 - 100.00 %Minority 57.14 2 25.00 - 50.00 %Minority 0.00 0.00 - 12.00 %Minority 28.57 50.00 - 75.00 %Minority 14.29 Total (3.23)
n 0 4 0 2 1 7
Malignant Cancer Cat. % nRate
respiratory rate P-value=0.1601 Chi-square=6.5748 df=4
Cat. % 12.00 - 25.00 %Minority 11.76 75.00 - 100.00 %Minority 64.71 5;3;13;1;4 25.00 - 50.00 %Minority 11.76 0.00 - 12.00 %Minority 0.00 50.00 - 75.00 %Minority 11.76 Total (7.83)
n 2 11 2 0 2 17
GIS Location U.S. Census Tract
cancer rate P-value=0.0132 Chi-square=10.7446 df=3
12.00 - 25.00 %Minority 14.29 75.00 - 100.00 %Minority 71.43 7;5;12;13;6;9;1 25.00 - 50.00 %Minority 0.00 0.00 - 12.00 %Minority 0.00 50.00 - 75.00 %Minority 14.29 Total (6.45)
Cat. 12.00 - 25.00 %Minority 75.00 - 100.00 %Minority 8;4 25.00 - 50.00 %Minority 0.00 - 12.00 %Minority 50.00 - 75.00 %Minority Total
% 0.00 33.33 66.67 0.00 0.00 (1.38)
2 10 0 0 2 14
n 0 1 2 0 0 3
TRACTID P-value=0.0000 Chi-square=28.0000 df=4
Cat. % 12.00 - 25.00 %Minority 0.00 75.00 - 100.00 %Minority 100.00 390610016.00;390610038.00;390610004.00;390610015.00;390610037.00;390610036.00;390610002.00;390610001.00;390610034.00;390610008.00 25.00 - 50.00 %Minority 0.00 0.00 - 12.00 %Minority 0.00 50.00 - 75.00 %Minority 0.00 Total (4.61)
n 0 10 0 0 0 10
Cat. % 12.00 - 25.00 %Minority 100.00 75.00 - 100.00 %Minority 0.00 390610100.01;390610020.00 25.00 - 50.00 %Minority 0.00 0.00 - 12.00 %Minority 0.00 50.00 - 75.00 %Minority 0.00 Total (0.92)
n 2 0 0 0 0 2
Cat. % 12.00 - 25.00 %Minority 0.00 75.00 - 100.00 %Minority 0.00 390610062.01;390610081.00 25.00 - 50.00 %Minority 0.00 0.00 - 12.00 %Minority 0.00 50.00 - 75.00 %Minority 100.00 Total (0.92)
n 0 0 0 0 2 2
20
ESRI ModelBuilder Geographic Information System
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 21
THE END … THANKYOU ARE THERE ANY QUESTIONS
Harris-Brown & Associates Copyright July 31, 2005
[email protected] 22