== A Stopgap Measure ==
As a quick and dirty fix, walk through the cases and do the best we can. The script for that is located at <code>E:\McNair\Projects\SimplerPatentData\src\db\ZipCodeHotfixhacks\June2017PostcodeHotfix.sql</code> and it creates the following table:
<nowiki>