Alert: Please correct the errors!
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.