Positional Advantage
Spatial Consultants

Case Studies

Case studies provide real world examples of where Spatial Consultants staff have applied GIS based technologies and practices to solve business challenges.

City of Portland, OR

The Business Challenge

The GIS Hub project had demonstrated the benefits of a united approach to spatial data management within the City of Portland, USA. Maintaining spatial data to a quality that would support a broader range of uses, however, required significant improvements to the data maintenace and access infrastructure:

  • Data integrity rules needed to be automated to improve consistency and efficiency;
  • Maintenance costs needed to be reduced;
  • Data needed to be accessed by multiple channels including web and potentially mobile;
  • Data currency needed to be improved so the updates were made available quickly;
  • Data auditing and security controls needed to be strengthened.

Solution Overview

The EGH (Enterprise GIS Hub) project built upon the progress made by the PortlandMapsGIS Hub to consolidate all the City disparate GIS systems and data, referred to as the “rich mix of technology”, into a single shared Enterprise GIS data warehouse for all GIS related data in the City of Portland. The project then went further to develop the “Core” rule based GIS data maintenance tools using ArcGIS to maintain the City’s GIS layers while enforcing data quality standards of the Enterprise data models. The maintenance environments of each bureau were integrated with the Hub such that individual data changes were replicated directly to the Hub as they were approved. Finally, a centralized Web infrastructure was developed by CGIS to provide GIS web services to Citizens, Customers and City staff.

Further Information

ESRI International User Conference 2000, authored by Graham Morgan and Brandon Meardon, available online at:
https://library.esri.com/docs/proc00/professional/papers/PAP504/p504.htm

Lessons in Geospatial Data Warehousing - A Proven Approach to Enterprise Data Integration, authored by Graham Morgan and Gary Jurkowski, available online at:
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.138.2476&rep=re...

ESRI Special Achievement in GIS Award to the City of Portland:
http://events.esri.com/conference/sagList/?fa=Detail&SID=403

GITA GIS Excellence Award for the City of Portland Enterprise GIS Hub:
http://gisuser.com/2006/04/city-of-portland-named-recipient-of-gitas-exc...

ESRI description of the Portland Hub:
http://gisknowledge.net/topic/gis_at_work/esri_city_of_portland_00.pdf

City of Portland Hub overview:
http://www.portlandoregon.gov/index.cfm?c=28130

City of Portland, OR

The Business Challenge

The City of Portland in Oregon, USA, comprises a number of divisions or bureaus, each responsible for the administration of a specific area of local government, e.g. buildings, police, water, planning, transportation, etc. Over time each bureau had adopted and developed a set of IT/GIS solutions to meet their needs – this worked reasonably well in isolation but over time led to a number of significant problems:
  • Organisations found it difficult to share information of common interest;
  • Multiple organisations were maintaining private versions of key datasets e.g. road network, land parcels, and addresses;
  • Users found it difficult and time consuming to locate (and obtain) the most accurate or upto date version of any given dataset;
  • Decision makers could not access the ‘big picture’ as datasets could not be integrated easily; they therefore lacked confidence in the data that supported them;
  • The city was investing in redundant application development as similar bespoke functionality was created for each platform.
Solution Overview
 
The solution was to enable citywide data sharing through a GIS Hub system that enables bureaus to publish their data into a corporate data structure in a common format, and to extract data provided by other bureaus in the working format of their choice.
 
Business Architecture
The City centralised spatial data management into a corporate body (CGIS) which was responsible for coordinating investment and development in GIS data and toolsets. A business case examining the expenditure on redundant application development and data maintenance as well as time wasted by users in locating and verifying data clearly justified this approach. CGIS contracted Convergent Group to support them in developing a GIS infrastructure to enable spatial data sharing; Graham Morgan was engaged as the Project Engineer for the design and implementation. The ability to share data required that a number of data governance issues be reviewed including data ownership and maintenance responsibility, data standards for enterprise-wide use and corporate data funding.
 
Data Architecture
The GIS Hub was attractive to city bureaus as it enabled them to continue to use their systems of choice to manage their data – but to also benefit from datasets managed by other bureaus or external organisations. The data could be consumed in the format and projection of choice but easily shared by the GIS Hub infrastructure. A central data model was developed for the Hub into which the source data could be translated and transformed. The central data model also provided a platform for enterprise reporting as all data was now available in one place in a common integrated format and coordinate reference system. 
 
Technical Architecture
The GIS Hub was developed using ArcSDE with the data stored in Microsoft SQL Server. The data was translated and transformed between bureau systems and the Hub by customised FME. Data was bulk loaded into a staging database where data integrity checks were performed before the data was published to the Hub. A custom FME application was used to translate from a range of formats into and out of the Hub; this facility was made available on the corporate intranet so that data requests could be queued and processed as received. The Hub was implemented on three SQL Server databases and the spatial data was automatically replicated between them to support local performance and general availability. A number of technical challenges were overcome during this project which involved working with ESRI to develop the (then) ArcSDE data structure to support database replication and declarative SQL. The CGIS team developed a cutting edge GIS web site based on Cold Fusion and GeoNorth’s MapOptix (and later ArcGIS Server), that accessed Hub data and made it available internally and externally. The website may be accessed online at: http://www.portlandmaps.com/
 
Additional Information
ESRI ArcNews article authored by Rick Shulte, Graham Morgan and Bart Elliot available online:
http://www.esri.com/news/arcnews/fall00articles/cityofportland.html
 
ESRI International User Conference 2000 Paper, authored by Graham Morgan and Brandon Meardon, available online at:
https://library.esri.com/docs/proc00/professional/papers/PAP504/p504.htm
 
ESRI International User Conference 1999 abstract authored by Graham Morgan, Steve Grise and Tim Lock available online at:
http://gis.library.esri.com/cgi-bin/koha/opac-detail.pl?biblionumber=88369