Case Studies on GIS/IT Integration
Mobile Data Collection Application using Android
Challenge
A Bay Area city needed a comprehensive and accurate storm drain geodatabase and geometric network to support their stormwater infrastructure planning, operations, and maintenance. They wanted it efficient for field crew data collection of 12000+ storm drain features, and real-time trackable by office managers.
Solution
Farallon developed an Android-based workflow-driven mobile data collection application to streamline the process of data collection and synchronize with the City's central database in both network connected (3G or Wi-Fi) and disconnected environments. Managers in the office track real-time progress using a simple Google Earth interface. Read more details...
Categories: GIS/IT Integration, Asset Management Systems, Geodatabase Design, GPS Field Data Collection
Farallon builds Emergency Operations Center (EOC) incident management application for MTC
Challenge
In order to effectively manage unpredictable events in real time, MTC's Emergency Operations Center needed an incident management application with a clean, intuitive interface optimized to streamline the collection of incident data, as well as the display of incident locations relative to other critical data sets.
Solution
Farallon created a robust web-based incident management application that enables users to register and flag emergencies on a map, report routine incidents such as service delays, add emergency routing and response information and generate summary reports. EOC can now effectively manage and assess large volumes of continuously generated data in real time, and to distribute this data to all relevant personnel. Read more details...
Categories: Web Applications, GIS/IT Integration, Geodatabase Design, Transportation & Linear Networks
Enterprise GIS for Town of Woodside with StreetSaver PMS integration
Challenge
The Town of Woodside needed an enterprise GIS. They also wanted to integrate the GIS with MTC’s StreetSaver Online Pavement Management System and a CRW Permit Management System.
Solution
Farallon Geographics built and deployed an enterprise GIS for the Town of Woodside, CA, and linked the GIS to the Town’s MTC StreetSaver Pavement Management System (PMS) as well as to its CRW Permit Management System. Town staff could quickly map StreetSaver information into the GIS to perform spatial analysis or use a map as an interface for managing property assets and notifications. Read more details...
Categories: Web Applications, Notification, Property Review, GIS/IT Integration, Pavement Management
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 "GIS Site Locator" website that lets users enter parameters such as price range and square footage, then view matching properties on a map in MS Virtual Earth. Click on a property to display additional information, including photographs, driving directions and current traffic conditions. 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
Farallon assists Marine Science Institute / MarineMap to build a marine life protection area web application
Challenge
The Marine Life Protection Act directs the State of California to design and manage a network of multi-use marine protected ecosystems.The state needed a web-based decision support system for designing marine protected areas and communicating proposed designs.
Solution
Farallon, working with the Marine Science Institute at UCSB, developed "MarineMap", a Web 2.0 online mapping application that enables members of scientific community and general public to participate in the selection of marine environments that should be designated for conservation, recreational, and commercial uses. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems
City of Santa Rosa: Utilities Geodatabase Deployment and Integration
Challenge
The City of Santa Rosa needed to automate the process of populating the asset inventory in its Asset Management System based on information in the utility maps generated with AutoCAD.
Solution
Farallon developed a GIS data model in an ESRI geodatabase that is populated from AutoCAD and uploads it to the City's Hansen Asset Management Software.
Read more details...
Categories: GIS/IT Integration, Asset Management Systems, Geodatabase Design, Utility System Data Modeling
Kern County Master Address Database Needs Assessment
Challenge
Kern County 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 Count departments to coordinate efforts and integrate information across business systems.
Solution
Farallon Geographics completed a Master Address Database needs assessment and budget plan for a single, centralized address source or MAD to solve the problem of duplicated and error-prone addresses. Read more details...
Categories: GIS/IT Integration, Master Address Database, Planning & Training, GIS Needs Asssessment
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. Read more details...
Categories: Web Applications, Notification, Property Review, GIS/IT Integration, Master Address Database, Geodatabase Design
Getty Conservation Institute Web-Based GIS for Managing Jordanian Antiquities
Challenge
The Getty Conservation Institute working with the World Monuments Fund and the Jordanian Department of Antiquities wanted to develop a new national GIS to assist in inventorying, monitoring, and managing the thousands of archaeological sites in Jordan
Solution
Farallon is developing a Web-based, bilingual (Arabic-English) system that will be used by inspectors, archaeologists, scholars, and government planners involved in cultural heritage management and research. The scalable solution using open source software, will subsequently be adapted for use in Iraq and possibly other countries in the region. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems, Geodatabase Design, Open Standards Solutions, Planning & Training, GIS Needs Asssessment
City of San Francisco Bridge Preventative Maintenance Program Web Application
Challenge
The City and County of San Francisco Department of Public Works Bureau of Engineering collects and analyzes data on over 300 structures, including pedestrian over-crossing, roadway structures and bridges. The data was distributed across multiple systems in in several locations making it difficult to reliably query and visualize necessary asset information.
Solution
Farallon created a Bridge Preventative Maintenance Program web application to allow City staff, across departments, to view and query bridge inspection reports, field-verify noted deficiencies, and develop accurate cost estimates for the repairs and maintenance of deficiencies. Read more details...
Categories: Web Applications, Enterprise Mashups, GIS/IT Integration, Asset Management Systems