Reviewing the history of these two AM/FM/GIS pioneers and their projects from both the electric and gas business sides is summarized below.

 
Profile
Parent Company: DTE EnergyElectric 
Utility: Detroit Edison
Headquarters: Detroit, Michigan
Customers: 2,100,000 (2000)

Profile
Parent Company: MCN Energy Group Gas 
Utility: Michigan Consolidated Gas
Headquarters: Detroit, Michigan
Customers: 1,200,000 (2000)
Year Detroit Edison Michcon
  Automated Mapping System (AMS)
Current Name: GenIsyS
Mapping & Automated Recordkeeping System (MARS)
1969 Service Request Number M4-9021 initiated by Administrative and Technical Systems  
1971 Work begins for the two-man study team looking at a facilities information and grid index system.  
1972 Facilities Information and Grid Index System (FIGS) Study Report, Project Number 4791 released.  
1975 Pilot begins with Bruce and Shelby Townships, Macomb Division. Project name established: AMS  
1976–78 Conversion of the remainder of Macomb Division  
1977   Comprehensive study performed looking at an information systems solutions for the Company. Automated mapping ranks eighth and is deferred.
1978 Simultaneous conversion effort of Oakland, Wayne-Monroe and Ann Arbor Divisions begins.  
1980 Migration from Data General to Intergraph’s DEC PDP 11/70 begins.
  • Data General – Graphics files containing data structures
  • Intergraph – Design files using true interactive graphics (IGDS) and a database system (DMRS).
MichCon conducts second study, the Gas Facilities System looking at distribution, transmission and storage gas facilities. Benchmarking done at Detroit Edison for automated mapping. Recommendations deferred due to significant resources required and corporate earnings issues.
1982 Migration to PDP11/70 completed. Conversion of Detroit begins.   Third study focuses on smaller scale database for distribution gas facilities. A small team is started but support is weak.
1984 Detroit conversion completed.  In 1983 a team is established to viability to develop a gas facilities system (GFS) using automated mapping and / or facilities database. Extensive time interviewing and learning from Detroit Edison. Study completed and recommendations approved for an AM/FM System by senior management in 1984.
1985 Detroit Edison - Alex Dow Award received (L. Cosgrove)   System selection made. Approval received to standardize on an Intergraph hardware / software platform.
Year Detroit Edison Michcon
  Automated Mapping System (AMS) 
Current Name: GenIsyS
Mapping & Automated Recordkeeping System (MARS)
1986-88 Thumb Division conversion effort approved and completed.   Team designs system. Prototype’s 1 square mile of Ann Arbor, Michigan. Timeshares with service bureau’s VAX and leases workstations using 9.6 kb modem. Later increased to 56 kb. Start acquiring digital land base and orthophotography products from Detroit Edison’s subsidiary, Syndeco.
1989 Migration of data from PDP 11/70 to VAX/VMS
  • 16 – 300 megabyte packs moved to 3 – 1 gigabyte drives.
  • 16 separate databases moved to 6 separate databases
  • Over 16,000 facility files with database moved in 3 weeks.
Completion of 36 square mile Pilot (Ann Arbor Township). Acquisition of own Intergraph system including a VAX/VMS 6310.
1990   Intergraph FRAMME 1.0 design and implementation. Pittsfield Township conversion completed.
1991 Intergraph FRAMME Pilot begins
  • Seamless mapping
  • Relational database technology – ORACLE
  • State Transitions Detroit Edison becomes charter member of Intergraph’s 100 Percent (Converted) Club
Detroit Project - Ypsilanti Township completed. Milford Township started. New conversion database rake-off system started. Grand Rapids Project - landbase project started – 4 townships.
1992 Approval given to move to FRAMME / UNIX
  • Project Name: GenIsyS – Geographically Enhanced Network Information System
  • Design the rulebase to support mapping
  • Develop migration software
Grand Rapids Project – Facility conversion starts on 4 townships (Walker, Wyoming, Grand Rapids, Paris)
1993 1993 Macomb Division is successfully migrated to GenIsyS and tested for several months. AM/FM International Excellence Award received.   Grand Rapids Project – 7 additional townships flown.
1994 Five remaining divisions migrated on schedule: Ann Arbor, Oakland, Wayne- Monroe, Thumb, and Detroit. Grand Rapids Project Land (11 Townships completed).
1995
  • GenIsyS fully operational.
  • Work Management System (WMS) interface to / from GenIsyS developed for service planners.
  • Work begins on Design & Estimating System
    • Detroit Project – Washtenaw County service territory complete with all facilities.
    • Grand Rapids Project - Four townships of facilities completed.
    Year Detroit Edison Michcon
      Automated Mapping System (AMS) 
    Current Name: GenIsyS
      Mapping & Automated Recordkeeping System (MARS)
    1995
  • Outage Analysis System
  • Crucial edits (68) and tests moved to the GenIsyS Rulebase
  •  
    1996 Mapping & Service Planning move from Clix to NT Desktops. MichCon starts migration from VAX / VMS to Windows NT and FRAMME NT. First major system at MichCon using NT.
    1997
    • Work Management System interface to GenIsyS Design & Estimating System
    • GenIsyS Team Members receive the Alex Dow Award for their work towards the Economic Development’s Site Selection System Internet Web Site using GenIsyS data and GeoMedia Web Map. (L. Cosgrove & D. Fletcher)
    Completed NT migration.
    1998
    • FRAMME Graphic and Database Servers moved from Unix to NT
    • GenIsyS Application achieves Silver Certification readiness for Y2K
    • Last of the VAX data conversion completed.
    • One call in the field using MARS FieldView and laptops piloted. 
    1999
    • All product extraction map and report software rewritten from Fortran/C to Visual Basic
    • Clix Application Menu replaced with GenIsyS Application Menu via the Intranet
    • Last Intergraph Clix servers retired
    • Digital Print Room implemented
    • Grand Rapids Project – Conversion of all of Grand Rapids Service Territory completed. Muskegon Urban is 50% complete without residential services.
    • Detroit Project – Detroit and downriver communities (Phase 1) in Southeast Michigan completed with exception of residential services. Phase 2 starts.
    • FieldView users expanded to Dispatch, Corrosion, Engineering, Investigation, etc.
    • Stoner Gas Network/Load Analysis Application and Connectivity Project kicked-off.
    2000
    • GenIsyS Application and its subsystems safely rollover during Y2K
    • Over fifty new reports are included on the GenIsyS Application Menu
    • Ground Line Strength Index Pole Calculation is added within GenIsyS to help defer over $1 million in pole replacements each year
    • Economic Development’s Site Selection System moved to GeoMedia 3.0. Entire State of Michigan is made available on-line. Site is now sponsored by the State of Michigan and the Michigan Economic Development
    • Grand Rapids / Muskegon Project – Muskegon Urban complete with exception of residential services (Phase 2)
    • Detroit Project (Phase 2 Residential services) continues.
    • MARS FieldView users number 250 (in office and field).
    • Stoner and Connectivity Project continues.
    • “Big Picture Map” Application completed.
    • Corrosion Application requirements underway. Association.
    • Development and implementation of a new method to reduce overall product extractions times by over forty percent. (C. Cwiek)