Case Studies on Property Review
Farallon assists with litigation support
Challenge
A California legal firm was handling a dispute over a large parcel of real estate located in rural California. They needed a way for a San Francisco jury to visualize the size of the property.
Solution
Farallon used publicly available parcel data for the relevant areas and overlaid these outlines on a Google Earth orthophotograph of the City of San Francisco to show the property size in relationship to the size of San Francisco. Read more details...
Categories: Web Applications, Property Review
Contra Costa Economic Development website integrates spatially-aware database and MS Virtual Earth
Challenge
To promote economic development, Contra Costa County Community Development Department wanted a website to help real estate professionals and business owners search for properties available for development or new business locations.
Solution
Farallon developed an easy-to-use prototype "GIS Site Locator" website using Microsoft's Virtual Earth that dynamically queries geodata and broker information stored in Oracle Express. Users enter parameters such as price range and square footage to quickly find and display properties on a map along with photos and driving directions. An RSS feed automatically keeps users updated of relevant new properties. Read more details...
Categories: Web Applications, Enterprise Mashups, Property Review, GIS/IT Integration, Business Intelligence Systems, Geodatabase Design, Open Standards Solutions
City of San Mateo Google Earth integration with OGC compliant data
Challenge
The City of San Mateo uses a suite of GIS applications for staff to access geospatial data. The City wanted to provide more intuitive access to its GIS data and make it accessible to the public using the Google Earth interface. However, the back end GIS was not able to deliver geospatial data directly to Google Earth.
Solution
Farallon built a web service interface using .NET to translate data from the City's Intergraph GeoMedia WebMap server to a format usable by Google Earth. This allows a Google Earth user to view selected City GIS data such as high quality aerial imagery and point, linear, & polygonal features - all in real-time. Read more details...
Categories: Web Applications, Enterprise Mashups, Property Review, Geodatabase Design, Open Standards Solutions
Army Corp of Engineers projects analyzed by congressional district
Challenge
The Army Corp of Engineers is the nation's primary federal engineering agency responsible for tasks ranging from hazardous waste clean-ups to reservoir and dam maintenance. The ACOE needed an accessible way to track and manage project budgets in CA, NV and AZ by geography and congressional district.
Solution
Farallon created a web-based application that lets a user select a geographic area, congressional district, or watershed region and retrieve a list of all current projects in that selected area. Click on a project name and a popup window provides full project details. Read more details...
Categories: Web Applications, Property Review
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. Read more details...
Categories: Web Applications, Notification, Property Review, GIS/IT Integration, Master Address Database, Geodatabase Design
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. Read more details...
Categories: Web Applications, Property Review, GIS/IT Integration, Geodatabase Design
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. Read more details...
Categories: Web Applications, Notification, Property Review, Geodatabase Design, Utility System Data Modeling, Planning & Training, GIS Needs Asssessment
City of Fairfield Enterprise Geodatabase and Master Address Development
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 designed to meet the needs of all its stakeholders.
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. Read more details...
Categories: Web Applications, Notification, Property Review, GIS/IT Integration, Master Address Database, Geodatabase Design, Planning & Training, GIS Needs Asssessment
Bureau of Indian Affairs Land Management System
Challenge
The Bureau of Indian Affairs (BIA) Division of Real Estate Servicesmanages 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 geo-data 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. Read more details...
Categories: Web Applications, Property Review, Geodatabase Design
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. Read more details...
Categories: Web Applications, Property Review