City of Cambridge Enterprise GIS Update Spring NEARC - Northampton, MA May 17, 2011 Jeff Amero, GIS Manager, City of Cambridge Sean Sweeney, GIS Specialist, City of Cambridge Presentation Overview Upgrade of Enterprise GIS Upgrade hardware and database software Upgrade data and data schemas Upgrade ArcGIS and users workflow Coordinating all the upgrades Perfect Storm of Change? New data from 2010 flyover New database server New database software New schema for databases ArcGIS 10 Last Changes for our Community User Last big change in 2002 - 2004 ArcView 3.2 to ArcGIS 8 Arc/Info Workstation to ArcGIS 8 Oracle to SQL Server ArcFM retired Hansen to Remedy New Changes for our User Community All at once? Hold back new data? How savvy are our desktop users? How can we make this less painful? Can we do this systematically? Our User Community 6 Power users (GIS, Planning, & DPW) 6-8 editors (using versioning) 25 viewers or task based users 20+ non users Web users User Considerations Ability to accept change Desire for new data Give them a reason to want to change Tools for seamless change GIS Dept. Considerations Other enterprise systems tied into GIS Work order management (Remedy) CAMA (Vision) Master Address Database GIS Web Tools Third party software Hydraulic modeling (Innovyze aka MWH Soft) Pavement Management (VHB) • Dropped in favor of Cartegraph Abutters Tool (Desktop extension by AppGeo) Other unknowns?? ArcGIS 10 Considerations Acceptance by user community 9.3 stable after issues with 9.2 Can the computers run software? Data Driven Pages VB custom scripts ArcEngine users ArcPad (should have been on list!)