TampaGov home page
Geographic Information Systems

Quick Links

DATA ELEMENTS IN WATER HYDRANT SYSTEM
HYDLOC# UNIQUE SEQ. NBR FOR HYDRANT. FORMAT: NNNNNNNNN
HYDUBB UNIQUE HYDRANT NBR. (ATLAS COL ELE# 1666, ROW ELE# 1669, 9 QUADRANT ELE# 1668, SEQ NBR) FORMAT.AA-NN-N-NN
HYDNBR2 SAME AS HYDRANT NBR BUT DIFFERENT FORMAT I.E. AA NNNNN.
LOC DES 50 CHARACTER FIELD FOR DESCRIPTION OF PHYSICAL LOCATION OF A HYDRANT. I.E. SW CORNER OF A ST & B ST.
ON STRT STREET HYDRANT IS ON. SHORT NAME MAX OF 5 CHARACTERS.
CRS STR NEAREST 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 CDL ATLAS MAP COLUMN OF RESIDUAL HYDRANT.
RES QUAD QUADRANT OF RESIDUAL HYDRANT ELE# 1694
RES SEQ SEQUENCE NBR OF RESIDUAL HYDRANT.
STAT COD HYDRANT STATUS CODE. ELE# 1698.
LOC IND LOCK INDICATOR. CODES ARE Y & N & ?. ELE# 9004.
IN OUT HYDRANT INSIDE OR OUTSIDE CITY LIMITS. ELE# 1347
DPT BURY DEPTH OF BURY. DISTANCE IN FEET FROM MAIN TO HYDRANT.
MAIN SIZE SIZE OF THE WATER MAIN.
MAIN KIND KIND OF HYDRANT MAIN. ELE# 1714.
TOP COLOR COLOR THE TOP OF THE HYDRANT IS PAINTED. ELE# 1699.
BARREL COL COLOR OF THE HYDRANT BARREL. ELE# 1671
GUARD QTY NUMBER OF HYDRANT GUARDS.
VALVE IND DOES THE HYDRANT HAVE A VALVE? Y/N. ELE# 9004
VALVE DIR DIRECTION VALVE FACES. ELE# 1701.
VALVE DIST DISTANCE FROM HYDRANT TO VALVE.
BOOK NBR HYDRANT BOOK NUMBER.
BOOK SUF HYDRANT BOOK NUMBER SUFFIX.
BOOK PAGE HYDRANT BOOK PAGE NUMBER.
FILE DESC AS BUILT FILE DESCRIPITON
BLT FILEID AS BUILT FILE ID NUMBER. ELE# 1367.
BLT SECT AS BUILT FILE SECTION NUMBER.
BLT POCK AS BUILT POCKET NUMBER
BLT FRPG NM AS BUILT FROM PAGE NUMBER
BLT FRPGI AS BUILT FROM PAGE NUMBER ID
BLT TOPG NM AS BUILT TO PAGE NUMBER
BLT TOPG ID AS BUILT TO PAGE NUMBER ID
MANF CD HYDRANT MANUFACTURER CODE. ELE# 1687.
MANF YR YEAR HYDRANT WAS MANUFACTURED
MODEL CD HYDRANT MODEL CODE. ELE# 1689.
TYPE CD HYDRANT TYPE CODE. ELE# 1700.
SIZE CD HYDRANT SIZE CODE. ELE# 1697.
HOSE QTY NUMBER OF HOSE OPENINGS. (ARMS)
PUMP QTY NUMBER OF PUMPER OPENINGS
OPEN CD DIRECTION IN WHICH THE HYDRANT NUT OPENS. ELE# 1690.
OPER ID OPID OF LAST PERSON TO UPDATE RECORD.
PRGM ID MSS PROGRAM ID NUMBER.
TERM ID TERMINAL ID TO WHICH UPDATE WAS MADE.
FLOW TIME TIME OF DAY FLOW TEST WAS CONDUCTED.
STATIC QTY MAX. PRESSURE W/NO OTHER HYDRANT OPEN
RESID QTY PRESSURE WITH REDIDUAL HYDRANT FULLY OPEN.
FLOW QTY AMOUNT OF WATER MEASURED DURING FLOW & PRESSURE TEST.
CCFLOW QTY CALCULATED FLOW QUANTITY DURING FLOW AND PRESSURE TEST.
FLOW OPER FLOW OPERATOR ID
FLOW PGM FLOW PROGRAM ID

Copyright © 1996-2012 City of Tampa.  All rights reserved. - Last Updated: 9/20/2011