Archive for January, 2010

h1

Some Goal setting….Customer Development

01/29/2010

Our management team was recently asked to set a couple of Goals based upon S.M.A.R.T (http://www.topachievement.com/smart.html) as a guideline to set and measure its success.   One of our GIS team goals for the year really focuses on our customers and our attempt to educate them on availability of Web resources.  We are calling this goal “Customer Professional Development”.  For clarification a customer defined by our group is anyone that uses or can make use of our data and services.

First let me talk a bit about this goal setting process (briefly). To be honest, goal setting has/is not one of my favorite things to do and I started off with this request absolutely dreading it.  Once I spent a little time looking over some of the work we have done in the past and trying to apply this SMART goal principles to these old projects, I began to see some of the valuable information I was missing.  Sure I can look back on a particular goal, however I cannot see or show all the little steps, (set-backs and victories) we took to our achievements.  So, even though I believed this to be just another task to do and watch, I have quickly become excited about this ongoing task and the periodic review process.

Now let me explain the “Customer Professional Development” goal.  Here at Linn County, I believe our GIS capabilities are very good.  We have a solid technology infrastructure and very skilled people that take on challenges in a way to help improve government and how it works locally.  One of our major crutches is dealing with routine daily management of property records, specifically when we find problems with recorded documents, such as a property transfer (Deed).  We process nearly 10,000 deeds each year that deal with property and/or property ownership changes.   With this volume, we do expect some issues, however why not shoot for perfection?  We began tacking all our work within a GIS Help Desk tool in September of 2009, which in and of itself is worthy of a Blog entry.  Through this documentation process we have realized that a majority of the problems are issues that start and could end with the deed preparer verifying document for accuracy.  To make this even more interesting, in most instances,  we have found that our web services, if used, would vastly reduce issues on the recorded documents we have to process.

Therefor it is our intention to schedule appointments to meet all our Deed Prepares and their staff’s to make sure they are aware of Linn County Web services that they can freely use.  Let me be clear, we don’t want to do their job or tell them how to do it, however we simply want to make sure they know of our products and how they may be able to apply them to their work flow.  This group of professionals are one of our most important customers because without highly accurate ownership research and documentation our land management system would lose a lot of trust by its daily users, not to mention increase errors to our tax bills.  So by allocating our staff time to spend with these customers, I feel we will spend less time having to deal with issues that show up in our office.  This is a potential huge efficiency improvement for our work flow! Basically we want to take care of our customers, so we can continue to improve upon our product and services.  As our customer base continues to grow we need to continually take it upon ourselves to find our improved efficiencies to keep up with our demand.

Stay tuned, I hope to be able to report back in several months with how this goal goes.  If nothing else, we’ll be able to meet those that we are in contact with every day in person not  just through paperwork.

h1

Working to improve workflow efficiencies…

01/20/2010

Last Friday (Jan 15th) I sent an email to our Supervisors in hopes to further educate and/or inform them of the GIS division’s major tasks. My real goal is to begin pushing ways to improve efficiency with many of our internal processes dealing with land management.

I have developed a growing concern that internal decisions are being considered without a full understanding of how offices work and depend upon one another. There are 4 offices in Linn County that work & depend upon one another at least several times each week. These offices (plus a potential 5th) primarily deal with Land and how it is divided, recorded, mapped, regulated, valued and tax collection. There are many possible methods to improve process efficiency, however being a GISer, I am going to promote system integration. The offices speak of all work together very well and we have always talked a good talk, but no one really has taken that first big step until recently.

I’m appending an excerpt of my email attachment where I have listed the GIS services daily business and the outlook of projects being planned and work on in 2010.   Several of these, however will likely take a little more time than I would like, but we all have to have something to strive for these days.

By the way, I am still waiting for a Supervisor to call or at least respond to my email…who knows blogging may be a better way to communicate?

—————————————————

2010 GIS Services Outlook

The Typical Daily Property Management Workflow
The daily workflow for property management heavily relies upon the Recorders office providing the Auditor’s office with all the recorded documents to map. The average daily document count ranges from 25 to over 100 documents on any given day with an average daily count of 45 to process and maintain current real estate records. Each document is reviewed, processed in COLECT (most require varying levels of research), processed in the GIS (where GPN’s are created or mapping is necessary), and all are run through a Quality control process to verify accuracy both with the document and with our stored data.

Daily contact with the Recorder and both the City and County Assessor are a critical part of our operation in order to maintain current up-to-date property records. Many automated procedures have been put into place over the years, however until the property management system (COLECT ) is replaced and the Assessors are fully integrated daily contact will remain highly important.

Linn County GIS expanded Support
The GIS portion of the property management system is considered to be a matured product, meaning it is currently in a maintenance state. GIS has and continues to expand its services to many County departments as well as the general public. Management of the property system continues to absorb over 60% of our resources, allowing development of new technologies, projects, services and general administration only to be fit in as time permits. We have extended a medium level of services to Planning and Development, Sheriff’s office and recently with the County Assessor over the years and many smaller projects & services to Secondary Roads, Health, Conservation and the Supervisors.

Several of our larger projects not directly tied to our daily work:
1) Sheriff’s Office – Web enabled mapping product to assist with managing Sex Offender residence. Primarily used internally by the Sheriff’s office to inform their staff where sex offender can or cannot live at the time the sex offender registers their new address.
2) Planning & Development – Assisted with completing and now managing tool used by Planning to determine development scoring. Tool is called LESA and is scheduled for total rewrite as time permits due to changes in our technology.
3) Co. Assessor – Land Exemption layer created to enable the Assessor to track and analyze Forest Reserve and Slough Bill areas for the first time. Major benefit is that it accurately illustrates the validity of each area. In some cases we have found areas that do not qualify or have had overlapping exemptions.
4) Conservation – Building a land maintenance tool to track land owned, maintained and managed by Linn County Conservation.
5) EMA – Support EOC operations during any activation as well as during drills. The GIS abilities during the Flood of 2008 supported pre-flood predictions, evacuations, reentry safety, affected properties (Commercial, industrial & residential) and assisted with many after event analysis projects

Current Major Projects
Several major projects are beginning to demand more and more time from the GIS group. It is viewed that with each of the listed projects below will greatly improve County business making our processing more efficient, reliable and useful to all County departments, local business and the general public. It is not believed that workload will be reduced largely due to the ongoing maintenance and support that will be required as well as the many new products that will come about due to data accessibility and analysis. This list has been narrowed to 3 high priority projects:
1) Replacement of COLET (mainframe) – Data behind the map shape is what makes GIS a powerful tool. The weakest point of Linn County’s GIS is the reliance upon COLECT (mainframe) largely due to the inability to make system changes and add important Geospatial attributes that was not important 30 years ago. The MS Govern project or the tool chosen to replace the mainframe is the next major benchmark for GIS in Linn County being able to support many more needs.
2) Integration with Assessor’s appraisal system (Vanguard or VCS) – this will provide the Assessor’s office to compare neighborhood sales data and produce study areas with a map. Over the next several years during their re-evaluation process, this integration will tightly support and illustrate changes needed or validate no change. Ongoing analysis will support new development and allow for areas to be tweaked based upon data.
3) Revamp Web GIS – Current tool is a powerful economic development tool used by nearly 120 unique visitors per day. Future changes include a much more simplified end-user interface as well as being connected to much more data and display designs as it becomes available.

Future

1) Constantly research, discover & implement efficiency improvements for internal work as well as for any County department.
a. Geospatial permit tracking system (Planning, Health, Engineering)
b. Snow removal analysis & routing
c. County projects status reporting
2) Heavy focus on Economic Development, continue to push accurate data out to the masses. Data availability is very important and it needs to become public domain data (free to use).
3) Expand and support mobile business practices for those departments with a mobile staff
a. Blackberry mobile GIS availability and data collection
b. GPS support
c. Non-Blackberry mobile support

h1

Bit of a reveiw of 2009

01/14/2010

So, it looks like I have taken a bit of a break from this site.  How is it time gets away so rapidly?  Well with a new year comes new challenges and what better way to start my year off than to sum up what we accomplished in 2009.

I believe change is inevitable within any organization and as a GIS professional we constantly seek change through improvements.  This last fall one of our long time employee’s decided to retire to hang and spend more time with her grand kids.  (Something I hope we all get to enjoy someday).  This provided us the opportunity to change things up a bit in our group and pave a new direction for County GIS, much to her outgoing suggestions.  We shuffled work around a bit and hired replaced her position with a GIS Technician, where in our County was a step or two lower on the pay scale.

The County Assessor worked with our group to build a Land Exemptions layer as well as adding Pictometry tools and imagery to our growing list of data.  This is significant to our County, primarily because in the past the County Assessor did not use our services other than to produce the County plat maps.  Our work with this office has opened to the door for many things to come and are working toward integrating our systems and assisting with supporting their work.

We did buy a mobile application that allows us to push our map technology to Blackberry’s.  This technology has a lot of potential for our field people, yet this really hasn’t taken off.  I believe a major issue we ran into was the overall lack of support from leadership within the departments that could really use this service, not to mention some technical issues with figuring out ways to store collected data.  I am holding out to believe that some groups will eventually want to use this service, however its priority has lowered.

Late in 2009 we introduced a GIS Help Desk system to help us keep track of the routine work we do as well as all the requests we get.  While we are only 3 months into using this tool, we have nearly 2000 tickets that have been created and closed.  Information being collected really helps a guy like me explain what it is we really do and the volume of work that passes through our group of 5 GIS employees.  I’ll have to pull some raw data out of the system and really get into this tool at a later time.

I’m ending with what I believe an exciting enhancement to the our GIS web tools for the public to leverage.  Using some newer technology (for us anyway) our GIS Analyst is working more in-depth with ArcGIS server and Adobe Flex Builder to improve our web presence.  Though it still is in development, I believe it will really improve the end-user experience.  If you’re interested check out the Linn County Flex Viewer at  http://gis.linncounty.org/maps/index.html .  Please comment.

Well, I better sign off for now.  One of my personal goals is to post something at least once a week so this blog should get a little more interested in time.

Cheers!

Follow

Get every new post delivered to your Inbox.