Engineering organizations accumulate data in forms that don't talk to each other: paper drawings, DWG archives, SHP files, Excel spreadsheets, database tables. Getting that data into a single accessible structure, and keeping it current, is a hard problem that general IT firms rarely have the domain knowledge to solve.
We do this work specifically for utilities, facilities, and infrastructure clients. Our staff are engineers who also program, which means we understand both what the data represents and how to move it. We have deep experience in AutoCAD Map 3D, FDO (Feature Data Objects), and EDD (Enterprise Data Dictionary), and we build applications in Microsoft .NET to ensure long-term compatibility with the Autodesk and Microsoft ecosystems.
Our project work includes: automated conversion of large DWG archives into standardized GIS feature classes; custom applications that read AutoCAD drawings to extract part counts, cost estimates, and quantities; and tools that generate complete AutoCAD drawings from scratch using database records. We can extract Civil 3D objects into GIS or create Civil 3D objects from database information.
One reference project: we built the GIS asset management system for the City of Palo Alto Utilities. That engagement consolidated utility data from paper records, MS Excel and Access files, DWG archives, and a custom GIS architecture into a unified Oracle database accessed through AutoCAD Map 3D. Field technicians, design engineers, and administrative staff each have tailored interfaces. SAP handles parts inventory and cost extraction. A custom sync application keeps Oracle and SQL Server current without manual intervention.
If your organization has data spread across formats and systems and needs it centralized and accessible, contact us to talk through the problem.
