| |
Back to SAG Winners 2003
Anchorage Water and Wastewater Utility
View Photo(s) of Award Presentation AWWU GIS data was redesigned and migrated from coverages to the ESRI Geodatabase (SDE/Oracle). The Intranet Geospatial Portal was developed to deliver GIS spatial and character based information to employees.
Learn more about us
Business Problem There was a dire need to provide an electronic single point of entry with current information and interfaces to various enterprise databases and documents. Specific goals of the project included: delivering current and consistent data, minimizing bottlenecks, improving productivity, and eliminating redundant data entry. Keys to success of the project included: management support, end user enthusiasm, cooperative developers, appropriate training, and phased development.
Redesigning and migrating the coverages to the geodatabase and programming for the Intranet Geospatial Portal with interfaces to enterprise databases was done over the course of several years. The users locate their area of interest by zooming into the map or selecting from a drop down list. The parcels active layer is interfaced to CAMA, AWWU Assessments, AWWU Permits, AWWU CIS, Well/Septic Permits, and Building Permits. The projects active layer is interfaced to project center points, boundaries, proposed pipe and nodes, the Oracle projects database, PeopleSoft, Internet project websites, and Microsoft Exchange. The infrastructure layers (water node, water pipe, sewer node, sewer pipe) are interfaced to the Oracle record drawing index, scanned record drawing tiff images, and Maximo. The excavation layers are interfaced to Maximo work orders including jpeg digital photos. Technology Implemented ArcGIS, ArcIMS, ArcSDE, ArcObjects, Maximo Work Management System, PeopleSoft Financials and Project Costing, Windows 2000 Advanced Server and Windows 2003.NET Server, IIS5 and IIS6, Oracle, Oracle Forms, Visual Studio.NET, C#, XML, ASP.NET, ADO.NET Development Team Biography AWWU Team Members:
Larry Brys, IT Project Manager and Design Team Leader
Julie Moisan, Engineering GIS Supervisor
Tim Kelly, Engineering GIS Technician
John De Vries, Engineering GIS Technician and Archivist
Vivian Latkowski, IT Systems Analyst
Everett Clary, IT Programmer for Map Service
Kathryn Browning, IT Database and SDE Administrator
Bitsy Lawhorn, Engineering Planning Technician
Resource Data Incorporated Team Members:
Diane Thompson, Contract Team Manager and Senior Analyst
Steve Finneran, Senior Analyst for Geodatabase Implementation
Jackie Shoaf, Programmer for Map Service
Dan Van Orden, Programmer for Enterprise Systems Interfaces
Joe Orley, Programmer for Enterprise Systems Interfaces
|
)
)
)