Hydrant System Data Elements

Hydrant System Data Elements

Hydrant System Data Elements

DATA ELEMENTS IN WATER HYDRANT SYSTEM
HYDLOC#UNIQUE SEQ. NBR FOR HYDRANT. FORMAT: NNNNNNNNN
HYDUBBUNIQUE HYDRANT NBR. (ATLAS COL ELE# 1666, ROW ELE# 1669, 9 QUADRANT ELE# 1668, SEQ NBR) FORMAT.AA-NN-N-NN
HYDNBR2SAME AS HYDRANT NBR BUT DIFFERENT FORMAT I.E. AA NNNNN.
LOC DES50 CHARACTER FIELD FOR DESCRIPTION OF PHYSICAL LOCATION OF A HYDRANT. I.E. SW CORNER OF A ST & B ST.
ON STRTSTREET HYDRANT IS ON. SHORT NAME MAX OF 5 CHARACTERS.
CRS STRNEAREST CROSS STREET. SHORT NAME MAX OF 5 CHARACTERS.
RESIDUAL HYDRANT DATA: A RESIDUAL HYDRANT IS ONE LOCATED ON THE SAME WATER MAIN AS THE HYDRANT BEING TESTED.
RES ROW ATLAS MAP ROW OF RESIDUAL HYDRANT. ELE# 1695.
RES CDLATLAS MAP COLUMN OF RESIDUAL HYDRANT.
RES QUADQUADRANT OF RESIDUAL HYDRANT ELE# 1694
RES SEQSEQUENCE NBR OF RESIDUAL HYDRANT.
STAT CODHYDRANT STATUS CODE. ELE# 1698.
LOC INDLOCK INDICATOR. CODES ARE Y & N & ?. ELE# 9004.
IN OUTHYDRANT INSIDE OR OUTSIDE CITY LIMITS. ELE# 1347
DPT BURYDEPTH OF BURY. DISTANCE IN FEET FROM MAIN TO HYDRANT.
MAIN SIZESIZE OF THE WATER MAIN.
MAIN KINDKIND OF HYDRANT MAIN. ELE# 1714.
TOP COLORCOLOR THE TOP OF THE HYDRANT IS PAINTED. ELE# 1699.
BARREL COLCOLOR OF THE HYDRANT BARREL. ELE# 1671
GUARD QTYNUMBER OF HYDRANT GUARDS.
VALVE INDDOES THE HYDRANT HAVE A VALVE? Y/N. ELE# 9004
VALVE DIRDIRECTION VALVE FACES. ELE# 1701.
VALVE DISTDISTANCE FROM HYDRANT TO VALVE.
BOOK NBRHYDRANT BOOK NUMBER.
BOOK SUFHYDRANT BOOK NUMBER SUFFIX.
BOOK PAGEHYDRANT BOOK PAGE NUMBER.
FILE DESCAS BUILT FILE DESCRIPITON
BLT FILEIDAS BUILT FILE ID NUMBER. ELE# 1367.
BLT SECTAS BUILT FILE SECTION NUMBER.
BLT POCKAS BUILT POCKET NUMBER
BLT FRPG NMAS BUILT FROM PAGE NUMBER
BLT FRPGIAS BUILT FROM PAGE NUMBER ID
BLT TOPG NMAS BUILT TO PAGE NUMBER
BLT TOPG IDAS BUILT TO PAGE NUMBER ID
MANF CDHYDRANT MANUFACTURER CODE. ELE# 1687.
MANF YRYEAR HYDRANT WAS MANUFACTURED
MODEL CDHYDRANT MODEL CODE. ELE# 1689.
TYPE CDHYDRANT TYPE CODE. ELE# 1700.
SIZE CDHYDRANT SIZE CODE. ELE# 1697.
HOSE QTYNUMBER OF HOSE OPENINGS. (ARMS)
PUMP QTYNUMBER OF PUMPER OPENINGS
OPEN CDDIRECTION IN WHICH THE HYDRANT NUT OPENS. ELE# 1690.
OPER IDOPID OF LAST PERSON TO UPDATE RECORD.
PRGM IDMSS PROGRAM ID NUMBER.
TERM IDTERMINAL ID TO WHICH UPDATE WAS MADE.
FLOW TIMETIME OF DAY FLOW TEST WAS CONDUCTED.
STATIC QTYMAX. PRESSURE W/NO OTHER HYDRANT OPEN
RESID QTYPRESSURE WITH REDIDUAL HYDRANT FULLY OPEN.
FLOW QTYAMOUNT OF WATER MEASURED DURING FLOW & PRESSURE TEST.
CCFLOW QTYCALCULATED FLOW QUANTITY DURING FLOW AND PRESSURE TEST.
FLOW OPERFLOW OPERATOR ID
FLOW PGMFLOW PROGRAM ID