260 likes | 411 Views
Using ProjectWise to support Interagency Performance Evaluation Taskforce (IPET). Harold L. Smith Chief, CADD/GIS Technology Center Retired. IPET Mission.
E N D
Using ProjectWise to support Interagency Performance Evaluation Taskforce (IPET) Harold L. Smith Chief, CADD/GIS Technology Center Retired
IPET Mission • …“to provide credible and objective scientific and engineering answers to fundamental questions about the performance of the hurricane protection and flood damage reduction system in the New Orleans metropolitan area.” - From IPET Report 1 Interagency Performance Evaluation Taskforce (IPET)
IPET Task 1 Scope • Assemble a comprehensive set of data and information about the conditions before and after Hurricane Katrina as well as a complete history of the hurricane protection projects’ construction and maintenance. This collection of data will serve as the repository for information and analytic results developed throughout the Performance Evaluation.
Data Collection • Performance Evaluation requires • Pre-Katrina conditions of the Hurricane Protection System • Events that occurred during Katrina • The effects of Katrina on the system. • Data collected in these three areas forms the basis for the IPET performance evaluation • Perishable data • Background data • New data
Data Requirements • Design Documents • Construction and as-built records • Profile, topographic, and section surveys • Inspection Reports • Field Investigations and Inspections • Public interviews, forums or meetings • Levee design heights • Levee properties • Aerial Photos, Videos • Data and analyses by other agencies, private firms • Time history of surge heights, wind speed/direction, waves • Photos, videos, measurements of erosion near breaches • Wall deflections • Evidence of wall yielding • Pump Station data (locations, elevations, discharge pool locations, optional discharge directions, performance, operators) • Sheet-pile tip elevations (design, as-built, measured) for all I-walls • Pool-to-pool heads during storm • Any other data and observations relevant to IPET
Approach • Task 1 Data Management is being executed by 3 coordinated teams: • Data Assembly and Coordination • Data Storage and Management • Data Synthesis
Team 1: Data Assembly and Coordination • Objective: Identify and acquire the data required to support Tasks 2-10 of this study, as well as data that must be retained for future reference. • Identify data requirements and associated sources • Define metadata standards and naming conventions for all types of data • Acquire data – perishable, survey, elevation, historic, GIS, hydro, timeline, photos, etc. • Standard Process and Staging area for data upload
Team 2: Data Storage and Management • Objective: Define and build the hardware and software framework required to store, organize, manage, and deliver the data associated with this study. • Design Hardware/Software Architecture • Develop architecture • Maintain architecture
Team 3: Data Synthesis • Objective: Develop mechanisms for adapting data to meet the needs of specific applications • Develop pre-storm DEM • Develop post-storm DEM • Adjust vertical datum of pre-storm and post-storm DEMs • Develop surface models based on DEMs
Primary Products • IPET Data Repository is a data management system for storing, delivering, maintaining the authoritative data sets associated with this study. • IPET Public Website
IPET Data Repository • https://erdcpw.erdc.usace.army.mil • access controlled – all IPET members have access • >7,000 documents posted • 3 primary components: • GIS data – leverages the CorpsMap corporate database at USACE CPC • Unstructured data – Microsoft SQL Server database managed by Bentley ProjectWise • Large data sets – terabyte server connected to Oracle SDO database • Bentley ProjectWise – provides the overall metadata management for all 3 data components
Microstation HEC-RAS XMS ArcGIS Web Data Repository Architecture Applications CorpsMap Search By location By project API GIS data Oracle SDO DataNet Large Datasets ArcSDE Content Manager CorpsMap DataEngine ProjectWise Unstructured Data QA/QC by designated POCs & Office of Counsel Staging area Upload client ftp client
ERDC ProjectWise Technical Architecture ProjectWise AdministratorClient ProjectWise Database ProjectWise Application Server ProjectWise ExplorerClient ProjectWise Storage Area ProjectWise Web Explorer LiteClient LTOTape Drive ProjectWise Web Server ProjectWise Data BackupServer
Why ProjectWise? • Leverages existing ProjectWise software from Enterprise License Agreement • ProjectWise was adopted by the USACE National Management Board as the Corps’ virtual engineering tool • Coordination with Navigation and Environmental Sustainability Program (NESP) effort to stand up a standard ProjectWise implementation throughout MVD • New Orleans District had adopted ProjectWise
Why CorpsMap? • Leverages existing corporate GIS database residing on Central Processing server • Configuration allows users to connect via SDE or directly to Oracle SDO • Complies with the Corps Enterprise Architecture
ProjectWise SDE Connector • provides link to SDE layers from within PW • PW administrator creates .dgn files or GIS project files (GeoGraphics) so users can view GIS layers within PW. • Problem with SDE layers having custom MVD projection – SDE Connector couldn’t read it • For IPET Data Repository, we created .shp files, .mxd files, .pdf files stored in PW • Creating geopdf files – users can view GIS layers without GIS software
PW Geospatial tab • Allows all documents to have a geospatial reference. Files can inherit spatial reference from folder or have an individual reference.
Public Web Site • https://ipet.wes.army.mil • Publicly released data • Approximately 5000 individual files • Interim and Final IPET Reports
2006 BE Award of Excellence • Geospatial Managed Environment
Related Projects • South Louisiana Coastal Protection and Restoration • Mississippi Coastal Protection and Restoration • National Levee Database and Re-certification.
Project Lead The CADD/GIS Technology Center https://tsc.wes.army.mil • Denise Martin (601) 634-4574 Voice Denise.B.Martin@erdc.usace.army.mil