SAG 2008 Winners

Calhoun County Commission

View Photo(s) of Award Presentation

Project Goal

Replace existing software developed by a contractor with platforms that are developed in house so we can have greater control over the functionality and better the user experience. To do this we needed to develop in house GIS cadastral data viewing with business logic querying capabilities to legacy databases. There were requirements for both public and intranet version of the program.
Learn more about us
Learn more about our application: Site 1

Business Problem Solved

Develop a platform that integrates CAMA (Computer Aided Mass Appraisal) and GIS into a user friendly, simple platform that can perform complex spatial and non spatial queries of GIS data joined on the fly with CAMA data on an AS400 system stored in logical files. Migrate from ArcInfo coverages to ESRI Geodatabase residing in SQL Server 2005 database. Make replica of necessary AS400 CAMA data in SQL Server to satisfy security issues with public accessible web service.

Technology Implemented

The development platform was Visual Studio 2005 using Visual Basic. Our subscription to EDN (ESRI Developer Network) was key to be able to develop the platforms before having to acquire the production licenses. The Intranet 'Parcel Viewer' platform was initial developed using ArcIMS 9.0 and the demand on the system grew quickly and user complaints of speed led us to redevelop using ArcGIS Engine and renamed 'Desktop Parcel Viewer', which gave us much more flexibility. Using IBM native .net data provider allowed us to have real time connections to the CAMA data. The public web site was developed using ArcGIS Server and .net. Through much customization of the basic mapping application that can be easily produced using server manager, we have some advanced querying capability, reporting, assessor photography review, and tax bill verification capabilities.

Development Team Biography

Our development team consists of our GIS Manager/Programmer Robert Scheitlin. He was advised concerning the requirements and unique constraints of the CAMA and assessment data by our IT Manager James Poe, and most of our Appraisal, Assessing, and Mapping Staff.