Whether you are looking for a specialized focused solution or planning an Enterprise GIS implementation, GeoNorth has the skills and experience to ensure success. We encourage you to explore some of our past projects to learn more about our services, expertise, and familiarity with diverse industries.
The City of Albany was an early adopter of ArcGIS Server and had a goal of providing a report centric intuitive mapping solution for both staff and the public. The result was an application concept called InfoHub. This was an enterprise web based solution which integrated spatial and tabular information from various sources such as the county assessor and a commercial asset management system. The City had prototyped the solution however required advanced skills to refine, modify and ultimately implement the solution. GeoNorth was contracted by the City to provide assistance. GeoNorth gathered requirements, reviewed application code, revised and redeveloped significant sections which greatly improved performance, and improved the overall look and feel. The application is based on the ArcGIS Server .NET ADF and today contains more features and functionality, is more intuitive, and accommodates change through simple configuration settings.
Due to the success of this work GeoNorth was invited by the City to expand the InfoHUB solution to accommodate integration with the City’s commercial building permit system. This is now in production and allows staff, developers, and citizens to have web access to permit history and inspections. Supporting the InfoHub solution is a data mart of aggregated spatial information generated from a geoprocessing model also developed by GeoNorth. Instead of the server performing complex spatial intersecting queries on-demand, the application references the data mart.
The City of Beaverton is the 5th largest city in the state of Oregon and continues to grow. The city of Beaverton also is a perfect example that demonstrates our experience in addressing visualization, data management, GIS analysis, and the data publication needs of our clients. GeoNorth assisted the City of Beaverton in configuring and implementing external ArcIMS and web servers to support a crime mapping ArcIMS application for public use. GeoNorth provided consulting services assisting the City in the system architecture design and implementation of its ArcSDE/Microsoft SQL Server database and the migration of the City’s existing legacy GIS database to the new ArcSDE database model.
GeoNorth recently upgraded ArcSDE to 9.3, implemented ArcGIS Server 9.3 and provided consulting services to architect map servers and establish tile caching procedures. GeoNorth developed a series of automated data processing tools using ArcGIS Geoprocessing scripts and SQL SSIS (DTS) procedures to track the City's Community Emergency Response Team (CERT) and Emergency Operations Center (EOC) staff locations. Currently GeoNorth is assisting the City with upgrading its existing business data processing and ArcGIS Geoprocessing scripts to provide daily updates of taxlot and address to multiple systems throughout the City. GeoNorth is also working with City GIS staff to develop an ArcGIS Server application based on the Flex API which will serve as the City’s primary web based GIS data explorer. This solution will in turn serve as the base template to support more focused business solutions.
Funding from a series of DOJ grants allowed GeoNorth to provide the City of Memphis Police Department with a comprehensive design and implementation of two Internet based crime mapping applications. GeoNorth was also able to automate the data management and generation of crime incident data. For the project, GeoNorth developed an advanced ArcView application that performs the necessary geocoding of crime incident data from the Department’s Visionair RMS. The application then prepares the necessary spatial and tabular data for the internet mapping applications. This includes the generation of a crime incident intensity layer used to show concentration of crime occurring within a ¼ mile grid cell. This entire data process was automated using SQL Server ETL process and is executed 3 times a day at the end of each shift.
GeoNorth also developed an ArcIMS public web site where citizens can query for an address, select a crime category and search distance to retrieve a map and list crimes. Originally developed as a JSP application utilizing ArcIMS Query and GeoCoding Services, it was later updated by GeoNorth to utilize an address database for improved performance and accuracy. GeoNorth later installed and configuring ArcSDE, redesigning the backend data management processes, improved data quality, and integrated mapping with the Police Department’s web based KIOSK information system for mobile systems. GeoNorth integrated the mapping application with an existing Shelby County Wants and Warrants database that contains detailed information and photographs. Parole and probation records and juvenile court case records were also mapped and integrated into the web based crime mapping solution for internal purposes. GeoNorth additionally developed a web based prototype statistical system allowing crime analysts to model abnormal crime activity for a specific geographic area and time period. Based on expected tolerances, an increase of a particular crime type for a geographic area within a set duration period would allow for an e-mail notification of unexpected elevated crime incidents to be sent to specific precinct staff.
Additional detailed graphing by designation and by day of week was well as mapping was reported. Unfortunately, due to issues with data accuracy concerns and funding, this solution was not implemented. However the data generated by the solution developed by GeoNorth is now used in conjunction with the University of Memphis efforts and their Blue C.R.U.S.H™ system serving as an early warning system. The delivered CrimeMapping system has been operational and successfully running since 2002 with minimal updates occurring in 2005. The solution demonstrates GeoNorth’s ability to successfully deliver robust yet low maintenance applications to cost constrained organizations.
GeoNorth recently developed and delivered an integrated internet based crime mapping system for the citizens of Pearland and the Pearland Police Department. Recognizing the importance of publishing crime incidents to better inform and educate the public, the City contracted with GeoNorth to leverage their existing business systems and GIS. GeoNorth rapidly implemented the system by directly accessing crime incident information managed in the City’s SunGard HTE system. Integrating this information system with the City’s existing MapOptix based internet GIS solution was completed in days. The crime mapping system, based on GeoNorth’s MapOptix Multi-Map Framework™, provides an intuitive report centric approach making information both easy to use and understand.
The application works by prompting the user for an address, which in turn generates a buffered selection and a map summarizing reported crime incidents occurring within ½ mile of the address. A graph illustrates the crime profile for the area. Individual summary maps for each major crime, such as burglary and motor vehicle theft, are available by clicking specific configurable tabs within the application. An arbitrary 1/4 mile grid overlay also shows crime intensity. Because the system is based on MapOptix, it simplifies application management and makes the same information accessible from a robust interactive web based GIS that will be used internally by police Officers and Detectives. Using the MapOptix Multi-Map Framework, the City can easily present other thematic information such as zoning, schools, and utilities or leverage other existing information from the State or County. It can also be integrated with Google™, Google Earth™ and Virtual Earth™.
Between 2000 and 2002 the City of Portland had invested millions of dollars in an effort to consolidate and manage corporate GIS data as well as streamline business applications using GIS. While the City was successful with the data consolidation effort, there were many redundant application development efforts occurring that also were requiring data preprocessing. Additionally there was no existing technology solution or development framework available that would both simplify and standardize application desktop and web development efforts.
Working with City’s Corporate GIS solution architects, GeoNorth responded to the needs by developing a highly advanced and innovative ArcObjects based spatial server. Built using a Service Oriented Architecture (SOA) and designed with a spatial SQL syntax interface, this solution enabled both desktop and web developers at the City to quickly and directly access and manipulate geospatial data. It has enabled the City to achieve rapid integration, streamlined and standardized application development efforts, and dramatically reduced or eliminate the preprocessing of spatial data. Additionally, the architecture of this software was designed in a flexible manner allowing both GeoNorth development staff and City of Portland development staff the ability to quickly add functionality using a “Plug-in” type approach referred to as “custom functions” making the server solution highly extensible.
In use since 2002, the award winning spatial server technology has been satisfying a number of internal business solutions and is the core technology behind the City’s nationally recognized www.PortlandMaps.com web site. With over 2 million page views and 42,000 unique visitors per month, averaging close to 20,000 maps per hour, the spatial server technology enables the city to provide access to over 20 different databases with the most popular requests being property, permit, utility, photo, and crime incident related.
In 2006 GeoNorth made improvements to the technology included upgrading the server components to .NET and ArcObjects 9.2, refined the custom function capabilities making it even easier for the City to extend server functionality, and provided extensive request and respond logging. All work contributed to improved performance and provided the City’s software architects with even more flexibility in developing efficient custom functions to extend the core spatial server.
More recently in 2009 GeoNorth made extensive upgrades moving the server technology to a 64-bit computing environment and leveraged the ArcObjects 9.3 platform. Additional improvements were made to accommodate batch processing of requests.
Created long before ArcGIS Server, the spatial server technology GeoNorth developed for the City is very developer friendly, has highly efficient memory management, is very stable, and performs exceptionally with large volume requests. With minimal investment over the last 7 years the solution has provided incredible capabilities and tremendous value to the City.
The City of Sherwood is one of the fastest growing communities in the State of Oregon. It was also rated as one of Money Magazine’s 2007 Best Places to live in the United States. As the City continues to grow, pressure is placed on City staff to better manage and maintain infrastructure as well as information in order to improve efficiencies and decision making. Part of becoming more efficient was the decision to implement an Enterprise GIS.
GeoNorth initially completed a situational analysis that provided the City with an executive report outlining needs, requirements, and costs associated with GIS implementation and integration with other business systems. In July 2007 GeoNorth immediately went to work laying the foundation for an Enterprise GIS. This included providing system architecture recommendations, ArcGIS Server software procurement and installation services, and developing geodatabase designs for utility infrastructure that would accommodate the integration with Hansen’s Asset Management System.
GeoNorth completed an extensive AutoCAD data conversion of all Sanitary and Storm water assets and populated the geodatabases. The data development phase included creating a database for street segments and intersections to support pavement management needs. GeoNorth also developed a geoprocessing data loading application to conveniently and quickly refresh 3rd party data on a regular basis.
By December of 2007 a comprehensive web based GIS was implemented to meet the needs of the City and its citizens. The web solution features an interactive web based GIS for display, query, analysis and reporting. From this system, Public Works staff can quickly access CCTV videos and as-built documents. Maintenance information will also be accessed once the asset management system is fully implemented. For citizens, an intuitive report centric solution was developed for presenting spatial and tabular data.
According to Ross Schultz, Sherwood’s City Manger, “I have known that shrinking sources of revenue and increasing human resource costs will continue to put pressure on providing the quality service our Citizens demand. Sherwood’s strategy has been to address this issue with the planned infusion of technology so that we may keep our productivity at its highest level. GeoNorth has done an excellent job of helping us with that goal. Implementing GIS technology will allow Sherwood citizens direct access to City data and eliminate the need for staff involvement.”
In the short time the system has been in place it has already saved employees time accessing information and mproved decision making. Having information integrated and presented in a map context makes it easier to locate and understand. Staff are quickly realizing how quickly additional information can be integrated. Current efforts are underway to incorporate licensed business locations and the City’s fiber optic network infrastructure.
For this project GeoNorth took a pragmatic approach which delivered immediate results and an extensible forward looking solution. Paul Ortiz, Public Works GIS Analyst states, “GeoNorth has proved to be an excellent resource for the City of Sherwood. The solutions offered by GeoNorth are exactly what we need to ensure optimal success of work flow and data management. They delivered our GIS system on time and offered excellent customer service through the entire process.”
The City is currently in the process of assuming the management of the City’s water system from a local Water District. Because of our past project success, GeoNorth was awarded an additional contract to design a water utility geodatabase and manage the complete conversion and development of the water system GIS. This involved extensive AutoCAD conversion, integration of GPS collected data, as well as the conversion and association with historical asset management records.
The service provided to the City of Sherwood demonstrates GeoNorth’s ability and capability to rapidly respond. Using a variety of technology and highly skilled staff, GeoNorth was able to rapidly implement an enterprise GIS program for the City in less than a year.
In 2006 the City of Tigard embarked on the lengthy process of implementing an enterprise GIS to meet the diverse needs across multiple departments. The City, needed to provide a much more effective and efficient way to centrally access disparate spatial and tabular business data. Management decisions were made to formalize a GIS program and move forward with an Enterprise GIS initiative to meet internal departmental needs and provide public access to information.
GeoNorth was initially hired to review internal planning efforts and completed 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.
To better conceptualize the concept of Enterprise GIS, GeoNorth worked with the City’s GIS and Police Departments to develop a Crime Mapping solution. Although it was called a Pilot project, the benefits of the infrastructure put in place as well as the Crime Mapping application were quickly realized. Within weeks of completion, the application was put in production and was made available to the public. The application later became instrumental in helping establish a commercial crimes unit within the Police Department.
Throughout 2007 and part of 2008 GeoNorth was contracted to complete multiple services associated with the design and development of the system infrastructure, various utility and address geodatabases, data management and ETL tools, business systems integration, an advanced web based internal enterprise GIS solution and a Public Portal. The benefits and return on investment were immediate. For the first time ever the City’s Police Department can now access both incident and 911 call records managed in two separate systems by two different jurisdictions from a convenient web based interface featuring maps and graphs. The Public Works Department can now quickly access maintenance and inspection history of a specific asset such as a valve or pipe from a map. The Community Development Department can query for a specific permit records and see these on the map or access permit history for a specific taxlot using an interactive map.
For the first time, city staff, department managers, and the public could access information from multiple business systems via a web based enterprise GIS and information portal. Systems integrated included permitting, customer billing, asset management, and police dispatch (CAD) and RMS. The result was quicker response times, improved decision making, and overall better efficiencies ranging from improved data management to a significant reduction of staff time associated with processing general information requests.
Based on the success of the enterprise GIS implementation GeoNorth was recently awarded an additional contract to assist with the implementation of ArcGIS Server 9.3 and the migration of ArcIMS based web applications. GeoNorth has since implemented ArcGIS Server in test and production environments assisted with the architecting of dynamic map services and provided a strategy and guidance for creation of base map tile cached services. Additionally, GeoNorth has prototyped integration with the City’s Laserfiche document management system providing access to documents from associated map features.
See http://www.tigardmaps.com or learn more at http://www.govtech.com/gt/articles/568708.
In 2006 GeoNorth successfully upgraded a GIS mobile mapping solution used by the Clackamas County Sheriff’s Office and other jurisdictional First Responders. Originally developed by GeoNorth and in use since 1998, the application known as MapFinder has provided numerous police and other first responders across multiple jurisdictions with an in-vehicle mapping application that features robust geocoding against the County’s street centerline, property ownership identification, and document viewing.
Recent improvements included the real-time integration with the County’s CompuDyne/Tiburon Computer Aided Dispatch (CAD) system for instantly mapping both current and historical calls for service as well as integration with in-vehicle Delorme Earthmate GPS systems. Officers can immediately determine their current location relative to the call location and keep both on screen while driving to the dispatch location. Large buttons are a user option for touch screens and short-cut keys are available making it extremely easy to perform tasks and navigate the application. Additionally, there are numerous quick-find drop-down fields that can be configured to rapidly query layers for specific locations, such as wireless hotspots, schools, parks, rural communities, etc.
Although the project involved the integration of three distinct technologies, GeoNorth was able to rapidly complete the project in three weeks. According to Maurice Boardman of the Clackamas County Sheriffs Office… “Our deputies think the recent change to MapFinder that incorporates information from the CAD system to map a call is a “Perfect 10.” It is simple to use, and it works. That and the link to the GPS device have added tremendous value to the application. I was impressed with how quickly GeoNorth was able to develop this enhancement. The quick turnaround means more funding is available for additional improvements. We’re already gearing up for the next round.”
GeoNorth continues working with the Sheriff’s office and surrounding first responder organizations to provide additional functionality and user tools. Recent work involved developing daytime and nighttime modes for the MapFinder application to reduce the ambient light in vehicles.
WEB Water manages a rural water system that includes 6200 miles of pipe in a service area that covers 5450 square miles across 17 counties in NE South Dakota. GeoNorth was contracted to implement a desktop application in support of water utility maintenance operations and customer service.
GeoNorth implemented a solution that consisted of two desktop applications. A data maintenance and management application was developed using .NET and ArcObjects to map utility assets and customers. A scheduled automated extract from the customer billing system is used to associate customer information with mapped meter locations.
A second application was developed to query, record, and report service call and work order information. This application is used to issue work orders for system maintenance or customer complaints and also contacts crew leaders and management via automated e-mail notification. The application enables users in multiple departments to query and view GIS and tabular property assessment data. Using broadband cards, field crews use remote desktop to access the application for recording materials, equipment, and labor hours associated with work orders.
GeoNorth designed the data-driven application to be extensible. Application functionality can be easily expanded through configuration tables rather than having to update application source code.
In conjunction with this implementation, GeoNorth completed several other tasks to include:
More recently GeoNorth developed a predictive line flushing system that was incorporated into the enterprise GIS application. Comparing the pipe carrying capacity with monthly customer water usage, the system auto generates water line flushing work requests.
Since initial implementation WEB Water has successfully deployed the application to all Rural Operators and Managers. All service requests are now managed by the application and the old paper process has been eliminated. Efficiency has dramatically improved and response times for service calls have been reduced. In 2006 GeoNorth’s work for WEB Water was featured in the AWWA Opflow magazine and in 2007 WEB Water received an ESRI Special Achievement Award at the International Users Conference.
Washington Emergency Management Division (WEMD) contracted with GeoNorth to assess the needs of the agency in order to develop a Homeland Security Infrastructure Database (HSIDB). For the first phase of this project, GeoNorth delivered a Needs Assessment of WEMD’s current IT and GIS Capabilities, a Conceptual Design Document,a Physical Database Model, and an Implementation Plan.
Due to the dynamic nature of WEMD’s Critical Infrastructure program and non-standardized data, GeoNorth developed a highly innovative and advanced “Data Driven” database to support the dynamic nature of the HSIDB and business processes. This allowed WEMD to easily add and modify content without requiring DBA staff. Additionally, abstracting the spatial data model from the primary HSIDB offered more flexibility. GeoNorth completed the first phase within WEMD’s accelerated schedule of two months.
Intermediate phases of this project produced the design and development of an ArcGIS Editing tool for GeoSpatial Data associated with the HSIDB and the development of a VB.NET Database Management tool. The Database Management tool allows WEMD to design, create and support the dynamic database model for various types of critical infrastructure.
To support data entry efforts, GeoNorth developed a VB.NET data entry application used by WEMD staff internally. The data entry application itself is also dynamic and presents data entry forms and functionality based on the configuration managed by the Database Management tool. The application featured a “No Touch” installation with a subset of the database distributed externally to others for data collection purposes. Information collected externally is then easily imported into the central database using the Database Management tool.
To save time and maximize budget, WEMD implemented GeoNorth’s web based COTS solutions; MapOptix and QueryMill, for the query and reporting tools allowing internal WEMD users to access critical infrastructure information. These tools were implemented through a new web portal also developed by GeoNorth. The front-end web portal was created to provide information to users about the project, documentation, and provide a central location for accessing the web applications.
Project outcome included the successful design and development of an advanced system to maintain and manage critical infrastructure information for the State of Washington. The solution delivered by GeoNorth meets the dynamic and changing needs and is both highly extensible and scalable.
The City of Annapolis was seeking to develop a GIS Project Plan as a proactive measure to help the City of Annapolis serve its citizens more efficiently and effectively through the use of emerging information technologies. The City desired to develop a comprehensive municipal enterprise-wide GIS framework that will provide a foundation consistent with the citywide strategic IT Plan.
GeoNorth was hired to assist the City with its GIS needs in developing a GIS project plan. One of the key components was to develop a memorandum of understanding for use of GIS data between the City of Annapolis and another local government, Anne Arundel County, for the sharing and distribution of data between the two agencies. This plan also served as a means for any cross-agency coordination of information technology plans and initiatives that already exist at the county level. The GIS Development Plan provided an overarching vision and process to enhance communication and combine efforts.
Additional project tasks included reviewing existing documentation, interviewing management and key staff, and documenting the City’s current IT state and its use of GIS data. GeoNorth also assessed the City’s GIS service capacity by analyzing the current GIS services, databases, human resources materials and available software/hardware. This effort resulted in the development of a GIS strategy and services plan that prioritizes the City’s GIS projects and IT needs.
In 2006 GeoNorth completed the geodatabase design for the City and implemented the City’s enterprise GIS using ArcSDE, ArcIMS, and GeoNorth’sMapOptixproduct. GeoNorth provided onsite implementation, training, and customization services as part of the implementation. GeoNorth continues providing ArcSDE administration and geoprocessing programming support.
GeoNorth has completed geodatabase design, implementation, application development, and performance tuning for the State of Alaska, Department of Transportation & Public Facilities (ADOT&PF). This project implemented ArcSDE 9.1 and ArcIMS 9.1 on Sun Solaris servers.
Applications which consumed the data included both desktop (ArcObjects) applications as well as web applications implemented using GeoNorth's MapOptix on Sun Solaris Servers. Raster and Vector spatial data as well as tabular data from a variety of sources were stored in Oracle 10g on Solaris.
This project included loading detailed new road centerlines for the state, as well as hundreds of different event feature types which represented road facilities, cultural features, maintenance tasks, traffic accidents and many other transportation-related features. In addition to the transportation network and related features, the project also encompassed the storage, retrival, and querying of many other 'background' vector and raster datasets, including orthophotography, hydrography, political boundaries, elevation data, environmental data, and landcover information.
One key to success for this project was the ability to incorporate millions of records of tabular data from a variety of sources - both linear referenced 'event' data as well as other tabular data. These data originated in various disparate non-GIS systems. In order to accomplish this, GeoNorth created many automated routines to enable the sharing and consumption of data by desktop and web applications.
Because excellent performance was a key requirement, GeoNorth developed a series of unit testing applications to load and measure performance of the Oracle, ArcIMS, and ArcSDE instances. This allowed GeoNorth to adjust parameters and optimize response times.
GeoNorth has been working with Anne Arundel County since 1998 to assist with the implementation of GIS technology related to asset management and planning. This work has been comprehensive and involved multiple projects including: GIS implementation planning, Enterprise GIS database design, GIS development which included a full conversion of water and sewer hardcopy maps, GIS database design for Storm Water facilities, integration of GPS information with storm water GIS facilities, development of CAD drafting standards, design and development of CAD/GIS interfaces, design and development of the GIS editing environment, development of GIS analytical tools, enterprise GIS integration with commercial asset management system , and custom application development.
Desktop Application Development:
GeoNorth also developed a highly sophisticated desktop GIS application called “CountyView”, which is deployed on over 500 machines throughout the County, including emergency management personnel, to assist county staff with their job functions.
Web Application Development:
Web applications developed by GeoNorth include our MapOptix Watershed Management Tool Viewer. This County-wide project was developed for the Office of Information Technology that involved Public Works, Planning and Zoning, Health Department, and Inspections and Permitting. The WMTV tool allows system administrators and end users to incorporate pre-defined and rendered watershed model output map layers and perform query and analysis of watershed information within AACo web-enabled mapping architecture. This was developed as an extension to GeoNorth’s MapOptix product. Specific functionality provided by the WMTV tool includes:
Allowing users to interact with Watershed Management projects and their associated GIS output through tabular and spatial query, interactive mapping of all project boundaries, delineation of new project boundaries, and cartographic map production of base maps over-laid by project outputs.
In 2008 a series of enhancements were completed to the County’s Enterprise GIS application. These included integration of Pictometry imagery, document viewer enhancements, CIP integration, DB2 database integration, and a specialized night viewing mode for in vehicle police systems.
Working on a long term contract a GeoNorth team is assisting BP Management in a review of current contracted GIS projects and is currently advising on enterprise GIS initiatives and systems integration. GeoNorth is also currently implementing a GIS for North Slope operations in Alaska. This project has enabled BP engineers, for the first time, to automatically map inspection, corrosion, and pipeline pigging data leading to improved and more informed management decision making.
GeoNorth has implemented a GIS at BP Exploration for the North Slope of Alaska – North American’s largest oilfield. This system covers Prudhoe Bay and the surrounding oilfields. GeoNorth architected the data model and systems to implement ArcGIS Server (including ArcSDE in Oracle 10g), ArcGIS Image Server and various web applications using the ArcGIS Server Web ADF (.Net). The project involved all phases of GIS implementation, including Needs Assessments, Project Planning, Data Model Design, Data Capture, Application Development, and integration with many other information systems within BP. One key task was the integration of physical inspection and corrosion data. These data are stored in a legacy system (MIMIR) and this project enabled BP engineers, for the first time, to automatically map inspection, corrosion, and pipeline pigging data.
Global Intranet Solution:
GeoNorth developed an extensive intranet application to be used by BP globally throughout the world, including North Slope field operations. This was created in ASP .NET using AJAX. One unique element is the heavy use of caching technology, allowing for uniquely instantaneous screen refreshments. The application integrates with many business systems such as corrosion management and document management systems.
GeoNorth also incorporated the use of “themes” to aggregate map services, allowing different users to select from 10 different services based on visual and technical needs.
Enabled BP engineers, for the first time, to automatically map inspection, corrosion, and pipeline pigging data leading to improved and more informed management decision making
Comprehensive GIS Services In Support of Watershed Management Program
Multi-year contract to provide multidisciplinary professional services and expertise in support of the Watershed Management Program created to comply with EPA regulations. This included design, development and maintenance of GIS data, relational databases, and web-based data access applications. Implemented ArcSDE Geodatabase with SQL Server in a secured workgroup web environment. Implemented a public ArcIMS and GeoNorth’s MapOptix web site for viewing spatial and tabular data sets which includes hydrology, watersheds, sub-watersheds, and other features. Developed desktop applications that provide data collection, decision support, analytical, and reporting tools to planners. Developed logical and physical data models, tabular and spatial data standards, data dictionary, and guidelines for data versioning.
Revised, updated, or created multiple datasets in Geodatabase, including: Marine Shoreline and Tidelands Maps, Watersheds and Sub-watersheds, Stream Features Mapping, Legacy Stream Maps, Floodzone Maps, Lake Features, Drainageways Features Mapping, Constructed (Piped) Drainageway Maps, Natural Drainageway Maps, Constructed (Ditched) Drainageway Maps, Outfall Basin Maps, and Outfall Maps.
Delivered spatial and tabular data derived from analysis of multi-spectral imagery. Provided integration tools for SWMM GIS data loading as well as model operation for calibration and model runs for storm water hydrology, sediment transport, sediment-associated coliform transport and chloride transport. This modeling application generated hydrographs and pollutographs for select watersheds, subwatersheds and outfall basins.
GIS Term Contract
The objective of this project was to assist and supplement AWWU’s Engineering GIS Section staff and provide additional IT resources as necessary to respond to a variety of GIS related projects and general technical support. This was initiated and delivered on a task basis. Each specific task was negotiated and individual notice-to-proceeds were written and made a binding part of the contract. Major tasks completed as part of this contract included: developing new ArcInfo coverages and spatial datasets, updating and maintaining data base information, reviewing and providing recommendations for third party GIS products and EPANet hydraulic modeling data conversion and application integration.
Water/Sewer Permit System
Developed system for tracking water and sewer connection permits for both new construction and maintenance. Various permit fees can be calculated and allows users to print hard copies of permits in several formats. Other features include an ad-hoc reporting module that allows users to create custom reports and also links to the tax assessment database (IBM VSAM format), which resides on a mainframe. A document management module allows users to view scanned images of hard copy permits that existed before the system was automated.
GIS Master Plan
Developed a GIS Master Plan that provides a high-level business planning mechanism used to document program direction, establish goals and objectives, and prioritize initiatives. This plan is a guide with strategies for implementing new hardware and software, developing applications, and directing the overall GIS program design and implementation, to allow AWWU to maintain an effective GIS program through the next four years.