Case Studies on GIS/IT Integration
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
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. Read more details...
Categories: Web Applications, Enterprise Mashups, GIS/IT Integration, Pavement Management, Asset Management Systems
City of Chula Vista uses dynamic segmentation to render StreetSaver information to the GIS
Challenge
The City of Chula Vista wanted the information in their ArcSDE GIS to be shared with a StreetSaver database.
Solution
Tools in ESRI's ArcGIS were used to develop dynamic segmentation procedures to render StreetSaver information to the GIS. The segmentation of the streets into paving sections is done dynamically using the StreetSaver database post mile data at the time the user requests the information so the two datasets remain in sync. Read more details...
Categories: GIS/IT Integration, Pavement Management
GIS PavePlan Application Helps San Mateo County Manage Pavement Conditions
Challenge
San Mateo County manages over $100 million of infrastructure assets such as roads and sewer infrastructure. Pulling together information from separate GIS, pavement management software and budgeting spreadsheets was time consuming. It could take up to three months for a decision, such as asphalt resurfacing, to be agreed upon by all departments.
Solution
Farallon Geographics developed the GIS PavePlan application which automates data interchange between their cost modeling application, GIS database, and pavement scenario manager. Read more details...
Categories: GIS/IT Integration, Pavement Management, Asset Management Systems
San Mateo County ArcSDE/Oracle Spatial Implementation
Challenge
San Mateo County wanted to wanted to deploy the map production and geocoding tools available in ArcGIS on top of their existing Oracle Spatial and Intergraph Geomedia Enterprise GIS.
Solution
Farallon configured and performance-tuned Oracle to integrate with ArcSDE and geodata access via ESRI software. Farallon also provided County staff with training and useful tools such as scripts, tips, and common troubleshooting techniques. Read more details...
Categories: GIS/IT Integration, Planning & Training, Training & Technology Transfer
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. Read more details...
Categories: Web Applications, Enterprise Mashups, GIS/IT Integration, Asset Management Systems
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 City of Menlo Park integrates ESRI GIS with StreetSaver PMS
Challenge
The City of Menlo Park wanted the their Enterprise GIS (ArcSDE/ArcGIS/SQL) data to be dynamically shared with a StreetSaver pavement management database with live links between the two.
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 60 miles of streets. Read more details...
Categories: GIS/IT Integration, Pavement Management
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. Read more details...
Categories: GIS/IT Integration, Pavement Management
California ISO GIS and Transmission Information Display System
Challenge
The California ISO manages the transmission of electricity through the State's extensive network of high voltage lines. To manage the electrical grid in response to factors such as wild land fires and extreme weather, the ISO needed a complete and positionally accurate accurate representation of the grid from all of the State's primary electricity generators and transmitters.
Solution
Farallon developed a Unified GIS data model that merged the State's major power generators' GIS data into a single, consistent, validated, and audited database. It offers a broad array of online and offline visualization and mapping capabilities and can easily integrate future external databases. Read more details...
Categories: Web Applications, GIS/IT Integration, Geodatabase Design, Network GIS