Information is everywhere these days but we can’t necessarily get our hands on exactly what we want when we want it. Much of our information still resides in paper format, and what exists digitally is often in disparate locations at various revision levels and under the control of decentralized silos. Compiling that data and quantifying results can be a daunting task. Imagine what we could accomplish with all of that data current and at our fingertips.
All hail the database! Database technology has revolutionized our ability to store and access data. But how to get our information into a database? And how to access it efficiently once it’s there?
CAD Masters staff are experts in the automated conversion and compilation of disparate data sources into a centralized data structure. We are also experts in the development and customization of graphical interfaces by which to access and manipulate that data. As engineers, we specialize in data associated with utilities, facilities, and other hard assets, and we’re used to finding that data in paper drawings, AutoCAD drawings, and SHP files. As programmers, our experience includes extensive development in the areas of FDO and EDD, the primary components of AutoCAD Map 3D. We are experts in both SQL and Oracle, and all of our applications are currently being developed using Microsoft .NET technology to ensure long term compatibility with Autodesk products, Microsoft products, and internet technology.
Our past projects have included the development of custom applications that read information from AutoCAD design drawings, insert and track parts, estimate costs and quantities, and produce required reports, detail drawings, or even data to a saw that cuts lumber.
We’ve automated the conversion of large digital dwg archives into a standard format, extracting and manipulating data as required. We’ve written applications to build an AutoCAD drawing from scratch from a series of database records, and vice versa. We’re intimately familiar with the coding of AutoCAD Civil 3D and can easily extract data from Civil 3D or create Civil 3D objects from database information. And we’re experts in website development should our clients desire to publish their data either internally or externally in web format.
Our most interesting project was the development of an asset design and management solution for City of Palo Alto Utilities, a centralized GIS. CAD Masters extracted and combined all data for all utilities into a centralized database structure. Some of this existing data was in paper format, some in MS Excel and Access, some in a library of dwg files and still more in a custom GIS architecture. The data can now be accessed by engineers for design, field technicians for maintenance, and administrative staff for project billing and service requests. AutoCAD Map 3D, with an Oracle backbone, is used to control the rules based design and workflow. SAP is used to provide parts inventory and extract project cost. Graphical interfaces have been developed both inside and outside of CAD to allow data input and query by various departments. And a custom application synchronizes Oracle to SQL for access by a multitude of staff at the City. CAD Masters’ combined experience in Civil Engineering and database programming enabled us to make this full scale GIS implementation a success.
Our background positions us to assist you with any data or GIS initiative. Call us to discuss your needs in detail.