Managing and Joining Multiple Geospatial Layers
Chris Wade from the National Flood Insurance Program helps manage building footprints and location data for the entire country. This data is so big, it takes about 3 weeks to load! He shows how he’s getting many different publicly available datasets merged into one canonical dataset. Some datasets work for certain areas while others might be better in a different area. Some of the special tools that make this all work are table inheritance and materialized views.