elikern-kc
commented
3 years ago Thanks Alastair! Can we review this discrepancy at our next informatics sprint meeting?
Eli Kern MPH RN | Epidemiologist (he/him) Assessment, Policy Development, and Evaluation Public Health - Seattle and King Countyhttps://owa.kingcounty.gov/owa/redir.aspx?C=TNuruUR_x0mMeOqn6rueKCfnLzCcxdAICR3iDfSS8atu12V25XSLIp_1k_j_A9NKOb-a_2dkPVw.&URL=http%3a%2f%2fwww.kingcounty.gov%2fhealthservices%2fhealth.aspx phone: 206.263.8727 | email: @.***https://owa.kingcounty.gov/owa/redir.aspx?C=TNuruUR_x0mMeOqn6rueKCfnLzCcxdAICR3iDfSS8atu12V25XSLIp_1k_j_A9NKOb-a_2dkPVw.&URL=mailto%3aeli.kern%40kingcounty.gov
COVID-19 resources:
- Public Health's website: www.kingcounty.gov/COVIDhttp://www.kingcounty.gov/COVID
- Public Health's blog: www.publichealthinsider.comhttp://www.publichealthinsider.com/
- Dr. David Kern's COVID-19 Literature Reviewshttps://tinyurl.com/sm3yc2q
From: Alastair Matheson @.> Sent: Wednesday, March 24, 2021 10:06 AM To: PHSKC-APDE/reference-data @.> Cc: Subscribed @.***> Subject: [PHSKC-APDE/reference-data] Inconsistent ZIP list in spatial data (#1)
[EXTERNAL Email Notice! ] External communication is important to us. Be cautious of phishing attempts. Do not click or open suspicious links or attachments.
https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_admin.csvhttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Freference-data%2Fblob%2Fmaster%2Fspatial_data%2Fzip_admin.csv&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365452023%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=%2FyJj9MV0z%2F%2FqOLHKKrbPjLQ5NjFgFg%2BsVngc%2FPVcb5I%3D&reserved=0 has 123 ZIPs listed, https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_city_region_vid.csvhttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Freference-data%2Fblob%2Fmaster%2Fspatial_data%2Fzip_city_region_vid.csv&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365452023%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=BTs8cr17DsVOLEPXZ5dSWSOD%2F5X18l1l0%2FxEW9JYLbM%3D&reserved=0 has 121 ZIPs, https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_hca.csvhttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Freference-data%2Fblob%2Fmaster%2Fspatial_data%2Fzip_hca.csv&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365461973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=stnyRuRckb2Oaub3Fe2Cng4QPk8B4pK0IjjPiA2acL8%3D&reserved=0 has 134 (though we know this is a more extensive list), https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_to_region.csvhttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Freference-data%2Fblob%2Fmaster%2Fspatial_data%2Fzip_to_region.csv&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365461973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=L7%2B56pkpoLp%2FoaERQqp6nhnFIbQw2gqxRh2UVMfLYLc%3D&reserved=0 has 121 ZIPs.
Shouldn't the zip_admin, zip_city_region_vid, and zip_to_region files have a consistent number of ZIPs? The city and region files have some the admin does not, so there is less overlap than implied by a difference of 2 ZIPs.
- You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Freference-data%2Fissues%2F1&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365461973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ItcTc7pi0Tspt9pdTyBO9ryGBmziiPKvn6%2B%2BLk9HsYM%3D&reserved=0, or unsubscribehttps://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FABL6ZKWGYFWY7LXHXJ3KBUTTFILV5ANCNFSM4ZXVTIUA&data=04%7C01%7Celi.kern%40kingcounty.gov%7C4d013b817dbc4cf170d108d8eee709f7%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C0%7C637522023365471931%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nMW0G8EwySwm7vPKIk0i5fm7NxaTVHoptfvMPP2nRH0%3D&reserved=0.
alastairmatheson
https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_admin.csv has 123 ZIPs listed, https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_city_region_vid.csv has 121 ZIPs, https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_hca.csv has 134 (though we know this is a more extensive list), https://github.com/PHSKC-APDE/reference-data/blob/master/spatial_data/zip_to_region.csv has 121 ZIPs.
Shouldn't the zip_admin, zip_city_region_vid, and zip_to_region files have a consistent number of ZIPs? The city and region files have some the admin does not, so there is less overlap than implied by a difference of 2 ZIPs.