Interagency Data Team - Octo

Transcription

Office of the Chief Technology OfficerDecember 9, DC GovernmentDecember 16, 2020Interagency DataTeam

Agenda2021 Enterprise Dataset Inventory ProgressEva Reid, Senior Analyst (OCTO)Enhanced Roadway Centerlines for Broad Traffic & Street Asset AnalysisJames Graham, GIS and Applications Manager (DDOT)Data ReportMario Field, Data Curation & Governance Program Manager (OCTO)December 16, 2020DC GovernmentOffice of the Chief Technology OfficerWelcome, News & UpdatesBarney Krucoff, Chief Data Officer (OCTO)Michael Bentivegna, Program Manager for Data Visualization & Analysis (OCTO)

Barney KrucoffChief Data OfficerOffice of the Chief Technology OfficerDecember 16, 2020DC GovernmentOffice of the Chief Technology OfficerWelcome

TableauInternalProductionTableauPublic Production 2020.2.32020.2.312 Agencywebsites inproduction with 88 embeddedTableauReports/DashboardsUpgrade toversion 2021planned forFebruaryAutomatic ScriptDecember 16, 2020TableauTest/Dev2020.2.3QuickBaseSecure AuthTableau SiteAdministratorquarterlymeetingNext meetingMarchDC GovernmentOffice of the Chief Technology OfficerBusiness Intelligence - Tableau Updates

MicroStrategyProduction @version 2020Update 1Upgrade to version2021 planned forMarch 2021December 16, 2020LowerMicroStrategyEnvironments2020 Update 1Enterprise/SelfServiceDeployingphysical IS serverfor developmentMicroStrategyPublic/SharePointCOVID19 onavirus-dataCoronavirus StatsDCPS Back-to-schoolCall dashboardMicroStrategyStake HoldersMeetingNext meeting will bein February 2021MicroStrategy WorldFeb. 3-4th GeneralAdmission is Free – VirtualDC GovernmentOffice of the Chief Technology OfficerBusiness Intelligence - MicroStrategy Updates

ArcGIS ServerProduction @ version10.7.1(10.8.1 planed for endof Q2 2021)Reminder HTTP for MapServices Disabled(12/3/2020)Secure EM Services:COVID service RESTendpoints: https://em.dcgis.dc.gov/dcgis/restDecember 16, 2020ArcGIS Portal @version 10.7.1Public Safety PortalFailover from 12/8to 12/15StreamingservicesEsri GeoEventInternal 10.7.1External 10.7.1Esri Federal GISConference – Feb 2224th ComplimentaryRegistration, DC GovEmployees/ContractorDataPictometry has POto fly new aerialimagery December2020 (Partnershipwith OCFO). Datawill beon https://explorer.pictometry.com/login.phpDC GovernmentOffice of the Chief Technology OfficerGeographic Information Systems - DC GIS

Big Data and Data Integration Updates Cloudera Software Platform Upgrade Enhanced Security Easier Kerberos Authentication Apache Spark 2.x and other new tools Data Lake docs now available for R-Studio, Microsoft Excel, Microsoft PowerBI DDOT Dockless Trips Data – Esri GeoEvent Integration!COVID-19 Response Mobility Data from multiple providers – over 13 Billion Records Replica - User Interface and Raw Data available - DC Regional Model now available! AWS Connect Call Center – DHS, OCTOHelps/DCPS, DC Health,DCRA, DCHRDecember 16, 2020DC GovernmentOffice of the Chief Technology OfficerCurrent and Upcoming Big Data Projects:

GIS User Group (Meetings via WebEx): December 17thContact: Eva.Reid@dc.govDC GovernmentOffice of the Chief Technology OfficerUser GroupsData Science @ DCNext Meeting: January 2021 (via Teams)Contact: Tomash.Bukowiecki1@dc.govDecember 16, 2020

ssJanuary 24January 12-13February 9-10March 17February 2-3March -coursesDecember 16, 2020DC GovernmentOffice of the Chief Technology OfficerVirtual Tableau Training

Office of the Chief Technology OfficerIntroductory trainingArchitect/Developer training Next training in early 2021 By invitation only, based on agency needFirst online training in earlyFebruary ntroductory-trainingDecember 16, 2020DC GovernmentMicroStrategy Training

Office of the Chief Technology Officer New class! DC Government GIS – Virtual live training, January 6 ,2021 DC Government Learning Paths available via ESRI Training Portal to employees withArcGIS Online access.Please submit an information request for more information. All courses requireArcGIS Online Access and/or ArcGIS Pro locally.December 16, 2020DC GovernmentGIS Training

Office of the Chief Technology OfficerDC Government GIS Learning Paths: DC Government: ArcGIS Online Fundamentals DC Goverment: ArcGIS Pro Fundamentals DC Government: Migrate to ArcGIS Pro (for current ArcGIS Desktop users) DC Government: ArcGIS API for Python FundamentalsPlease submit an information request for more information about these courses). All courses require ArcGIS Online Access and/orArcGIS Pro installed locally.December 16, 2020DC GovernmentGIS Training

Office of the Chief Technology OfficerEva ReidSenior AnalystOffice of the Chief Technology OfficerDC GovernmentDecember 16, 20202021 Enterprise Dataset InventoryProgress

Office of the Chief Technology OfficerWe encourage agencies to inventory any COVID 19-related datasets and datasets fromnew programs. October 20th, 2020: EDI Open for Editing January 4th, 2021: Recommended date for agency general counsel review to begin January 15th, 2021: All changes to agency inventory must be complete March 10, 2021: Public distribution of the full Inventory (per Mayor's order)December 16, 2020DC GovernmentEnterprise Data Inventory

Office of the Chief Technology OfficerHelpful Links: District’s Data Policy (Mayor Order 2017-115) Enterprise Data Inventory (EDI) website Email EDI.Admin@dc.gov with questions.December 16, 2020DC GovernmentEnterprise Data Inventory

DDOT’s New Centerline Data:TRAINING & EXAMPLESThe DDOT GIS Team

Everybody loves a tions/

Sharing Transportation Data (recent)Pavement ConditionsCenterlinesSpeed LimitsTraffic VolumesAddressingParkingSidewalksSnowBike

Goals Detail. Provide as much detail, on as many roadwayfeatures, for as many use cases as possible. Reduce Data Wrangling. Strive to make roadway dataas complete and ready for analysis as possible,considering both the attributes and geometrysegmentation users might need.

Sharing Transportation Data eed LimitsSidewalksSnowBike

Slow Zones/Streets (Vision Zero)Universe of ntConditionsCrash DataShort-termTraffic CountsAccess ControlTurnRestrictionsCross-walksSpeed LimitsTruckRoutesSafetyAnalysis(coming soon)SnowRoutesLane CountsEmergencyRoutesGISTurnMovements(coming soon)Bike LanesLinear Referencing System (LRS)Lane ctionsSignInventoryMIRE DataElementsSign ck )Cross-section dIntersectionsPermitting(TOPS)(coming soon)ADA DataItemsRight-of-Way(coming soon)

BlocksChoose your Centerline “Flavor”

SubBlocksBlocksChoose your Centerline “Flavor”

BlocksSubBlocksApproachesChoose your Centerline “Flavor”

BlocksSubBlocksApproachesBlockfacesChoose your Centerline “Flavor”

BlocksSubBlocksApproachesBlockfacesChoose your Centerline “Flavor”

Slow Zones/Streets (Vision Zero)Universe of ntConditionsCrash DataShort-termTraffic CountsAccess ControlTurnRestrictionsCross-walksSpeed LimitsTruckRoutesSafetyAnalysis(coming soon)SnowRoutesLane CountsEmergencyRoutesGISTurnMovements(coming soon)Bike LanesLinear Referencing System (LRS)Lane ctionsSignInventoryMIRE DataElementsSign ck )Cross-section dIntersectionsPermitting(TOPS)(coming soon)ADA DataItemsRight-of-Way(coming soon)

Let’s Take a Tour

Bike Safety I need a map of “safe” bike lanes in DC. Lower traffic volume (AADT 10k) On small-medium roads (Functional Class) “Protected Bike Lanes” Only (see docs)

Pavement Conditions I need a map showing poor pavement quality in DC. With high traffic volume With higher speed limit

Find a Parklet I need a map of Parklet Locations (For Car Free DC.) Overall street width of 40-60’ Parking on both sides (Parking Width 12’) Wide sidewalks (Sidewalk Width 8’) Speed 25 or less

You Choose! What would you like to map?

ReferencesOpen Data: ocumentation/Background:– DDOT’s LRS: https://wiki.ddot.dc.gov/display/public/GIS/Roads and Highways LRS– Cross-section Data: section Data– Data Dictionary: y Characteristics

What’s next? Tell your friends Up on Open Data Today! Parking Data by the End of the Year!

Office of the Chief Technology OfficerMario FieldData Curation Program ManagerOffice of the Chief Technology OfficerDC GovernmentDecember 16, 2020Data Report

Streatery7 New ReOpen DC TablesDCPS Call Trace RecordsDC COVID-19 District of Columbia PublicSchools DDOT Residential Visitor Parking Zone Critical Tree Root ZoneDecember 16, 2020 All available atopendata.dc.gov Published sincelast meeting,9/29/20 Contributors: DCHealth, DCPS,EOM, DDOT, UFADC GovernmentOffice of the Chief Technology OfficerNew Datasets on Open Data DC

Charter SchoolsConventional Recycling DaysConventional Trash DaysDC PropertyHistoric Preservation EasementsHistoric LandmarksHistoric Landmark SitesHistoric Landmark PointsHistoric DistrictsLeaking UndergroundStorage Tank Liquor LicensesDecember 16, 2020 All available atopendata.dc.gov Updated since lastmeeting, 9/29/20 Moving ViolationParking ViolationResidential Trash RoutesResidential Recycling RoutesSenior Village BoundaryUnique Building IdentifierUnderground Storage TankWardWireless HotspotsDC GovernmentOffice of the Chief Technology OfficerUpdated Data

Public extract of thedatabase used forsending tax assessmentbills. It is also known astax assessment roll. ITSstores comprehensivetax information such asownership, mailingaddresses etc of recordlots, tax lots, parcels,condominiums andfederally owned landssuch as reservations andappropriations.MetadataDecember 16, 2020Dropped FieldsNew tax-system-public-extractPublic Notice of Coming ChangesDC GovernmentOffice of the Chief Technology OfficerFile Changes with new Tax System

Questions?December 16, Presentation and Meeting NotesDC GovernmentOffice of the Chief Technology OfficerThank you for joining. For notes and presentationmaterial visit:

QuickBase. Secure Auth. Tableau Site Administrator quarterly meeting. Next meeting March. Business Intelligence -