Name: Water_Mains_HDR_Leak_Potential

Display Field: VERSIONNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2069928.5671455
YMin: 220760.851723984
XMax: 2112160.05781358
YMax: 252265.195211232
Spatial Reference: 102677 (3419)

Drawing Info:

{"renderer":{"type":"classBreaks","field":"Leak_Potential__GPM_","classificationMethod":"esriClassifyManual","minValue":4077.1863513771559,"classBreakInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"classMaxValue":10000,"label":"<10,000","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[139,209,0,255],"width":1},"classMaxValue":20000,"label":"10,000-20,000","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"classMaxValue":30000,"label":"20,000-30,000","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,128,0,255],"width":1},"classMaxValue":70000,"label":"30,000-70,000","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"classMaxValue":163255.30244512064,"label":">70,000","description":""}]},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LINETYPE (type: esriFieldTypeString, alias: Main Line Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PIPECLASS (type: esriFieldTypeString, alias: Pipe Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LABELFIELD (type: esriFieldTypeString, alias: Label Field, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OPERATIONAREA (type: esriFieldTypeString, alias: Operation Area, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FLOWMETERID (type: esriFieldTypeString, alias: Flow Meter ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: WORKORDERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECT (type: esriFieldTypeString, alias: ProjectNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CONTRACTEDBY (type: esriFieldTypeString, alias: Contracted By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ENGINEEREDBY (type: esriFieldTypeString, alias: Engineered By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PRESSURETESTED (type: esriFieldTypeDate, alias: Pressure Tested, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BACTERIATESTED (type: esriFieldTypeDate, alias: Bacteria Tested, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTPASSDATE (type: esriFieldTypeDate, alias: InspectionPassedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATIONALDATE (type: esriFieldTypeDate, alias: Operational Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SERIALNO_LOTNO (type: esriFieldTypeString, alias: SerialNo_LotNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• EXTCOVERING (type: esriFieldTypeString, alias: Ext Covering, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TRACEWIRE (type: esriFieldTypeString, alias: Trace Wire, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HYPERLINK (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VERSIONNAME (type: esriFieldTypeString, alias: VERSIONNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PPG_NUMBER (type: esriFieldTypeString, alias: Pipel Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PPG_ID (type: esriFieldTypeInteger, alias: Pipe_RecID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPG_DB (type: esriFieldTypeSmallInteger, alias: In Lucity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOINTTYPE (type: esriFieldTypeString, alias: JOINTTYPE, SQL Type: sqlTypeOther, length: 20, 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Age (type: esriFieldTypeDouble, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ServiceConnections (type: esriFieldTypeDouble, alias: Connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EMAG_Inspection (type: esriFieldTypeString, alias: EMAG_Inspection, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FacilityID_2 (type: esriFieldTypeString, alias: FacilityID_2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FacilityID_23 (type: esriFieldTypeString, alias: FacilityID_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flow_gpm_ (type: esriFieldTypeDouble, alias: Flow(gpm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Model_Label (type: esriFieldTypeString, alias: Model Label, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pressure__psi_ (type: esriFieldTypeDouble, alias: Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pipe_Cross_Sectional_Area__sq_f (type: esriFieldTypeDouble, alias: Pipe Cross Sectional Area (sq ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Failure_Mode (type: esriFieldTypeString, alias: Failure Mode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• F__of_Cx_Sxn_Area (type: esriFieldTypeDouble, alias: % of Cx Sxn Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Area_of_Opening__sq_ft_ (type: esriFieldTypeDouble, alias: Area of Opening (sq ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Leak_Time__Hour_ (type: esriFieldTypeDouble, alias: Leak Time (Hour), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sqrt_2_Gravity_Head__Feet__ (type: esriFieldTypeDouble, alias: Sqrt(2*Gravity*Head (Feet)), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Leak_Potential__GPM_ (type: esriFieldTypeDouble, alias: Leak Potential (GPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Peak_Hourly_Volume_Loss__Gal_ (type: esriFieldTypeDouble, alias: Peak Hourly Volume Loss (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeInteger, alias: ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Water_Mains_HDR_Leak_Potential
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LINETYPE: Distribution
• DIAMETER: 8
• MATERIAL: PVC
• WATERTYPE: Potable
• ENABLED: 1
• ACTIVEFLAG: 1
• OWNEDBY: 1
• MAINTBY: 4
• TRACEWIRE: Yes
• PPG_DB: 0
• JOINTTYPE: BellSpigot

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/27/2023 11:10:09 PM

Schema Last Edit Date: 1/27/2023 11:10:09 PM

Data Last Edit Date: 1/27/2023 11:10:09 PM

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