CLOSE WINDOW

City and County of Denver, CO /
Environmental Services Department

Working for the City and County of Denver’s Environmental Services Department (ESD), Destiny provides on-call GIS and data services, including custom programming and application development. Projects center on developing effective tools, and streamlining processes, supporting environmental characterization, remediation planning, program management, reporting, and compliance.

 

Recent projects include:

Developing an environmental job tracking and management system (project oversight tool) Developing an Environmental Data Entry System (EDES) for use by City contractors Creating an ArcIMS application to query and display data from Brownfields sites Developing an application for use by staff with little or no GIS experience to add and edit spatial data and attributes describing landfills Developing a custom application to access scanned photographs and other documents through an interactive GIS map Scanning, georeferencing, and indexing historic aerial photographs Migrating and converting legacy GIS data and legacy databases Loading and auditing environmental conditions data Locating, acquiring, and integrating aerial photos Providing custom training / Applying GIS to environmental, health, and safety

Examples (partial list) of GIS design, development, and custom programming services follow:

Environmental Project/Job Tracking
Programming in Visual Basic, Destiny developed a job tracking system designed to integrate ArcGIS 8.2 (ArcObjects) and MS Access enabling staff to enter information about new projects, and to map the locations of active environmental site assessment (ESA) and related jobs within the City/County’s boundary. Development tasks included finalizing the initial application design; programming in Visual Basic to create data entry and editing forms that connect to an ESD Access database of jobs; creating a system to automatically increment the standardized job number used by the ESD each time a new job is initiated; creating drop-down menus to allow users to identify relevant information about a job; creating a system to save incomplete entries and allow the user to complete the form in multiple sessions; programming a function to automatically start the ArcGIS interface for job types that include a geographic location; and programming a function to geocode the initial a job location by address and then enabling polygon digitizing and attribute entry.

Environmental Data Entry System (EDES)
Destiny developed an Environmental Data Entry System (EDES) to assist the City and contractors in entering and integrating data from field sampling activities. The system includes easy-to-use data entry forms that facilitate quick and accurate entry, batch loading utilities for electronic data deliverables, QC and data checking routines, and output files formatted for quick upload into the City’s EQuIS database.

Integrating Aerial Photography with ArcGIS
Enabling staff to view historical aerial photos for quick analysis of a project area, Destiny provided custom programming and data services to scan, georeference, and integrate photos into an ArcGIS environment. This included referencing the photos to the City’s street centerline file, creating a file system and organizational schema based on geographic and historic distributions, and custom programming to enable graphical searches, to manage image transparency and brightness, to toggle images on and off in bulk, to load new images, and to export image and map views to PDF files.

ArcIMS Brownfields Data Application
Destiny developed an ArcIMS website designed to integrate Brownfields data with environmental data, historic aerial photographs, map features, and other data drawn from the City’s Enterprise GIS and ArcSDE server. The project included prototype design and development, custom programming, data referencing, data integration, and the rollout of the website. The application enables easy-access and user-friendly tools to query and display Brownfields and related data including site status, Phase I and Phase II Environmental Assessments, and other data useful to City planners, officials, and stakeholders. Additional custom mapping and reporting functions make it easy to save and export site redevelopment scenarios into PDF format for off-line use at meetings and presentations. Customized programming utilized ASP, JavaScript, VB Script, dynamic HTML, and ArcXML. The application was developed as an extension to an existing Enterprise ArcIMS.

ArcObjects Landfill Editing Application
Destiny converted complex coverages and associated INFO tables into a geodatabase, including attribute domains and relationship classes. We then built an application using ArcObjects to allow non-GIS personnel to edit and add landfill features. The application was designed to enforce data validation rules and to capture user and editor information. Development included providing consultation for the best methods to migrate historic landfill ArcINFO polygon files to a personal geodatabase; creating a menu driven tool to select a polygon and begin editing the polygon feature’s geography; and creating a menu driven tools to select and edit a polygon’s attribute data, either as free text or based on a list from the geodatabase’s domains. The tool automatically captures key data about the editing session, for example, the name of the editor, a time/date-stamp, a record of what they are editing, and the reasons for edits.