Clients
Property Review Case Studies
Oakland uses orthophotography & enterprise GIS for parcel management and economic analysis
Challenge
The City of Oakland wanted to improve the usefulness and accuracy of its existing parcel data and integrate it with an enterprise geodatabase to expand city services across multiple departments.
Solution
Farallon and its team built an enterprise-scale parcel database using spatially accurate orthophotographs and integrated it with a new master address database, which was created in just six months. That high level of integration meant that any City information with a spatial or property component could be spatially enhanced, including property review, permit tracking, land-use planning and notification, and E-911 dispatch.
Davis County, Utah Enterprise Parcel Database and Web Application Development
Challenge
Davis County wanted to transform their existing GIS system by developing an enterprise geodatabase and website capable of delivering dynamic spatial information for property review.
Solution
Farallon designed a Land Information System (LIS) database and web portal that supports the county's property management workflows and converts the county's legacy file-based data to a SQL Server geodatabase. The web-based property review application consolidates property ownership, taxation, and jurisdiction information from several county databases.
Fairfield Suisun Sewer District Water Utility Enterprise GIS and RDBMS
Challenge
Fairfield Suisun Sewer District (FSSD) needed to expand their existing GIS for utility pipeline management, to integrate with and be of use to other departments.
Solution
Farallon developed a business case for a complete enterprise GIS, including the development of technology, geodata, workflows, a web portal, and staffing plans. Implementation included a water utility data model, a populated geodatabase (using ArcSDE and ArcGIS), and specific GIS workflows designed to ensure that FSSD's network administrators and GIS staff were comfortable managing the enterprise GIS. A geospatial web portal integrated other District business units, consolidating specific GIS applications (such as property review and notification), metadata, workflows, and standards into a single, web-based environment, available to all staff.
City of Fairfield Enterprise Geodatabase
Challenge
The City of Fairfield (Fairfield) faced several challenges in building a functional Enterprise GIS. Fairfield had fragmented, disparate technologies and limited communication with potential external GIS partners. Fairfield needed an enterprise-wide strategic GIS to integrate many departmental datasets, including Public Works, Planning, Police, and Economic Development data.
Solution
Farallon recommended that Fairfield develop an enterprise geodatabase using ESRI's ArcSDE software and Microsoft's SQL Server database. From this, Farallon built a variety of GIS applications that support business functions of the city and it various departments, including a geospatial portal that allows all city staff to quickly create notification lists and summary reports for any property within the city.
Bureau of Indian Affairs Land Management System
Challenge
The Bureau of Indian Affairs (BIA) Division of Real Estate Services manages all land held in trust for California Indian Tribes. The Pacific Regional Office needed to develop and deploy a working land management system that would support business needs and leverage partnerships with other Federal Agencies and Indian tribes on a very aggressive timeframe.
Solution
Farallon designed and built an ArcSDE geodatabase on Oracle to support web/map publication of an enterprise GIS to manage the State of California's Indian Lands. The GIS integrates diverse geodata from a number of federal, state, and local sources to describe the extent, ownership, and use of Indian Nation lands within California and western Nevada.
Santa Clara County Assessor Office Online Tax Assessment Viewer
Challenge
Santa Clara County houses some of the world's leading technology firms. With the technology boom in the late 90s there was a surge in population and the housing market. Santa Clara County needed an accessible and intuitive way for both County staff and home-owners to access property data while also managing the influx of people visiting the County offices.
Solution
Farallon built and deployed an Oracle 9i database that provides access to over 2 million records related to property values, tax assessments, situs addresses, and tax rate areas for the entire Santa Clara County. By designing a web application with a user-friendly interface, the Assessor's Office Assessment Roll Information Inquiry and Retrieval application, both County staff and County residents can access up-to-the-minute property assessment information for the current and past three tax years without ever having to go to the County Assessor's office.