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

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 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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. GIS USER GROUP What? Recent Discussions • Monthly meeting with users from • Property Data in DC across DC Government. • Master Address Repository and opportunities to implement • Next meeting February 25 th • “In Search Of” • RSVP with Eva.Stern@dc.gov • Agencies in search of specific data or information

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

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

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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. NOTIFICATIONS (GIS AND BI) • Patch Notices • New Data • Migrations • Outages Sign up at http://dcgis.dc.gov Follow @opendatadc

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>

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. PLANIMETRIC DATA & ELA OFFERINGS MATTHEW CROSSETT

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.

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. 2017 – REDACTION AREA • The redaction area was increased at the request of the USSS • White House, Naval Observatory did not change • 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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. PLANIMETRIC DATA CAPTURE • Railroads • Air Field • Recreation Area • Barrier • Road • Building • • Bridge and Tunnel Sidewalk including Stairs and Crosswalks • Geodetic Survey Points • Street Centerlines • Grate • Swimming Pool • Curb and Guardrail • Water • Hydrography Lines On The Horizon: • Obscured Area - Impervious Surface Update - Update to DC Base map services http://opendata.dc.gov/

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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. NEARMAP • Citywide update flown on November 28 th , 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

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

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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. DC AGO USERS / USAGE

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,

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. DC PUBLIC SAFETY PORTAL • What is it? • Who can use it?

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. HSEMA PUBLIC SAFETY PORTAL How we’re using it Overall Experience • Special Events Coordination • Managing Users • Multi-user Editing • Ease of Sharing • Editing & Sharing Secure Data • Sensitive & Secure Data Storing • Story Mapping

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. HSEMA SPECIAL EVENTS Start to Finish • Start to finish.. • Non-GIS users can create data that contributes to the COP. • Publishing Data • Time enabled maps help to • Sharing in groups organize data that stretches • Using smart editor template out over the course of a day or multiple days. • Secure Common Operating Picture: • Can work with and create secure data for special events and disasters to be included in COP

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. DCGIS 2.0 & DATA REPORT MARIO FIELD

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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. GIS 2.0 ARCHITECTURE FME INFORMATICA GEODBDEV DWDBDEV • GIS development database • Data Warehouse development database • Versioning, archiving, replication, editor • Cleaner and leaner tracking, standardization • Only geospatial layers GEODBTST DWDBTST • GIS Testing database • Data Warehouse Testing • Replication GEODBPRD DWDBPRD • GIS Production/Publication database • Data Warehouse production ArcGIS R Tableau Microstrategy SQL Open Data ArcServer 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

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. GIS 2.0: SCREENSHOTS

CUSTOMER SERVICE. ACCOUNTABILTY. EFFICIENCY. SECURITY. GIS 2.0 SCREENSHOTS