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.

T