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.
ExistingCode | ExistingLULCDescription | ReclassifiedCode | ReclassifiedLULCDescription | |
|---|---|---|---|---|
1 | Open Water | 11 | Open Water |
|
21 | Developed, Open Space | 21 | Developed, Open Space | |
22 | Developed, Low Intensity | 22 | Developed, Low Intensity | |
4 | Developed, Medium Intensity | 23 | Developed, Medium Intensity | |
5 | Developed, High Intensity | 24 | Developed, High Intensity | |
6 | Barren Land | 31 | Barren Land |
|
7 | Deciduous Forest | 41 | Deciduous Forest |
|
8 | Evergreen Forest | 42 | Evergreen Forest |
|
9 | Mixed Forest | 43 | Mixed Forest |
|
10 | Shrub/Scrub | 52 | Shrub/Scrub |
|
11 | Herbaceous | 71 | Herbaceous |
|
12 | Hay/Pasture | 81 | Hay/Pasture |
|
13 | Cultivated Crops | 82 | Cultivated Crops |
|
14 | Woody Wetlands | 90 | Woody Wetlands |
|
15 | Emergent Herbaceous Wetlands | 95 | Emergent Herbaceous Wetlands | |
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.
Code | LULCDescription | NImperviousValue | NPerviousValue | |
|---|---|---|---|---|
21 | Developed, Open Space | 0.13 | 0.065 |
|
22 | Developed, Low Intensity | 0.14 | 0.07 |
|
23 | Developed, Medium Intensity | 0.15 | 0.075 |
|
24 | Developed, High Intensity | 0.16 | 0.08 |
|
31 | Barren Land | 0.17 | 0.085 |
|
41 | Deciduous Forest | 0.18 | 0.09 |
|
43 | Mixed Forest | 0.2 | 0.1 |
|
71 | Herbaceous | 0.22 | 0.11 |
|
81 | Hay/Pasture | 0.23 | 0.115 |
|
90 | Woody Wetlands | 0.25 | 0.125 |
|
95 | Emergent Herbaceous Wetlands | 0.26 | 0.13 |
|
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.
Code | LULCDescription | DImperviousValue | DPerviousValue | |
|---|---|---|---|---|
11 | Open Water | 0.15 | 0.0075 |
|
21 | Developed, Open Space | 0.16 | 0.008 |
|
22 | Developed, Low Intensity | 0.17 | 0.0085 |
|
23 | Developed, Medium Intensity | 0.18 | 0.009 |
|
24 | Developed, High Intensity | 0.19 | 0.0095 |
|
31 | Barren Land | 0.2 | 0.01 |
|
41 | Deciduous Forest | 0.21 | 0.0105 |
|
42 | Evergreen Forest | 0.22 | 0.011 |
|
43 | Mixed Forest | 0.23 | 0.0115 |
|
52 | Shrub/Scrub | 0.24 | 0.012 |
|
71 | Herbaceous | 0.25 | 0.0125 |
|
81 | Hay/Pasture | 0.26 | 0.013 |
|
82 | Cultivated Crops | 0.27 | 0.0135 |
|
90 | Woody Wetlands | 0.28 | 0.014 |
|
95 | Emergent Herbaceous Wetlands | 0.29 | 0.0145 |
|
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.
LULCType | NValue |
|---|---|
Developed, Open Space | 0.11 |
Developed, Low Intensity | 0.1 |
Barren Land | 0.09 |
Deciduous Forest | 0.15 |
Mixed Forest | 0.17 |
Woody Wetlands | 0.18 |
Herbaceous | 0.19 |
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.
LULCType | DValue |
|---|---|
Impervious surfaces | 0.25-0.27 |
Lawns | 0.28-0.29 |
Pastures | 0.24 |
Forest Litres | 0.21 |
Wooded Areas | 0.31 |
Open Field | 0.33 |
Large Paved Area | 0.36 |
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.
Open | CONCRETE | 0.015 |
|---|---|---|
Open | RIPRAP | 0.011 |
Closed | C. ALUM | 0.014 |
Closed | CMP | 0.012 |
Closed | BRICK | 0.013 |
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.
Date (M/D/Y) | Time (H:M) | Value |
|---|---|---|
4/13/2015 | 0:05 | 1.14 |
4/13/2015 | 0:10 | 1.33 |
4/13/2015 | 0:15 | 2.23 |
4/13/2015 | 0:20 | 2.84 |
4/13/2015 | 0:25 | 5.49 |
4/13/2015 | 0:30 | 9.95 |
4/13/2015 | 0:35 | 4.12 |
4/13/2015 | 0:40 | 2.48 |
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.
;;PROJCS["NAD_1983_StatePlane_Virginia_North_FIPS_4501_Feet",GEOGCS["GCS_North_American_1983",DAT UM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting ",11482916.66666666],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",- 78.5],PARAMETER["Standard_Parallel_1",38.03333333333333],PARAMETER["Standard_Parallel_2",39.2],PARA METER["Latitude_Of_Origin",37.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2283]]
[TITLE] GeoSWMM Quick Start Manual Utilian November 2023
[OPTIONS] FLOW_UNITS CFS INFILTRATION GREEN_AMPT FLOW_ROUTING KINWAVE LINK_OFFSETS DEPTH MIN_SLOPE 0 ALLOW_PONDING NO SKIP_STEADY_STATE NO
START_DATE 09/29/2021 |
START_TIME 00:00:00 REPORT_START_DATE 09/29/2021 REPORT_START_TIME 00:00:00 END_DATE 09/29/2021 END_TIME 12:00:00 SWEEP_START 01/01 SWEEP_END 12/31 DRY_DAYS 0 REPORT_STEP 0:15:00 WET_STEP 0:05:00 DRY_STEP 1:00:00 ROUTING_STEP 00:01:00 RULE_STEP 00:00:00
INERTIAL_DAMPING PARTIAL NORMAL_FLOW_LIMITED BOTH FORCE_MAIN_EQUATION H-W SURCHARGE_METHOD EXTRAN VARIABLE_STEP 0.75 LENGTHENING_STEP 0 MIN_SURFAREA 12.557 MAX_TRIALS 8 HEAD_TOLERANCE 0.005 SYS_FLOW_TOL 5 |
LAT_FLOW_TOL 5 MINIMUM_STEP 0.5 THREADS 1 TEMPDIR C:\Users\GeoSWMM\AppData\Local\Temp\arcF628\
[EVAPORATION] ;;Type Parameters ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CONSTANT 0 DRY_ONLY NO
[RAINGAGES] ;;Name Rain Type Time Intrvl Snow Catch Data Source TimeSeriesName ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- RG-1 INTENSITY 1:00 1 TIMESERIES TS-1
[SUBCATCHMENTS] ;;Name Raingage Outlet Total Area Pcnt. Imperv Width Pcnt. Slope Curb Length Snow Pack ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- S-3 RG-1 J-5 3.31 38.3 827.05 2.2 0 |
S-2 RG-1 J-4 4.03 46.1 601.38 3.13 0 S-1 RG-1 J-1 4.18 47.25 1498.47 1.43 0
[SUBAREAS] ;;Subcatchment N-Imperv N-Perv S-Imperv S-Perv PctZero RouteTo PctRouted ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- S-3 0.013 0.015 0.1 0.1 25 OUTLET S-2 0.013 0.015 0.1 0.1 25 OUTLET S-1 0.013 0.015 0.1 0.1 25 OUTLET
[INFILTRATION] ;;Subcatchment Param1 Param2 Param3 Param4 Param5 ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- S-3 2 1 0.2 1 0 HORTON S-2 2 1 0.2 1 0 HORTON S-1 2 1 0.2 1 0 HORTON
[JUNCTIONS] |
;;Name Invert Elev. Max. Depth Init. Depth Surcharge Depth Ponded Area ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- J-1 480.48 0 0 0 0 J-2 494.43 0 0 0 0 J-5 526.29 0 0 0 0 J-3 501.83 0 0 0 0 J-4 537.64 0 0 0 0
[OUTFALLS] ;;Name Elevation Type Stage Data Gated Route To ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- O-1 470.57 FREE NO
[CONDUITS] ;;Name Inlet Node Outlet Node Length Manning N Inlet Offset Outlet Offset Init. Flow Max. Flow ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- C-2 J-2 J-1 481.79600523 0.013 0 0 0 0 C-3 J-3 J-2 190.779553763 0.012 0 0 0 0 |
C-1 J-1 O-1 154.469563992 0.012 0 0 0 0 C-5 J-5 J-3 86.2707264297 0.012 0 0 0 0 C-4 J-4 J-3 87.4828170322 0.012 0 0 0 0
[XSECTIONS] ;;Name Shape Geom1 Geom2 Geom3 Geom4 Barrels Culvert ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- C-2 CIRCULAR 1.5 0 0 0 1 C-3 CIRCULAR 1.5 0 0 0 1 C-1 CIRCULAR 1.5 0 0 0 1 C-5 CIRCULAR 1 0 0 0 1 C-4 CIRCULAR 1 0 0 0 1
[LOSSES] ;;Link Inlet Outlet Average FlapGate Seepage ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- C-2 0 0 0 NO 0 |
C-3 0 0 0 NO 0 C-1 0 0 0 NO 0 C-5 0 0 0 NO 0 C-4 0 0 0 NO 0
[POLLUTANTS] ;;Name Mass Units Rain Concen. GW Concen. I&I Concen. Decay Coeff. Snow Only Co-Pollut.Name Co-Pollut.Fraction DWF Concen. Cinit ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TSS mg/L 5 2 0 0.1 NO * 0 0 0
[LANDUSES] ;;Name Cleaning Interval Fraction Available Last Cleaned ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Residential 0 0 0 Undeveloped 0 0 0
[BUILDUP] ;;LandUse Pollutant Function Coeff1 Coeff2 Coeff3 Normalizer |
;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Residential TSS POW 50 1 1 AREA Undeveloped TSS POW 25 0.5 0.5 AREA
[WASHOFF] ;;LandUse Pollutant Function Coeff1 Coeff2 Cleaning Effic. BMP Effic. ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Residential TSS EMC 100 0 0 0 Undeveloped TSS EMC 50 0 0 0
[TIMESERIES] ;;Name Date Time Value ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TS-1 0 0 TS-1 1 0.5 TS-1 2 1 TS-1 3 0.8 TS-1 4 0.5 TS-1 5 0.3 TS-1 6 0 |
[REPORT] SUBCATCHMENTS ALL NODES ALL LINKS ALL
[COORDINATES] ;;Node X-Coord Y-Coord ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- J-1 1107973.76138559 13149258.8175074 J-2 1108395.968537 13149028.1626812 J-5 1108436.22119023 13148833.6650078 J-3 1108359.76525417 13148873.6290926 J-4 1108309.44442512 13148802.0675286 O-1 1107836.70161803 13149330.0598145
[VERTICES] ;;Link X-Coord Y-Coord ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- C-2 1108382.50134073 13149034.7970242 C-2 1108314.04169632 13149079.8542749 C-2 1108149.65628093 13149160.8351225 |
C-2 1108059.66996662 13149216.4967646 C-3 1108428.34236477 13149012.3595422
[Polygons] ;;Subcatchment X-Coord Y-Coord ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- S-3 1108487.27390119 13148614.8915934 S-3 1108496.1781276 13148640.694391 S-3 1108395.89551099 13148697.7106177 S-3 1108395.33174811 13148781.0305994 S-3 1108368.00104967 13148802.1083328 S-3 1108367.84044605 13148817.2376797 S-3 1108363.29428576 13148823.2843363 S-3 1108367.78657016 13148832.4033072 S-3 1108358.66759868 13148836.8955914 S-3 1108387.45760608 13148876.7156573 S-3 1108447.3042206 13148888.8231309 S-3 1108478.28916965 13148931.6783458 S-3 1108547.2099607 13148907.5989278 S-3 1108589.65619749 13148983.7402793 S-3 1108825.64286783 13148861.9070835 S-3 1108820.47303037 13148819.2539981 S-3 1108737.60857438 13148622.0726716 |
S-3 1108921.69265683 13148519.5332707 S-3 1108881.52235259 13148460.1170327 S-3 1108749.18785869 13148514.4098312 S-3 1108705.55493121 13148456.5808485 S-3 1108649.11101773 13148495.2867392 S-3 1108677.2600926 13148575.2075622 S-3 1108602.97149065 13148608.2154664 S-3 1108567.04953049 13148627.7164812 S-3 1108520.3950627 13148609.8479086 S-3 1108487.27390119 13148614.8915934 S-2 1108024.89462873 13148389.393836 S-2 1108028.31959927 13148405.7421672 S-2 1108025.6929172 13148427.62513 S-2 1108035.96872178 13148476.6697043 S-2 1108038.76655 13148523.1726538 S-2 1108059.09340906 13148583.2257535 S-2 1108055.39942153 13148612.3381573 S-2 1108049.51864351 13148658.6825875 S-2 1108080.51641218 13148741.7282289 S-2 1108166.62302907 13148709.490562 S-2 1108244.88176507 13148858.9538881 S-2 1108306.48956814 13148834.0536769 S-2 1108343.68411087 13148883.3504065 S-2 1108353.52200316 13148850.3304623 |
S-2 1108358.66759868 13148836.8955914 S-2 1108354.1753151 13148827.7766201 S-2 1108363.29428576 13148823.2843363 S-2 1108367.84044605 13148817.2376797 S-2 1108368.00104967 13148802.1083328 S-2 1108395.33174811 13148781.0305994 S-2 1108395.89551099 13148697.7106177 S-2 1108496.1781276 13148640.694391 S-2 1108487.27390119 13148614.8915934 S-2 1108316.56650443 13148268.3710764 S-2 1108234.49589105 13148308.8017218 S-2 1108225.5113439 13148290.5638724 S-2 1108024.89462873 13148389.393836 S-1 1108358.66759868 13148836.8955914 S-1 1108367.78657016 13148832.4033072 S-1 1108363.29428576 13148823.2843363 S-1 1108354.1753151 13148827.7766201 S-1 1108358.66759868 13148836.8955914 S-1 1108358.66759868 13148836.8955914 S-1 1108353.52200316 13148850.3304623 S-1 1108343.68411087 13148883.3504065 S-1 1108306.48956814 13148834.0536769 S-1 1108244.88176507 13148858.9538881 S-1 1108253.86631352 13148877.1918366 |
S-1 1108080.60542168 13148962.5450564 S-1 1108035.68269949 13148871.3549761 S-1 1107990.08752517 13148893.8163915 S-1 1107971.84957246 13148902.8008931 S-1 1108048.21802381 13149057.8239124 S-1 1107874.95684034 13149143.1767858 S-1 1107906.32212101 13149214.5746933 S-1 1107860.75325899 13149244.6367881 S-1 1107865.08495761 13149268.885462 S-1 1107846.89881197 13149293.0715654 S-1 1107846.65799518 13149315.765699 S-1 1107857.82576981 13149327.5808038 S-1 1107884.03241114 13149346.1048212 S-1 1107916.31443197 13149345.2186923 S-1 1107941.36686821 13149330.9655431 S-1 1107949.05408749 13149303.3475946 S-1 1107985.88942273 13149287.8520576 S-1 1108021.29457119 13149267.7092067 S-1 1108068.22859547 13149247.9652332 S-1 1108199.31812948 13149173.3841662 S-1 1108215.64244395 13149190.654622 S-1 1108248.25725381 13149246.9006895 S-1 1108465.38235176 13149131.297573 S-1 1108455.09127177 13149054.4490886 |
S-1 1108589.65619749 13148983.7402793 S-1 1108547.2099607 13148907.5989278 S-1 1108478.28916965 13148931.6783458 S-1 1108447.3042206 13148888.8231309 S-1 1108387.45760608 13148876.7156573 S-1 1108358.66759868 13148836.8955914
[SYMBOLS] ;;Gage X-Coord Y-Coord ;;---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- RG-1 1107728.55059908 13148596.5065974 |
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:
Date (M/D/Y) | Time (H:M) | Value |
|---|---|---|
10/11/2020 | 8:00 | 5.6 |
10/11/2020 | 12:00 | 16.5 |
10/11/2020 | 16:00 | 6.0 |
10/11/2020 | 20:00 | 3.4 |
10/11/2020 | 24:00 | 2.6 |
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.