Avineon converted water and sewer network paper sources to Alliant's digital mapping system. The conversion software used was AutoCAD. The combination of AutoCAD, AutoLISP, proprietary software CadCap, and ADE produced graphic files linked to a non-graphic database. The final data was delivered to Alliant in ArcGIS and Oracle platforms.

At the onset of the project, an inventory of all sources was conducted to resolve conflicts. We then conducted data preparation, entailing color-coding and highlighting primary source records for use during conversion. The prepared documents were subjected to quality control to ensure all required information was property transferred and prepared.

Data conversion consisted of precision placement of water and sewer network features from the prepared source documents onto a digital landbase. As the features were placed, a non-graphic database was populated either manually by the technician, or automatically via programs within the placement routines. Each graphic feature placed was automatically assigned a unique identifier which links it to its non-graphic database record. All maps were edgematched to surrounding maps, and later merged to create a single, seamless map. The accuracy of feature placement was checked on-screen and corrections were made as needed. The last phase of AutoCAD production consisted of validation and corrections of data, directional flow and connectivity.

The graphic files were stored in .dxf format and transferred to ArcGIS for processing and translation. The non-graphic database was extracted into a DBF format and imported directly into Oracle. The translated ArcGIS coverage was then linked to the Oracle database, plotted, checked and corrected prior to delivery to Alliant Energy.

The project scope included 1,155 water pipeline & asset ¼-quad maps containing approximately 500,000 point and line features; over 22,550 water service cards; and 1,800 unposted work orders.

Avineon is providing modeling support and expertise using Intergraph Plant Design System (PDS) Solutions to AirLiquide's ongoing engineering design projects. These projects are taking place in Europe and South East Asia for AirLiquide's Oxygen, Nitrogen and Hydrogen gas plants. The support involves working on-site with AirLiquide's design engineers and coordinating the design, modeling, review, and analysis efforts.

Avineon was awarded a contract by AT&T to perform facilities drawing conversion services for the conversion of Central Office Drawings for all Platinum and Gold switch offices throughout the United States in support of the Business Information Planning (BIP) group. Avineon was tasked to convert the largest and busiest offices in the country including New York, Los Angeles, Orlando, Minneapolis, and others. The project involves the conversion of several thousand central office drawings into AutoCAD format. All drawing information is converted into the specific AutoCAD layers in accordance with the AT&T CAD Specifications Standards. The original source drawings for each central office section are converted into an integrated set of digital databases. The central office drawing types consist of Central Office Planner (COP) Development Plan, Floor Plan, Cable Plan, Cable Plan - Upper, and Cable Plan - Lower, Cable Diversity, Lighting Plan, Ground Schematic, ESS Cable Trough, Wave Guide, Fiber Protection, DMACS, and miscellaneous support disciplines including HVAC and other Electrical, Structural and Mechanical. All drawings are entered into the database using explicit coordinate dimensions and are geometrically correct and dimensionally accurate. The AT&T symbol block library is used for placement of equipment and other graphical elements. Non-Graphic attribution for data such as heat dissipation and weight are entered for telephony equipment and used by the COP for network planning. Resolution of discrepancies that resulted from the integration of the drawing types into a single database was accomplished by maintaining a close working relationship with the client and the development of rule sets that were followed to minimize production down time.

Avineon is performing engineering services for Piping & Layout for 1x40 MW Steam Turbine Generator (Turbine Integral Steam & Drain, Lube Oil, Condensate Flow, and Jacking Oil Scheme) for Bharat Heavy Electricals Limited (BHEL).

In this project, Avineon is preparing and furnishing Bill Of Material (BOM) based on preliminary routing to BHEL for indenting purposes. Avineon will reconcile with final isometrics and furnish BOM for the following indenting.

Avineon will carry out flexibility analysis for all operating conditions - steam piping for expansion, sustained, wind and seismic cases. Avineon will furnish the actual values exerted on steam turbine nozzles, and forces and moments exerted at anchor points. Avineon will prepare composite piping layout for each floor.

Avineon will prepare isometrics for piping. The isometrics will indicate BOM, location, welding details etc. Support sketches, drain points, maximum stress points and other required details as per Indian Boiler Regulations shall be indicated in isometrics.

Avineon will also prepare support schedule and purchase specifications for procurement of Hangers.

Avineon was selected as one of several vendors to perform conversion of BT's equipment, duct, cable and fibre data from incongruent raster records and existing vector data. The Data Transformation Project is one of a number of projects within the BT PIPeR Programme. The project will implement a system which will replace the existing GIS system and provide enhanced support for the automation of the network planning activities within BT. In addition the project will populate this system with good quality network asset data.

The existing GIS system, Planning and Records Modernisation information system (PRM) holds much of geographical and schematic data of BT’s entire physical network and an inventory of assets for the whole of the UK. However, not all of the required records to manage the network are held within PRM and most of the records in PRM are held as raster images. BT has a 3-year Network Access Strategy to deliver an integrated intelligent physical inventory system. The goal of this is to achieve a full “end-to-end” model of Network Asset connectivity for use within an auto-mated planning system.

Avineon performs conversion utilizing a proprietary AutoCAD / ORACLE-based tool customized to model BT’s database format and containing a central “rules” database. All data is subject to a series of manual and automated quality control inspections during production and delivery to the client is in an xml format.

Avineon was also previously contracted by BT to convert external plant facilities data from paper source documents to digital format in support of BT's PRM project. Avineon received digital landbase files from the Ordnance Survey (UK) and placed the required facilities data on the landbase using MicroStation-based data conversion software on a PC platform. Final data processing, quality assurance and formatting tasks prior to delivery to BT's Vision*-based system were performed on SUN SPARC Workstations.

Phase I of the project consisted of the conversion of 33 exchanges, 4 of which constituted a Pilot Project completed early in 1994. Conversion of the pilot exchanges provided BT ample data to perform an in-house evaluation of the PRM final product and validate their choice of Vision* software as their final platform. Between 1995 and 1998, an additional 221 total exchanges were converted and delivered in phases; the project was completed on schedule in December 1998.

Avineon was contracted by Cablevision Systems to acquire landbase data within their New York/New Jersey service area, translate the data to the Smallworld environment, and enhance the data for compliance with Cablevision's Model.it data model.

At the onset of the project, Avineon's project staff reviewed and finalized the technical project specifications with Cablevision, and customized / developed the necessary conversion software. then acquired existing digital source data in ArcInfo and ASCII formats. Upon receipt at our Clearwater facility, the digital source data was loaded onto our project server and registered to the Lambert Conformal Conic projection. Once registered, geographic landmarks available within the source data were appended, and an automated software application was run to generate right-of-ways at standard offsets from the street centerlines based on Department of Transportation road classifications.

Initial quality control tasks were conducted. Working on-line, Avineon's operators carefully reviewed each object and the right-of-ways to verify position and ensure there were no overshoots, undershoots, or overstrikes. Zip code data was conflated to the street centerlines. Once the data passed this quality control inspection, it was translated to Smallworld Model.it to create Smallworld objects with the required attribution.

Following translation, a series of automated and interactive routines was executed to confirm the translation was successful and the attribution of each Smallworld object was valid. All converted data was delivered to Cablevision in the Smallworld Model.it format.

Avineon is providing Web Services to Cargill, a McDonald's Business Unit. Avineon is providing Cargill's customers with web access to supply management data as a part of Cargill's Quality of Service (QOS) Initiative using Java, .NET, C#, SOAP, UDDI, WSDL, XML, JMS etc.

Cargill is a major supplier of oil and other food products to McDonald' Corporation. Cargill, as a part of their QOS initiative decided to provide some of its management data like oil usage etc. to its end customers (owners of the McDonald's restaurants) via the Web. This helps the store owners realize the maximum value for the oil they are using.

This Web based system, which is being developed with leading edge technologies like JAVA, .NET etc. will be in use by over 15,000 stores in the U.S. This system not only reduces a significant amount of overhead but also results in better time management for Cargill and its end users. This system will be capable of generating reports in multiple languages, thus allowing its use by stores and distributors outside the U.S. For Cargill, this will be one of its proven practices that will differentiate it from its competitors.

CenterPoint Energy maintains its Electric Network in an ArcGIS 8.1 Geodatabase format. The Engineering Department and Field construction crew record the changes happening in the field on a daily basis in the form of Work Order sketches, which are mostly schematic in nature. Avineon has been contracted to correctly analyze and interpret these work orders and relate these sketches to the appropriate location on the GIS and post these work orders onto the CenterPoint Energy Electric Geodatabase

Engineers at Avineon's state-of-the-art Production facility in India connect to the CenterPoint GIS server located in Houston, TX, via a 512 Kbps dedicated Internet bandwidth connectivity. The CenterPoint GIS Server is setup on Citrix Metaframe Win 2000 Client- Server architecture. The connection to the Citrix server is established over a secure, encrypted Virtual Private Network (VPN) and each user gets connected on a Direct I.P. This allows the Production Engineers in India to access all applications hosted by CenterPoint Energy on their Citrix application manager. The Engineers launch CenterPoint's Metro Electric ArcMap application and view and post the work orders in the CenterPoint Electric Geodatabase on a 2-shift basis, 7 days a week.

In 60 days, Avineon migrated Central Maine Power (CMP) Company's existing ArcView shape files of radial distribution circuits and devices from a preliminary conversion state to a final connectivity, database, and cartographic state. CMP supplies electricity to approximately 550,000 customers in 344 communities throughout central and southern Maine. CMP's 11,000 square mile service area contains more than 70% of Maine's population.

The work consisted of reviewing and adjusting the circuit and device shapefile layers to provide circuit connectivity, feature attribute completeness, and cartographic quality in conformance with detailed specifications. The migration task also included executing several quality control programs to verify circuit connectivity and attribute completeness after performing the initial editing. Additional tasks involved white space management and the placement of labels on the circuit line shape file using existing CMP ArcView programs.

The scope of work included nine work sets (service areas) containing approximately 340 circuits, approximately 533,908 poles, and 1,873 plots. CMP provided the CAD, Microstation based shapefiles, and hardcopy maps. These materials cover transmission structures and transmission centerlines, major and minor roads, streams, rivers, coastline, town boundaries, service area boundaries, geographic place names layers, and plot file grids.

Citizens provided hard copy maps and digital databases; including 1,860 facility maps, a Service Card database with over 83,000 records, a Main Card database with over 15,000 records, and a Customer Information database with over 63,000 records. All sources were to be assimilated into a centralized enterprise geospatial database. Utilizing Avineon's Data Capture Solution (DCSol) and Integration Solution (ISol) processes and ISO 9001:2000 standards, a project development procedure was engineered which guarantees an accurate database in an efficient and timely manner.

Avineon conducted conversion in the native software, Smallworld, that Citizens had selected for its enterprise AM/FM/GIS solution to guarantee the integrity of the captured data without encountering the problems often caused by importing spatial coverages. Important limitations and data integration requirements were applied to the process by Citizens, requiring advanced data capture and integration engineering. We could not alter the data model or GIS tables. One of the integration requirements involved the accurate division of one external database length to multiple captured main pipe segments. The sum of the segments needed to be within one foot of the database value and the values in the segments needed to reflect the spatial segments size. Solutions to these challenges involved the development of a DCSol/ISol data model that was applied to a separate database partition. By utilizing a spatial object controller, the database partitions were integrated. By populating designed DCSol/ISol tables in the Avineon database partition, customized applications were written to take the external database values into the Citizens database spatial objects. The Avineon database partition also acted as a working base for customized processes such as unique number assignments to facility objects and for proportional arithmetic calculations.

Innovative Data Capture elements included the creation of a customized Data Conversion Interface (DCI). The DCI allowed the conversion technician to intuitively call up the proper table and values for a facility object by selecting one menu option. Very little data entry was required which ensured attribute accuracy and standardization. Other innovative data capture elements were incorporated into a customized Post Processing Application. The results of this project will produce a central enterprise database with precisely placed spatial objects containing data from several different external database sources.

The City of Durham and Durham County contracted Avineon to conduct photogrammetric mapping services. Durham is located at the pinnacle of NC's famous "Triangle" region, and is home to 250,000 residents over a 300-square mile area.

The services provided include the acquisition of black and white airborne GPS (AGPS)controlled aerial photography for Durham County at a scale of 1"=660'. The flight mission consisted of 24 flight lines (flown north to south) with a total of 1151 exposures. Three dual-frequency base receivers collecting data at a one-second interval were utilized during the flight mission. The photography was acquired over a two-day period using a Cessna 401-B aircraft fitted with a Leica RC30 precision mapping camera and Leica GPS dual frequency receiver. Surveying was conductedfor the acquisition of ground control points and check points.

Fully Analytical Aerial Triangulation (FAAT) of the 1151 exposures was conducted, and DTM data was photogrammetrically captured. The existing DTM data for the southern half of the County was updated to support 2-foot contour interval accuracy. The black and white photography was scanned at 15 microns to yield a raw pixel resolution of 0.39 foot, and to develop digital orthophotography of 1467 modular map sheets with a ½- foot pixel resolution.

Project deliverables consisted of Ground Control Survey, AGPS and AGPS/AT reports, aerial photography, digital orthophotographs, topographic contours, planimetric data. Data was delivered in both MicroStation 3D design files and ArcInfo coverages.

Avineon was awarded a multi-year contract from the Columbia Gas Distribution Companies (CG) to provide comprehensive data conversion services. The project involves the digital mapping of the CG's gas line features and landbase. The conversion involves over 21,000 maps covering a geographic area of 6,900 square miles with 30,000 miles of pipeline. The mapping is being done using Bentley's MicroStation. Avineon has developed procedures and standards that will be used by CDC. Avineon will be doing the conversion of the CG companies (located in Ohio, Pennsylvania, Maryland, Virginia, and Kentucky) service areas. The gas facilities include transmission pipeline, distribution pipeline, valves, fittings, M&R stations and cathodic protection devices related to the distribution system. Landbase is generated using USGS Quadrangle color separates of landbase and hydrology. The quadrangle separates are geo-referenced to the UTM coordinate system based on the 1927 North American Datum.

Initially, road centerlines and hydrology are captured. Columbia Gas source maps are geo-referenced to the USGS quads data using the Helmert method of linear warping. Following this process, additional roads not included on the USGS Quadrangles are captured and the right-of-way is established. Upon completion of the landbase, gas features are captured and tagged with attribute data. Throughout the conversion process, all data are subjected to extensive QA/QC checks for format and content. MDL, MicroStation Basic, and Visual Basic programs have been developed to ensure that MicroStation databases are always in compliance with project specifications. Check plots are made and a complete content check is performed on each map. Final deliverables include plots and digital files of the converted area. Currently, Avineon is mapping the Toledo operating area in Ohio.

An additional contract was awarded to Avineon for programming services for the Columbia Distributions Companies. The programs, written in MicroStation MDL and Basic were designed to assist CDC in map maintenance and asset accounting.

Two CG operating units (Kentucky and Virginia) have contracted with Avineon to map completion reports to their respected systems. To date Avineon has mapped over 2,500 changes to the Kentucky and Virginia distribution maps in a three-year period.

In February, 2001, the Ohio operating unit had Avineon relate the customer database (in excess of 1.6 million customers) to the current maps. In a three-week period Avineon scanned, geo-referenced, and generated polygon coverage for 9,031 maps. Utilizing ArcInfo, Avineon related the customer address database to the proper maps. In the process, map numbers were related to the customer addresses. Twenty-eight separate Access databases were updated and delivered to CG-Ohio on schedule.

Avineon, Inc. has been contracted by Corning Cable Systems to provide the services for digitizing the Fiber Optic Network against a reference landbase and populating the attributes for the Networks objects using OptiCon™ (a unique software package developed by Corning Cable), which has MapInfo and Oracle 8i as the backend software.

Engineers at Avineon's state-of-the-art Production facility in India connect to the Citrix located at Keller, TX via a 512 Kbps dedicated Internet bandwidth connectivity. The Corning Cable Systems Server is setup on Citrix Metaframe Win 2000 Client-Server architecture. This allows the Production Engineers in India to access multiple databases at Corning on their OptiCon™ Network Manager. The Engineers launch OptiCon™ Network Manager application and perform the data capture/digitization and population of attribute data online per the feature specifications, naming conventions and attribution rules provided by Corning as part of Customer supplied information.

Avineon's production engineers digitize network components including complete physical layout of optical equipments inside of pedestals and buildings (down to the level of the specific component modules within housings and within frames). The Network connectivity includes splicing of fibers within splice trays in Wallmounts in buildings and in Splice closures or pedestals, mating of fibers into designated ports of patch panels, splitters, receivers, transmitters, etc. Node Trace checks and other network connectivity check programs and tools are executed on the database to ensure a high quality and seamless network information.

Avineon provided support to The US Department of Transportation Pipeline and Hazardous Materials Safety Administration to develop a comprehensive Enterprise Architecture (EA) that defines a comprehensive target architecture that integrates records currently stored in more than twenty separate databases. As one of the first steps toward developing the applications for the PHMSA enterprise architecture, Avineon initiated the Integrated Database Application (IDA) project to embark upon an economical strategy solely for the PHMSA office. Within the PHMSA office, there exist approximately seventeen major database applications currently being used by agents and over twenty other applications developed to support various departments and functions. Avineon's objective in the Enterprise Architecture design is to perform consulting and support services for the design and implementation of an IDA environment for PHMSA applications via the development of a pilot web application. Sepcific objectives included:

• Developing a detailed method for integrating future applications into an integrated database environment (IDA);
• Encouraging  the reuse of various components (e.g. software modules, database elements, models, document formats, etc) in the future;
• Developing a core database infrastructure, with the flexibility  to support any/all applications integrated, as well as handle other contingencies;
• Web-enabling these applications and develop structures to encourage the sharing of data, both within the family of PHMSA Offices, and with external stakeholders;
• Ensuring the security and privacy of data retained on these databases; providing data only on a strict need-to-know basis and;
• Reducing ongoing support costs, by standardizing the support requirements for all these different database applications

For FMS, Avineon is reengineering a legacy, single-user, stand-alone system for the Background Investigation Case Management (BICMAN) system. This effort involves converting the current BICMAN Dbase III database to Oracle, and implementing features that include expanded queries, ad-hoc and standard reporting, a full audit trail, and expanded documentation. The system implements required security features including role-based access, read-only capability for Regional Security Officers, and full system integrity. The modular, standards-based design allows for future upgrades and enhancements anticipating changes in federal guidelines and regulations for personnel security at FMS. The system is Microsoft-based and built around a .NET framework.

Avineon provides ongoing centralized technical support for the development, maintenance, and enhancement of FACTS II and GOALS II applications for the Department of Treasury, Financial Management Service (FMS). The support focuses in the areas of client/server application development, database development and support, and general management of network components, application servers, and end-user support.

Avineon also provides support in re-engineering of legacy client/server applications to web-based applications, including GOALS II, FACTS II, and IAS applications.

Avineon is responsible for providing all necessary personnel and materials to support the development of application software, both client/server and web based applications, for FACTS II, GOALS II, and IAS. For the web-based applications development, different technologies and tools are used, although the software methodology remains the same. Web based technology includes JAVA, JAVAScript, HTML, XML, JSP, Servlets, JAVA Beans, Enterprise JAVA Beans, Microsoft.NET, Struts Framework, DB2, Sybase SQL Server, and Microsoft SQL Server.

For all development efforts, Avineon maintains an environment in which to develop, install, test, and document newly developed and/or modified existing programs.

Avineon also provides Internet mentoring and development services to FMS. The objective of the mentoring services is to provide FMS with the technology and skills necessary to develop successful FMS systems using Internet technology. Avineon provides the experience and expert knowledge of the software products that are utilized at FMS including JAVA, J2EE, WebSphere, and MQ Series. The Avineon staff provides leadership by advising FMS project management and staff in sound decisions based on lessons learned and instituting industry best practices.

Avineon is working with the Internal Revenue Service’s (IRS’s) to enhance and improve their existing processing system for filing and releasing the Notice of Federal Tax Liens (NFTL). The project encompasses 2 main tasks 1) Logical System Design for the full implementation of the E-Lien software and 2) a pilot software development task to develop a subset of the full system.  

The Logical System Design includes the full functionality for an E-Lien system capable of sending liens electronically, receiving back confirmation, and interfacing with IRS’s Integrated Financial System (IFS).  The pilot application that is being developed will send IRS liens electronically to a local jurisdiction.  The application will includes functionality such as: User interface to control lien processing and file generation; Data loading from flat files into a database; Batch data extraction from database and generation of extensible markup language(XML) data files; Data encryption; and Manipulating / pushing files of liens to local jurisdiction(s).

Avineon’s task is to develop the detailed physical design and the software that builds the E-Lien database, user interface, data extraction logic and audit trail.

Avineon provides Enterprise Resource Planning (ERP) services to the United States Mint, Department of Treasury, specifically in PeopleSoft Finance, Distribution, and Manufacturing. The overall objective of the PeopleSoft re-engineering effort is to bring the U.S. Mint in compliance with the least access role based solutions. Avineon is responsible for analyzing current security classes attached to each PeopleSoft module, developing functional requirements for classes that are role based, developing classes based on these functional requirements, and facilitating the testing of the classes.

Avineon provides full life cycle support for information assurance, data and network security.  The scope of Avineon’s responsibility is at the enterprise level including all Mint IT systems, applications, databases, servers and network components.  Avineon provides system security life cycle support for new or modified Mint IT systems, user provisioning services, system operations oversight, infrastructure support, and fulfillment of other information security responsibilities.  Within these task areas, Avineon provides a full range of services including requirements analysis, research and development of security best practices, and independent validation and verification of existing and proposed applications, software and hardware components.

Avineon’s expertise covers a wide range of additional information security responsibilities including strategic management support, security requirements and analysis planning, awareness and training support for new Mint employees and contractors and emergency management support. Avineon's success in providing information security support services to the Mint is in their ability to adapt to an ever changing environment and leverage the latest state-of-the-art technologies.

The FOSS system manages and tracks DEA personnel who are assigned for service abroad, storing required data for the employees and their dependents.  Additionally, FOSS tracks other HR related information as DEA personnel are assigned to different locations overseas. This allows managers and users to produce personnel management reports.  

The current FOSS system was re-designed and enhanced by Avineon in a Microsoft .NET environment with an Oracle back-end database.  Avineon was subsequently awarded a follow-on extension to DEA FOSS, which is currently in the production phase.

The U.S. Drug Enforcement Administration awarded Avineon a five-year contract to assist in the conversion, modification, and enhancement of Microsoft Access applications and databases developed as part of the Workstation Tech Refresh (WTR) initiative. Avineon is responsible to the DEa Office of Information Systems (SI) for a wide variety of Access support across multiple users, organizations, and locations involving the design and development of multiple new databases and maintaining existing ones. Recently the team received four more new requirements to incorporate into the systems.

The MAS team continues to provide support to all ENEDS users at every DEA Division Office.  Some of the databases involved on this project are BPC (Board of Professional Conduct) database which is used by DEA's Human Resources, and BPC section which is used to track professional conduct for government employees and contractors.  Also included is OPFDS (Office of Personnel Folder Database System) which is used to track all government personnel folders in the file room and the database used by DEA's audiovisual unit to track video tapes, DVDs, and services provided

In November 2001 the CIB Team (CHS Ltd. and Avineon) was contracted to provide data conversion of telecommunications facility features in support of EPM's SIGMA project. Avineon's specific responsibilities include development of the software tools, training of our Colombian partners in use of the software tools, assisting with the Pilot area conversion, and migrating the converted MicroStation facilities data to EPM's FRAMME data model via the .SEF FRAMME Loader utility prior to delivery to the client.

Avineon is also providing ongoing consulting services via our Program Manager, Conversion Coordinator and Technical Coordinator; and consulting and technical support on an as-needed basis throughout the remainder of the conversion process.

The development of the conversion tools entailed software design and customization of existing Avineon software tools, using Visual Basic with Microstation as the graphics engine, and an ORACLE database. All converted data is delivered to EPM in the Intergraph FRAMME Workset format.

The telecommunications data conversion element of the SIGMA project entails the conversion of 482,364 telecommunications features.

Avineon is also providing ongoing management services via our assigned Program Manager, Conversion Coordinator and Technical Coordinator; and consulting and technical support on an as-needed basis throughout the remainder of the conversion process.

The development of the conversion tools entailed software design and customization of existing Avineon software tools, using Visual Basic with Microstation as the graphics engine, and ORACLE for database capture. All converted data is delivered to EPM in the Intergraph FRAMME Workset format.

The water/sewer data conversion element of the SIGMA project entails the conversion of 309,754 water/sewer facility features.

Avineon has partnered with Florida Power and Light (FPL) to undertake a large-scale GE Smallworld project that involves spatial repositioning and white space management for FPL's entire service territory within a fifteen-month production schedule. FPL is one of the largest and fastest growing utilities in the United States. Its service territory covers 27,650 square miles with facilities in approximately 14,000 square miles of this area. FPL has more than 3.9 million customers with a rapidly increasing customer base. In the year 2000, FPL added more than 92,000 accounts. FPL assets include 34 major generating units, 436 substations, 2,580 feeders, over 68,000 miles of electric lines, and over 1.1 million poles. In the year 2000, FPL added 13 distribution stations and 114 feeders. While this project originally involved multiple vendors, Avineon was quickly selected as the sole vendor as a result of our exceptional quality of work and client-oriented approach.

Avineon will adjust over two million electric facilities objects from their "logical state" in a legacy system to real-world positions in GE Smallworld using a positionally accurate landbase and raster imagery as references. As each object is moved, Avineon inspects the legacy data for errors in: 1) topological connections, 2) facility attributes, 3) circuit phases, and 4) internal worlds. All such errors must be corrected and missing topology or facilities objects must be captured in the correct location. All asset creation, manipulation, and re-positioning is performed natively within the FPL-customized GE Smallworld data model.

With a database exceeding 200 GB in size and an aggressive production schedule, FPL has pushed the envelope of Smallworld capabilities in order to ensure data integrity and project schedule. Avineon worked closely with FPL in conducting tests to identify the best method for data transfer including data replication, data extraction, and Citrix production. We also worked closely with FPL to find the optimal and most secure method for data connection modes between parent and remote databases including VPN configuration, SWMFS optimization, and optimal fiber optic dataline routes. A replicated database was initially the preferred method of data transfer because it allowed continuous updating of both parent and remote databases. However, due to the constraints that the auditing tables placed on the synchronization of the replicated database, it was determined that extracts would be used to perform the data transfer.

The challenges overcome for this project have enabled Avineon to further develop and refine its proficiency with GE Smallworld's latest technology and unconventional database strategies. The FPL project utilizes the DCU delivery strategy that governs alternatives, the AMTK toolset, a duplicated set of geometries for different database Views, connected internal worlds with "blow-up" capabilities, and advanced Clean-up and Validation tools. Avineon has been very successful at transitioning its conversion and migration process to support this large-scale project while maintaining focus on producing exceptional quality results.

Avineon was subcontracted by CADTEL, Inc. to post 470 backlog work orders, as well as additional 502 "blanket work orders" for Frontier Communications, Inc. of Minnesota. CADTEL, Inc., is a leading provider of GIS software for the telecommunications industry.

The posting effort included updates to existing OSP data sets for facilities, as well as landbase. The source materials consisted of as-builts prints, plats and engineering notes/assignment system printouts.

Avineon conducted the work using the Citrix Window Emulator via telephone connections between our Clearwater facility and Frontier's Minnesota office. The target GIS platform was CADTEL, Inc.'s LOGIC/GIS V6.0.

By posting work orders on two shifts daily, Avineon was able to maximize the utilization of Frontier Communication's Spatial Base system to complete the project as quickly as possible, to the client's complete satisfaction.

Avineon was contracted by Gabriel Ride Controls to convert over 1,300 complex mechanical drawings into AutoCAD format in accordance with Gabriel specifications. The task included converting family of parts drawings into AutoCAD files along with all supporting part table data.

Avineon provided Facilities Drawing Conversion Services to GSA Joseph ADDABBO Federal Building at Jamaica, Queens of about 900,000 Square Feet in area which involved scanning, digitizing, vectoring, modification and graphics and erroneous characters clean up and also inserting missing text.

The conversion effort involves an on-site survey of the building(s) to be converted, and the necessary update of the design documentation, to render products that reflect an as-built condition. Field verification of architectural features was done using DISTO laser device, as-built verification information was incorporated into the converted drawings. Also, in support of this effort, Avineon developed an agency-wide Computer Aided Design and Drafting (CADD) Standards Manual for GSA Joseph ADDABBO Federal Building, including file naming and layering standards, and a standardized symbol block library. Conversion of facilities drawings for all disciplines (architectural, structural, mechanical, plumbing, electrical, etc.) was accomplished using AutoCAD and the CADD Standards Manual. Additionally, on-site AutoCAD and drawing maintenance training was performed.

Avineon also analyzed and documented GSA's workflow processes and procedures and developed a standard drawing maintenance and revision procedure. Avineon then conducted an in-depth analysis of GSA's business and functional requirements as they pertain to the facilities management process, working closely with the COTR and through working sessions with the user community, to define the requirements.

Helix Water District in La Mesa, California selected Avineon to convert a variety of graphic and nongraphic data sources to populate the District's Smallworld Geographic Information System (GIS) database. Helix Water District provides water services to approximately 250,000 customers through 54,000 service connections in the cities of El Cajon, La Mesa, Lemon Grove, and Spring Valley, California.

Avineon performed a successful pilot project at its offshore facility in Malaysia that was accepted by Helix in June, 2000. The pilot and full conversion phases entailed the migration and conversion of data from AutoCAD files, primary map sets, schematics, and spreadsheet information. The Helix plat maps depicted landbase features, including subdivision record of survey, parcel, and street right of way lines, and water system facilities and structures. Intelligent street centerline file products were incorporated into the Helix GIS database and used to support street intersection queries. At the request of the client, Avineon was able to shorten the overall project timeline by two months, enabling Helix to meet other internal deadlines.

Avineon supports HUD’s Real Estate Assessment Center (REAC) to provide system development, enhancement and maintenance of the agency’s Physical Assessment Subsystem (PASS). PASS facilitates numerous mission-critical functions related to HUD’s physical property inspections to ensure public housing is properly maintained.

REAC is an organization within HUD Public and Indian Housing (PIH) that is responsible for capturing, standardizing, improving and evaluating data from the portfolio of properties for which HUD has a financial interest or statutory obligation to monitor. HUD requires periodic physical property inspections conducted by HUD/REAC certified inspectors in conformance with HUD’s Uniform Physical Condition Standards (UPCS). To ensure consistency and uniformity of inspections, inspectors must utilize a laptop computer “data collection device” (DCD) and UPCS inspection software to capture inspection results, which are uploaded via the Internet to PASS. The system then facilitates numerous functions including ordering, reverse auctioning and review of inspections as well as publication of inspection results.

Avineon’s goal is to assist PIH-REAC in providing standardized and quality program assessment information to support program management of Public Housing and Office of Housing Multifamily properties. PASS is the cornerstone of the PIH-REAC suite of products, and the Avineon team is responsible for system development, enhancement and maintenance of the PASS and DCD software. Additionally, Avineon is redesigning both the PASS and DCD software to accommodate migration from a ColdFusion development environment to a Java/J2EE environment.

Avineon supports the HUD Real Estate Assessment Center (REAC) in the applications development, maintenance, and enhancement of the Financial Assessment Subsystem - Public Housing (FASS-PH) Project. FASS-PH enables centralized financial analysis that can be used to identify where HUD should focus its resources to improve service delivery and manage its housing programs more effectively. HUD/REAC utilizes a standard financial assessment protocol, based on generally accepted accounting principles (GAAP), to annually assess the financial health of the 3,300 Public Housing Agencies (PHAs) existing in the U.S. These assessments are based on financial statements submitted electronically to HUD according to a standard chart of accounts.

The FASS-PH system provides trend, performance, and compliance analyses; PHA profiles; standardized monitoring checklists; results and status of document reviews; and PHA expense and revenue reports. It also tracks review milestones and timeframes, and serves as a knowledge base of current compliance requirements, PHA self-assessment tools, and referrals to PHAs with exemplary practices.

The Avineon team is responsible for the FASS-PH system development, enhancement, and maintenance, while ensuring that FASS-PH, a mission critical system, is fully functional and operational at all times. Additionally, the project team is redesigning FASS-PH to accommodate migration from a ColdFusion development environment to a Java/J2EE environment. Currently, FASS-PH is developed using ColdFusion for the web front-end and Sybase as the back-end database.

Avineon is providing detailed engineering and Plant Design System (PDS), 3D modeling services to Larsen & Toubro (L&T) Chiyoda Limited for the ongoing India Oil Corporation Limited, Madhura’s MSQ (Mortar Spirit Quality up gradation) project. The scope of work includes Equipment Modeling of Process Columns, Vessels, Heat Exchangers and Coolers etc., using PDS, preparation of Nozzle Orientation Drawings for Process Equipments using Drawing Manager of PDS, Preparation of Equipment Layout for Compressor House, Piping Study, 3D modeling of various Piping Systems, Generation of Stress Isometrics for Static Analysis, Support Modeling, Extraction of General Arrangement Drawings, Extraction of final Isometrics for shop release and support drawings.

Avineon conducted various GIS and imagery related services as part of MAG's GIS Database Enhancement project. These services included the georegistration of imagery and Arc/Info datasets, the update and address encoding of street centerline files, and the production of specific GIS data layers (coverages) for MAG planning and analysis. The project involved the coordination of standards and database specifications with over 27 jurisdictions and stakeholders in the Maricopa regional modeling area. Avineon developed addressing standards, data dictionaries, and database capture specifications for over a dozen coverages. ArcView, Arc/Info, and AutoCAD Map were the primary software tools being customized for use within this project. The project also required interview, data collection, and assessment processes in cooperation with the stakeholder community. Specific features were evaluated for update, flagged, edited, and tagged with various metadata on a per feature basis. Avineon delivered 27 separate coverages to each jurisdiction as ArcExplorer files; all coverages were appended to a single region wide GIS dataset. Avineon achieved a 95% accuracy rate for almost a million records.

Sources included street centerline data, actual and theoretical address range, existing/planned land use, census, land owner information, etc. One of the primary sources for this project was a collection of countywide imagery that included a mix of resolutions and data types (aerial survey and USGS DOQQ). Because the imagery was not orthorectified, Avineon had to develop a series of procedures, data capture rules, and interpretation keys in order to assist the analysts in "localized" decision making when updating the position, shape, and attributes for road centerlines and municipal planning area polygon boundaries. Accuracies of 2 feet to 25 feet in rural areas were achieved. The MAG project area covers 11,000 square miles, over 250,000 street records with 39 attributes, 18 million total attributes, 1000's of municipal planning area polygons, and conflation of 6 major source documents including TIGER, Wide World of Maps, Maricopa DOT TASC, and MAG. Additional source data included Arizona DOT TASC data sets, 6,800 aerial photographs, 6,000 tiled square miles of Multispectral digital imagery, USGS DOQQ, 5 primary address databases from 3 utilities, E-911, tax assessor documents, and numerous other sources.

Avineon provided Information technology services in design, development, and implementation of a data warehouse. The data warehouse integrates data from multiple transaction systems of different platforms into one single centralized repository eliminating data redundancy and providing data integrity. Avineon also provided on-line analytical analysis capability that has a user-friendly GUI application with secure access though internet/intranet. The system stores GIS data, which can be processed into graphically represented and analyzed results using the decision support functionality.

Avineon provides technical support for the analysis and evaluation of the Navy's Terminal Instrument Procedures (TERPS). TERPS are used by Naval and Marine Corps aviators at Air Stations worldwide, as well as at certain Host Nation airports, when operating around airfields under instrument flight rules (IFR). Avineon's Flight Procedure Specialists (FPS) develop, review, and analyze TERPS in conformance with NAVFIG flight safety standards, prepare supporting documentation, and recommend validation to the Head of NAVFIG. FPS assist in maintaining the NAVTERPS NAVAID, Obstacle, Airport, and Runway databases and conduct evaluations of proposed obstacles. Avineon's Aeronautical Information Specialists research, analyze, evaluate, compute, and compile textual and graphical aeronautical data for inclusion in DOD and DOT flight publications, and also review, revise, or delete previous publications. AIS provide support in processing Notices to Airmen, Aeronautical Radar Video Maps, and in maintaining Air Field Records

In order to automate the TERPS analysis, Avineon has developed NAVTERPS, Naval Terminal Instrument Procedures. Based on Microsoft Access and Visual Basic, NAVTERPS performs the TERPS analysis for each segment (including Initial Approach, Intermediate Approach, and Final Approach) for radar, non-radar, precision, and non-precision instrument approach procedures. Avineon continues to maintain and enhance the existing NAVTERPS system by catering to immediate repairs of the database and/or software problems as well updating the software to meet requirements in the Change Orders issued by the FAA.

In conjunction with NAVTERPS, Avineon is developing AVNAVTERPS to incorporate GIS into the system. Using ESRI ArcView GIS and supporting software products, Avineon's programmers create an easy-to-use, customized interface and enable the user to import NAVTERPS data, analyze NIMA Digital Terrain Elevation Data (DTED), determine the highest DTED Cells, and transfer selected cells to the NAVTERPS obstacle table.

Avineon developed a large management information system for the U.S. Navy for battle group interoperability certification. During the initial phases of this project, the focus has been on system design, development, and integration requirements. This work has involved applications development in a LAN-WAN environment, database administration in Oracle 8i and SQL Server, and web site development. The primary product of this effort is a data warehouse that contains up-to-date information on the resolution status of trouble reports generated by land-based and at-sea tests of combat systems on the ships in the battle group. Avineon also studied the problems of facility operation and maintenance that will arise during the implementation phase that is to follow the current effort.

Avineon developed the C/CLAM system for the NAVSEA combat systems group. C/CLAM provides an automated user assisted equipment arrangement tool to place user-defined equipment into a CAD model of a ship's compartment. Equipment may be extracted from up to 20 different "combat system" libraries. Avineon developed a prototype system for integration of C/CLAM System and relational database on Intergraph CAD 2 platform. The program produces reports and performs analysis such as area ratios and clearances on compartment arrangements.

Avineon provided support to PMS-500 of the Naval Sea Systems Command, in Modeling and Simulation (M&S). Avineon provided technology support in the development, review, and evaluations of M&S designs, as well as technologies, risk analysis of M&S concept, designed, planned and reviewed M&S concepts. Avineon also performed general modeling and developed M&S protocols and standards. Avineon performed M&S related technical studies and analysis and provided technical support with an emphasis on M&S plan, risk reduction, and Smart Product Model (SPM). Specifically, Avineon has been involved in the evaluation and assessment of Dessault's CATIA 3D modeling software development as it applies to the DD21 program and SPM applications.

Avineon provided services for comprehensive integration of Intergraph CAD-2 in the design of the next generation nuclear fast attack submarine (NSSN). This included data conversion to and from various platforms and software including AutoCAD, VIVID, MicroCADDS, Intergraph Microstation, and VDS using IGES and DXF translators. Avineon developed 3-dimensional product model utilizing I/VDS to model the hull, subdivision, compartmentation, and equipment files. Avineon also provided database management of all design files and attribute data files using PDM, generated attribute files to facilitate analyses and report generation, performed model drawing extraction and data extraction, and provided user support to NAVSEA and shipyard personnel. Standards and procedures were developed for users to assure a high degree of consistency and model integrity.

Avineon developed a large management information system for the U.S. Navy for battle group interoperability certification. During the initial phases of this project, the focus has been on system design, development, and integration requirements. This work has involved applications development in a LAN-WAN environment, database administration in Oracle 8i and SQL Server, and web site development. The primary product of this effort is a data warehouse that contains up-to-date information on the resolution status of trouble reports generated by land-based and at-sea tests of combat systems on the ships in the battle group. Avineon also studied the problems of facility operation and maintenance that will arise during the implementation phase that is to follow the current effort.

Under contract to the Naval Surface Warfare Center, Carderock Division (NSWCCD), Avineon provided support to the Integrated Data Environment Applications Branch (Code 264) and related projects from other technical codes. The work involved a wide range of system support services under multiple delivery orders for IT services in support of the research, development, and implementation of product model technology in shipbuilding. Avineon developed individual delivery order plans and proposals, including phasing in of project staff to meet delivery order requirements. Avineon provided staffing covering a diverse set of labor categories including Program Manager, Computer Scientist, Systems Analysts, Engineers, Designers, and Administrative Support. Avineon received an initial contract and then a follow-on contract for NSWCCD support over a five-year period starting in 1997. There were approximately 12 delivery orders during this period. Work was accomplished both on-site at Carderock and NAVSEA HQ, and at Avineon facilities in Alexandria, Virginia.

Avineon provided comprehensive services for the Early Stage Design Information System Support (ESDISS). This delivery order involved computer and Network Operations and Maintenance Support and Computer Aided Engineering. On-site computer systems operation support responsibilities included: support for all systems and platforms, including the server, database, and design file systems; support of backup and disaster recovery operations, reel and cartridge tape mounts, and printed output distribution; automated operations support including removable media management, automated rerun and recovery, automated report distribution, job scheduling, and print facilities. Avineon also provided comprehensive LAN and Microcomputer Support including installation, upgrade, and configuration of workstations; troubleshooting; cable plant testing; and COTS software installation, upgrade, and removal. Responsibilities included organization and implementation of the network file systems, back-up routines to support storage and maintenance scripts, equipment, and PPL routines. Software and hardware products used by Avineon included: Novell, Windows NT, Windows 98; VAX cluster, SUN SPARCenter 2000, HP 9000 Series 800, HP Apollo, and Sequent S27.

Avineon provided the Intergraph experience and technical design expertise for the Engine Room Arrangement Model (ERAM) project to the NSWC in support of the Mid-term Fast Sealift Program. Avineon performed comprehensive integration of CAD-2 in the iterative design process of a world-class machinery room arrangement. Avineon converted vendor supplied paper based and digital component 2-D data into solid models utilizing IGES, DXF, and raster image conversion. This required developing a 3-Dimensional product model utilizing I/VDS to model the hull, subdivision, compartmentation, and equipment files. Avineon also developed a complete 3-Dimensional ship product model for three separate propulsion plants utilizing an Integrated Product Design (IPD) approach that involves state of the art design methods including Quality Functional Deployment (QFD) and Strategic Design Method (SDM).

Our personnel have extensive training and experience in QFD and SDM in implementing an IPD product design that includes a complete review and evaluation of current practices and technology for product designs and manufacturing and reducing risks associated with new technology insertion while maximizing new product utility. We also provided database management of all design files and attribute data files using PDM, developed and maintained Informix database, generated attribute files to facilitate analyses and report generation, performed model drawing extraction and data extraction, and developed the ERAM CAD-2 Applications Users Guide defining the standards and procedures for users to follow to assure data consistency and model integrity.