1 / 27

Building Footprint Data Collection and Processing

Building Footprint Data Collection and Processing. Allen Sparks Enterprise GIS Program Resource Information Management Division National Information Services Center Office of the Chief Information Officer. Presentation Outline. History of the Buildings Standard

Download Presentation

Building Footprint Data Collection and Processing

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. Building Footprint Data Collection and Processing Allen Sparks Enterprise GIS Program Resource Information Management Division National Information Services Center Office of the Chief Information Officer 2008 GIS & Data Management Conference

  2. Presentation Outline • History of the Buildings Standard • Buildings Data Model Implementation • Initial Data Collection Efforts • Lessons learned • Next Steps 2008 GIS & Data Management Conference

  3. History of the Buildings Standard • Buildings chosen as “low-hanging fruit” • Standards team formed • Standard developed through multi-year process • Regional GIS programs agree to support effort • Implementation started FY2007 2008 GIS & Data Management Conference

  4. Buildings Data Model Original Model 2008 GIS & Data Management Conference

  5. Buildings Data Model Implemented Model 2008 GIS & Data Management Conference

  6. Initial Data Collection • Geodatabase & Shapefile templates • Rudimentary Upload/Download Workflow • Simple Summary Statistics • Documentation • Support (Contact Form) 2008 GIS & Data Management Conference

  7. Access to External Data • FMSS • Read-only Direct Access to Oracle DB • SQL Server Integration Services (SSIS) to Replicate Data. (Session 19) • Efficient & Easily Repeatable • LCS • Unable to Obtain Direct Access • Manual Extract/Transform/Load • Generate 3 Reports – Save as Access97 • Load from Access97 into SQL Server • Inefficient & Error-Prone 2008 GIS & Data Management Conference

  8. Creating Park Templates • Model Builder used to: • Query FMSS & LCS extracts • Create schema and relationships • VBScript generated • Command line wrapper • 4-6 hours to create templates for all parks 2008 GIS & Data Management Conference

  9. Download / Upload • Active Directory Organizational Unit • EGIS “OU” • Park Groups used for Access Control • Scripts for creation and management of groups • Read, or Edit (Upload) Access • Folder structure with Access Control Lists (ACLs) containing EGIS Groups 2008 GIS & Data Management Conference

  10. Download / Upload • Active Directory Organizational Unit 2008 GIS & Data Management Conference

  11. Download / Upload • http://egis.nps.gov • EGIS Contacts Table • Simple Table in SQL Server • Doesn’t Support 1:Many User:Park relationships • “Primary” users get Upload access • ‘Data Grabber” Web Page • Integrated Windows Authentication • User selects Park, then Dataset • Uploaded data placed in folder • Email sent to RIMD Staff • All transactions logged 2008 GIS & Data Management Conference

  12. EGIS Contacts Table 2008 GIS & Data Management Conference

  13. Download / Upload Overview 2008 GIS & Data Management Conference

  14. Download / Upload Overview 2008 GIS & Data Management Conference

  15. 2008 GIS & Data Management Conference

  16. NPS System Viewer http://insidemaps.nps.gov/npssystemviewer 2008 GIS & Data Management Conference

  17. Completion Statistics (20080401) 2008 GIS & Data Management Conference

  18. Lessons Learned • Database Model • Highly “Normalized” is good for data integrity, but increases complexity of data development; • Solutions: • Simplify the Model; • Develop Tools for Loading and Validating Data; • Tools would need to be Model-Specific • Generalize the Model and develop tools • ** Reusable Model and Tools ** 2008 GIS & Data Management Conference

  19. Lessons Learned • Database Model • Requests for minor revisions to standard • Polygon_Type, Point_Type • Map_Method • Position_Error • Opportunity to simplify model • Remove Subtypes • Move link fields to Buildings Table • Some re-coding of data required • Implications for data distribution • need to deliver transformed data back to the field 2008 GIS & Data Management Conference

  20. Lessons Learned Data Collection and Distribution • Download / Upload is labor intensive • ** Current process does not support delivery of existing Building Footprints to parks • Current Solution is Not Scalable / Sustainable for Multiple Simultaneous Theme Collection Efforts • Solutions: • Improve Download / Upload Process (Interim) • Use Distributed Geodatabase technology • Leverage Lessons Learned by Dave Best • Collaboration with Army Corps of Engineers 2008 GIS & Data Management Conference

  21. Lessons Learned • Data Display • Basemap Performance • It is not feasible to develop a service-wide basemap with reasonable performance • A commercial-service is required • Currently using ESRI ArcWebServices 2008 GIS & Data Management Conference

  22. Next Steps • Database Standard and Model • Publish comments and responses to proposed standard revision • Final revision to model • Publish on Data Store • Transform Existing Data into New Model 2008 GIS & Data Management Conference

  23. Evolution of the Model 2008 GIS & Data Management Conference

  24. Next Steps • Data Collection / Distribution • Revise Process for Generating GDBs • Generate New GDBs and Shapefiles • Update Documentation • Begin a new Data Collection Cycle 2008 GIS & Data Management Conference

  25. Next Steps • Data Display • Revisions to System Viewer • See Session 24 (Nate Irwin) • ArcGIS 9.3 Services • Microsoft Virtual Earth Basemap 2008 GIS & Data Management Conference

  26. Park Media Future “Generic” Standard 2008 GIS & Data Management Conference

  27. Questions? 2008 GIS & Data Management Conference

More Related