GIS STEERING COMMITTEE 2/7/2018 Hosted by the Office of the Chief - - PowerPoint PPT Presentation

▶
gis steering committee
SMART_READER_LITE
LIVE PREVIEW

GIS STEERING COMMITTEE 2/7/2018 Hosted by the Office of the Chief - - PowerPoint PPT Presentation

Aug 20, 2022 150 likes •986 views

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. GIS STEERING COMMITTEE 2/7/2018 Hosted by the Office of the Chief Technology Officer open.data@dc.gov CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. AGENDA Welcome, Data

slide-1
SLIDE 1

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS STEERING COMMITTEE

2/7/2018

Hosted by the Office of the Chief Technology Officer

  • pen.data@dc.gov
slide-2
SLIDE 2

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

AGENDA

  • Welcome, Data Program News & Updates

Alex Santos, Office of the Chief Technology Officer

  • Barney Krucoff is now Interim-CTO
  • GIS User Group & GIS, BI Training
  • ArcGIS 10.6
  • Initiative Pages
  • Planimetric Data Released

Matthew Crossett, Office of the Chief Technology Officer

  • Available Layers & Planned Work
  • Final QC Findings/Limitations
  • Esri ELA Offerings

Matthew Crossett, Office of the Chief Technology Officer

  • New Product Licenses – Insights/BOA
  • DC AGOL Single Sign-on
  • ArcGIS Portal in Public Safety (HSEMA)
  • A City Based Model to Combat Emerging Vector-Borne Diseases

Trey Cahill, Sr. Research Administrator, DC Department of Health

  • How GIS Informs Decision Making in Public Health
  • DCGISPRD 2.0, Enterprise Data Inventory & Data Report

Mario Field, Office of the Chief Technology Officer

  • New GIS Database Structure
  • Current Data Inventory Assessment Tool
slide-3
SLIDE 3

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

  • Property Data in DC
  • Master Address Repository and
  • pportunities to implement
  • “In Search Of”
  • Agencies in search of specific

data or information

  • Monthly meeting with users from

across DC Government.

  • Next meeting February 25th
  • RSVP with Eva.Stern@dc.gov

GIS USER GROUP

What? Recent Discussions

slide-4
SLIDE 4

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS TRAINING

  • First Quarter FY18:
  • Overview (#230): 17 (2 classes)
  • ArcGIS Online (#233): 15 (2 classes)
  • DOEE Brownbag (at agency request)
  • Upcoming training (register through PeopleSoft):
  • ArcGIS Overview: Today… 3/14… 4/4
  • ArcGIS Desktop: 2/20-21…. 4/25-26
  • ArcGIS Online: 2/14… 3/28… 4/11
slide-5
SLIDE 5

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

BI TRAINING FOR TABLEAU

  • Two day class - available to all DC government

employees interested in visualizing their data.

  • FY 2018 attendance:
  • 53 government employees from 23 agencies have

received training

  • Agencies with the highest attendance thus far:
  • DDOT, CFSA and DHS
  • February & March are FULL
  • Tim.Harwood@dc.gov
slide-6
SLIDE 6

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

ARCGIS 10.6

  • For Desktop
  • GISLicense2 manager is now supporting

10.6 (GISLicense1 next week)

  • For Servers
  • End of March, upgrade failover and

staging to 10.6

  • End of May, upgrade production servers

to 10.6

slide-7
SLIDE 7

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

NOTIFICATIONS (GIS AND BI)

  • Patch Notices
  • New Data
  • Migrations
  • Outages

Sign up at http://dcgis.dc.gov Follow @opendatadc

slide-8
SLIDE 8

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DATA INITIATIVE PAGES

  • Highlighting high value data from

OCTO

  • Your data?

Addressing in DC

(previous)

Property Lots in DC

<previous>

slide-9
SLIDE 9

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

PLANIMETRIC DATA & ELA OFFERINGS

MATTHEW CROSSETT

slide-10
SLIDE 10

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

2017 ORTHOPHOTO AND PLANIMETRIC DATA CAPTURE

  • Flown March 2017 by Fugro - 3 inch resolution
  • True ortho was not processed
  • Increased redacted area around Capitol
  • New data captures
  • Crosswalks
  • Heliports/Helipads
  • Wastewater Holding Ponds
  • Areas around White House and US Capitol that

were not captured in the 2015 planimetric data collection.

slide-11
SLIDE 11

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

2017 – REDACTION AREA

  • The redaction area was increased at the request of the USSS
  • Area around the Capitol grew, added a small area in the Navy Yard

2015 Redaction around Capitol 2017 Increased redaction around Capitol, new Navy Yard AOI

  • White House, Naval Observatory did not change
slide-12
SLIDE 12

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

PLANIMETRIC DATA CAPTURE

  • Air Field
  • Barrier
  • Building
  • Bridge and Tunnel
  • Geodetic Survey Points
  • Grate
  • Curb and Guardrail
  • Hydrography Lines
  • Obscured Area

http://opendata.dc.gov/

  • Railroads
  • Recreation Area
  • Road
  • Sidewalk including Stairs and

Crosswalks

  • Street Centerlines
  • Swimming Pool
  • Water

On The Horizon:

  • Impervious Surface Update
  • Update to DC Base map services
slide-13
SLIDE 13

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

ORTHO/PLANIMETRIC/LIDAR UPDATE

  • FY 18 - 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

  • **Modified to include classification for Bldgs and Veg
slide-14
SLIDE 14

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

  • Citywide update flown on November

28th, 2017 (Tuesday)

  • Gain access by visiting

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

  • Available as imagery service (ArcGIS

Desktop), Web Viewer and in ArcGIS Online marketplace (join Imagery Apps group)

  • **Resource is SaaS and temporarily

unavailable due to contracting issue

NEARMAP

slide-15
SLIDE 15

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

ELA – ESRI UPDATES

  • DC AGOL Update & Single Sign-On
  • Licenses for Insights and Business Analyst Online
  • 10.6 and ArcGIS Pro 2.1 released recently.
  • License manager to be updated 2/9
  • Software and documentation will be updated.
  • Upcoming Market Development Webinar

Tomorrow) - http://go.esri.com/info_global

slide-16
SLIDE 16

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

ARCGIS ONLINE HIGHLIGHTS

  • 423 Users
  • 8228 Content Items
  • Open Data DC (1.3m) and DC Circulator Map (1.2m)

lead in views

  • 226 Groups (compared to 152 as of May 2016)
  • 972 items from 73 contributors in January 2018
  • Compared to 312 items from 39 contributors in

May 2016

slide-17
SLIDE 17

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DC AGO USERS / USAGE

slide-18
SLIDE 18

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

RECENT ENHANCEMENTS TO AGO

  • New updates to ArcGIS Online
  • https://blogs.esri.com/esri/arcgis/tag/december-

2017-release/

  • https://blogs.esri.com/esri/arcgis/2018/01/01/try-

something-new-in-arcgis-online/

  • ArcGIS Online
  • App Launcher | Redesign of Ops Dashboard,
slide-19
SLIDE 19

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DC PUBLIC SAFETY PORTAL

  • What is it?
  • Who can use it?
slide-20
SLIDE 20

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

  • Managing Users
  • Ease of Sharing
  • Sensitive & Secure Data Storing

HSEMA PUBLIC SAFETY PORTAL

How we’re using it Overall Experience

  • Special Events Coordination
  • Multi-user Editing
  • Editing & Sharing Secure Data
  • Story Mapping
slide-21
SLIDE 21

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

HSEMA SPECIAL EVENTS

Start to Finish

  • Start to finish..
  • Publishing Data
  • Sharing in groups
  • Using smart editor template
  • Secure Common

Operating Picture:

  • Can work with and

create secure data for special events and disasters to be included in COP

  • Non-GIS users can create data

that contributes to the COP.

  • Time enabled maps help to
  • rganize data that stretches
  • ut over the course of a day or

multiple days.

slide-22
SLIDE 22

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DCGIS 2.0 & DATA REPORT

MARIO FIELD

slide-23
SLIDE 23

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS 2.0

  • Streamlines data presentation
  • Consistent Attribution
  • Dev -> Test -> Prod Architecture
  • Archived Data Available
  • Editing workflows in dev database
  • Current Standardized Metadata
  • Standard Coordinate System
  • Spatial Data Object Storage
  • Use ArcGIS Pro and AGOL to connect
  • Integration with Enterprise Data Inventory
slide-24
SLIDE 24

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS 2.0 ARCHITECTURE

GEODBDEV

  • GIS development database
  • Versioning, archiving, replication, editor

tracking, standardization

  • Only geospatial layers

GEODBTST

  • GIS Testing database
  • Replication

GEODBPRD

  • GIS Production/Publication database

25

DWDBDEV

  • Data Warehouse development database
  • Cleaner and leaner

DWDBTST

  • Data Warehouse Testing

DWDBPRD

  • Data Warehouse production

INFORMATICA FME

ArcGIS ArcServer Tableau R Open Data Microstrategy SQL

slide-25
SLIDE 25

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS 2.0 ATTRIBUTION RULES

OLD COLUMN NAME NEW COLUMN NAME ACTION ADDRID MAR_ID ADDRESS_ID MAR_ID ADDR_ID MAR_ID X XCOORD X_COORDINATE XCOORD POINT_X XCOORD Y YCOORD Y_COORDINATE YCOORD POINT_Y YCOORD WEB_URL note it as in layer WEBURL note it as in layer URL note it as in layer LAT LATITUDE LONG LONGITUDE NAME if no name is present in table, note it ADDR ADDRESS ADDRES ADDRESS LOCATION ADDRESS DESCRIPTIO DESCRIPTION DIFFX remove DIFFY remove

slide-26
SLIDE 26

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS 2.0: SCREENSHOTS

slide-27
SLIDE 27

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

GIS 2.0 SCREENSHOTS

slide-28
SLIDE 28

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

DATA POSTINGS - UPDATES

  • Bus Stop and Line
  • Census Tract – 2010
  • Census Tract – 1930 - 1980
  • Charter School
  • Clean Team Service Area
  • DC Circulator Stop
  • District Property
  • Farmers Market
  • FOIA request
  • Grocery Store
  • Homeless Shelter
  • Homeless Service
  • Leaf Boundary
  • Library
  • Liquor License
  • Liquor Moratorium Zone
  • Notary Public
  • Nursing Home
  • Main Street
  • Museum
  • Planimetrics - 2017
  • Public School
  • P-card
  • Purchase Order
  • Recreation Area
  • School Test Score -2016-17
  • Senior Service Network Location
  • Street Light
  • Transportation Analysis Zone
  • Ward
  • Wetland
slide-29
SLIDE 29

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

  • DPW Tonnage Recycling/Trash
  • DMPED Project Location
  • Food Layers (WIC, joyful markets, low food

access, healthy corner stores, etc.)

  • HUB Zone
  • Impervious Surface 2017
  • Liquor License
  • Notary Public
  • Other Bus Line and Stop
  • Public School

DATA POSTINGS – NEXT BATCH

slide-30
SLIDE 30

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

  • Errors in downloading
  • Relating property data
  • Geographic Projections
  • 2015 lidar download & metadata
  • Pre-K Education Facilities
  • Address Residential Development
  • Data as API
  • Census Tracts to Neighborhoods
  • Light Installation at Parks
  • Zip Codes by Ward
  • Returning Citizen Demographics
  • Detailed business data (sales,

employee, etc)

  • Cosmetology licensees
  • Residential Rentals

REQUESTS FROM OPEN DATA DC

Have nots Help with…

slide-31
SLIDE 31

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

A CITY BASED MODEL TO COMBAT EMERGING VECTOR-BORNE DISEASES

TREY CAHILL DC DEPARTMENT OF HEALTH

slide-32
SLIDE 32

A City-Based Model to Combat Emerging Vector-borne Diseases – Zika Virus, 2016

How GIS Informs Decision Making in Public Health

Wednesday, February 7, 2018 GIS Steering Committee Meeting Presenter: Trey Cahill

  • Sr. Research Administrator | Program Evaluator

Arbovirus Surveillance | Animal Services Division Health Regulation & Licensing Administration

slide-33
SLIDE 33

Outline

  • Overview of 2016 and 2017 activities
  • GIS Overview
  • Power of Mapping
  • Uses of GIS in Arborvirus Surveillance &

Control

  • Strategic Alliances, Regional Collaboration:

Leveraging Information Technology

  • Delivering Risk Communications & Other uses
  • Summary

Mosquito Surveillance and Vector Control DOH Animal Services Division

slide-34
SLIDE 34

Mosquito Surveillance and Vector Control in DC—Overview

  • Arbovirus season

– Since 2002: June through September–West Nile (WNV) only – In 2016: April through October– Chikungunya (ChikV), Dengue (DenV), Zika (ZV) added – In 2017: May through October - Chikungunya (ChikV), Dengue (DenV), Zika (ZV) and West Nile (WNV)

  • Vector control activities

– DC DOH larvicides catch basins only (no spraying or fogging) – Residents can use an approved pest management company to spray/treat their property with pyrethrin insecticides – Investigate complaints (reported by phone: 311 hotline) – Mitigate standing water and mosquito harborage

slide-35
SLIDE 35

Geographic Information Systems (GIS)

  • Enables decision makers to

capture, manage, display, and analyze large quantities of spatial and temporal data in a geographic context

  • Directs Field Operations and

enhances surveillance

  • Provides evidence needed to

educate the public, government, funding bodies and other stakeholders

  • It allows us to Review existing

sites (DOH & DOD) in a spatial context and…..

  • Plan new sites for enhanced

surveillance programs

slide-36
SLIDE 36

Power of Mapping

Sites with populations of Aedes aegypti

GIS lets us:

  • Visualize
  • Question
  • Analyze and
  • Interpret data

To understand relationships, patterns, and trends

slide-37
SLIDE 37
slide-38
SLIDE 38
slide-39
SLIDE 39

CDC’s new MosquitoNet Portal

slide-40
SLIDE 40
slide-41
SLIDE 41

In the world of Arbovirus Surveillance Mapping consists of:

Utilizing appropriate map scale

slide-42
SLIDE 42

Recording surveillance and control data at the finest spatiotemporal resolution that is

  • perationally feasible
slide-43
SLIDE 43

Ensure that all data are linked to spatial information for use in (GIS) geographic information systems

slide-44
SLIDE 44
  • Quantify mosquito population sizes when possible, using standardized methods that allow comparisons

among locations and identify “hot-spots” and infestations

  • Visualization and analysis of mosquito distributions and abundance
slide-45
SLIDE 45

Mosquito Surveillance and Vector Control– 2016

DC Mosquito population

  • 85% Culex pipiens
  • 12% Aedes species
  • 7% Aedes albopictus
  • 4% Aedes unkown
  • 1% Aedes aegypti

Image Source: BioQuip Products, Inc.

slide-46
SLIDE 46

Documentation of Larval and adult mosquito sources:

slide-47
SLIDE 47

Documentation of service requests received from the public (i.e., 311 service requests)

slide-48
SLIDE 48

Documentation of Surveillance and Control

  • Provide up-to-date

information to residents who contact DC DOH

– Mitigation activities

Image Source: DC Water

slide-49
SLIDE 49
slide-50
SLIDE 50

Identification of “hot-spots” of mosquito activity or pathogen transmission risk

slide-51
SLIDE 51

Data Enrichment & Analysis

slide-52
SLIDE 52

ESRI Business Analyst Online: 5, 10 and 15 min walk radius around each WNV Positive Site

slide-53
SLIDE 53

ESRI Business Analyst Online

slide-54
SLIDE 54

ESRI Business Analyst Online

slide-55
SLIDE 55

ESRI Business Analyst Online

slide-56
SLIDE 56

Strategic Alliances: Department of Defense (DOD)

  • Large part of the District encompasses Federal land, including
  • pen/green space
  • Since 2002 DC DOH has collaborated with US Army MedCom Division
  • f the Public Health Command- Atlantic
  • Collaboration

– Provides regional arbovirus training (e.g. trapping, speciating) – Trap on 7 DC military installations and perform their own harvesting, speciating, and testing (Anacostia Annex, JBAB, Naval Observatory) – Provides DC DOH access to their data through an electronic portal

slide-57
SLIDE 57

Regional Collaboration: Northern Virginia West Nile Managers Team

  • WNV Management Team
  • Monthly meetings
  • Data sharing: Positive PCR Panels, Unusual observations
  • Discuss new processes and products, challenges and successes
  • Training
slide-58
SLIDE 58

2016 & 2017

Posters presented to the National Gallery

  • f Art of their specific

site results per season

slide-59
SLIDE 59

Strategic Alliances

2016

  • 1 site
  • 1 trap (Gravid)

2017 Season Program Expansion at the NGA Site

slide-60
SLIDE 60

National Gallery of Art

slide-61
SLIDE 61
slide-62
SLIDE 62

Strategic Alliances

Ward 2: National Gallery of Art Sculpture Garden (Site 2D)

Smithsonian National Museum American History Museum

2016 Seasonal Permission granted for Surveillance at the National Gallery of Art (NGA)

Located in the Heart of the National Mall

slide-63
SLIDE 63

Strategic Alliances

Original site 2017

  • 3 sites
  • 3 traps

NATIONAL MALL 2017 Season Program Expansion at the NGA Site

slide-64
SLIDE 64

Strategic Alliances

2017 Season Program Expansion at the NGA Site

slide-65
SLIDE 65

Delivering Risk Communication Messages

slide-66
SLIDE 66
  • Site tests positive for an

arbovirus

  • Alert letter and

educational materials prepared

  • DC DOH hand-

delivered letter and talked with residents

Delivering Risk Communication Messages

slide-67
SLIDE 67

Extended Hot Zone for WNV Community Outreach

Delivering Risk Communication Messages

slide-68
SLIDE 68
slide-69
SLIDE 69

ESRI Story Map

Leveraging Information Technology

slide-70
SLIDE 70

Leveraging Information Technology

slide-71
SLIDE 71

Leveraging Information Technology

slide-72
SLIDE 72

Leveraging Information Technology

slide-73
SLIDE 73

Rabies Program

slide-74
SLIDE 74

Rodent Control Division

slide-75
SLIDE 75

DC Food Trucks

Track Inspections Citations Alert the Public of Food Safety Violations Track locations in real time

slide-76
SLIDE 76
slide-77
SLIDE 77

Summary

Power of Mapping Allows us to Visualize, Question, Analyze and Interpret data to understand relationships, patterns and trends Strategic Alliances & Regional Collaboration

  • Allowed us expand
  • ur surveillance

across key areas of the District and ensured cross- jurisdictional continuing education and data sharing resulting in more comprehensive data collection and quality Delivering Risk Communication Messages

  • Facilitated a more

focused Public

  • utreach plan by

enriching the data to target vulnerable populations in areas testing positive for an arbovirus

  • Multiple strategies

used to address specific audiences

Leveraging Information Technology to improve

  • ther programs
  • Improve

management and tracking of vector control activities

  • Use GIS to track

and analyze data

  • n a real time basis
  • Executive buy-in

has occurred and the uses and advantages of this technology are clear

slide-78
SLIDE 78

Contacts

DC DOH Website https://doh.dc.gov/service/infectious-diseases Mosquito Related Issues Mosquito.Info@dc.gov

Trey L. Cahill

  • Sr. Research Administrator | GIS Analyst

Program Evaluator | Animal Services Program Arbovirus Surveillance DOH Contractor (202) 442-4932 tracy.cahill@dc.gov

slide-79
SLIDE 79
slide-80
SLIDE 80
slide-81
SLIDE 81
slide-82
SLIDE 82
slide-83
SLIDE 83

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY.

THANK YOU FOR JOINING US 

Feedback

  • pen.data@dc.gov