US Census Bureau Geographic Support System Initiative Partnership Program OVERVIEW SOLUTIONS – Cont’d •  Centrally managed, authoritative database (MAF/TIGER) •  Oracle APEX (Application Express) •  Centrally managed Partnership Program SDE geodatabase •  Oracle Exadata •  Supports all censuses and surveys RESULTS CHALLENGES / OPPORTUNITIES •  Data is secured with FISMA compliant mechanisms (using Oracle OID) •  Need for centralized repository for data sets, security for mission critical data •  Single Sign On implemented (using Oracle OID) •  Need to support access by various COTS •  Successful processing of 450+ partner data sets, by 50+ business analysts, with thousands more to come •  Increased level of automation for update processes •  Consolidation of partner road-centerline and address data in •  Maintaining persistent topology 27 GB sized (and growing) central repository SOLUTIONS •  Successful integration with FME (for ETL), ArcGIS SDE (for browsing and analysis), 1Spatial Radius Studio (for conflation •  Oracle Database 11g Enterprise Edition 11.2.0.3 automation tasks), and Acquis Data Editor (for editing) •  Spatial Option with Spatial Topology Data Model •  Used Oracle Spatial Topology Data Model to successfully •  Partitioning maintain persistent topology •  Oracle Web Logic 10.3.6 •  Exadata has enabled faster processing – timely completion of •  MapViewer 11.1.6, including Oracle Maps previously time-intense tasks •  Oracle Business Intelligence Enterprise Edition •  Oracle Exadata compression helps manage large datasets •  Oracle Internet Directory with ease (MAF/TIGER Data sets total approx. 17 TB) May 2014 Oracle Spatial Summit May 21, 2014 Walter E. Washington Convention Center Washington, DC USA Jay E. Spurlin Special Assistant to the Assistant Division Chief for Spatial Data Systems and Database Management GSSI Partnership Program Program Agenda •  Overview •  MAF/TIGER Database •  Geographic Partnership Program •  Oracle Exadata Overview US Census Bureau - Geography Division •  The Geography Division handles geographic and cartographic activities in support of the Census Bureau's statistical programs. •  We continuously update features, boundaries, geographic entities, and address information –  TIGER (Topologically Integrated Geographic Encoding and Reference) –  MAF (Master Address File). •  We research geographic concepts, methods, and standards needed to facilitate data collection and dissemination. Overview Geographic Support System Initiative •  In support of the 2020 Decennial Census, the Census Bureau is evaluating what areas should be targeted for a traditional, on-the-ground address canvassing operation and areas in which it is not necessary. •  How will we decide which areas should be considered for targeting? –  GEO has evaluated the MAF/TIGER database and assigned quality indicators to each of the census tracts –  The MAF/TIGER is being updated through the Geographic Partnership Program –  A Targeted Address Canvassing strategy has been developed that contains an inventory of criteria for evaluation Overview Geographic Support System Initiative •  The Geographic Partnership Program is now underway. –  GEO is receiving both address and spatial data from invited partners –  The data are being evaluated and integrated with the MAF/TIGER database. –  The next step is to determine what level of feedback we can give to the partners about their data. •  The combination of the evaluation of the current MAF/TIGER database, the partner data, and predictive modeling will contribute to the recommendation on which areas of the country should be considered for targeting. MAF/TIGER Database An overview •  Implemented on Oracle Spatial Topology Data Model –  Custom topological primitive features –  Over 50 feature “layers” implemented in dozens of feature tables –  Hierarchical features (features built on other features) •  Many software systems in MAF/TIGER system – all using Oracle –  GWCS (GSSI Workflow Control System) –  School District Review Program (SDRP) Crowd Source application –  PCPTR (Problem Capture, Prioritization, Tracking, and Reporting) –  QIs (Quality Indicators)