GIS STEERING COMMITTEE 2/21/2017 Hosted by the Office of the Chief - - PowerPoint PPT Presentation

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS STEERING COMMITTEE

2/21/2017

Hosted by the Office of the Chief Technology Officer

• cto.data@dc.gov

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

AGENDA

• Welcome, Data Program News & Updates

Barney Krucoff, Chief Data Officer, Office of the Chief Technology Officer

• Program Growth – New hires
• GIS Executive Committee
• Data Policy
• Esri ELA Negotiations
• Imagery and LiDAR

Matthew Crossett, GIS Project Manager, Office of the Chief Technology Officer

• NearMap
• Pictometry
• Photogrammetric Project
• HistoryQuest DC and Historic Buildings

Charlie Richman, Chief Information Officer, Office of Planning

• Success Story and Challenges
• Data Behind the Scenes
• Esri FedGIS Conference
• ArcGIS Pro
• ArcGIS Enterprise: Insights, Portal & ArcGIS Online
• Data Report and Inventory Tools

Mario Field, Data Curation Project Manager, Office of the Chief Technology Officer

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

OCTO DATA PROGRAM GROWTH

• New Hires
• Peter Casey, Senior Data Scientist
• Likely focus on: OCA, Criminal Justice, Mayoral

Outreach Agencies.

• Nicole Donnelly, Senior Data Scientist
• Focus 9-1-1 and 3-1-1, plus TBD
• Tim Harwood, Senior Business Inelegance Analyst
• Likely focus: DCPS, OSSE, plus TBD
• Weichi Xiong, Senior GIS Developer
• Agency analytics projects
• Interested?

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

BUSINESS INTELLIGENCE EXPANSION AND TIES TO GIS

• Tableau
• Enterprise purchase
• 24 server cores for total of 32 cores
• 100 desktops for total of 200
• Must meet OCTO criteria
• OP experimenting with importing geography
• Microstrategy
• Desktop software now free
• Partnership with Esri for geo
• Training for both platforms being coming…

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GISSC EXECUTIVE COMMITTEE

• Call for Nominations!
• Establishes priorities and identifies

issues that must be addressed by GISSC

• Two members, not OCTO, must be DC

Voting Agency

• Assume the duties of the chair in

GISSC matters when the chair is not available

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• If you don’t know the person it’s
• kay to nominate an agency
• Nominate today, vote online soon

Department of Consumer and Regulatory Affairs (DCRA) Department of Health (DOH) Department of Public Works (DPW) Department of Fire and Emergency Medical Services (FEMS) District Department of the Environment (DDOE) District Department of Transportation (DDOT) Homeland Security and Emergency Management Agency (HSEMA) Metropolitan Police Department (MPD) Office of the Chief Technology Officer (OCTO) Office of the City Administrator (OCA) Office of Planning (OP) Office of the Deputy Mayor for Planning and Economic Development (DMPED) Office of Tax and Revenue (OTR) Office of Unified Communications (OUC) Office of Zoning (OZ) DC Water (Formerly Water and Sewer Authority)

GISSC EXECUTIVE COMMITTEE

Voting Member Agencies Who is here today?

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DATA POLICY – BRIEF UPDATE

• Status
• OCA Completed a detailed review
• Document is now with Office of Attorney General for legal

sufficiency review

• Changes since last meeting
• Definitions reordered
• Definitions of Level 1,2 and 3 changed to reference FOIA
• Streamlined agreements for sharing Level 1 and Level 2 data

now required

• Minimum Data Protection Standards Adjusted
• More support referenced for small agencies particularly

regarding security.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• have the potential to jeopardize

the safety, privacy, or security of residents, agency workforce members, clients, partners, or anyone else identified in the information;

• require subjective redaction;
• impose an undue financial or

administrative burden on the agency; or

• expose the District to litigation or

legal liability.

• Refers to a dataset that is not

protected from public disclosure under any law and is releasable under FOIA. Nevertheless, publication of the dataset on the public Internet and exposure to search engines would

MODIFIED DEFINITIONS

Level 1 Public Not Proactively Released

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• For example, OCTO licenses

commercial data on businesses

• perating in the District. The

license prohibits the public distribution of the data, and proprietary restrictions qualify as a FOIA exemption. Nevertheless, the data has widespread utility within the government, including for economic development and emergency management, and therefore would be classified as Level 2.

• Refers to dataset that the
• riginating agency determines is

subject to one or more FOIA exemptions but is not highly sensitive and may be distributed within the government.

MODIFIED DEFINITIONS

Level 2 For District Government Use

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• Such datasets generally include datasets

that contain data designated by a federal agency or District agency as:

• Attorney-Client Privileged
• Criminal Justice Information
• Critical Infrastructure Information
• Critical Program Information
• Family Educational Rights and Privacy

Act (FERPA),

• Federal Tax Information (FTI),
• For Official Use Only (FOUO),
• Health Insurance Portability and

Accountability Act (HIPAA) / Protected Health Information (PHI)

• Law Enforcement Sensitive
• refers to dataset that the
• riginating agency has

determined is protected from disclosure by law, including FOIA,

• r regulation.

MODIFIED DEFINITIONS

Level 3 Confidential

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• To lower the cost and increase the speed of the intra-District

sharing of datasets classified as Level 2 or Level 1, the Chief Technology Officer, in coordination with the Office of the City Administrator, shall develop uniform data-sharing agreements. A public body shall not require another public body to enter into a data-sharing agreement other than the uniform data-sharing agreement in order to have access to view, utilize, or transfer Level 1 or Level 2, datasets, unless a different data-sharing agreement is approved by the City Administrator.

MODIFIED INTERAGENCY SHARING

VIII Streamlined Processes for Interagency Data Sharing

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• Looking South
• 2003*
• 2005*
• 2007*
• 2009*
• 2011*
• 2014 (Fall)
• 2015 (Spring)
• 2017 (Winter)
• Procured

Pictometry Connect in 2016 (Explorer, Mobile and Desktop)

• Scheduled Flight

Plan completed 1/23/17. Now 30- 60days to data delivery.

• Looking East
• Looking North
• Looking West

OBLIQUE DATA REFRESH 2016 WINTER

*Licensed Data *Access

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

NEARMAP

• Citywide update flown on November 8th

2016 (Tuesday)

• Gain access by visiting

http://octo.in.dc.gov/node/165505

• Available as imagery service (Desktop),

Map Viewer and in ArcGIS Online marketplace (join Imagery Apps group)

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

5YR ORTHO/PLANIMETRIC/LIDAR CONTRACT VEHICLE COMPLETED

• 3” Ortho and Planimetric Updates Years 1, 3 and

5

• QL2 LiDAR Acquisition, Processing and

Derivatives (based on USGS Base Specs). Includes:

• Raw Point Cloud in LAS 1.4 format.
• Classified Point Cloud
• Bare Earth Surface (Raster DEM)
• Breaklines, Contours, Lidar Intensity Images,

Control and Metadata

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HistoryQuest DC

Historic building data for the District of Columbia Charlie Richman, Ph.D. DC Office of Planning

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HISTORYQUEST DC – WHERE TO FIND IT

• Search for “HistoryQuest DC” or
• The app: http://goo.gl/3HVemA
• The update page: http://goo.gl/nPWrL1
• The data:

http://opendata.dc.gov/datasets/8ffa91 09cd9a4e37982cea67b289784d_0

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HISTORYQUEST DC – BEHIND THE SCENES

• Straight-up ArcGIS Online Web Builder app
• Best and worst parts: the data
• 10 years of painstaking microfilm research by

Brian Kraft (plus newer info that isn’t as good)

• 170,000 building polygons
• A gigabyte of attribute data

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HISTORYQUEST DC – MAKING IT WORK

• Eliminated the buildings we don’t draw
• Slimmed down the attribute data
• Filtered out unnecessary vertices
• Added a tiled overview layer
• Published the map, an update tool, and the data

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HISTORYQUEST DC – GOING FORWARD

• Historic Preservation staff are reviewing

updates suggested by the public now

• We’ll have to look at how to update our building

footprints based on new planimetrics Thank you

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

ESRI FED GIS CONFERENCE

• Open Discussion
• ArcGIS Pro
• ArcGIS Enterprise
• Insights
• Portal / ArcGIS Online

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• Metro Station
• Notary Public
• Recreation Area (DHCD

properties)

• Single Member District (Contact)
• Supermarket Tax Credit
• Village Boundary (Office of

Aging)

• Ward (Contact)
• Zip Code
• Camera Enforcement
• Camera
• Commission of Fine Arts Award
• DC Agency
• DC Property (DHCD properties)
• Enterprise Zone
• Hub Zone
• Main Street

DATA POSTED

In the last six weeks

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• Moving Violation (thru 1/17)
• Museum
• Notary Public
• P-card
• Purchase Order (2016-17)
• Parking Violation (thru 1/17)
• Trash Day
• Wetland
• Business – 2017
• Business archive - 1997, 2002,

2007, 2013, 2014, and 2015

• DHCD
• DPW Trash and Recycling

Tonnage by route

• Floodplain
• Great Street Grantee
• Green Building
• Historic Building
• Main Street (polygon)

DATA ON THE WAY

Soon…

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

AGENCY DATA INVENTORY TOOLS

• Within 60 days of the issuance of this Order, OCTO shall provide

public bodies with an intranet-based data inventory tool and train ADOs and AISOs on its use.

• Within 180 days of receiving the tool, public bodies shall inventory

and designate the dataset classification levels of their enterprise datasets using the online tool provided by OCTO. The tool shall include a series of questions that walk public bodies through the dataset classification. Prioritization will not be included in the initial Enterprise Dataset Inventory.

• Where enterprise datasets are not classified as Level 0: Open, an

explanation for the higher classification shall be included in the inventory.

• Within 270 days of the issuance of this Order, OCTO shall publish

the first iteration of the Enterprise Dataset Inventory as Level 0, Open.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

SYSTEMS AND DEVELOPMENT

• SDE service is offline.
• Connect via direct connection or easy

connection

• Geoevent server 10.4. 1 is established
• Started work for ArcGIS server 10.5

development environment

• One of ArcGIS desktop License managers

is upgraded to 10.5. The other one will be updated to 10.5 by the end of February.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

• Available on DC GIS

website

• 3 currently:
• Mapping Address Data
• AGOL Web Maps and Apps
• Joining Data to Maps
• More Soon!

Classes through the end

• f FY 17 are in PeopleSoft
• Overview of DC GIS - ArcGIS:
• ArcGIS 1
• DC ArcGIS Online for

Organizations (AGOL)

• AGOL Web Maps and Apps

TRAINING

DCHR WEBINARS

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

We need more responses!

• Leadership: n=3
• Users: n=29
• We’ll be sending out

both surveys again after Inauguration 2 Surveys in November:

• Leadership (CIO/IT

Leads)

• Users

TRAINING

SURVEYS Take the Survey

Leadership Survey (executive and management level staff) User Survey

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

Of the people who answered the survey:

• The majority are using GIS every day
• Most users indicated that they are intermediate or advanced

users

• Most respondents (user or leader) indicated “Analysis” or “Spatial

Analysis” as a learning goal

TRAINING

SURVEY TRENDS

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

THANK YOU FOR JOINING US 

Feedback

• cto.data@dc.gov