#INFOSEWER

Explanation of The DBF Files in the IEDB Folder of InfoSewer

The list comprises various CSV files that store different types of data. The ALINK.csv, CBLINK.csv, DMLINK.csv, HLLINK.csv, LINK.csv, LKHLINKS.csv, MOLINK.csv, NDHLINKS.csv, and XNGLINK.csv files contain information about specific types of link elements.

The ANNO.csv and ANNODATA.csv files contain annotation data, while the ANODE.csv, CBNODE.csv, DMNODE.csv, HLNODE.csv, MONODE.csv, NODE.csv, MAPSSND.csv, and XNGNODE.csv files contain details about specific types of node elements.

CHAMBOUT.csv file relates to chamber output, CONTOUR.csv to contour data, and CONTROL.csv and CTRDATA.csv to control data. COSTING.csv contains costing information, CURVE.csv has curve data, and CUVDATA.csv contains culvert-related data.

DISCGHGL.csv file stores discharge GHGL information, FDMDATA.csv has FDM data, FDSDATA.csv has FDS data, and FLDMAP.csv holds FLD map data. FORCEOUT.csv is for force output data, FOXUSER.csv holds user data, and GISFDATA.csv and GISGATE.csv contain GISF and GIS gate data respectively.

HYDROGRH.csv holds hydrographic data, LUCOEFF.csv has LUC coefficients, MANCOVER.csv and MANHOLE.csv contain manhole cover and manhole data respectively. MAPSSLK.csv holds MAPSS link data, MHHYD.csv, MHOFFSET.csv, MHOUT.csv, and MHSHP.csv have MH hydraulic, offset, output, and shape data respectively.

NAMEVIEW.csv is for name view data, NCPIDGN.csv and NCPIXSEC.csv hold NCP IDGN and NCP IXSEC data, and NDSOURCE.csv has ND source data. OPERSET.csv contains operator settings, OUTLEOUT.csv stores outlet output data, PATNDATA.csv and PATTERN.csv files have pattern data and information.

PIPE.csv, PIPECNST.csv, PIPEDGN.csv, PIPEHYD.csv, PIPEII.csv, PIPEOUT.csv, PIPESHP.csv, PIPESPLT.csv, and PIPEWQ.csv files contain data regarding a specific type of pipe element, construction, design, hydraulic, II data, output, shape, split, and water quality data respectively. PISPTSET.csv contains PI/SP/TSET data, POLYREG.csv has polygon regression data, PUMP.csv, PUMPHYD.csv, PUMPOUT.csv, and PUMPSET.csv store pump data, hydraulic, output, and settings respectively.

QRYSET.csv, QSETDATA.csv, QSSSLK.csv, QSSSND.csv, and QUERY.csv contain query settings, set data, QSSS link data, QSSS node data, and query data respectively. RELATE.csv holds data about element relationships, REPORT.csv and RPTDATA.csv contain report data, RUNOPT.csv has run options, and SCENARIO.csv holds scenario data.

SELSET.csv contains selection set data, STATUS.csv has status data, TIME.csv contains time settings, and VERTEX.csv holds vertex data. WWELL.csv, WWELLHYD.csv, WWELLOUT.csv, and WWELLSET.csv contain well data, hydraulic, output, and settings respectively. XLOAD.csv and XLOADSET.csv hold external load data and settings.

Note the DBF files or converted CSV files -  ALINK.csv CBNode.csv ANODE.csv CBLINK.csv InfoSewer Files in the IEDB folder have only 2 Columns, ID and Type. Alink and Anode are active Elements.

Column Label Description
ID A unique identifier for a specific record or row in the file. This could be a sequential number, a randomly generated code, or any other system for identifying individual entries in the file. InfoSewer Element ID.
Type A categorical variable that assigns a type or category to each record in the file. This could be used to group similar items together, classify data based on a certain criterion, or any other use case where data needs to be organized by type. Domain or Active

InfoSewer PIPEHYD.DBF File in the IEDB Folder

Field Value
ID 53
FROM_INV 292.5
TO_INV 291
LENGTH 624
DIAMETER 12
COEFF 0.014
PARALLEL 0

InfoSewer PATTERN.DBF File in the IEDB Folder

Field Value
ID 1
DESCRIPT
TYPE
FLOW New Pattern
UNITHYDROGRAPH
BYTIME
RUNOFF_PATTERN NEW STORM RUNOFF PATTERN

InfoSewer PATNDATA.DBF File in the IEDB Folder

Field Value
ID 1
SEQ 0
FACTOR 0.1

 InfoSewer NODE.DBF File in the IEDB Folder

Field Value
ID 44
SELECTED 0
SYMBOL
SYMSIZE
HANDLE 829.3470717
ANNOHNDL 1278.33278
X
Y
Z 0
INACTIVE 0
DOMAIN
QRYSET
COLOR

InfoSewer MHHYD.DBF File in the IEDB Folder

Field Value
ID 44
DIAMETER 4
RIM_ELEV 278
HEADLOSS 0.4
LOAD1 1.25
TYPE1 1
PATTERN1 1
COVERAGE1
LOAD2 0
TYPE2
PATTERN2
COVERAGE2
LOAD3 0
TYPE3
PATTERN3
COVERAGE3
LOAD4 0
TYPE4
PATTERN4
COVERAGE4
LOAD5 0
TYPE5
PATTERN5
COVERAGE5
LOAD6 0
TYPE6
PATTERN6
COVERAGE6
LOAD7 0
TYPE7
PATTERN7
COVERAGE7
LOAD8 0
TYPE8
PATTERN8
COVERAGE8
LOAD9 0
TYPE9
PATTERN9
COVERAGE9
LOAD10 0
TYPE10
PATTERN10
COVERAGE10
SWS_AREA
SWS_RUNOFF
SWS_SLOPE
SWS_LEN
HYETOGRAPH MYRAINFALL
HYDROGRAPH MYRTK_UH
SWS_PERIMP
SWS_PERV
SWS_IMPERV
SWS_INFIL1
SWS_INFIL2
SWS_DECAY
SWS_REGEN
SWS_TOC

InfoSewer MANHOLE.DBF File in the IEDB Folder - Information Tables

Field Value
ID 44
DESCRIPT
TYPE
ELEVATION
YR_INST
YR_RETIRE
ZONE
PHASE

InfoSewer LINK.DBF File in the IEDB Folder

Field Value
ID 53
FROM 52
TO 54
CAL_LENGTH
SELECTED 0
SYMBOL
SYMSIZE
HANDLE 0
SYMHANDLE 0
ANNOHNDL 0
INACTIVE
DOMAIN 0
QRYSET 0
COLOR

 InfoSewer PIPE.DBF File in the IEDB Folder - Pipe Information Table

Field Value
ID 10-1.1
DESCRIPT
TYPE
YR_INST
YR_RETIRE
ZONE
PHASE
MATERIAL VCP
LINING
COST_ID
NOTE

InfoSewer HYDROGRH.DBF File in the IEDB Folder

Field Value
ID UNITHYDROGRAPH
DESCRIPT USER DEFINED UNIT HYDROGRAPH
TYPE 0
AREA 70
PATTERN UNITHYDROGRAPH
RFVOL_EFF 30
RFVOL1 20
RFVOL2 40
PEAKTM1 2
PEAKTM2 8
PEAKTM3 24
RECESS1 2
RECESS2 3
RECESS3 2
NRCS_LAGTM
NRCS_HYDLN 5000
NRCS_CUVNO 75
NRCS_SLOPE 0.01
WS_LEN 5000
WS_CENTRO 2500
WS_SLOPE 0.01
WS_PERIMP 75

  InfoSewer PIPEII.DBF File in the IEDB Folder

Field Value
ID Element
TYPE Type of II
FACTOR
COUNT
PATTERN

 InfoSewer PUMP.DBF File in the IEDB Folder

Field Value
ID P51
DESCRIPT New Pump
YR_INST
YR_RETIRE
ZONE
PHASE
RATED_PWR
COST_ID

 InfoSewer PUMPHYD.DBF File in the IEDB Folder

Field Value
ID P51
TYPE 2
PARALLEL 0
CAPACITY 1.5
SHUT_HEAD 400
DSGN_HEAD 300
DSGN_FLOW 1
HIGH_HEAD 50
HIGH_FLOW 2

 InfoSewer Control.DBF File in the IEDB Folder

Parameter Value Description
ID Identifier for the object/element
METHOD Control method or rule applied
ON Condition for activating the control
OFF Condition for deactivating the control
STA_FLOW Starting flow rate for the control
BASE_FLOW Base flow rate without control
PATTERN Flow pattern or profile
MIN_SPEED Minimum allowed speed for flow control
MAX_SPEED Maximum allowed speed for flow control

 InfoSewer DISCGHGL.DBF File in the IEDB Folder

Column Heading Description Example
ID An identification number or code for the data. 001
LEVEL A level or category associated with the data. High

 InfoSewer WWELLHYD.DBF File in the IEDB Folder

Column Heading Description Example
ID An identification number or code for the data. WW48
TYPE The type or category of the structure. 0
BTM_ELEV The elevation of the bottom of the structure. 266
HEADLOSS The head loss through the structure. 0.6
MIN_LEVEL The minimum water level allowed in the structure. 3
MAX_LEVEL The maximum water level allowed in the structure. 18
INIT_LEVEL The initial water level in the structure. 6
DIAMETER The diameter of the structure. 12
CURVE The name or label of the rating curve is associated with the structure. A vs. H

 InfoSewer WWELL.DBF File in the IEDB Folder - Information Tables

Column Heading Description Example
ID An identification number or code for the data. 001
DESCRIPT The name or label of the item or asset. Pump Station A
YR_INST The year the item or asset was installed. 1998
YR_RETIRE The year the item or asset was retired or decommissioned. 2022
ZONE The zone or location of the item or asset. Zone 3
PHASE The phase or stage of the item or asset's life cycle. Operational
COST_ID The identification number or code of the cost associated with the item or asset. 002

 InfoSewer SCENARIO.DBF File in the IEDB Folder

column Heading Description Example
ID An identification number or code for the data. 001
DESCRIPT The name or label of the item or feature. Pump Station 1
PARENT The parent or higher-level object to which the item or feature belongs. Water Distribution System
FAC_TYPE The type or category of the item or feature. Pump Station
QUERY_SET A set of queries or search criteria associated with the item or feature. All Pumps
USE_TIME A flag indicating whether time-based data is used or not. Yes
TIME_SET A set of time parameters associated with the item or feature. 24 Hour Period
USE_REPORT A flag indicating whether reports are generated or not. No
REPORT_SET A set of report parameters associated with the item or feature. None
USE_OPTION A flag indicating whether user options are available or not. Yes
OPTION_SET A set of user options associated with the item or feature. Pump Speed Control
MH_SET A set of manhole parameters associated with the item or feature. None
WELL_SET A set of well parameters associated with the item or feature. None
PIPE_SET A set of pipe parameters associated with the item or feature. 10-Inch Pipe
PUMP_SET A set of pump parameters associated with the item or feature. Pump 1
XLOAD_SET A set of external load parameters associated with the item or feature. None
PIDGN_SET A set of pipe design parameters associated with the item or feature. None
PISLT_SET A set of pipe installation parameters associated with the item or feature. None
CTRL_SET A set of control parameters associated with the item or feature. Pump Start/Stop
OPER_SET A set of operational parameters associated with the item or feature. None
PIII_SET A set of pipe inspection parameters associated with the item or feature. None

All DBF Files

FILENAME DESCRIPTION
ALINK.csv File containing information about active link elements
ANNO.csv File containing annotation data
ANNODATA.csv File containing additional annotation data
ANODE.csv File containing information about active node elements
CBLINK.csv File containing information about a specific type of link element
CBNODE.csv File containing information about a specific type of node element
CHAMBOUT.csv File containing data related to chamber output
CONTOUR.csv File containing contour data
CONTROL.csv File containing control data
COSTING.csv File containing costing information
CTRDATA.csv File containing control data
CTRLSET.csv File containing control settings
CURVE.csv File containing curve data
CUVDATA.csv File containing data related to culverts
DISCGHGL.csv File containing information about discharge GHGLs
DMLINK.csv File containing information about a specific type of link element
DMNODE.csv File containing information about a specific type of node element
FDMDATA.csv File containing FDM data
FDSDATA.csv File containing FDS data
FLDMAP.csv File containing FLD map data
FLDSET.csv File containing FLD settings
FORCEOUT.csv File containing force output data
FOXUSER.csv File containing user data
GISFDATA.csv File containing GISF data
GISGATE.csv File containing GIS gate data
HLLINK.csv File containing information about a specific type of link element
HLNODE.csv File containing information about a specific type of node element
HYDROGRH.csv File containing hydrographic data
LINK.csv File containing information about a specific type of link element
LINK.DBF.csv File containing information about a specific type of link element
LKHLINKS.csv File containing LKH links data
LUCOEFF.csv File containing LUC coefficients
MANCOVER.csv File containing manhole cover data
MANHOLE.csv File containing manhole data
MAPSSLK.csv File containing MAPSS link data
MAPSSND.csv File containing MAPSS node data
MHHYD.csv File containing MH hydraulic data
MHOFFSET.csv File containing MH offset data
MHOUT.csv File containing MH output data
MHSET.csv File containing MH settings
MHSHP.csv File containing MH shape data
MOLINK.csv File containing information about a specific type of link element
MONODE.csv File containing information about a specific type of node element
NAMEVIEW.csv File containing name view data
NCPIDGN.csv File containing NCP IDGN data
NCPIXSEC.csv File containing NCP IXSEC data
NDHLINKS.csv File containing NDH links data
NDSOURCE.csv File containing ND source data
NODE.csv File containing information about a specific type of node element
NODE.DBF.csv File containing information about a specific type of node element
OPERSET.csv File containing operator settings
OUTLEOUT.csv File containing outlet output data
PATNDATA.csv File containing pattern data
PATTERN.csv File containing pattern information
PIDGNSET.csv File containing PIDGN settings
PIIISET.csv File containing PIII settings
PIPE.csv File containing information about a specific type of pipe element
FILENAME DESCRIPTION
PIPECNST.csv File containing pipe construction data
PIPEDGN.csv File containing pipe design data
PIPEHYD.csv File containing pipe hydraulic data
PIPEII.csv File containing pipe II data
PIPEOUT.csv File containing pipe output data
PIPESET.csv File containing pipe settings
PIPESHP.csv File containing pipe shape data
PIPESPLT.csv File containing pipe split data
PIPEWQ.csv File containing pipe water quality data
PISPTSET.csv File containing PI/SP/TSET data
POLYREG.csv File containing polygon regression data
PUMP.csv File containing pump data
PUMPHYD.csv File containing pump hydraulic data
PUMPOUT.csv File containing pump output data
PUMPSET.csv File containing pump settings
QRYSET.csv File containing query settings
QSETDATA.csv File containing query set data
QSSSLK.csv File containing QSSS link data
QSSSND.csv File containing QSSS node data
QUERY.csv File containing query data
RELATE.csv File containing data about element relationships
REPORT.csv File containing report data
RPTDATA.csv File containing report data
RUNOPT.csv File containing run options
SCENARIO.csv File containing scenario data
SELSET.csv File containing selection set data
STATUS.csv File containing status data
TIME.csv File containing time settings
VERTEX.csv File containing vertex data
WWELL.csv File containing well data
WWELLHYD.csv File containing well hydraulic data
WWELLOUT.csv File containing well output data
WWELLSET.csv File containing well settings
XLOAD.csv File containing external load data
XLOADSET.csv File containing external load settings
XNGLINK.csv File containing cross-nodal links data
XNGNODE.csv File containing cross-nodal node data

Leave a Reply