Case Studies on Web Applications
Utah Department of Transportation (UDOT) Oracle Spatial Transportation Asset Management
Challenge
UDOT maintenance division had developed an Oracle database with tabular reports to track and analyze Utah's 5,900 miles of roads and 250,000+ transportation-related assets. UDOT wanted to integrate this with a web-based map interface to make spatial and business data more accessible and allow for field verification techniques.
Solution
Farallon worked with UDOT to create an enterprise-wide spatial database building on their existing Oracle infrastructure. This allowed UDOT to pilot a spatially enabled transportation asset management system, without having to deploy a new or separate GIS. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems, Geodatabase Design, GPS Field Data Collection, Planning & Training, Training & Technology Transfer
King County, WA: Homeland Security Public Safety Portal Development
Challenge
King County, Washington needed to improve coordination of local emergency responders in the event of natural or man-made disasters using a Public Safety Portal. A critical requirement was for the portal to integrate large volumes of both spatial and non-spatial data.
Solution
As part of the team, Farallon designed and implemented a data model using Oracle Spatial to allow for quick cross-referencing between non-spatial data such as contingency plans with geographic location. This combined information could then be rapidly visualized in online or printed maps for pre-incident planning. .NET web services made it easy for County programmers to incorporate revisions. Read more details...
Categories: Web Applications, Geodatabase Design
Virgin River Watershed Habitat Conservation Plan
Challenge
Rapid population growth and development near the Virgin River Watershed area of Nevada required the city of Mesquite to develop a habitat conservation plan. They needed a way to visualize and plan around endangered species locations and ecological communities.
Solution
Farallon is creating a GIS web application using ArcIMS, .NET and custom web services to track and manage species' data including population and habitat location for the area's endangered species. Developers and planners can use the web interface to map out and work around threatened habitats. Read more details...
Categories: Web Applications
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
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. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems, Geodatabase Design, GPS Field Data Collection
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
Parsons-UXB Joint Venture on Kaho’olawe Island Reserve Demilitarization GIS
Challenge
Farallon worked with Parsons-UXB to develop an online mapping system that managed the cleanup of unexploded ordnance (UXO) on the small Hawaiian island of Kaho'olawe.
Solution
Using a web interface, users who click on a grid square get a summary of information at a glance, while those who click on a piece of UXO get information and photographs about that item including GPS coordinates and images depicting everything from vegetation to the destruction date, as well as proximity to historically signficant Hawaiian sites and artifacts. Read more details...
Categories: Web Applications, Geodatabase Design, Planning & Training, GIS Needs Asssessment
San Mateo County Voter Registration
Challenge
The County's Clerk-Assessor-Recorder-Election Departments (CARE) were required to implement and monitor a countywide voter outreach program to target underrepresented communities in the county. CARE needed a quick and accurate visual representation of the disenfranchised Latino and Chinese-American communities in order to appropriately plan voter outreach activities.
Solution
Farallon Geographics integrated precinct information from the existing enterprise GIS with Census information to visually identify communities that had high ethnic concentrations with low voter registration. Read more details...
Categories: Web Applications, Voter Registration
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