Monday, November 11, 2013

Background - Restoring a County GIS (Part 2)

I accepted the position of GIS Manager, just as I began my final year working towards a Bachelor of Science in Physical Geography (special emphasis on GIS and karst environments, along with a Minor in History). Little did I know that everything I had learned or been a part of in the past 20 years was about to be put to use.

The position reported directly to the County Assessor, a rural Republican woman from the north end of the County. She had held the seat for about 6 years I think, after being appointed from within the Office by the Governor, following the resignation of the previous Assessor. She was hard-nosed and demanding, while at the same time perfectly clear and reasonable in her expectations. Much like me, she preferred getting down to business with straight and honest answers to questions, and had very little tolerance for folks that beat around the bush. As a result, we got along really well, after testing each other a few times, and I was determined to make good things happen for her, the Office, and the County GIS.

The previous GIS Manager had left the position about 6 months prior to my arrival and only about a year in the position. I later discovered that this was a scenario that had repeated itself numerous times in the past. GIS folks signed on to the position long enough to hold the title, then left for a position in the private sector. There had been no attempt to retain anyone in the position, through commensurate compensation, and there was no interest in doing so. Consequently, the GIS was in a crumbling and dilapidated state, and not really much use to anyone except the persons maintaining and analyzing the records.

A GIS Analyst had only recently signed on, after having been absent from the profession for several years. She was doing her best maintain the data and day-to-day business; that is, in spite of a total lack of guidance, direction, documentation, or procedure, from the previous GIS Manager. I was concerned she would follow the same path as many others that had been in that position, but was fortunate to have her give the situation a chance and stay on through 4 years of the restructuring.

Throughout the County, there were only a couple of others involved with GIS. The GIS Coordinator within the Planning & Zoning Department mostly worked independently on projects associated with his department. Although he really had no responsibility to our office, he enthusiastically joined in most of the projects we rolled out during the next 5 years. The Director of Information Services was an immense help in forwarding our objectives too. He had originally been brought on years before, to initiate a GIS for the County. He had not worked in GIS for quite a few years, but understood the basic concepts; as well as the importance of a structured and well-documented approach to building and maintaining a useful GIS.

While this situation probably would have been quite a challenge for someone just finishing college, I had enough background to make a good run of it. I had already been in the business world for 20 years and just then leaving an Analyst role I had been in for 2 years with a financial software firm. Prior to that, I spent 5 years working with a team in my own company providing creative services, primarily in photography and event production, and pre-social media web marketing and promotional support. For the 13 years before that time, I proved my technical worth, rising through the ranks of a semi-local financial firm in various technology roles from quality assurance, helping structure production standards, statistical analytics, database management, data modeling, software and hardware support, software design and development, and even a little web production in the early days of HTML.

Sunday, October 20, 2013

Initial Thoughts - Restoring a County GIS (Part 1)


During the past 5 years, I spent most of my waking hours rebuilding and restructuring a dilapidated Geographic Information System (GIS) for a Platte County in Missouri.

My team and I restructured systems and data to be more efficient, reliable, and accurate, while fully documenting processes and procedures, and organizing policy towards a functioning business solution using the ESRI suite of products, ArcGIS. Indeed, we only recently positioned our GIS to enable the Assessor and the County to begin to reduce its reliance on taxation and begin generating revenue through a fee structured subscription environment, capable of delivering geographic and non-geographic data to any client in the world, 24 hours a day, 365 days per year.

Resources for GIS were extremely limited, so it was very hands on, and I did most of the work on this system, personally. Along with a GIS Analyst under my supervision, the GIS Coordinator n the Planning & Zoning Department, as well as a bit of consulting on system design, architecture, and setup support from the Information Services Department.

In spite of numerous obstacles, both internal and external, we successfully upgraded all ArcGIS software from version 9.1 through v10.2, and implemented ArcGIS for Server v10.2, while at the same time, migrating this situation from an aging IBM DB2 v8.1 database on a Windows 2003 server to a Microsoft SQL Server 2008 R2 database on a Windows 2008 server.

This multi-part series will document those adventures in full, from beginning to the bitter end, when a newly-elected Republican Assessor, closely affiliated with the Tea Party, made one of several uninformed decisions. In his opinion, an [underpaid] GIS Manager was an unnecessary expense, because “nobody really uses maps anymore;” ironically, just a few days later he realized he had made a mistake. The GIS Manager did not just make maps.

Fortunately for him, the system was well documented and permitted the GIS Analyst to easily step in and start with a good foundation. That was one of project goals, after all; that anyone could easily step in and assume command of the GIS, with little effort. 

Essentially, this is a “Post Mortem” on the PCAO Geographic Information System Project, in every sense of the word, in the hopes of providing some insight to any other GIS Manager or Project Team that may face similar circumstances.


Popular Variations