City and County of Denver, Colorado

Working for the City’s GIS Department, for Public Works, and for the City’s Environmental Services Department (ESD), Destiny provides a broad range GIS programming and data services matched to City needs and initiatives. Not all projects are listed below.

For the City’s GIS Department, Destiny is providing C# .NET programming services to develop SDE tools that will convert GIS data formats and manage the GIS layer updating process. Custom programming will automate routine management tasks such as publishing agency data to the data distribution SDE database, publishing to the City’s internet, and exporting data in response to external data orders. Additional programming centers on the development of a Windows Service to run all of the required tasks without user prompt or intervention. The service will direct the upload of multiple-source datasets to the ArcSDE databases. The service will also perform all format conversions - coverages to shapefiles or personal geodatabases – automatically updating the ArcIMS map service and reporting any errors identified during processing.

 

For Public Works, Destiny is utilizing GIS and providing custom programming services to support a significant infrastructure master planning project. Project aims are two-fold: First, to assess capacity, needs, and infrastructure at key dates; and second, to automate and integrate the data handling, analysis, and processing needed to complete future assessments. This includes providing GIS services to analyze population and land use changes producing key input (change units) for the modeling process. Following capacity assessment and modeling, Destiny will assist in the compilation of results. In parallel, Destiny is providing consulting and custom programming to streamline and automate the end-to-end process of moving data from the City’s enterprise database into GIS, conducting land-use and population modeling to determine change unit values, moving the values into the modeling software for capacity assessment and modeling, and following modeling, rolling the results into standard maps, reports, and PDF work products. The automated tools will also track versions, assumptions, and results to save duplicating scenarios.

For the City’s Environmental Services Department (ESD), projects center on developing effective tools and processes supporting environmental characterization, remediation planning, program management, regulatory 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.

CLOSE WINDOW