search

CDCgov / prime-reportstream

ReportStream is a public intermediary tool for delivery of data between different parts of the healthcare ecosystem.
https://reportstream.cdc.gov
Creative Commons Zero v1.0 Universal
69 stars 39 forks source link

Replace FIPS County File w/proper Geo-coding library #1151

Open MauriceReeves-usds opened 3 years ago

MauriceReeves-usds commented 3 years ago

We are currently using a flat file csv table for the purposes of mapping postal codes to counties, but we need to migrate this to a proper geocoding library that lets us get the correct county based on address and postal code. This would then need to be used for both HL7 serialization and ingestion for patients, labs, and providers.

MauriceReeves-usds commented 2 years ago

@rhood23699 I know that the SimpleReport team is using SmartyStreets for address look up. Perhaps we can see if we can share their license?

fysa: @Adrian-Brewster

rhood23699 commented 2 years ago

Mo, below is the Slack response from Alicia Beckett. We can use SimpleReport's SmartyStreets license. Let me know what/if you need me to do anything else. I believe this would now fall under the Pipeline Team for prioritization and grooming, but I'll help in anyway possible.

My thoughts are that Zip Codes with Counties should be in a DB and updated routinely. Seems an API call for each inbound message and/or outbound message would be far slower than DB queries.

Alicia Beckett 1 hour ago Yes, it is available to you. We have unlimited API calls. @Tim Best can get you setup with the API key.