Clients
SQL Server Case Studies
Bay Area Air Quality Management District - Geospatial Components Integration With Mobile Field App
Challenge
The Bay Area Air Quality Management District is responsible for maintaining air quality standards within the nine San Francisco Bay Area counties. BAAQMD needed to develop and integrate geospatial functionality into backend applications for permitting, engineering, and enforcement used for daily operations. They also wanted to build and integrate a mobile application into their system to support inspectors in the field.
Solution
Farallon developed and integrated geospatial functionality into the District's customer facing permitting application and internal SharePoint portal that contained all of the District's spatially related data. Farallon also developed an Android-based mobile application and integrated it into the District's production system to support coordination between inspectors in the field and managers in the District's office.
Union Sanitary District Plant GIS
Challenge
Union Sanitary District wanted to develop a Plant GIS Rich Internet application for viewing wastewater treatment plant infrastructure and managing mission critical workflows. It needed to tightly integrate with 15 business systems including SharePoint, Hansen Asset Management System, Wastewater Asset Management database and ArcGIS Server.
Solution
Farallon designed designed, developed and deployed a web-based Plant GIS asset tracking application that monitors wastewater treatment plant infrastructure and manages mission critical workflows.
City of Oakland, CA Enterprise GIS and Master Address Database Development
Challenge
The City of Oakland wanted to improve the efficiency, automation and integration of its location-based data, improve the usefulness and accuracy of its existing parcel data, and develop an enterprise geodatabase to expand city services.
Solution
Farallon built an enterprise-scale parcel database using spatially accurate orthophotographs and then implemented a master address database (MAD), providing the City with a comprehensive inventory of the City's addresses. The system also tied in other outside data sources including the Alameda Assessor's property database and Oakland permit tracking database.
City of Fairfield Master Address Database Development and Integration with Enterprise GIS
Challenge
The City of Fairfield had no single complete, accurate, and current address list that could be used as the authoritative list of business and residential locations for providing essential services. This limited the ability for City departments to coordinate efforts and integrate information across business systems.
Solution
Farallon is developing a comprehensive Master Address Database within the City of Fairfield’s GIS geodatabase.
City of San Mateo Master Address Database
Challenge
Addresses are a key dataset used by the City of San Mateo to provide essential services. No single complete, accurate, and current address list existed within the City that could be used as the authoritative list of business and residential locations. This limited the ability for City departments to coordinate efforts and integrate information across business systems.
Solution
Farallon designed and deployed a Master Address Database (MAD) as a central authoritative service for all City departments. The MAD offers increased data availability, reduced errors and maintenance, elimination of duplicate data, and enhanced City services.
City of Boston Redevelopment Authority: Web Based GIS Redevelopment Project Tracking Portal
Challenge
The Boston Redevelopment Authority manages the review process of City development projects. Over time, redevelopment related data had become spread across several independent databases making it difficult to integrate the data necessary to complete a formal redevelopment project review.
Solution
Farallon created a web application to integrate the City's permitting system with an enterprise databases using GIS . Fast and simple access to 2D & 3D maps, City GIS data, and project specific redevelopment information, was developed using web services to dynamically overlay GIS results onto Virtual Earth.
City of Santa Rosa GIS/PMS integration
Challenge
The City of Santa Rosa wanted to integrate their pavement management system with their enterprise GIS and provide live-links between the two systems.
Solution
Farallon integrated MTC's StreetSaver v.8 pavement management software with ESRI's ArcSDE/ArcGIS software on an enterprise SQL Server database and defined a new data model, linking procedures, and database views to provide a live-link between the PMS and GIS systems over 542 miles of streets.
San Ramon Valley Fire Protection District Brings Enterprise GIS to the Fire Truck
Challenge
The San Ramon Valley Fire Protection District provides fire and ambulance service to a rapidly growing population from two cities. New land development meant that the District's GIS maps, CAD system, and records management system had to be integrated to allow fire fighters to quickly find homes in new subdivisions and confirm that nearby fire hydrants were connected to functional pressure zones.
Solution
Farallon helped the district implement a web-based system that links GIS with CAD and records management databases, providing dispatchers and fire fighters with a consolidated and near real-time view of dispatch, hydrant, and logistics (best access to remote rescue areas). The geodata can be forwarded directly to the responding units via the onboard mobile data computers in the vehicles.
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.