20220317 09105800 1.0 FALSE Server=MSSQL-01; Service=sde:sqlserver:MSSQL-01; Database=Basemap_3D; Version=dbo.DEFAULT ArcSDE Connection DBO.wHydrant 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,984250.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-88.33333333333333],PARAMETER[&quot;Scale_Factor&quot;,0.999975],PARAMETER[&quot;Latitude_Of_Origin&quot;,36.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,3435]]</WKT><XOrigin>-17463800</XOrigin><YOrigin>-46132600</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102671</WKID><LatestWKID>3435</LatestWKID></ProjectedCoordinateSystem> FeatureClassToFeatureClass "New Group Layer\Water Device" D:\Mapping\5808_007_Catalog_GDB_Users\ADMIN@Master.sde\VOPMaster.DBO.UN_WATER_2022 Water_Device # "ASSETGROUP "Asset group" true true true 4 Long 0 0,First,#,New Group Layer\Water Device,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true true true 2 Short 0 0,First,#,New Group Layer\Water Device,ASSETTYPE,-1,-1;ASSOCIATIONSTATUS "Association status" true true true 2 Short 0 0,First,#,New Group Layer\Water Device,ASSOCIATIONSTATUS,-1,-1;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true true 2 Short 0 0,First,#,New Group Layer\Water Device,ISSUBNETWORKCONTROLLER,-1,-1;ISCONNECTED "Is connected" true true true 2 Short 0 0,First,#,New Group Layer\Water Device,ISCONNECTED,-1,-1;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true true 2000 Text 0 0,First,#,New Group Layer\Water Device,SUBNETWORKCONTROLLERNAME,0,2000;TIERNAME "Tier name" true true true 4 Long 0 0,First,#,New Group Layer\Water Device,TIERNAME,-1,-1;TIERRANK "Tier rank" true true true 4 Long 0 0,First,#,New Group Layer\Water Device,TIERRANK,-1,-1;TERMINALCONFIGURATION "Terminal path" true true true 128 Text 0 0,First,#,New Group Layer\Water Device,TERMINALCONFIGURATION,0,128;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#,New Group Layer\Water Device,GLOBALID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true true 2000 Text 0 0,First,#,New Group Layer\Water Device,SystemSubnetworkName,0,2000;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true true 2000 Text 0 0,First,#,New Group Layer\Water Device,SUPPORTEDSUBNETWORKNAME,0,2000;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true true 2000 Text 0 0,First,#,New Group Layer\Water Device,SUPPORTINGSUBNETWORKNAME,0,2000;creationdate "Creation date" false true false 8 Date 0 0,First,#,New Group Layer\Water Device,creationdate,-1,-1;creator "Creator" false true false 255 Text 0 0,First,#,New Group Layer\Water Device,creator,0,255;lastupdate "Last update" false true false 8 Date 0 0,First,#,New Group Layer\Water Device,lastupdate,-1,-1;updatedby "Updated by" false true false 255 Text 0 0,First,#,New Group Layer\Water Device,updatedby,0,255;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,diameter,-1,-1;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,secondarydiameter,-1,-1;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,pressure,-1,-1;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,designtype,-1,-1;normalstatus "Normal Status" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,normalstatus,-1,-1;presentstatus "Present Status" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,presentstatus,-1,-1;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,additionaldetails,-1,-1;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,designinfo,-1,-1;operable "Operable" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,operable,-1,-1;name "Name" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,name,0,64;installdate "Install Date" true true false 8 Date 0 0,First,#,New Group Layer\Water Device,installdate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,assetid,0,64;accountid "Account ID" true true false 50 Text 0 0,First,#,New Group Layer\Water Device,accountid,0,50;ownedby "Owned By" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,maintby,-1,-1;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,additionaldevice,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,New Group Layer\Water Device,notes,0,2000;symbolrotation "Symbol Rotation" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,symbolrotation,-1,-1;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#,New Group Layer\Water Device,lastmaint,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,lifecyclestatus,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,New Group Layer\Water Device,inservicedate,-1,-1;retireddate "Retired Date" true true false 8 Date 0 0,First,#,New Group Layer\Water Device,retireddate,-1,-1;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,spatialconfidence,-1,-1;manufacturer "Manufacturer" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,manufacturer,-1,-1;operator "Postindicator Valve" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,operator,-1,-1;locationvop "Location" true true false 255 Text 0 0,First,#,New Group Layer\Water Device,locationvop,0,255;enclosurevop "Enclosure" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,enclosurevop,-1,-1;materialvop "Material" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,materialvop,-1,-1;pdopvop "PDOP" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,pdopvop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,datasourcevop,-1,-1;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,sectioncodevop,0,64;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,objectnumbervop,0,64;eamidvop "EAM ID" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,eamidvop,0,64;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,eamdescvop,0,64;dqualityvop "D Quality" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,dqualityvop,-1,-1;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,nodeidvop,0,64;makevop "Make" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,makevop,0,64;breakawayvop "Breakaway" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,breakawayvop,-1,-1;lastpaintvop "Year Constructed" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,lastpaintvop,-1,-1;nutdepthvop "Nut Depth" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,nutdepthvop,-1,-1;yearabandonedvop "Year Abandoned" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,yearabandonedvop,-1,-1;capacityvop "Capacity (Gal)" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,capacityvop,-1,-1;pinvop "PIN" true true false 13 Text 0 0,First,#,New Group Layer\Water Device,pinvop,0,13;elevationvop "TOF Elevation" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,elevationvop,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 0,First,#,New Group Layer\Water Device,yearconstructedvop,-1,-1;contractvop "I Contract Num" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,contractvop,0,64;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,cathodicprotectionsysnumvop,0,64;tanknovop "Tank No" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,tanknovop,0,64;apiwellvop "API" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,apiwellvop,-1,-1;longwestwellvop "LONG_WEST" true true false 8 Double 0 0,First,#,New Group Layer\Water Device,longwestwellvop,-1,-1;lamxwellvop "LAMX" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,lamxwellvop,-1,-1;lamywellvop "LAMY" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,lamywellvop,-1,-1;tdwellvop "TD" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,tdwellvop,-1,-1;sectwellvop "SECT" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,sectwellvop,-1,-1;twpwellvop "TWP" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,twpwellvop,-1,-1;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,tdirwellvop,0,9;rngwellvop "RNG" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,rngwellvop,-1,-1;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,rdirwellvop,0,9;nsfwellvop "NSF" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,nsfwellvop,0,9;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,nsdirwellvop,0,9;ewfwellvop "EWF" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,ewfwellvop,0,9;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,ewdirwellvop,0,9;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,cornerwellvop,0,9;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,quarterswellvop,0,9;elevwellvop "ELEV" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,elevwellvop,-1,-1;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,elevrefwellvop,0,9;cdatewellvop "CDATE" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,cdatewellvop,-1,-1;stwellvop "ST" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,stwellvop,0,9;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,fnamewellvop,0,9;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,fnumwellvop,0,9;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,cnamewellvop,0,9;permitnumwellvop "PERMITNUM" true true false 4 Long 0 0,First,#,New Group Layer\Water Device,permitnumwellvop,-1,-1;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,permitdatewellvop,0,9;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,welltypewellvop,0,9;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,wformationwellvop,0,9;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,wfmfromwellvop,0,9;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,wfmtowellvop,0,9;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,scrndiamwellvop,0,9;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,scrnlgthwellvop,0,9;slotwellvop "SLOT" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,slotwellvop,0,9;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,caseholewellvop,0,9;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,statlevlwellvop,0,9;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,pumplevlwellvop,0,9;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,pumpgpmwellvop,0,9;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#,New Group Layer\Water Device,pumphrswellvop,0,9;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#,New Group Layer\Water Device,heightvop,0,64" # Append VOPMaster.DBO.WaterDevice_Cody VOPMaster.DBO.Water_Device "Use the field map to reconcile field differences" "ASSETGROUP "Asset group" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,ASSETTYPE,-1,-1;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,ASSOCIATIONSTATUS,-1,-1;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,ISSUBNETWORKCONTROLLER,-1,-1;ISCONNECTED "Is connected" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,ISCONNECTED,-1,-1;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,SUBNETWORKCONTROLLERNAME,0,2000;TIERNAME "Tier name" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,TIERNAME,-1,-1;TIERRANK "Tier rank" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,TIERRANK,-1,-1;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,TERMINALCONFIGURATION,0,128;GLOBALID "Global ID" false false false 38 GlobalID 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,GlobalID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,SystemSubnetworkName,0,2000;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,SUPPORTEDSUBNETWORKNAME,0,2000;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,SUPPORTINGSUBNETWORKNAME,0,2000;creationdate "Creation date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,creationdate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,creator,0,255;lastupdate "Last update" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,lastupdate,-1,-1;updatedby "Updated by" true true false 255 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,updatedby,0,255;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,diameter,-1,-1;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,secondarydiameter,-1,-1;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,pressure,-1,-1;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,designtype,-1,-1;normalstatus "Normal Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,normalstatus,-1,-1;presentstatus "Present Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,presentstatus,-1,-1;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,additionaldetails,-1,-1;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,designinfo,-1,-1;operable "Operable" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,operable,-1,-1;name "Name" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,name,0,64;installdate "Install Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,installdate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,assetid,0,64;accountid "Account ID" true true false 50 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,accountid,0,50;ownedby "Owned By" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,maintby,-1,-1;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,additionaldevice,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,notes,0,2000;symbolrotation "Symbol Rotation" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,symbolrotation,-1,-1;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,lastmaint,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,lifecyclestatus,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,inservicedate,-1,-1;retireddate "Retired Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,retireddate,-1,-1;spatialsource "Spatial Source" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,spatialconfidence,-1,-1;manufacturer "Manufacturer" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,manufacturer,-1,-1;operator "Postindicator Valve" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,operator,-1,-1;locationvop "Location" true true false 255 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,locationvop,0,255;enclosurevop "Enclosure" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,enclosurevop,-1,-1;materialvop "Material" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,materialvop,-1,-1;pdopvop "PDOP" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,pdopvop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,datasourcevop,-1,-1;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,sectioncodevop,0,64;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,objectnumbervop,0,64;eamidvop "EAM ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,eamidvop,0,64;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,eamdescvop,0,64;dqualityvop "D Quality" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,dqualityvop,-1,-1;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,nodeidvop,0,64;makevop "Make" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,makevop,0,64;breakawayvop "Breakaway" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,breakawayvop,-1,-1;lastpaintvop "Year Constructed" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,lastpaintvop,-1,-1;nutdepthvop "Nut Depth" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,nutdepthvop,-1,-1;yearabandonedvop "Year Abandoned" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,yearabandonedvop,-1,-1;capacityvop "Capacity (Gal)" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,capacityvop,-1,-1;pinvop "PIN" true true false 13 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,pinvop,0,13;elevationvop "TOF Elevation" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,elevationvop,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 5,First,#,VOPMaster.DBO.WaterDevice_Cody,yearconstructedvop,-1,-1;contractvop "I Contract Num" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,contractvop,0,64;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,cathodicprotectionsysnumvop,0,64;tanknovop "Tank No" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,tanknovop,0,64;apiwellvop "API" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,apiwellvop,-1,-1;longwestwellvop "LONG_WEST" true true false 8 Double 8 38,First,#,VOPMaster.DBO.WaterDevice_Cody,longwestwellvop,-1,-1;lamxwellvop "LAMX" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,lamxwellvop,-1,-1;lamywellvop "LAMY" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,lamywellvop,-1,-1;tdwellvop "TD" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,tdwellvop,-1,-1;sectwellvop "SECT" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,sectwellvop,-1,-1;twpwellvop "TWP" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,twpwellvop,-1,-1;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,tdirwellvop,0,9;rngwellvop "RNG" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,rngwellvop,-1,-1;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,rdirwellvop,0,9;nsfwellvop "NSF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,nsfwellvop,0,9;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,nsdirwellvop,0,9;ewfwellvop "EWF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,ewfwellvop,0,9;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,ewdirwellvop,0,9;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,cornerwellvop,0,9;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,quarterswellvop,0,9;elevwellvop "ELEV" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,elevwellvop,-1,-1;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,elevrefwellvop,0,9;cdatewellvop "CDATE" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,cdatewellvop,-1,-1;stwellvop "ST" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,stwellvop,0,9;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,fnamewellvop,0,9;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,fnumwellvop,0,9;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,cnamewellvop,0,9;permitnumwellvop "PERMITNUM" true true false 4 Long 0 10,First,#,VOPMaster.DBO.WaterDevice_Cody,permitnumwellvop,-1,-1;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,permitdatewellvop,0,9;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,welltypewellvop,0,9;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,wformationwellvop,0,9;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,wfmfromwellvop,0,9;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,wfmtowellvop,0,9;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,scrndiamwellvop,0,9;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,scrnlgthwellvop,0,9;slotwellvop "SLOT" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,slotwellvop,0,9;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,caseholewellvop,0,9;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,statlevlwellvop,0,9;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,pumplevlwellvop,0,9;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,pumpgpmwellvop,0,9;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,pumphrswellvop,0,9;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#,VOPMaster.DBO.WaterDevice_Cody,heightvop,0,64" # # CalculateField "New Water UN\Water Device In Service" locationvop "Silverlake WM Replacement Phase 1" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "New Water UN\Water Device In Service" lastpaintvop "2021" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "New Water UN\Water Device In Service" lastpaintvop "2021" "Python 3" # Text NO_ENFORCE_DOMAINS Append BBox_Locations_07252022 "Utilities\New Water UN\Water Device In Service" "Use the field map to reconcile field differences" "ASSETGROUP "Asset group" true true false 4 Long 0 10,First,#;ASSETTYPE "Asset type" true true false 2 Short 0 5,First,#;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 5,First,#;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 5,First,#;ISCONNECTED "Is connected" true true false 2 Short 0 5,First,#;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#;TIERNAME "Tier name" true true false 4 Long 0 10,First,#;TIERRANK "Tier rank" true true false 4 Long 0 10,First,#;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 8 38,First,#;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 8 38,First,#;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 8 38,First,#;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 5,First,#;normalstatus "Normal Status" true true false 2 Short 0 5,First,#;presentstatus "Present Status" true true false 2 Short 0 5,First,#;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 5,First,#;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 8 38,First,#;operable "Operable" true true false 2 Short 0 5,First,#;name "Name" true true false 64 Text 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;accountid "Account ID" true true false 50 Text 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 5,First,#;maintby "Maintained By" true true false 2 Short 0 5,First,#;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 5,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;symbolrotation "Symbol Rotation" true true false 2 Short 0 5,First,#;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 5,First,#;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#;retireddate "Retired Date" true true false 8 Date 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 5,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 5,First,#;manufacturer "Manufacturer" true true false 2 Short 0 5,First,#;operator "Postindicator Valve" true true false 2 Short 0 5,First,#;locationvop "Location" true true false 255 Text 0 0,First,#,BBox_Locations_07252022,Location_Description,0,256;enclosurevop "Enclosure" true true false 2 Short 0 5,First,#;materialvop "Material" true true false 2 Short 0 5,First,#;pdopvop "PDOP" true true false 8 Double 8 38,First,#;datasourcevop "Data Source" true true false 2 Short 0 5,First,#;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#;eamidvop "EAM ID" true true false 64 Text 0 0,First,#;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#;dqualityvop "D Quality" true true false 8 Double 8 38,First,#;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#;makevop "Make" true true false 64 Text 0 0,First,#;breakawayvop "Breakaway" true true false 2 Short 0 5,First,#;lastpaintvop "Year Constructed" true true false 2 Short 0 5,First,#;nutdepthvop "Nut Depth" true true false 2 Short 0 5,First,#;yearabandonedvop "Year Abandoned" true true false 2 Short 0 5,First,#;capacityvop "Capacity (Gal)" true true false 8 Double 8 38,First,#;pinvop "PIN" true true false 13 Text 0 0,First,#;elevationvop "TOF Elevation" true true false 8 Double 8 38,First,#;yearconstructedvop "Year Constructed" true true false 2 Short 0 5,First,#;contractvop "I Contract Num" true true false 64 Text 0 0,First,#;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#;tanknovop "Tank No" true true false 64 Text 0 0,First,#;apiwellvop "API" true true false 8 Double 8 38,First,#;longwestwellvop "LONG_WEST" true true false 8 Double 8 38,First,#;lamxwellvop "LAMX" true true false 4 Long 0 10,First,#;lamywellvop "LAMY" true true false 4 Long 0 10,First,#;tdwellvop "TD" true true false 4 Long 0 10,First,#;sectwellvop "SECT" true true false 4 Long 0 10,First,#;twpwellvop "TWP" true true false 4 Long 0 10,First,#;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#;rngwellvop "RNG" true true false 4 Long 0 10,First,#;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#;nsfwellvop "NSF" true true false 9 Text 0 0,First,#;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#;ewfwellvop "EWF" true true false 9 Text 0 0,First,#;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#;elevwellvop "ELEV" true true false 4 Long 0 10,First,#;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#;cdatewellvop "CDATE" true true false 4 Long 0 10,First,#;stwellvop "ST" true true false 9 Text 0 0,First,#;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#;permitnumwellvop "PERMITNUM" true true false 4 Long 0 10,First,#;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#;slotwellvop "SLOT" true true false 9 Text 0 0,First,#;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#" "Service Valve" # Append BBox_Locations_07252022 "Utilities\New Water UN\Water Device In Service" "Use the field map to reconcile field differences" "ASSETGROUP "Asset group" true true false 4 Long 0 10,First,#;ASSETTYPE "Asset type" true true false 2 Short 0 5,First,#;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 5,First,#;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 5,First,#;ISCONNECTED "Is connected" true true false 2 Short 0 5,First,#;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#;TIERNAME "Tier name" true true false 4 Long 0 10,First,#;TIERRANK "Tier rank" true true false 4 Long 0 10,First,#;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,GlobalID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,CreationDate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,Creator,0,128;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 8 38,First,#;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 8 38,First,#;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 8 38,First,#;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 5,First,#;normalstatus "Normal Status" true true false 2 Short 0 5,First,#;presentstatus "Present Status" true true false 2 Short 0 5,First,#;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 5,First,#;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 8 38,First,#;operable "Operable" true true false 2 Short 0 5,First,#;name "Name" true true false 64 Text 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;accountid "Account ID" true true false 50 Text 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 5,First,#;maintby "Maintained By" true true false 2 Short 0 5,First,#;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 5,First,#;notes "Notes" true true false 2000 Text 0 0,First,#,BBox_Locations_07252022,Location_Description,0,256;symbolrotation "Symbol Rotation" true true false 2 Short 0 5,First,#;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 5,First,#;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#;retireddate "Retired Date" true true false 8 Date 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 5,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 5,First,#;manufacturer "Manufacturer" true true false 2 Short 0 5,First,#;operator "Postindicator Valve" true true false 2 Short 0 5,First,#;locationvop "Location" true true false 255 Text 0 0,First,#,BBox_Locations_07252022,Service_Address,0,256;enclosurevop "Enclosure" true true false 2 Short 0 5,First,#;materialvop "Material" true true false 2 Short 0 5,First,#;pdopvop "PDOP" true true false 8 Double 8 38,First,#,BBox_Locations_07252022,esrignss_pdop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 5,First,#;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#;eamidvop "EAM ID" true true false 64 Text 0 0,First,#;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#;dqualityvop "D Quality" true true false 8 Double 8 38,First,#;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#;makevop "Make" true true false 64 Text 0 0,First,#;breakawayvop "Breakaway" true true false 2 Short 0 5,First,#;lastpaintvop "Year Constructed" true true false 2 Short 0 5,First,#;nutdepthvop "Nut Depth" true true false 2 Short 0 5,First,#;yearabandonedvop "Year Abandoned" true true false 2 Short 0 5,First,#;capacityvop "Capacity (Gal)" true true false 8 Double 8 38,First,#;pinvop "PIN" true true false 13 Text 0 0,First,#;elevationvop "TOF Elevation" true true false 8 Double 8 38,First,#,BBox_Locations_07252022,esrignss_altitude,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 5,First,#;contractvop "I Contract Num" true true false 64 Text 0 0,First,#;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#;tanknovop "Tank No" true true false 64 Text 0 0,First,#;apiwellvop "API" true true false 8 Double 8 38,First,#;longwestwellvop "LONG_WEST" true true false 8 Double 8 38,First,#;lamxwellvop "LAMX" true true false 4 Long 0 10,First,#;lamywellvop "LAMY" true true false 4 Long 0 10,First,#;tdwellvop "TD" true true false 4 Long 0 10,First,#;sectwellvop "SECT" true true false 4 Long 0 10,First,#;twpwellvop "TWP" true true false 4 Long 0 10,First,#;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#;rngwellvop "RNG" true true false 4 Long 0 10,First,#;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#;nsfwellvop "NSF" true true false 9 Text 0 0,First,#;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#;ewfwellvop "EWF" true true false 9 Text 0 0,First,#;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#;elevwellvop "ELEV" true true false 4 Long 0 10,First,#;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#;cdatewellvop "CDATE" true true false 4 Long 0 10,First,#;stwellvop "ST" true true false 9 Text 0 0,First,#;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#;permitnumwellvop "PERMITNUM" true true false 4 Long 0 10,First,#;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#;slotwellvop "SLOT" true true false 9 Text 0 0,First,#;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#" # # Append BBox_Locations_07252022 "Utilities\New Water UN\All Water Devices" "Use the field map to reconcile field differences" "ASSETGROUP "Asset group" true true false 4 Long 0 10,First,#;ASSETTYPE "Asset type" true true false 2 Short 0 5,First,#;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 5,First,#;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 5,First,#;ISCONNECTED "Is connected" true true false 2 Short 0 5,First,#;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#;TIERNAME "Tier name" true true false 4 Long 0 10,First,#;TIERRANK "Tier rank" true true false 4 Long 0 10,First,#;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,GlobalID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,CreationDate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,S:\5001 Administration\GIS\Cody R\Scratch GIS - ArcPro\Scratch GIS - ArcPro.gdb\BBox_Locations_07252022,Creator,0,128;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 8 38,First,#;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 8 38,First,#;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 8 38,First,#;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 5,First,#;normalstatus "Normal Status" true true false 2 Short 0 5,First,#;presentstatus "Present Status" true true false 2 Short 0 5,First,#;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 5,First,#;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 8 38,First,#;operable "Operable" true true false 2 Short 0 5,First,#;name "Name" true true false 64 Text 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;accountid "Account ID" true true false 50 Text 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 5,First,#;maintby "Maintained By" true true false 2 Short 0 5,First,#;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 5,First,#;notes "Notes" true true false 2000 Text 0 0,First,#,BBox_Locations_07252022,Location_Description,0,256;symbolrotation "Symbol Rotation" true true false 2 Short 0 5,First,#;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 5,First,#;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#;retireddate "Retired Date" true true false 8 Date 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 5,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 5,First,#;manufacturer "Manufacturer" true true false 2 Short 0 5,First,#;operator "Postindicator Valve" true true false 2 Short 0 5,First,#;locationvop "Location" true true false 255 Text 0 0,First,#,BBox_Locations_07252022,Service_Address,0,256;enclosurevop "Enclosure" true true false 2 Short 0 5,First,#;materialvop "Material" true true false 2 Short 0 5,First,#;pdopvop "PDOP" true true false 8 Double 8 38,First,#,BBox_Locations_07252022,esrignss_pdop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 5,First,#;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#;eamidvop "EAM ID" true true false 64 Text 0 0,First,#;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#;dqualityvop "D Quality" true true false 8 Double 8 38,First,#;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#;makevop "Make" true true false 64 Text 0 0,First,#;breakawayvop "Breakaway" true true false 2 Short 0 5,First,#;lastpaintvop "Year Constructed" true true false 2 Short 0 5,First,#;nutdepthvop "Nut Depth" true true false 2 Short 0 5,First,#;yearabandonedvop "Year Abandoned" true true false 2 Short 0 5,First,#;capacityvop "Capacity (Gal)" true true false 8 Double 8 38,First,#;pinvop "PIN" true true false 13 Text 0 0,First,#;elevationvop "TOF Elevation" true true false 8 Double 8 38,First,#,BBox_Locations_07252022,esrignss_altitude,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 5,First,#;contractvop "I Contract Num" true true false 64 Text 0 0,First,#;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#;tanknovop "Tank No" true true false 64 Text 0 0,First,#;apiwellvop "API" true true false 8 Double 8 38,First,#;longwestwellvop "LONG_WEST" true true false 8 Double 8 38,First,#;lamxwellvop "LAMX" true true false 4 Long 0 10,First,#;lamywellvop "LAMY" true true false 4 Long 0 10,First,#;tdwellvop "TD" true true false 4 Long 0 10,First,#;sectwellvop "SECT" true true false 4 Long 0 10,First,#;twpwellvop "TWP" true true false 4 Long 0 10,First,#;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#;rngwellvop "RNG" true true false 4 Long 0 10,First,#;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#;nsfwellvop "NSF" true true false 9 Text 0 0,First,#;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#;ewfwellvop "EWF" true true false 9 Text 0 0,First,#;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#;elevwellvop "ELEV" true true false 4 Long 0 10,First,#;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#;cdatewellvop "CDATE" true true false 4 Long 0 10,First,#;stwellvop "ST" true true false 9 Text 0 0,First,#;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#;permitnumwellvop "PERMITNUM" true true false 4 Long 0 10,First,#;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#;slotwellvop "SLOT" true true false 9 Text 0 0,First,#;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#" "Service Valve" # FeatureClassToFeatureClass VOPMaster.DBO.Water_Device "C:\Users\zzimmerman_radm\Desktop\Orland Park Basemap\Basemap.gdb" wHydrant # "ASSETGROUP "Asset group" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,ASSETTYPE,-1,-1;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,ASSOCIATIONSTATUS,-1,-1;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,ISSUBNETWORKCONTROLLER,-1,-1;ISCONNECTED "Is connected" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,ISCONNECTED,-1,-1;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.Water_Device,SUBNETWORKCONTROLLERNAME,0,2000;TIERNAME "Tier name" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,TIERNAME,-1,-1;TIERRANK "Tier rank" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,TIERRANK,-1,-1;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#,VOPMaster.DBO.Water_Device,TERMINALCONFIGURATION,0,128;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#,VOPMaster.DBO.Water_Device,GLOBALID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.Water_Device,SystemSubnetworkName,0,2000;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.Water_Device,SUPPORTEDSUBNETWORKNAME,0,2000;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.Water_Device,SUPPORTINGSUBNETWORKNAME,0,2000;creationdate "Creation date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,creationdate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,VOPMaster.DBO.Water_Device,creator,0,255;lastupdate "Last update" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,lastupdate,-1,-1;updatedby "Updated by" true true false 255 Text 0 0,First,#,VOPMaster.DBO.Water_Device,updatedby,0,255;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,diameter,-1,-1;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,secondarydiameter,-1,-1;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,pressure,-1,-1;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,designtype,-1,-1;normalstatus "Normal Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,normalstatus,-1,-1;presentstatus "Present Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,presentstatus,-1,-1;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,additionaldetails,-1,-1;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,designinfo,-1,-1;operable "Operable" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,operable,-1,-1;name "Name" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,name,0,64;installdate "Install Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,installdate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,assetid,0,64;accountid "Account ID" true true false 50 Text 0 0,First,#,VOPMaster.DBO.Water_Device,accountid,0,50;ownedby "Owned By" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,maintby,-1,-1;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,additionaldevice,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,VOPMaster.DBO.Water_Device,notes,0,2000;symbolrotation "Symbol Rotation" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,symbolrotation,-1,-1;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,lastmaint,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,lifecyclestatus,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,inservicedate,-1,-1;retireddate "Retired Date" true true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,retireddate,-1,-1;spatialsource "Spatial Source" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,spatialconfidence,-1,-1;manufacturer "Manufacturer" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,manufacturer,-1,-1;operator "Postindicator Valve" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,operator,-1,-1;locationvop "Location" true true false 255 Text 0 0,First,#,VOPMaster.DBO.Water_Device,locationvop,0,255;enclosurevop "Enclosure" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,enclosurevop,-1,-1;materialvop "Material" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,materialvop,-1,-1;pdopvop "PDOP" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,pdopvop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,datasourcevop,-1,-1;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,sectioncodevop,0,64;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,objectnumbervop,0,64;eamidvop "EAM ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,eamidvop,0,64;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,eamdescvop,0,64;dqualityvop "D Quality" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,dqualityvop,-1,-1;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,nodeidvop,0,64;makevop "Make" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,makevop,0,64;breakawayvop "Breakaway" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,breakawayvop,-1,-1;lastpaintvop "Year Constructed" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,lastpaintvop,-1,-1;nutdepthvop "Nut Depth" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,nutdepthvop,-1,-1;yearabandonedvop "Year Abandoned" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,yearabandonedvop,-1,-1;capacityvop "Capacity (Gal)" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,capacityvop,-1,-1;pinvop "PIN" true true false 13 Text 0 0,First,#,VOPMaster.DBO.Water_Device,pinvop,0,13;elevationvop "TOF Elevation" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,elevationvop,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 5,First,#,VOPMaster.DBO.Water_Device,yearconstructedvop,-1,-1;contractvop "I Contract Num" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,contractvop,0,64;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,cathodicprotectionsysnumvop,0,64;tanknovop "Tank No" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,tanknovop,0,64;apiwellvop "API" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,apiwellvop,-1,-1;longwestwellvop "LONG_WEST" true true false 8 Double 8 38,First,#,VOPMaster.DBO.Water_Device,longwestwellvop,-1,-1;lamxwellvop "LAMX" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,lamxwellvop,-1,-1;lamywellvop "LAMY" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,lamywellvop,-1,-1;tdwellvop "TD" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,tdwellvop,-1,-1;sectwellvop "SECT" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,sectwellvop,-1,-1;twpwellvop "TWP" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,twpwellvop,-1,-1;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,tdirwellvop,0,9;rngwellvop "RNG" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,rngwellvop,-1,-1;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,rdirwellvop,0,9;nsfwellvop "NSF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,nsfwellvop,0,9;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,nsdirwellvop,0,9;ewfwellvop "EWF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,ewfwellvop,0,9;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,ewdirwellvop,0,9;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,cornerwellvop,0,9;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,quarterswellvop,0,9;elevwellvop "ELEV" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,elevwellvop,-1,-1;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,elevrefwellvop,0,9;cdatewellvop "CDATE" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,cdatewellvop,-1,-1;stwellvop "ST" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,stwellvop,0,9;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,fnamewellvop,0,9;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,fnumwellvop,0,9;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,cnamewellvop,0,9;permitnumwellvop "PERMITNUM" true true false 4 Long 0 10,First,#,VOPMaster.DBO.Water_Device,permitnumwellvop,-1,-1;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,permitdatewellvop,0,9;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,welltypewellvop,0,9;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,wformationwellvop,0,9;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,wfmfromwellvop,0,9;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,wfmtowellvop,0,9;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,scrndiamwellvop,0,9;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,scrnlgthwellvop,0,9;slotwellvop "SLOT" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,slotwellvop,0,9;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,caseholewellvop,0,9;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,statlevlwellvop,0,9;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,pumplevlwellvop,0,9;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,pumpgpmwellvop,0,9;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#,VOPMaster.DBO.Water_Device,pumphrswellvop,0,9;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#,VOPMaster.DBO.Water_Device,heightvop,0,64;created_user "created_user" false true false 255 Text 0 0,First,#,VOPMaster.DBO.Water_Device,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,VOPMaster.DBO.Water_Device,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,VOPMaster.DBO.Water_Device,last_edited_date,-1,-1" # FeatureClassToFeatureClass "C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant" "Z:\ByClient\Prospect Heights\GIS\Mapping\4755_017_SQL_Database\Basemap_3D.sde\DBO.OrlandPark" wHydrant # "ASSETGROUP "Asset group" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ASSETTYPE,-1,-1;ASSOCIATIONSTATUS "Association status" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ASSOCIATIONSTATUS,-1,-1;ISSUBNETWORKCONTROLLER "Is subnetwork controller" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ISSUBNETWORKCONTROLLER,-1,-1;ISCONNECTED "Is connected" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ISCONNECTED,-1,-1;SUBNETWORKCONTROLLERNAME "Subnetwork controller name" true true false 2000 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,SUBNETWORKCONTROLLERNAME,0,2000;TIERNAME "Tier name" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,TIERNAME,-1,-1;TIERRANK "Tier rank" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,TIERRANK,-1,-1;TERMINALCONFIGURATION "Terminal path" true true false 128 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,TERMINALCONFIGURATION,0,128;GLOBALID "Global ID" false false true 38 GlobalID 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,GLOBALID,-1,-1;SystemSubnetworkName "System Subnetwork Name" true true false 2000 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,SystemSubnetworkName,0,2000;SUPPORTEDSUBNETWORKNAME "Supported subnetwork name" true true false 2000 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,SUPPORTEDSUBNETWORKNAME,0,2000;SUPPORTINGSUBNETWORKNAME "Supporting subnetwork name" true true false 2000 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,SUPPORTINGSUBNETWORKNAME,0,2000;creationdate "Creation date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,creationdate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,creator,0,255;lastupdate "Last update" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lastupdate,-1,-1;updatedby "Updated by" true true false 255 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,updatedby,0,255;diameter "diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,diameter,-1,-1;secondarydiameter "secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,secondarydiameter,-1,-1;pressure "pressure: Amperage, Pressure, Rated Pressure, Volume" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pressure,-1,-1;designtype "designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,designtype,-1,-1;normalstatus "Normal Status" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,normalstatus,-1,-1;presentstatus "Present Status" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,presentstatus,-1,-1;additionaldetails "additionaldetails: Clockwise to Close, Cooling Method, Critical, Material" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,additionaldetails,-1,-1;designinfo "designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,designinfo,-1,-1;operable "Operable" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,operable,-1,-1;name "Name" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,name,0,64;installdate "Install Date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,installdate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,assetid,0,64;accountid "Account ID" true true false 50 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,accountid,0,50;ownedby "Owned By" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,maintby,-1,-1;additionaldevice "additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,additionaldevice,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,notes,0,2000;symbolrotation "Symbol Rotation" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,symbolrotation,-1,-1;lastmaint "Last Maintenance" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lastmaint,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lifecyclestatus,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,inservicedate,-1,-1;retireddate "Retired Date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,retireddate,-1,-1;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,spatialconfidence,-1,-1;manufacturer "Manufacturer" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,manufacturer,-1,-1;operator "Postindicator Valve" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,operator,-1,-1;locationvop "Location" true true false 255 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,locationvop,0,255;enclosurevop "Enclosure" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,enclosurevop,-1,-1;materialvop "Material" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,materialvop,-1,-1;pdopvop "PDOP" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pdopvop,-1,-1;datasourcevop "Data Source" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,datasourcevop,-1,-1;sectioncodevop "Section Code" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,sectioncodevop,0,64;objectnumbervop "Object Number" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,objectnumbervop,0,64;eamidvop "EAM ID" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,eamidvop,0,64;eamdescvop "EAM Description" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,eamdescvop,0,64;dqualityvop "D Quality" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,dqualityvop,-1,-1;nodeidvop "NODE ID" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,nodeidvop,0,64;makevop "Make" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,makevop,0,64;breakawayvop "Breakaway" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,breakawayvop,-1,-1;lastpaintvop "Year Constructed" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lastpaintvop,-1,-1;nutdepthvop "Nut Depth" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,nutdepthvop,-1,-1;yearabandonedvop "Year Abandoned" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,yearabandonedvop,-1,-1;capacityvop "Capacity (Gal)" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,capacityvop,-1,-1;pinvop "PIN" true true false 13 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pinvop,0,13;elevationvop "TOF Elevation" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,elevationvop,-1,-1;yearconstructedvop "Year Constructed" true true false 2 Short 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,yearconstructedvop,-1,-1;contractvop "I Contract Num" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,contractvop,0,64;cathodicprotectionsysnumvop "Cathodic Protection System Num" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,cathodicprotectionsysnumvop,0,64;tanknovop "Tank No" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,tanknovop,0,64;apiwellvop "API" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,apiwellvop,-1,-1;longwestwellvop "LONG_WEST" true true false 8 Double 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,longwestwellvop,-1,-1;lamxwellvop "LAMX" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lamxwellvop,-1,-1;lamywellvop "LAMY" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,lamywellvop,-1,-1;tdwellvop "TD" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,tdwellvop,-1,-1;sectwellvop "SECT" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,sectwellvop,-1,-1;twpwellvop "TWP" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,twpwellvop,-1,-1;tdirwellvop "TDIR" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,tdirwellvop,0,9;rngwellvop "RNG" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,rngwellvop,-1,-1;rdirwellvop "RDIR" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,rdirwellvop,0,9;nsfwellvop "NSF" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,nsfwellvop,0,9;nsdirwellvop "NSDIR" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,nsdirwellvop,0,9;ewfwellvop "EWF" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ewfwellvop,0,9;ewdirwellvop "EWDIR" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,ewdirwellvop,0,9;cornerwellvop "CORNER" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,cornerwellvop,0,9;quarterswellvop "QUARTERS" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,quarterswellvop,0,9;elevwellvop "ELEV" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,elevwellvop,-1,-1;elevrefwellvop "ELEVREF" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,elevrefwellvop,0,9;cdatewellvop "CDATE" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,cdatewellvop,-1,-1;stwellvop "ST" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,stwellvop,0,9;fnamewellvop "FNAME" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,fnamewellvop,0,9;fnumwellvop "FNUM" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,fnumwellvop,0,9;cnamewellvop "CNAME" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,cnamewellvop,0,9;permitnumwellvop "PERMITNUM" true true false 4 Long 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,permitnumwellvop,-1,-1;permitdatewellvop "PERMITDATE" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,permitdatewellvop,0,9;welltypewellvop "WELLTYPE" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,welltypewellvop,0,9;wformationwellvop "WFORMATION" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,wformationwellvop,0,9;wfmfromwellvop "WFMFROM" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,wfmfromwellvop,0,9;wfmtowellvop "WFMTO" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,wfmtowellvop,0,9;scrndiamwellvop "SCRNDIAM" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,scrndiamwellvop,0,9;scrnlgthwellvop "SCRNLGTH" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,scrnlgthwellvop,0,9;slotwellvop "SLOT" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,slotwellvop,0,9;caseholewellvop "CASEHOLE" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,caseholewellvop,0,9;statlevlwellvop "STATLEVL" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,statlevlwellvop,0,9;pumplevlwellvop "PUMPLEVL" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pumplevlwellvop,0,9;pumpgpmwellvop "PUMPGPM" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pumpgpmwellvop,0,9;pumphrswellvop "PUMPHRS" true true false 9 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,pumphrswellvop,0,9;heightvop "Overall Height Span" true true false 64 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,heightvop,0,64;created_user "created_user" true true false 255 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,C:\Users\zzimmerman\OneDrive - Gewalt Hamilton Associates\Desktop\OP Basemap\Basemap.gdb\Basemap.gdb\wHydrant,last_edited_date,-1,-1" # Rename "Z:\ByClient\Prospect Heights\GIS\Mapping\4755_017_SQL_Database\Basemap_3D.sde\DBO.OrlandPark\DBO.wHydrant" "Z:\ByClient\Prospect Heights\GIS\Mapping\4755_017_SQL_Database\Basemap_3D.sde\DBO.OrlandPark\DBO.wHydrant_OP" FeatureClass 20230907 10045700 20230907 10045700 Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 13.0.2.36056 Orland Park Fire Hydrants Orland Park Fire Hydrants Orland Park Fire Hydrants Enterprise Geodatabase Feature Class dataset EPSG 8.9.3(9.3.0.0) 0 Simple FALSE 0 TRUE TRUE DBO.wHydrant Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. ASSETGROUP Asset group Integer 4 10 0 ASSETTYPE Asset type SmallInteger 2 5 0 ASSOCIATIONSTATUS Association status SmallInteger 2 5 0 ISSUBNETWORKCONTROLLER Is subnetwork controller SmallInteger 2 5 0 ISCONNECTED Is connected SmallInteger 2 5 0 SUBNETWORKCONTROLLERNAME Subnetwork controller name String 2000 0 0 TIERNAME Tier name Integer 4 10 0 TIERRANK Tier rank Integer 4 10 0 TERMINALCONFIGURATION Terminal path String 128 0 0 GLOBALID Global ID GlobalID 38 0 0 SystemSubnetworkName System Subnetwork Name String 2000 0 0 SUPPORTEDSUBNETWORKNAME Supported subnetwork name String 2000 0 0 SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String 2000 0 0 creationdate Creation date Date 8 0 0 creator Creator String 255 0 0 lastupdate Last update Date 8 0 0 updatedby Updated by String 255 0 0 diameter diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight Double 8 38 8 secondarydiameter secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width Double 8 38 8 pressure pressure: Amperage, Pressure, Rated Pressure, Volume Double 8 38 8 designtype designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count SmallInteger 2 5 0 normalstatus Normal Status SmallInteger 2 5 0 presentstatus Present Status SmallInteger 2 5 0 additionaldetails additionaldetails: Clockwise to Close, Cooling Method, Critical, Material SmallInteger 2 5 0 designinfo designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage Double 8 38 8 operable Operable SmallInteger 2 5 0 name Name String 64 0 0 installdate Install Date Date 8 0 0 assetid Asset ID String 64 0 0 accountid Account ID String 50 0 0 ownedby Owned By SmallInteger 2 5 0 maintby Maintained By SmallInteger 2 5 0 additionaldevice additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered SmallInteger 2 5 0 notes Notes String 2000 0 0 symbolrotation Symbol Rotation SmallInteger 2 5 0 lastmaint Last Maintenance Date 8 0 0 lifecyclestatus Lifecycle Status SmallInteger 2 5 0 inservicedate In-Service Date Date 8 0 0 retireddate Retired Date Date 8 0 0 spatialsource Spatial Source SmallInteger 2 5 0 spatialconfidence Spatial Confidence SmallInteger 2 5 0 manufacturer Manufacturer SmallInteger 2 5 0 operator Postindicator Valve SmallInteger 2 5 0 locationvop Location String 255 0 0 enclosurevop Enclosure SmallInteger 2 5 0 materialvop Material SmallInteger 2 5 0 pdopvop PDOP Double 8 38 8 datasourcevop Data Source SmallInteger 2 5 0 sectioncodevop Section Code String 64 0 0 objectnumbervop Object Number String 64 0 0 eamidvop EAM ID String 64 0 0 eamdescvop EAM Description String 64 0 0 dqualityvop D Quality Double 8 38 8 nodeidvop NODE ID String 64 0 0 makevop Make String 64 0 0 breakawayvop Breakaway SmallInteger 2 5 0 lastpaintvop Year Constructed SmallInteger 2 5 0 nutdepthvop Nut Depth SmallInteger 2 5 0 yearabandonedvop Year Abandoned SmallInteger 2 5 0 capacityvop Capacity (Gal) Double 8 38 8 pinvop PIN String 13 0 0 elevationvop TOF Elevation Double 8 38 8 yearconstructedvop Year Constructed SmallInteger 2 5 0 contractvop I Contract Num String 64 0 0 cathodicprotectionsysnumvop Cathodic Protection System Num String 64 0 0 tanknovop Tank No String 64 0 0 apiwellvop API Double 8 38 8 longwestwellvop LONG_WEST Double 8 38 8 lamxwellvop LAMX Integer 4 10 0 lamywellvop LAMY Integer 4 10 0 tdwellvop TD Integer 4 10 0 sectwellvop SECT Integer 4 10 0 twpwellvop TWP Integer 4 10 0 tdirwellvop TDIR String 9 0 0 rngwellvop RNG Integer 4 10 0 rdirwellvop RDIR String 9 0 0 nsfwellvop NSF String 9 0 0 nsdirwellvop NSDIR String 9 0 0 ewfwellvop EWF String 9 0 0 ewdirwellvop EWDIR String 9 0 0 cornerwellvop CORNER String 9 0 0 quarterswellvop QUARTERS String 9 0 0 elevwellvop ELEV Integer 4 10 0 elevrefwellvop ELEVREF String 9 0 0 cdatewellvop CDATE Integer 4 10 0 stwellvop ST String 9 0 0 fnamewellvop FNAME String 9 0 0 fnumwellvop FNUM String 9 0 0 cnamewellvop CNAME String 9 0 0 permitnumwellvop PERMITNUM Integer 4 10 0 permitdatewellvop PERMITDATE String 9 0 0 welltypewellvop WELLTYPE String 9 0 0 wformationwellvop WFORMATION String 9 0 0 wfmfromwellvop WFMFROM String 9 0 0 wfmtowellvop WFMTO String 9 0 0 scrndiamwellvop SCRNDIAM String 9 0 0 scrnlgthwellvop SCRNLGTH String 9 0 0 slotwellvop SLOT String 9 0 0 caseholewellvop CASEHOLE String 9 0 0 statlevlwellvop STATLEVL String 9 0 0 pumplevlwellvop PUMPLEVL String 9 0 0 pumpgpmwellvop PUMPGPM String 9 0 0 pumphrswellvop PUMPHRS String 9 0 0 heightvop Overall Height Span String 64 0 0 Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Unknown 0 ASSETTYPE 0 UtilityNetwork_111_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger Flow Valve 1 ASSETTYPE 0 Asset_Type_Water_Device_Flow_Valve The Asset Types for the Water Device's Asset Group Flow Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger System Valve 2 ASSETTYPE 0 Asset_Type_Water_Device_System_Valve The Asset Types for the Water Device's Asset Group System Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger enclosurevop Water_Enclosure_VOP Valves enclosure types Coded Value Default value Duplicate DBO SmallInteger Pressure Valve 3 ASSETTYPE 0 Asset_Type_Water_Device_Pressure_Valve The Asset Types for the Water Device's Asset Group Pressure Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Station 4 ASSETTYPE 0 Asset_Type_Water_Device_Station The Asset Types for the Water Device's Asset Group Station Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Pump 5 ASSETTYPE 0 Asset_Type_Water_Device_Pump The Asset Types for the Water Device's Asset Group Pump Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double secondarydiameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double designtype 0 Water_Pump_Type The different types of pump designs. Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Valve 6 ASSETTYPE 0 Asset_Type_Water_Device_Service_Valve The Asset Types for the Water Device's Asset Group Service Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger operator Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger enclosurevop Water_Enclosure_VOP Valves enclosure types Coded Value Default value Duplicate DBO SmallInteger materialvop Water_Service_Material Materials for water service lines Coded Value Default value Duplicate DBO SmallInteger datasourcevop Water_DataSource_VOP Data Source Coded Value Default value Duplicate DBO SmallInteger Fire Hydrant 7 ASSETTYPE 0 Asset_Type_Water_Device_Fire_Hydrant The Asset Types for the Water Device's Asset Group Fire Hydrant Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Hydrant_Service_Diameter List of hydrant service sizes, in Imperial units Coded Value Default value Duplicate DBO Double secondarydiameter 0 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger manufacturer Water_Fire_Hydrant_Manufacturer The valid hydrant manufacturers Coded Value Default value Duplicate DBO SmallInteger breakawayvop Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger Outlet 8 ASSETTYPE 0 Asset_Type_Water_Device_Outlet The Asset Types for the Water Device's Asset Group Outlet Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Flushing and Blow Off 9 ASSETTYPE 0 Asset_Type_Water_Device_Flushing_and_Blow_Off The Asset Types for the Water Device's Asset Group Flushing and Blow Off Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown normalstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Meter 10 ASSETTYPE 0 Asset_Type_Water_Device_Service_Meter The Asset Types for the Water Device's Asset Group Service Meter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Monitoring 11 ASSETTYPE 0 Asset_Type_Water_Device_Monitoring The Asset Types for the Water Device's Asset Group Monitoring Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Connection 12 ASSETTYPE 0 Asset_Type_Water_Device_Service_Connection The Asset Types for the Water Junction's Asset Group Service Connection Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown additionaldetails 2 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 2 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger System Meter 13 ASSETTYPE 0 Asset_Type_Water_Device_System_Meter The Asset Types for the Water Device's Asset Group System Meter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Supply 15 ASSETTYPE 0 Asset_Type_Water_Device_Supply The Asset Types for the Water Device's Asset Group Supply Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Well_Diameter General list of well sizes Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Filter 17 ASSETTYPE 0 Asset_Type_Water_Device_Filter The Asset Types for the Water Device's Asset Group Filter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Controller 18 ASSETTYPE 0 Asset_Type_Water_Device_Controller The Asset Types for the Water Device's Asset Group Controller Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Injection Facility 19 ASSETTYPE 0 Asset_Type_Water_Device_Injection_Facility The Asset Types for the Water Device's Asset Group Injection Facility Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Storage 20 ASSETTYPE 0 Asset_Type_Water_Device_Storage The Asset Types for the Water Device's Asset Group Storage Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 d_ASSETGROUP d_ASSETGROUP String 255 0 0 d_ASSETTYPE d_ASSETTYPE String 255 0 0 d_ASSOCIATIONSTATUS d_ASSOCIATIONSTATUS String 255 0 0 d_ISSUBNETWORKCONTROLLER d_ISSUBNETWORKCONTROLLER String 255 0 0 d_ISCONNECTED d_ISCONNECTED String 255 0 0 d_TIERNAME d_TIERNAME String 255 0 0 d_diameter d_diameter String 255 0 0 d_secondarydiameter d_secondarydiameter String 255 0 0 d_designtype d_designtype String 255 0 0 d_normalstatus d_normalstatus String 255 0 0 d_presentstatus d_presentstatus String 255 0 0 d_additionaldetails d_additionaldetails String 255 0 0 d_operable d_operable String 255 0 0 d_ownedby d_ownedby String 255 0 0 d_maintby d_maintby String 255 0 0 d_additionaldevice d_additionaldevice String 255 0 0 d_symbolrotation d_symbolrotation String 255 0 0 d_lifecyclestatus d_lifecyclestatus String 255 0 0 d_spatialsource d_spatialsource String 255 0 0 d_spatialconfidence d_spatialconfidence String 255 0 0 d_manufacturer d_manufacturer String 255 0 0 d_operator d_operator String 255 0 0 d_enclosurevop d_enclosurevop String 255 0 0 d_materialvop d_materialvop String 255 0 0 d_datasourcevop d_datasourcevop String 255 0 0 d_breakawayvop d_breakawayvop String 255 0 0 last_edited_date last_edited_date Date 8 0 0 20230907 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwC9DZHR 9bXRXiBjMhuYVk6bSDk89wQf0qXVdKle7bU1lDwBtzoAcntgeua6zxB4enj1nS9QitzMoudkyRnO EYEZ6djXUWljDaW/krauqHtjdWDpuWjJabOR8KW19FerdtaiK2lBIKtxjHBx2zgVyXinWmtvEd1J BbBZ42PmRHJBB/ir2KQWxtZISCgZSMFcV4F4k0eaPVJzIszTSA/vOgKj61NW8I6MmWiK9lFaSyyL cSNK0rDbhTn5ux9O/wCVW7S0gtLxlEjqUfkMx4BHYYzVK3tbm2FqsSQfvSsWQOT6kn8a6n7I+l6h FeZiIDIJlQDgHg/lWEYu9yYrqYulaYL+7v7aZvKjZ/MDkcDqce1VNT0xbS2inQebbklQue9dovhx rvxHr39m7CkEkTKjHg7gCfw61z+q3+I5LC5s2jMQ2CTcQP8AvnoBmnOCS94ckup13wk1G3kS9sxG scwIb745HpivUq8Q+FenXEfieSdnIRYzkDoeeAa9uHSunDv3Cqfwi0UUVsWRzIXjKjvXJy+HdQDs V8lhnj5iD/KuwooA4Z9H1KPraM3+6wP9aga0u0+/aTj/AIATXoFGB6UAecs204YFT7jFAYHvXojR owwygj3FVn0yxk+9aQn/AIAKAOEyPWlyK7Y6LpzDH2SP8BimnQtNP/Lsv4EigDi80V2J8Paax/49 /wAnP+NNPhzTieImH/AzQByFFdYfDNhnOJB/wOm/8IxZZ+/N/wB9UAcrTXztIHU8CurbwvZnpLMP ow/wp0Phu1hmSQSSttOcMRj+VAFnSLQWlhHHjnGT9a0aRVCjApaACsrWNQNjHGVUMWbGD6VqmuT8 SSk3USHgKpP5/wD6qAJk8RL/AB25H+61Tpr9o33hIv1WuY3A96WgDrk1axfpcKP94EVYS5gk+5NG 30YGuJooA7uiuHSaWP7kjr9GIqwmp3qdLh/x5/nQB2FFcsmu3q9WRvqtTDxDPjmFCfrQB1mR6H8q Mj1Fch4I8Xx+Irdrcq/nW6BWkc58w9Ca7ClGSkroSd9QxmszVtIttRtZEkiQuVIVscjIrS2j0pCv uae4zwWW3n0W9MV7EDHCSDHjhc989+1Oltb9pkvrUOlm53lnB6dgBXsWr6BZ6xFsuYlY9mxg0v8A YsDadFZugMcahRjjpXP7J99DPlZ5p4VcQNrMzhpiHR8+20Y/DORW/H4T0zxK0WoMNxDfPHkgN7Gu mtfDen2iy7LcbpUVJCcncB04/Gr2m2MWnWywRLhV/WrUH9rYqze5FaafDYEGGwRCFC5jIzj9KvC4 A+9HKv8AwDP8s1LketLWpRCLqDODKqn0Y4P61KCGGQQR7UpAPUVCbW3Y5MMefULg/nQBNRUP2ZR9 2SVfpIT/ADo8qUfduGP++oP8sUATUVF/pA7xt+a/40nmSjrCT/usP60ATUVD9oA+8ki/VTSi6hJx 5i5oAlopokQ9HU/jXBfELXbm08ixtiY92JGkBweDxipnJQjdibsd/RXm3gTxLcfaDpl0ZJjNIWjZ myUXbz+tekg5pU5qcboE7hRRQTgZNWMKK5+TxlpEeotZGYl1wCwGRnOMVvggjIpKSewC0UUUwCo5 LeGX/WRq31GakooAoyaPp8n3rZPwFVZPDVg/3Q6H2atiigDnZPCqf8s7px7MAarP4Yul+5cRt9QR XV0UAca3h/UV6JG30aoH0nUY+toxHqpBruaKAPPXgnj+/bzL9UNRF1BwTg+9ejYB7Unlp/dH5UAe D+EfEsOkanG5bKdWRT2Ir3S2nS5t45k+66givBJbS3stThE1iyyx4jdFOQzdc+4r27Q7x73TIZJI xG2OVCkAfga5sO2rxZnT7GnRRRXSaBRRRQAUUUUAFJgelLRQAmPc0c+tLRQAnPpRn2NLRQAmRS5B 6GikwD2oAWggEYIzSbR/+qjHuaAI2giIz5SZ+leZeNvCl1dX8+pROSiwkbCTwMHNeo4Pr+lNaMOC GVSD60nFNWYHmvgvwneWN6t7cXDKUXbFGACAMdTXoqrcqOJEb6ripVRV6Jj6U7IpRioqyElYi3zj rCpHqGrP1vUlstJuZ5IZQEQnj/61auQe9Q3Vsl1A0UihkYYIPQ1Qz5/tbkz3xMaHMp3qyDJBBzXv OkuG022G/cwjXOWyc471z+meCrXStZlvLZFRHUAIB909yPTNdOtrDtAaND9RWNKlyXJSsT0VD9mj H3d6/wC65H9aPJkH3biT6MFI/lWxRNRUJW5HSSI/VCP60m65HWKJvo5H9KAJ6Kg89x963lHuMH+R o+1xD7xZP99SP50AT0VGs8T/AHZFP0NSAg9DQAUUUUAFFFFAHGWPhGM3f2i82ykncq44U11kEHlK ADxSrIm0Eqyf7ykYqRXRvusD9DUxioqyElYXmjPtS0VQwzRRRQAUUmKRWVs7XBwcHB6GgB1FJz60 c+lAC0UmaXIoAKKKKACiiigAooooAKKKKACiiigAwD2pNopaKAE2+5owfWlooATn2oyfSlooATcP ejI9RS0YFABRSbR6UY9zQA1oo3+9GrfUUz7LD2Ur/usRUuD6/mKOfQfnQBF5DD7s0g9ic0bJx0lV vquKlyfQ0bh7/lQBFuuF6xo3+62KPOkHWB/wIqXcPUUtABTWRG+8qn6inUUAR+So6Fl+hpdjjpJ+ YzT6KAI8yjsp+ho8xh96Nh9OakooAj81DxnH1rL0XRl0q41GRLkypeXJuAmP9WSACOvtmtggHrTT Gh6qKB3ew6imeUvYsPoaTY46SH8QKBElFR5mHZG/HFHmEfejce45oAfgUY96Z58ecFwp9G4/nUnW gBOaOfSlooATNLkUUUAFFGBSYoAWik59aOaAFopM+1GRQAtFFFABRRRQAUUU13EcbOc4UZOBmgB1 FeaXfxWe21GRF0lntUbbu34b/D8K9C0++j1LT4LyEMI5kDgMORmojUjPSLEpJ7FmiiirGFFFFABS bR6ClooAKKKKACimu4Qe9RCc9wKAJ6KiE6nrkU8Op6MKAHUUUUAFFFFABRRSEhRknFAC1GYIj/AA fVeD+lPDA9CDS0AR+UR92Rx7Zz/OjEw6MjfUYqSigCPe46xn8DR5yfxbl+oqSigBokRujA/jTqaY 0PVR+VN8lR90sv0NAElFR7HHSQ/iM0fvh/cb9KAJKKj8xh96JvqMGjz4+7bf94Y/nQBJgelJigMG GQQR7UtACc+tHNLRQAmfavO/ijrl3aWkGn2koiWb55nB+bAPQen9a9FrkPHPhyHWNNaXIjljwTJj J2jOR+tRUTcXYmV7aHhyNPduFEkisidQcZr2X4XXd3c6BKlwylIZPLVf4lI65ryjTNPmvNTntrBH uAH8vd9K9s8HeHm0DTnjaQu8rb2Nc1GL9pciK946aik/Gjmuw1FopM+1GRQAtZt5rVrZ3BhkkjDA ZILgVJq+oxaXpdxeSyrGsaE7m6A9q+bNUk1fU9TuLya+AeVy3fp2rGrV5CJSsfUNNdwgz3odwgye tVWYscmtiwZixyaSiigAooooAUMR0JFPEzjvmo6KAJxceq/lTxKh74qrRQBc3DGciq0km9uOgqMj IpoJU4NAD6cHYdGNNoFAEonYdQDTxOO4IqDBpKALQlQ96eCD0NUqASOhoAu0VVErjvThOe4FAFii ohOp6giniRT0YUAOooooAY0MTHJRc+uOaTycfdkkX/gWf55qSigCPbKOkgP+8v8AhRmUdUU/Rqko oAj83H3o3H4Z/lUc3kzoY3IIIwQasUEAjBGaAMXT/DWmadcPNaW8cbOxZtoAyT1NbIGBTTDGf4QP pxSeSOzuPoaSSWwElFR7JB0kz9RRmYdVRvocUwJKKj81h96Jvw5o8+Pu2P8AeBFAGD4z0mTWvDlz ZRKC7gEAjrg5xXkFz8LfEN3N5qXDRDAGwvjGPxr38Mrjghh7GjYvpWcqcZO7JcUyoWLnJopBS1oU FFKBS0AJijFLRQAmKSnUUANopTRQAlIRkU6igBigg4NPoooAcKKavpTqADApCKWigBuKKDRQAUUU UARXNx9mt3lzyBx7ntWgv3Rn0rm9Yn33Vvaqf4wW/PiulHSgAooooAKKKKACiiigAooooAKKKKAC jGaKKAGNDGxyUUn6U37OnrIPpIw/rUtFAFIDiloooAKWkpaACiiigAooooAKSlpKACiiigAooooA KdTaUHtQAtFFFACGkp1NNABSOwRGZugGTS1ma3c+TZ+WD80nH4UAY8MputZikP8AFKD+tduOlcJp mTqlsAMndmu6HSgBaKKKACiiigAoooPSgAoqITjuDThKh70APooyDRQAUUUUAFFFFAFOiiigAooo oAWiiigAooooAKDRRQAlFFFABRRRQAUdOaKx/EN4YLB4kOJJAR9BQBtUVxFnfXUMKeXO446ZyPyr Sh1+5TiREkH5GgDpaQ1lReILZ+JEdD+Yq9FfW0/+rmQn0zQBNXK6tc/aL5sH5U+UV0N/cC2s5JQR nGF+tceST7kn9aANzw1a+ZPJdMOF+Vf611NUdJtRaWEcffGT9avUAFFFFABRRRQAU2Q4QmnVFOcI B6mgCvS4pKWgAyR3pwlcd6bSYoAmE57iniZT1yKrUUAXA6noRS1Spdx9TQAUUUUAFFFFABS0lFAC 0UUUAFFFFACGilpKACiiigBGYIhZjgAZJrjNUuTdySyHpjCj2rd1y78uEW6n5n6+wrm5OY2+lADL b/UJ9KlqC0ObdanoAKKKKAHmWRk2F2K9cE1a0m2+1alGpHyp8xqlXS+GrXbA9ww5c4H0oA3wMACl oooAKKKKACiiigAqvOfmA9KsVUkOZDQAgooooAKKKKACkpaKAEopaSgDkYdRuoPuTNj0PNaEPiBx gTRBvdTisWigDqodXs5uPM2H0YYq8rq4yrBh6g5rh6fHNLEcxyMp9jQB21FcxDrd3Fw5WQf7Q5/O tGHX7d+JUeM+o5FAGvRUEN3bz/6qVG9geanoAKKKKACkpaDQAlNkdY42djhVGTTqxdeu9qLaoeW5 f6elAGNd3DXVy8rdzwPQVXf7jfSnVd0q0+2agiEZRPmagCnDp17BbgyWzgHnIGaTPODwfQ16GEAU DHFQT6fa3AxLCjfUUAcHRXUz+GbV8mF3iPscj9azJ/Dt7FkxlJR7cGgDLRGlkWNfvMQBXeWkC29t HEvRRiub0XTZxqO+eFkEYyNw6muroAKKKKACiiigAooooAQnAJqp1NWZTiM1WoAKKKKACiiigAoo ooAKKKKAOGooooAKKKKACiiigABIOR1q3DqV3B92ZiPRuaKKANGHxCw4mhz7qa0IdWs5sASbT6Nx RRQBdVlcZVgR6g0tFFAEc0qwQvI54UZrjriZrid5WPLHNFFAEVdX4es/Js/OYfPJz+HaiigDaooo oAKKKKADFFFFABRRRQAUUUUAFFFFAEM54AqGiigAooooAKKKKACiiigBQKWiigD/2Q==