Globally, aging water and wastewater infrastructure is rapidly deteriorating and sometimes failing, with potentially dire human, environmental and financial consequences. A vital background to investigating and understanding the infrastructure is having inspection data and images, the infrastructure history and the hydraulic characteristics of the infrastructure. A key format in Germany and Europe is the ISYBAU 2006 XML format. ISYBAU is an acronym based on the words “Integriertes DV-System-Bauwesen” or “Integrated IT System-Building”. ISYBAU was a collaboration of German federal and state governments, the late 1980s and early 1990s to help document and understand the wastewater infrastructure. This blog describes a new InfoSWMM Exchange tool (Figure 1) to import the ISYBAU hydraulic data which is one of the eight Tags für Datenkollektive or layers in the ISYBAU XML file (Figure 2 and Figure 3). The XML file can be also be read with Excel and has tags and hot links to both DWG/DXF files and inspection images.
InfoSWMM allows you to use the Windows Regional Settings for either German, Spanish, French or Italian (Figure 4). The dialogs, attribute browser and InfoSWMM menus will be in the selected language. This is not necessary for the import but allows the XML data imported from ISBYBAU to be better understood in the InfoSWMM Interface.
The steps to import the ISYBAU 2006 XML data to InfoSWMM include:
- Initialize Arc Map for InfoSWMM for a new Project (Figure 5).
- In the new project use either Gauss-Kruger Zone 3 or Zone 4 for the Spatial coordinates of the Map (Figure 6).
- Click through the Arc Map Next commands to see the initial InfoSWMM DB Spatial Reference (Figure 7).
- Import the ISBYBAU XML data using the new Exchange Tool for ISYBAU which is part of the InfoSWMM Exchange Menu (Figure 8).
- Choose a Hydraulics layer XML file to Import (Figure 9).
- Optionally, the background DXF or DWG file from the Ground Plan Section using the Add Data tool into ArcMap can also be imported (Figure 10).
- You will see the Imported Node and Link data on top of the DWG file from the XML file (Figure 11).
- It is also possible to use Excel to see each of the XML sections in Excel as a XML Table (Figure 12).
- In addition, the field Mapping Alias DB Table of InfoSWMM allows the user to customize the Rows in the Attribute Table for the selected language (Figure 13).