Closed prestoncabe closed 3 months ago
You can download zip code crosswalk spreadsheets from https://www.huduser.gov/apps/public/uspscrosswalk/home (after creating a free account).
This website also seems nifty, but I'm not sure if our use would be allowed under the free license?
making headway... have a basic architecture down pretty good... need more tests and to flesh out the locations table. Also will probably need a more sophisticated way to provide the inputs? (a residential address structure perhaps?)
I added a full list of all the locations (zip codes) to the DMN and it went about as well as one might expect :laughing: ...
It made the editor unresponsive, but my tests against the web API do work, albeit very slowly.
Looks like we might have pull out the power tools for this one to make it performant; get the list from a Java call to a sqlite db?
branch for in-progress work: https://github.com/prestoncabe/dmn-benefit-toolbox/tree/location-work
I was able to get the Java/sqlite version of the county/state lookups working! I just have to clean up the mess I made and push things up over the next few days.
I pushed the location.dmn + Java + sqlite solution to main.
There are still some related things to take care of (including connecting these new services to our existing benefits). We can tackle these in other issues.
location.dmn
state
-> attempts to return the US State (as a two-letter code) based on the inputs (may return multiple states)county
-> attempts to return the county (as a FIPS code) based on the inputs (may return multiple counties)city
-> attempts to return the city name based on the inputs (may return multiple cities)eligibility.dmn
:livesInPennsylvania
-> booleanlivesInPennsylvaniaConfident
-> boolean (indicates whether or not we have certainty or we are taking our best guess)livesInPhiladelphiaPA
-> booleanlivesInPhiladelphiaPAConfident
-> boolean (indicates whether we are certain)(maybe something like
mayLiveInPhiladelphiaPA
anddefinitelyLivesInPhiladelphiaPA
would be better?)Open question: How will we actually do the lookup? Is there an existing DMN model out there for this?