I have a table that has the lat/long of zip codes so that I can find the closest observation station.

Edit: If I can't find the zip, I'll default to that state's center. So even invalid zip codes like 12345 will "work"- in this case, it'll go to around Schenectady.