Appendix E - Special File Formats Generated by GeoSWMM

E.1 Land Use Reclassification Template (Land Use/ Land Cover Properties Tool)

The CSV / Excel files that are read or used for land use reclassification by the Land Use/Land Cover Properties Tool has the following data formats. 

The first data column in the file shows the source land cover code values. 

The second data column in the file shows the user assigned description for each source land cover value. 

The third data column in the file shows the reclassified (user assigned) land cover code values. 

The fourth data column in the file shows the user assigned description for each reclassified land cover value. 

E.2 Land Use Properties Table (Land Use/Land Cover Properties Tool)

The CSV / Excel files that are read or used in the estimation of the land use roughness and depression storage by the Land Use/Land CoverProperties Tool has the following data formats. 

The first data column in the file shows the reclassified land cover code values. 

The second data column in the file shows the user assigned description for each reclassified land cover value. 

The third data column in the file shows the property values for each reclassified land cover. This property shows N-Impervious and fourth data column shows N-Pervious values. 

The CSV / Excel files that are read or used in the estimation of the land use depression storage by the Land Use/Land Cover Properties Tool has the following data formats. 

The first data column in the file shows the reclassified land cover code values. 

The second data column in the file shows the user assigned description for each reclassified land cover value. 

The third data column in the file shows the property values for each reclassified land cover. This property shows D-Impervious and fourth data column shows N-Pervious values. 

E.3 User Defined Reference Table (Land Use/Land Cover Properties Tool)

The CSV / Excel files that are used as user defined reference table for assigning roughness value  by the Land Use/Land CoverProperties Tool has the following data formats. 

The CSV / Excel files that are used as user defined reference table for assigning depression storage value   by the Land Use/Land CoverProperties Tool has the following data formats. 

E.4 Conduit Roughness Table (Conduit Roughness Tool)

The text files that are read or used in assigning conduit roughness by the Conduit Roughness Tool has the following data formats. 

The first data column in the file shows the type of conduit cross section whether its open channel or closed structure. 

The second data column in the file shows the conduit material. 

The third data column in the file shows the user assigned roughness value for each conduit material. 

E.5 Time Series Import File

The text files that are used for time series data import in the Time Series Editor have the following data formats. 

The first data column in the file shows date in mm/dd/yyyy format. 

The second data column in the file shows the time in hh:mm or decimal hours format. 

The third data column in the file shows the time series values in the project unit. 

E.6 EPA-SWMM 5.1 Input File

The following text file shows a sample input file for EPA-SWMM 5.1 generated from a GeoSWMM project. 

E.7 Calibration Data Table

The text files used for importing calibration time-series data into the Calibration Data Manager must follow the format shown below: 

Note:  

• The first column specifies the date in MM/DD/YYYY format. 
• The second column specifies the time in HH:MM (24-hour) or decimal hours format. 
• The third column contains the observed values in the project’s unit system.