Abstract
 Leveraging Geoprocessing Functionality to Manage Enterprise Data in Sacramento County Track: Database Design, Automation, and Management Author(s): Cynde Porter, Bob Earle As primary data providers for enterprise departmental systems, intranet/Internet ArcIMS solutions, shared GIS cooperative data repositories, and E-911 dispatching, Sacramento County is committed to providing accurate, timely, and standardized tabular and spatial data in the most efficient manner possible. We have accomplished this by utilizing geoprocessing scripting in tandem with both Oracle and SQL Server core database functionality. Scripting has been used not only to facilitate laborious creation/conversion processes and disseminate the resulting datasets in multiple formats but also to integrate real-time tabular information derived from numerous relational databases. We have further been able to embed compiled geoprocessing scripts into scheduled RDBMS data transformation packages to integrate native SQL coding and view generation with fundamental GIS capabilities. As a result of more efficient data integration and task consolidation, staff are now freed to devote more time and focus toward developing and growing our GIS to support ever increasing customer requirements. Cynde Porter Sacramento County GIS GIS 9700 Goethe Rd. Suite A Sacramento , CA 95827 US Phone: 916-875-7032 Fax: 916-875-6213 E-mail: porterc@saccounty.net Bob Earle Sacramento County GIS GIS 9700 Goethe Rd. Suite A Sacramento , CA 95827 US Phone: 916-875-6800 Fax: 916-875-6213 E-mail: earleb@saccounty.net |
|||||
