Enterprise GIS Developments in St. Clair County

1. Enterprise GIS Developments in St. Clair County Charles Kofron, Ph.D. GIS Coordinator 18 May 06

2. OVERVIEW • Enterprise GIS Models • Data Developments • Access Developments • Organizational Developments

3. ENTERPRISE GIS MODEL “The goal of an enterprise GIS is to implement interoperable technologies, standards, and methods so that GIS data and services can be used more efficiently and more effectively.” ESRI White Paper,Enterprise GIS in Municipal Governments, “The Enterprise Model of GIS is the highest level of GIS development that provides the maximum benefit to the organization that adopts and achieves it. It is a multi-purpose system that is part of the operational framework of an organization. It is based on large-scale GIS data, including parcels and other land-related data. It supports a wide range of applications across the entire organization.” Tomaselli, The Enterprise Model of GIS,and the Implications for People and Organizations The evolution of data management in large organizations typically follows a “punctuated equilibrium” model (Gould and Eldredge 1977), in which the status quo limits the growth or change until the system is disturbed and then rapid change occurs, followed by a new status quo. Such a disturbance may come in the form of a natural or man-made disaster, during which urgency demands action, the limitations of the existing system are exposed, and neces­sity opens the door for change. Keating, et.al., Challenges for Enterprise GIS

4. ENTERPRISE GIS CHARACTERISTICS • Cooperation • No Duplication of Effort • Data Models • Workflow Analysis • Emphasis on Data Quality • Compatible With a Variety of Software • Small Central Staff and Decentralized Skilled Users and Developers Tomaselli, The Enterprise Model of GIS,and the Implications for People and Organizations

5. ENTERPRISE GIS CHARACTERISTICS • Maximize utilization of GIS capabilities • Channel timely and accurate spatial and non-spatial data from various sources • Provide access to GIS capabilities and data across the organization or enterprise (domain of organizational activity) • Share data, avoid redundancy, duplication of effort • Avoid confusion • Make better decisions with the latest and best data available • Implement interoperable technologies, standards, and methods • Multi-purpose system that is part of the operational framework of an organization • Based on but not limited to large-scale data • Necessity occasionally opens the door for change

6. ST. CLAIR COUNTY ENTERPRISE GIS • Short-term goals • Establish an authoritative base map of St. Clair County • Develop a database structure to support data stewardship • Improve business processes for maintaining and increasing the quality of spatial and attribute data • Provide support for power and occasional data users • Extend access to the authoritative base map • Municipal governments • Taxing districts • Longer-term goals • Extend access to the commercial sector • Share data in a multi-user and multi-versioning environment

7. Shapefile ENTERPRISE GIS DATA DEVELOPMENT • Evolution of Organizational Mapping Technologies CAD Paper maps CAD Files Tagging Entities With Information Shapefiles Storing Information In Database files Geodatabase Geodatabases Storing various kinds Of features in RDB Enterprise GIS OpenGIS Enterprise Data Access

8. Shapefile ENTERPRISE GIS DATA DEVELOPMENT • St. Clair County’s Evolution 1992 2002 1999 2003 2004 CAD Paper maps Intergraph DGN data capture Vendor maintenance Digital updates on CDs 2006 2005 Geodatabase Standards-based PGDB Vendor updates with PGDB Data exchange with Scott AFB New Database Design Versioning Environment VPN Access

9. COUNTY DATA Enterprise GeoDatabase A A R R S S C C T T H H T T A A I I O O N N T T O O D D E E L L A A C C S S R R T T D D U U S S R R E E Information Requirements Mapping and Platting Zoning Assessments R Police Fire, EMS, 911 IGD I Public Health GeoBase Reference Special Projects Framework Utilities Elections

10. ENTERPRISE GEODATABSE STRUCTURE • Built on SDSFIE 2.5 Standards • Provides Different Levels of Viewing Capability • Utilizes Versioning • VPN Connections for Cadastral feature dataset maintenance • Implements Data Stewardship • County Departments are the Joint Owners of the Geodatabase

11. ENTERPRISE GEODATABASE STRUCTURE

12. CADASTRAL FEATURE DATASET

13. SPATIAL DATA VIEWS

14. SPATIAL DATA VIEWS

15. MAKING SDSFIE WORK

16. MAKING SDSFIE WORK

17. MAKING SDSFIE WORK

18. Network Terminal Services Access to Floating Licenses Access to ArcReader Maps Replacing Desktop GIS Licensing at Remote County Office Locations County Highway Department Intergovernmental Grants Public Health Public Housing VPN Terminal Services Supports Versioned Editing Environment Provides Municipal Government Access Capabilities DATA ACCESS DEVELOPMENTS

19. VPN SPATIAL DATA CONNECTIONS Vendor Using VPN Connection Mapping and Platting Data Processing Using PLTS Public Access

20. WORKFLOW DEVELOPMENTS

21. ORGANIZATIONAL DEVELOPMENTS MidAmerica Airport County Clerk Public Health ETSB 911 Mapping And Platting Data Processing County Highways Inter- Governmental Grants Economic Deveopment

22. ORGANIZATIONAL DEVELOPMENTS Parcel Numbers Site Addresses Mapping and Platting ETSB 911 Assessment System Enterprise Geodatabase Municipal Boundaries Township Boundaries Street Centerlines Address Ranges Parcel Addresses Special Districts Parcel Geometry Data Processing Support

23. ORGANIZATIONAL DEVELOPMENT

24. SUMMARY • Tomaselli’s Enterprise GIS Goals • Top Management Leadership (a team of Champions) • Moving away from reliance on contractors • Moving toward discrete project contractor support • An extensive, accurate and available GIS database, typically containing parcels and centerlines. • Reengineering enterprise geodatabase design and workflow • A skilled core group of GIS staff • One guy (could use another) • Adequate centralized, as well as distributed GIS hardware and software. • Terminal Server and Direct Network Connections • Active and knowledgeable GIS users and developers in the participating departments and jurisdictions. • DP supports GIS staff development with training seminars • Standards, guidelines and procedures for the users to follow. • Database development using the SDSFIE • Assigned roles and responsibilities for maintaining the data, with no duplication of effort. • Enterprise geodatabase versioning is in early stages of development

25. THOUGHTS? COMMENTS?

26. NEXT MEETING • When? • Where? • What about?