DC GIS Enterprise Computing Overview

1
DC GIS Enterprise Computing Overview

• Barney Krucoff
• GIS Director
• District of Columbia
• Office of the Chief Technology Officer
• Barney.Krucoff_at_dc.gov
• 202-727-9307

2
Washington, District of Columbia

• Basic Facts
• Capital of the United States
• 68.7 square miles / 177.4 square kilometers
• 581,000 residents
• 1,000,000 day time population
• District of Columbia Government Functions
• City
• County
• State

3
Improve the quality and lower the cost of
services provided by the District through the
efficient application of geospatial technology.

• Provide a one stop shop for DC data
• http//dcgis.dc.gov
• Develop maintain cross-functional data sets
• Aerial photography
• Planimetric, Topographic 3D
• Property Addresses
• Develop and Operate Enterprise systems
• Web sites / Web services
• Hosted applications
• DC GIS Central Database

• Provide customer service
• Training
• Help desk
• Consulting
• Plan
• Plan and Coordinate
• Steering Committee
• Strategic Business Plan
• Standards
• District, Regional, Federal
• Emergency Service Function

4
Shared Services / Enterprise GIS Strategies

• More IT Cowboys than Utah!
• Web Services
• Stateless Web Sites
• Enterprise Service Bus
• Data Warehouse
• Distributed Desktop GIS (Citrix) with Layerfile
  Library

5
Web Services Stateless Web Applications
DC GIS Services Oriented Architecture (SOA)
XML - SOAP - Web Services
6
Stateless Web applications allow deep links
http//about.dc.gov
7
Enterprise Service Bus
8
Shifting Homicide Hotspots
2003
2007
2006
The maps track homicides only for the first 145
days of each year. Orange areas have 1-2
homicides within an 800-meter radius. Red areas
have 3 to 5 homicides within an 800-meter radius.
Medium
9
CapStat, Citywide Data Warehouse (CDW) DC GIS

• CapStat A program run by Mayors/City
  Administrator's Office that uses data to help
  agencies improve their performance while
  providing transparency and accountability.
• CDW and DC GIS are OCTO (Technology Department)
  programs that provide data and tools to CapStat
  and others.
• CDW collects transactional data in near real
  time this includes service requests, crimes,
  permits. (points only)
• DC GIS collects spatial data (points, lines or
  polygons). DC GIS points are usually not
  transactional, for example, fire stations,
  parking meters, place names. However, DC GIS is
  the transactional system for base property
  address data even though some of that data is
  points.
• Users should not know our care whether a given
  dataset is managed by DC GIS or CDW.

10
CDW Live Data Work Flow (variations occur)
http//dcstat.octo.dc.gov
http//crimemap.dc.gov
11

DPW Bulk trash pick with GIS routing
Mayors Call Center geocodes service requests as
they come in.
Citywide Data Warehouse updates service request
feed.
Each crew receives checklist of stops
DPW uses hosted desktop GIS to route crews.
and a route map
12
DC GIS TOOLS Hosted GIS Applications

• Custom Tools to improve usability and
  productivity of Central resources

• Demonstration

13
Lessons Learned

• DC has saved money (we dont know how much)
• Many functions/agencies are supported by the same
  hardware, software and data.
• Development costs have fallen.
• Standardization has increased.
• Maintenance has been centralized
• Many of DCs services are not standards based.
• Data feeds do break.
• People want to use Citrix with data on their C
  drive no matter what.
• DCs stateless websites and web services have
  been subject to intentional and unintentional
  denial of service attacks. We did not build in
  enough security upfront. Always Include STATE!

14
Whats next for DC

• Google or Google like cached base map service
  to complement DC Basic Map Service
• Google Earth client for non-analytical users
• Add database replication ArcGIS 9.2 as a tool to
  complement existing Citywide Data Warehouse and
  Layerfiles
• More analysis tools/wizards/web services
• Publishing data in KML
• ArcGIS Server 9.2 to add more analytic Web
  Services
• Data generalization
• Thematic mapping on the web
• Density analysis
• Cascading geocoding