—Jeffrey Engerski and Ian Watson, Photo Science, Inc.
View Presentation [PDF]
The Florida Department of Transportation is a creator and consumer of CADD data. These data are built and maintained using COTS CADD software packages and there are strict workflows associated with the development and management of these data assets. However, the ability to view and interrogate those data from within a GIS environment has become critical to business functions across District 7. The District 7 Development Team enabled wide use of these CADD data assets by integrating those data into the District's enterprise geodatabase. The Data Interoperability extension for ArcGIS proved to be the key tool in creating an Extract-Transform-Load (ETL) model that automated the translation of CADD data into the existing enterprise geodatabase. ArcObjects coding was used to wrap the ETL model into a 'CADD Interoperability Application' or CIA. The CIA is a console application that is spawned each evening and retrieves available CADD data for inclusion in the enterprise geodatabase. During the automated translation to feature classes, the CADD data are classified based upon their initial layer types and a set attributes including color, weight, and line style. Once posted to the geodatabase, the data are accessed by District users through a browser-based ArcGIS Server application that provides viewing, querying, and analysis capabilities. District users are able to view these data within the appropriate spatial context and with access to a multitude of thematic data layers overlaid with current aerial photography.