The City of Santa Rosa needed a well structured, valid, and accurate geographically referenced data (geodata) to support a wide range of departmental business functions. But their existing workflow involved drawing maps using AutoCAD, and then physically handing the paper maps to staff who manage the Hansen Asset Management System to be used as source data for asset inventory records. The City needed to automate the process of populating the asset inventory in its Asset Management System based on information in the utility maps generated with AutoCAD.
Farallon developed a GIS data model in an ESRI geodatabase that is populated from AutoCAD using an automated ETL (Extract, Transform, Load) process driven by FME software. Farallon also built an FME process that performs spatial comparisons and populates all of the spatially derived fields for every feature in the geodatabase where a spatial relationship exists. These fields, in addition to other AutoCAD derived fields, are then uploaded to the Hansen Asset Management Software using Hansen’s GeoAdministrator product.