Correspondence between

Thanks, Gob. t need some tine to refresh my memory so twill schedule a time later this week te go over the randomization process. Juriaid

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

ivigov>; Stanbury, Martha (DHHS) <sianburyrn @inichigar gigy> Wow, Junaid, this looks really good! |agree, | think they could use this ane for a meaningful presentation. Next week, or whenever you're available, id like to learn how you did this. Thariks! Bob

n.goy>; Stanbury, Martha (DHHS) <stanbur Here's another version of the map. | used a slightly different randomization method that fd mentioned. Either this man or the one i sent in my previous e-mail is fine to use.

>; Stanbury, Martha (DHHS) <stanburym@rnichiganeov> Martha and Bob, Attached is a new rnap of EBLL cases in Flint randomized by a method used by Ed Hartwick. It’s better than the previous man | generated where cases were scattered at randarn throughout the city. in the revised mas, cases were shifted slightly fram their original point so some of the clustering stl holes up. This is probably the final map that GCHD could use for their presentation. Let me know if you have any questions or if you want to discuss. Thank you, Junaid

go>; Stanbury, Martha (DHHS) <stanburyrn geri OK, thanks. xxxEND_PAGE:dhhs03_b0797_2896_2897_1 002897

Oh, | see. I’m trying to randomize the points and need to indicate which layer to display the randomized points on. Are the points outside of the Flint layer (yellow-colored layer) important to the map?

No. | was simply providing an update to a map | had provided them last year (see attached).

Tharihs. The map you pravided isn’t at the zim code lavel, is it?

This is the only zip code layer | have (seven attached files), but it’s for the whole state, and several years old.

Bob, Do you remember which feature class contained the relavart zin codes for the map? Thanks, Junaid

Thanks Bob! | will let you know if | have any questions.

Junaid, Please see attached: the ArcGIS file itself, plus a zipfile with all related shapefiles. Also the PDF so you can see what’s it looks like. Let me know if you have questions. Thanks, Bob

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