These are not happy days in the company.
Right now, I am waiting for one of our developers to unwind 700 lines of nested loops and PLSQL routines into something resembling plain SQL that I can import into our design application. He has promised to deliver it by end of day tomorrow, but in the meantime I am sitting here with nothing to do and a very short deadline. I managed to find all but two of the data elements that I need, but figuring out how to unwind it in plain SQL may be tricky. I understand the scripting interface in this application has some similarities to VB, so I might be able to have something mostly in place by the end of tomorrow without too much assistance.
It took a bit of deduction on my part, but I finally figured out how the data is being stored. It is stored hierarchically, with a repeating set of dependent vertical layers. What I need to do is find a way to unwind it into horizontal layers. That probably doesn't make a lot of sense to read, but it makes about as much sense to me at the moment. We'll see what my brain can do with it after a good night's sleep.
One of the things that I noticed when I started visiting the midwest was all the water towers. If we have them up here, I have never noticed them.
I did not know that they served a purpose the first few times I went down to visit. They always had the name of the town on them, so I assumed they were just some kind of standard way of identifying the town to visitors. Then when I learned that they were water towers, I assumed they were post-war relics or the like that the towns kept around because it was handy to remind the residents of where they lived.
Can somebody who lives in a town with a water tower tell me if they are still in use, or are they relics of a time before the invention of pump houses?