2 ms·
Long, long ago; I put together a database and code to take an address/Zip code and map it to Congressional District. My table of "split Zips" was large, and i o
by h2odragon 5y ago
Long, long ago; I put together a database and code to take an address/Zip code and map it to Congressional District. My table of "split Zips" was large, and i only had the vaguest nod towards using address data to refine that; so most of the time we could give you "its in one of these 2 districts" at worst. As i recall tho there was one set that could return any or all of 6 answers for "which District is this?" ... Puerto Rico and New York's mingled Zip codes, I think it was.
I was competing with a subscription service for the idea; and utterly missed my market. People wanting that service didn't care for "lower cost", they were charging expenses plus anyway; and they certainly didn't want to have to think about "databases and updates", they were quite happy with an online service they could have a secretary use and retype answers into their spreadsheets.
Also: Zip codes aren't static: they update them often and publish those updates on some schedule I dunno anymore. Used to be getting the new books out of USPS was a full time job itself.