Enterprise GIS - Building a Strong Foundation
Since a large portion of the City’s graphic data investment existed in the form of AutoCAD files, it was recommended that the City convert the files to a format that the GIS software could manage and maintain. After the GIS graphic files are built, a relationship between existing systems/databases could be established and new attribute data could be added to the SQL Server relational database. Additional GIS data requirements were determined by finding out what types of applications were most important to the City. A conceptual database design was created to show the relationship between the GIS graphic data, the attribute data stored in SQL Server and the external databases and systems. It was found that the City’s existing computing environment could support an Enterprise GIS if a phased process of upgrading hardware, software and network components was implemented as the project progressed. It was determined from the Needs Assessment that the City of Grapevine would benefit greatly from an Enterprise
GIS. Some benefits would include increased work efficiency, better service to customers, improved maintenance planning and enhanced analysis.
Implementation Action Plan
The Implementation Action Plan takes a three-phase approach to building and developing an Enterprise GIS. In order to successfully implement an Enterprise GIS, four essential elements must be in place: Data, Software/Hardware, Applications and People. All are key to the success of the project. The implementation plan takes all four of these elements into account in each phase. At the end of each phase, the City will have approximately one third of its data requirements, a quality control program, four to six priority applications, support staff and the software and hardware necessary to support it. The Implementation Plan also contains a planning level budget estimate for completing the implementation of the City’s Enterprise GIS. The cost estimate was broken down into tasks for each phase of the project.
Status of Phase One
In addition to converting the existing AutoCAD files in Phase One, data was acquired from external agencies such as the Appraisal District, the E-911 District and the Council of Governments. The Appraisal District parcel data required graphic conversion and, in over half the city, redrawing of the linework. Street Centerlines with address ranges for approximately two-thirds of the city were obtained from the E-911 District. Political boundaries and orthophotography were obtained from the Council of Governments. The GIS Data Server, the Intranet/Internet Server, GIS related software and the Relational Database Management System were acquired and currently functioning.
Two administrative groups were formed at the City of Grapevine to oversee the project and provide support and feedback to the GIS Project Manager. The Steering Committee consists of City Managers and Department Directors. The GIS User Group is comprised of representatives from all city departments and most divisions. Temporary and part-time staff was acquired to fulfill the City’s staff support obligation. They performed the functions of data entry, data compilation, research and verification.
|