| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 14 0;"><SPAN>Originally created by Claunch & Miller, Inc. (part of HDR Engineering as of 2008) in 2002, this file has been maintained in-house since then. Updates are provided through a combination of as-builts, field verifications, and word of mouth from employees who have worked on a particular feature.</SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>Field breakdown: </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>POINT_ID [Valve ID] </SPAN></SPAN><SPAN>contains the unique identifier for each valve, with the first digit references the fire district in which the valve is found. </SPAN><SPAN STYLE="font-style:italic;">ASSETID [Asset ID] </SPAN><SPAN>is the randomly assigned, unique identifier used by VUEWorks (Public Works' work order system)*. </SPAN><SPAN STYLE="font-style:italic;"><SPAN>LID [Lid Condition]</SPAN></SPAN><SPAN><SPAN>uses the ValveLid domain to rate the condition of the valve</SPAN></SPAN><SPAN><SPAN>’</SPAN></SPAN><SPAN><SPAN>s lid (note that this field has not been updated since the valves were originally entered). </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>PHYS_LOCA [Physical Location]</SPAN></SPAN><SPAN><SPAN>uses the ValveLocation domain to describe where the feature is located (e.g., street surface). </SPAN></SPAN><SPAN STYLE="font-style:italic;">TYPE [Type]</SPAN><SPAN>u</SPAN><SPAN><SPAN>ses the ValveType domain to denote the type of valve (e.g., gate valve). </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>OPEN_DIREC [Open Direction] </SPAN></SPAN><SPAN><SPAN>designates the direction (left or right) the valve must be turned to open it. </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>DIAMETER [Diameter (in)]</SPAN></SPAN><SPAN><SPAN>uses theWLineSize1 domain as a dropdown to record the diameter (in inches) of the valves. </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>POSITIONTYPE [Position Type] </SPAN></SPAN><SPAN><SPAN>categorizes the valves by their relation to other water infrastructure. The </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>GPS_DATE [GPS Date] </SPAN></SPAN><SPAN><SPAN>and </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>GPS_TIME [GPS Time]</SPAN></SPAN><SPAN>fields contain information about when the feature was originally shot into the system. </SPAN><SPAN><SPAN>The </SPAN></SPAN><SPAN><SPAN>NORTHING [Northing (Y)]</SPAN></SPAN><SPAN><SPAN>, </SPAN></SPAN><SPAN><SPAN>EASTING [Easting (X)] Z [Elevation (Z)] </SPAN></SPAN><SPAN><SPAN>fields contain coordinate data. </SPAN></SPAN><SPAN><SPAN>DEPTH_HEIGHT</SPAN></SPAN><SPAN><SPAN>is the below or above Z, the surface elevation. </SPAN></SPAN><SPAN>The following fields were populated by Data Transfer Solutions in 2017: </SPAN><SPAN STYLE="font-style:italic;"><SPAN>IMAGE [Image]</SPAN></SPAN><SPAN><SPAN>contains the file name of a picture of the feature; </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>STREET [Street]</SPAN></SPAN><SPAN>contains the name of the street on which the feature is located; </SPAN><SPAN STYLE="font-style:italic;"><SPAN>CONDITION [Condition] </SPAN></SPAN><SPAN><SPAN>and </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>CONDITIONINDEX [Condition Index] </SPAN></SPAN><SPAN><SPAN>are condition ratings; and the </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>INSTALLYEAR [Installation Year] </SPAN></SPAN><SPAN><SPAN>and </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>CONMMENTS [Comments] </SPAN></SPAN><SPAN>fields should be self-explanatory. </SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>To derive the actual elevation of a feature = Z + </SPAN></SPAN><SPAN><SPAN>DEPTH_HEIGHT</SPAN></SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>All Z values are in feet. All Elevation data is Surface Elevation.</SPAN></SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN>Due to VUEWorks, care must be taken when deleting features. The IDs cannot be reused and must be retired after a deletion. The retired IDs for this feature class are: 1681, 1700, 1735, 2240, 2241, 3781, 5292, and 6871. (The retired Valve IDs are: 10640, 10812, 10863, 10864, 11229, 50502, 50503, and unknown.)</SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN>* The reason for two different IDs is that VUEWorks uses randomly assigned IDs; it cannot handle IDs that have meaning.</SPAN></P></DIV></DIV></DIV> |