The City of Tigard is currently embarking on the lengthy process of implementing an enterprise GIS to meet the diverse needs of many departments such as Public Works, Community Development, and Public Safety.
GeoNorth was hired to review internal planning efforts and complete a financial analysis of a 5 year budget plan. The process of implementing an enterprise GIS and integrating GIS with other business systems can take many years so ensuring continuity of funding is critical to the successful program.
As part of an enterprise GIS implementation, GeoNorth provided general consulting services. These services provided long range budget planning and assistance with the implementation of a COTS based solution (GeoNorth’s MapOptix), ArcIMS, and ArcSDE for a Crime Mapping Pilot Project to help demonstrate the benefit of GIS. GeoNorth installed and configured ArcSDE and ArcIMS. GeoNorth provided administrative training and established backup procedures for the spatial data.
The Implementation of the Pilot (Crime Spotter) (http://www.ci.tigard.or.us/police/crimespotter/default.asp) involved an extract, analysis and processing of crime incident data stored in SQL Server to create specific layers as defined by the City’s Crime Analyst. GeoNorth developed an automated data processing process (ETL) to extract, transform and produce monthly updated crime statistic feature layers for publication on the City’s Crime Spotter website. The automated process involves the use of SQL Server queries, ArcGIS Geoprocessing tools, and Python scripts to generate crime point and statistic layers. The process is scheduled and runs unattended automatically updating multiple layers in ArcSDE.
The processed information is provided to the public in an ArcIMS based application running on Adobe’s ColdFusion MX platform. Web forms were created for users to input address information, which is being used to query the City’s geospatial crime data. Users are provided detailed reports displaying crime information within a preset distance around the desired location. A fusebox architecture was used to develop the Crime Mapping application and can easily be extended to accommodate utilities, planning, and other business themes for internal and public access. This greatly leverages the value of the existing system.
GeoNorth was competitively selected and is actively working with the City on two projects. GeoNorth completed the System Architecture and Application Design. GeoNorth also completed the design and development of three geodatabases; address, utilities, and transportation. GeoNorth is curently in the final developmemt phase to implement an enterprise web based GIS. This will replace a widely used older ArcView 3x solution and will integrate information from other business systems, documents, and will serve as the primary enterprise information system for all departments. GeoNorth will be extending the highly successful current Crime Mapping solution, also developed by GeoNorth, to accommodate other information such a property ownership, utilities, and permitting information.
Financial recommendations which included a phased approach to balance implementation and operating costs over many years while meeting immediate goals for cost recovery. Long range planning included staffing, training, equipment replacement costs, application maintenance and upgrades. GeoNorth completed the successful implementation of a web-based GIS platform and a crime reporting site demonstrating the value provided with implementing an Enterprise GIS. This project included the implementation of data processing tools for the creation of spatial crime data and crime statistic feature layers.
GeoNorth has successfully completed other projects as part of the enterprise implementation. Both the infrastructure geodatabase design project and System Architecture and Application Design were completed under budget and on time. GeoNorth is currently assisting the City with the enterprise implementation. Tasks included:
