As has been discussed, the most fragile component of the this system might be the single zipcode table that is used for the zipcode requests. This is a very large table in an SQLlite database. We need to determine a better strategy for the long term operations of this. In the very least we might
archive all but the last few years to the CIMIS oracle database, and limit the historical record that the system uses for zipcode queries
consider moving the database to the CIMIS db, and make queries directly to that system.
As has been discussed, the most fragile component of the this system might be the single zipcode table that is used for the zipcode requests. This is a very large table in an SQLlite database. We need to determine a better strategy for the long term operations of this. In the very least we might