GeoNorth is currently assisting with the County’s implementation of a new Computerized Maintenance Management System (CMMS) software solution, which will be integrated with the WESWorks GIS application developed by GeoNorth. The County desired to use its existing Enterprise GIS System (WESWorks) to initiate, edit, query and view work orders and service requests. This required modifications to the existing WESWorks enterprise GIS software to interact with the maintenance management database and software provided by GBA Master Series, Inc. Integration was completed for both sanitary and storm utility systems.
In 2007 and 2008 GeoNorth completed an upgrade to the County’s erosion permitting database. Work included migrating the database from Access to SQL Server and significant updates to the MS Access frontend application.
In 2007 GeoNorth completed a geodatabase upgrade. The project involved the installation of ArcSDE 9.2 on the County’s new SQL Server 2005 enterprise server and migration of the County’s existing ArcSDE databases to the new server. GeoNorth assisted with the transfer of current DTS packages and Geoprocessing Models to the new server. GeoNorth also assisted in the migration of other non-ESRI SQL Server databases. Additional consulting services were provided to address versioning, replication, and to establish backup and tuning policies.
Developed a desktop application that provides the ability to automate the data creation of storm water facilities based on field inventory information collected from as-built drawing and GPS locations into a spreadsheet. The application imports the spreadsheet data and guides the user through creation of new catch basin and manholes facilities to eliminate data entry errors. The application automatically generates and attributes pipe facilities for connectivity and modeling purposes. A 4-step process has been reduced to a single step. A 2-year backlog of work has been completed in 4 months. Data entry errors have been dramatically reduced. Ease of use minimizes training requirements. The application was recently ported from Avenue to ArcObjects.
Developed Desktop Enterprise browsers called PlanMap and WESWorks used to query, browse, and report on utility customers and property owners. Both application integrate GIS and database functionality. WESWorks, designed specifically for the Utilities department, provides an integrated information system for facility data, scanned documents, complaint tracking, activities tracking, and capital improvements.
Developed automated Geocoding utility for the County’s Emergency Operation Center in order to randomly, or on a scheduled basis, pin map activity calls for response, coordination and resource planning.
Developed an ArcView application designed to interface Clackamas County’s GIS data and XP-SWMM, a storm water-modeling software package. The user can select facilities in ArcView to include in a storm water model run. Certain attributes for these facilities are passed to XP-SWMM for modeling. Model results are then passed back to ArcView where they are rendered in a thematic map.
System Administration and Network Security consulting. Provided GIS, Network and Database support services on an as-needed basis. Among other things, this included assisting with the development of Unix system administration procedures, migration of desktop GIS applications from Unix to NT, modification of legacy AML routines, system security and firewall assessments, and mentoring/training services.
Provided consulting services for migrating access databases intro SQL Server and the implementation of ArcSDE. Services included installation services and application migration for accessing data managed in ArcSDE.
GeoNorth developed an integrated Biosolid distribution system. The system consists of a spatial distribution constraint definition system and a query and reporting system which interfaces with a commercial Laboratory Information Management System (LIMS).
GeoNorth developed an application that is used to determine the application area for bio-solid distribution on agricultural fields based on numerous criteria and buffer distances. The application allows users to enter criteria features and based on the type of bio-solid distribution will automatically delineate the area and calculate the appropriate acreage for Biosolid distribution. Based on natural and land features, criteria is specified for the distribution content and method. Information is integrated with a separate MS Access database used to store distribution volume, frequency, chemical analysis, and compliance.
Due to a change in the County’s Laboratory Information Management System (LIMS) software, the Biosolids application was migrated from Access to SQL Sever and is currently being modified again to work with a new data model. There are numerous tables, queries, forms, reports, macros and code modules requiring modification. Work includes updating data mapping for linking to external tables, reports for the nutrients group and the metals group, and sampling dates.
Related to the Biosolids systems, GeoNorth developed an ArcObjects desktop application that provides the ability to automate the data creation of storm water facilities based on field inventory information collected from as-built drawing and GPS locations stored in an Excel spreadsheet. The application imports the spreadsheet data and guides the user through creation of new catch basin and manholes facilities to eliminate data entry errors. The application automatically generates and attributes pipe facilities for connectivity and modeling purposes. The storm drains in proximity to biosolids distributions are monitored.
GeoNorth provided user documentation and application training for County staff.
