Import of German ISYBAU XML 2006 Files using a new tool in the InfoSWMM Exchange Menu

InfoSWMM_medium

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:

  1. Initialize Arc Map for InfoSWMM for a new Project (Figure 5).
  2. In the new project use either Gauss-Kruger Zone 3 or Zone 4 for the Spatial coordinates of the Map (Figure 6).
  3. Click through the Arc Map Next commands to see the initial InfoSWMM DB Spatial Reference (Figure 7).
  4. Import the ISBYBAU XML data using the new Exchange Tool for ISYBAU which is part of the InfoSWMM Exchange Menu (Figure 8).
  5. Choose a Hydraulics layer XML file to Import (Figure 9).
  6. 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).
  7. You will see the Imported Node and Link data on top of the DWG file from the XML file (Figure 11).
  8. It is also possible to use Excel to see each of the XML sections in Excel as a XML Table (Figure 12).
  9. 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).
Figure 1 Import ISYBAU Tool in InfoSWMM Exchange or Austasch.

Figure 1 Import ISYBAU Tool in InfoSWMM Exchange or Austasch.

Figure 2 Tags für Datenkollektive in the ISYBAU 2006 XML file.

Figure 2 Tags für Datenkollektive in the ISYBAU 2006 XML file.

Figure 3 Sections in the ISYBAU 2006 XML file.

Figure 3 Sections in the ISYBAU 2006 XML file.

Figure 4 If you set the regional language settings to German in InfoSWMM you will have multi language dialogs.

Figure 4 If you set the regional language settings to German in InfoSWMM you will have multi language dialogs.

Figure 5 Initialize Arc Map for InfoSWMM for a new Project.

Figure 5 Initialize Arc Map for InfoSWMM for a new Project.

Figure 6 Use Gauss-Kruger Zone 3 or Zone 4 for the Map.

Figure 6 Use Gauss-Kruger Zone 3 or Zone 4 for the Map.

Figure 7 The initial InfoSWMM DB Spatial Reference.

Figure 7 The initial InfoSWMM DB Spatial Reference.

Figure 8 The new Exchange Tool for ISYBAU is part of the InfoSWMM Exchange Menu.

Figure 8 The new Exchange Tool for ISYBAU is part of the InfoSWMM Exchange Menu.

Figure 9 Choose a Hydraulics layer XML file to Import.

Figure 9 Choose a Hydraulics layer XML file to Import.

Figure 10 You can also import the DXF or DWG file from the Ground Plan Section using the Add Data tool into ArcMap.

Figure 10 You can also import the DXF or DWG file from the Ground Plan Section using the Add Data tool into ArcMap.

Figure 11 Imported Node and Link data on top of the DWG file from the XML file.

Figure 11 Imported Node and Link data on top of the DWG file from the XML file.

Figure 12 You can also view each of the XML sections in Excel as a XML Table.

Figure 12 You can also view each of the XML sections in Excel as a XML Table.

Figure 13 The field Mapping Alias DB Table of InfoSWMM allows the user to customize the Rows in the Attribute Table.

Figure 13 The field Mapping Alias DB Table of InfoSWMM allows the user to customize the Rows in the Attribute Table.

 

 

Share this post!

    About Robert Dickinson

    Robert Dickinson is a Product Sector Leader with Innovyze in the USA for InfoSewer, InfoSWMM and H2OMAP SWMM. He has over 42+ years experience in modeling the key hydrologic, water quality and hydraulic processes involved in urban and surburban drainage design and analysis. He has been very lucky to work with many talented engineers and scientists in his professional life at the University of Florida, XP Software, CDMSmith, the US EPA and at Innovyze Inc which allows him to offer worldwide support, training and sales/adaptation help for the Innovyze Products InfoSWMM, InfoSewer, InfoSWMM 2D, H20Map SWMM, SWMMLive and SWMM features in ICM and ICM SE.
    Short Time History:
    Product Sector Leader with @Innovyze for InfoSWMM / InfoSewer, 46+ years w/ SWMM3/4/5 11+ Years w/ @Innovyze! 8+ years @CDMSmith 9 years w/ XPSWMM 17 years @UF
    Very long bio –
    https://www.linkedin.com/pulse/my-history-various-versions-swmm-swmm3-swmm4-swmm5-robert-dickinson?trk=prof-post

    This entry was posted in InfoSWMM and tagged . Bookmark the permalink.