Name: WaterDevice

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1928167.04500072
YMin: 767822.959952727
XMax: 2001377.80179414
YMax: 829467.285482734
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[54,161,170,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• TIERNAME (type: esriFieldTypeSmallInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: true)
• SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: false, editable: true)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Surveyor (type: esriFieldTypeString, alias: Surveyor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LCR_CustType (type: esriFieldTypeString, alias: LCR Cust Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• PressureZone (type: esriFieldTypeSmallInteger, alias: Pressure Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Operation (type: esriFieldTypeString, alias: Operation, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SerialNum (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ImageHyperlink (type: esriFieldTypeString, alias: Image Hyperlink, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ImageHyperlink2 (type: esriFieldTypeString, alias: ImageHyperlink2, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ZoneSeparator (type: esriFieldTypeSmallInteger, alias: Zone Separator, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PDFHypderlink (type: esriFieldTypeString, alias: PDF Hyperlink, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• HighTorque (type: esriFieldTypeSmallInteger, alias: High Torque, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Remarks (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Insp_NormPosition (type: esriFieldTypeString, alias: Inspection Normal Position, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Inp_CloseDir (type: esriFieldTypeString, alias: Inspection Close Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Inp_PositionFound (type: esriFieldTypeString, alias: Inspection Position Found, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Inp_Notes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Insp_Street (type: esriFieldTypeString, alias: Inspection Street, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Insp_Operation (type: esriFieldTypeString, alias: Inspection Operation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Insp_Condition (type: esriFieldTypeString, alias: Inspection Condition, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Insp_CrossStreet (type: esriFieldTypeString, alias: Inspection Cross Street, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Insp_ValveType (type: esriFieldTypeString, alias: Inspection Valve Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Insp_SessionID (type: esriFieldTypeString, alias: Inspection Session ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Watertype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ValveSize (type: esriFieldTypeDouble, alias: Valve Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Municipality (type: esriFieldTypeSmallInteger, alias: Municipality, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SampleSite_ID (type: esriFieldTypeString, alias: Sample Site ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Insp_ValvSize (type: esriFieldTypeString, alias: Inspection Valve Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OverflowElevation (type: esriFieldTypeDouble, alias: Overflow Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InspectionID (type: esriFieldTypeString, alias: Inspection ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GPSDate (type: esriFieldTypeDate, alias: GPSDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Meter_Number (type: esriFieldTypeString, alias: Meter_Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ServicePointNumber (type: esriFieldTypeString, alias: ServicePointNumber, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ServiceType (type: esriFieldTypeString, alias: ServiceType, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Meter_Size (type: esriFieldTypeString, alias: Meter_Size, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Meter_Status (type: esriFieldTypeString, alias: Meter_Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Install_Date (type: esriFieldTypeDate, alias: Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Premise_Number (type: esriFieldTypeString, alias: Premise_Number, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Route (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Billing_Cycle (type: esriFieldTypeString, alias: Billing_Cycle, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Account_Number (type: esriFieldTypeString, alias: Account_Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Account_Status (type: esriFieldTypeString, alias: Account_Status, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Account_Type (type: esriFieldTypeString, alias: Account_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Customer_Number (type: esriFieldTypeString, alias: Customer_Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Customer_Name (type: esriFieldTypeString, alias: Customer_Name, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Phone_Mobile (type: esriFieldTypeString, alias: Phone_Mobile, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Phone_Home (type: esriFieldTypeString, alias: Phone_Home, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Premise_Type_Number (type: esriFieldTypeString, alias: Premise_Type_Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Customer_Type (type: esriFieldTypeString, alias: Customer_Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MailAddress_Line1 (type: esriFieldTypeString, alias: MailAddress_Line1, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MailAddress_Line2 (type: esriFieldTypeString, alias: MailAddress_Line2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MailAddress_Line3 (type: esriFieldTypeString, alias: MailAddress_Line3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MailAddress_Zip (type: esriFieldTypeString, alias: MailAddress_Zip, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MeterLocationDescrip (type: esriFieldTypeString, alias: MeterLocationDescrip, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Rate_Code (type: esriFieldTypeString, alias: Rate_Code, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Meter_Connection_Install_Date (type: esriFieldTypeDate, alias: Meter_Connection_Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Business_Name (type: esriFieldTypeString, alias: Business_Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Phone_Business (type: esriFieldTypeString, alias: Phone_Business, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Service_Address (type: esriFieldTypeString, alias: Service_Address, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• SurveyDate (type: esriFieldTypeDate, alias: SurveyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ManufacturerYear (type: esriFieldTypeString, alias: Manufacturer Year, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• PremiseID (type: esriFieldTypeString, alias: Premise ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Service_City (type: esriFieldTypeString, alias: Service_City, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ServiceZip (type: esriFieldTypeString, alias: Service_Zip, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Premise_Type (type: esriFieldTypeString, alias: Premise_Type, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Parcel_Pin (type: esriFieldTypeString, alias: Parcel_Pin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Mail_Address_State (type: esriFieldTypeString, alias: MailAddress_State, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• DisinfectionByproductSite (type: esriFieldTypeSmallInteger, alias: DisinfectionByproductSite, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• X_Coord (type: esriFieldTypeDouble, alias: X_Coord, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_Coord (type: esriFieldTypeDouble, alias: Y_Coord, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Critical (type: esriFieldTypeString, alias: Critical, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Service_OW_Source (type: esriFieldTypeString, alias: Service OW Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Service_OW_Comment (type: esriFieldTypeString, alias: Service OW Comment, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Service_Cust_Source (type: esriFieldTypeString, alias: Service Cust Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Service_Cust_Comment (type: esriFieldTypeString, alias: Service Cust Comment, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Service_OW_Date (type: esriFieldTypeDate, alias: Service OW Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Service_Cust_Date (type: esriFieldTypeDate, alias: Service Cust Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Service_OW_Material (type: esriFieldTypeSmallInteger, alias: Service OW Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Service_Cust_Material (type: esriFieldTypeSmallInteger, alias: Service Cust Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MailAddress_City (type: esriFieldTypeString, alias: MailAddress_City, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• LocationID (type: esriFieldTypeString, alias: LocationID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: WaterDevice
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• VALIDATIONSTATUS: 6
• ASSETGROUP: 0
• ASSETTYPE: 0
• ASSOCIATIONSTATUS: 0
• ISSUBNETWORKCONTROLLER: 0
• ISCONNECTED: 2
• SUBNETWORKCONTROLLERNAME: Unknown
• TIERNAME: 0
• TIERRANK: 0
• TERMINALCONFIGURATION: Default
• SystemSubnetworkName: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• PressureSubnetworkName: Unknown
• IsolationSubnetworkName: Unknown
• DMASubnetworkName: Unknown
• operable: 1
• ownedby: 1
• maintby: 1
• lifecyclestatus: 0
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/9/2025 2:46:15 PM

Schema Last Edit Date: 6/9/2025 2:46:15 PM

Data Last Edit Date: 6/9/2025 2:46:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat