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 |