Correspondence between

Whoops, | think | responded to the wrong email. The second map you sent is the best, | think.

Scott, Robert L. (DHHS) <% ’'m going to try to randomize points by City (Flint) and zip code(only zip codes in city af Flint} rather than just zip code - perhars the output will be better? will get the new map out sometirne tomorrow.

EBSD BOv> Martha and Bob, Attached is the map of Flint with points randomized by zip code, meaning | calculated the # of cases with BLL between 5 and 9 ug/dL (inclusive) and with BLL 210 ug/dL for each zip code and plotted the same number of cases per zip code in random locations within the zip code boundary. Unfortunately, as we originally suspected, the clustering of cases depicted in the original map (also attached) is lost with this randomization. Junaid xxxEND_PAGE:dhhs03_b0797_2896_2897_2

| looked up how to do randomization in GIS and think | might have found a way | can give it a try if | can access Bob’s map document.

See below — and I'll stop by.

Oy. Hi All, Here are the next tasks on our DEH Flint Coordination Team (Martha named us!}) collaboration to create the Child EBL Services Database: 1. Hotlink to the draft data dictionary £:\£84 fnvestigat a. Bobis checking and adding nurse case management variables (CM). (DONE) b. Need to check EBL Investigation (El) variables. (Ask Courtney) c. Need to finalize the data dictionary (Review by Junaid) 2. Need to determine the common variable ID between the CM and El spreadsheets a. Based ona discussed between Martha and | — the suggestion is using the HUD EBL ID for a home. 3. Need a list of questions that we want to be able to answer with this database. a. Kory will talk with Linda, Wes, Courtney (already talked with Martha) about the questions they want to be able to answer with this database. Kory will compile the questions and send around for review. c. Compare the questions to the variables in the data dictionary and consider if we have the correct variables to answer our questions. (TO BE DETERMINED — how and who is best to do that — may be a group effort) 4. Once all variable are entered in the data dictionary and Junaid says the dictionary is done, then he start working on Access Database. Thank you for your attention. Kory Groetsch, MS , Manager Toxicology and Response Section Michigan Dept of Health and Human Services (MDHHS) 201 Townsend St. Lansing, MI 48913 517-335-9935 Confidentiality Notice: This message, including any attachments, is intended solely for the use of the above named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure, or distribution of any 2 xxxEND_PAGE:dhhs02_b0641_2317_2319_2 002319 torfidertial andlfor priviteged Infermntren eenedired in this exndil is expressly prohibited. If you are not the Inkaidéd recipient, pease eorrtact tire sendtr by reply exmrdil and destroy amy antl atl eapies ef the origiaal message. xxxEND_PAGE:dhhs02_b0641_2317_2319_3