1 / 23

Cartographic Database Optimizing TIGER data for Mapping

Cartographic Database Optimizing TIGER data for Mapping Connie Beard Chief, Cartographic Products Branch. Our Spatial Databases. MAF/TIGER Database (~2 TB) Benchmark Database (~1.6 TB) Product Database (~364 GB) Cartographic Database (~75 GB).

altsoba-wright
Download Presentation

Cartographic Database Optimizing TIGER data for Mapping

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cartographic Database Optimizing TIGER data for Mapping Connie BeardChief, Cartographic Products Branch

  2. Our Spatial Databases • MAF/TIGER Database (~2 TB) • Benchmark Database (~1.6 TB) • Product Database (~364 GB) • Cartographic Database (~75 GB)

  3. Cartographic Database (CDB) What Why How

  4. What • Feature Type Tables • Based on TIGER and PDB • Extended Attribution • Link to TIGER Topology • Extensive Geospatial processing

  5. CDB tables illustration

  6. Using the Cartographic Database Benchmark DBs Live MAF/TIGER DB CAMPS Application Census Automated Map Production System Cartographic DBs Product DBs

  7. Why Data Visualization

  8. Why Entity Based

  9. Limit Spatial Processing

  10. Feature Relationships

  11. Why Lots of Maps

  12. HOW Topology Denormalize Classify Generalize Extend

  13. How Spatial Processing Using Topology

  14. Chaining

  15. Chaining Using Topology SELECT topo_id AS edge_id FROM mt_relation$ WHERE tg_layer_id = 1101 AND topo_type = 2 AND tg_id = 1105; SELECT start_node_id, end_node_id FROM mt_edge$ WHERE edge_id IN (8,9);

  16. Dissolving

  17. DissolvingUsing Topology

  18. Classify and Generalize

  19. Extend Attributes

  20. Future Plans • Integration of Oracle Spatial with COTS GIS software • Integrate Generalized Coordinate Representations • Adding features • Performance Enhancement • User-defined Cartographic DataBase

  21. Questions? Cartographic Products Branch 301-763-1101 constance.beard@census.gov nick.a.padfield@census.gov

More Related