Name: Existing Charles County Water Main (16”)

Display Field: ENABLED

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 1263944.66721805
YMin: 214732.045431021
XMax: 1404820.07041322
YMax: 370599.283547464
Spatial Reference: 3582 (3582)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":4}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 7 more ...)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OperationalArea, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Benedict: Benedict], [Waldorf: Waldorf], [Bryans Road: Bryans Road], ... 7 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 1 more ...)
• SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: WORKORDERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FLOWMEASUREMENTID (type: esriFieldTypeString, alias: FLOWMEASUREMENTID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Treated: Treated Water], [Combined: Combined Waste Water], [Potable: Potable Water], ... 6 more ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [CI: Cast Iron], [PVC: Poly Vinyl Chloride], ... 7 more ...)
• EXTERIORCOATING (type: esriFieldTypeString, alias: EXTERIORCOATING, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• JOINTTYPE1 (type: esriFieldTypeString, alias: JointType1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flange: Flange], [Weld: Weld], [Bond: Bond], ... 2 more ...)
• JOINTTYPE2 (type: esriFieldTypeString, alias: JointType2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flange: Flange], [Weld: Weld], [Bond: Bond], ... 2 more ...)
• LININGTYPE (type: esriFieldTypeString, alias: LININGTYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PIPECLASS (type: esriFieldTypeString, alias: PIPECLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUGHNESS (type: esriFieldTypeDouble, alias: ROUGHNESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTH (type: esriFieldTypeInteger, alias: DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 inch], [2: 2 inch], [4: 4 inch], ... 17 more ...)
• PIPELENGTH (type: esriFieldTypeDouble, alias: PIPELENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAXFLOWRATE (type: esriFieldTypeString, alias: MAXFLOWRATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GROUNDSURFACETYPE (type: esriFieldTypeString, alias: GROUNDSURFACETYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Concrete: Concrete], [Grass: Grass], [Soil: Soil], ... 3 more ...)
• PRESSURERATING (type: esriFieldTypeString, alias: PRESSURERATING, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UTIL_ID (type: esriFieldTypeInteger, alias: UTIL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UTILITYQUALITYLEVEL (type: esriFieldTypeString, alias: UTILITYQUALITYLEVEL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 1 more ...)
• SOURCEDOCACCURACY (type: esriFieldTypeString, alias: SOURCEDOCACCURACY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [High: High], [Low: Low])
• CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATIONDATE (type: esriFieldTypeDate, alias: CREATIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• QCSTATUS (type: esriFieldTypeString, alias: QCSTATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Ready for QC: Ready for QC], [Passed QC: Passed QC], [Passed QC with Errors: Passed QC with Errors], ... 1 more ...)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SYSTEMCODE (type: esriFieldTypeString, alias: System Code, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• ORG (type: esriFieldTypeString, alias: ORG, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DESC_ (type: esriFieldTypeString, alias: DESC, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• DEPT (type: esriFieldTypeString, alias: DEPT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SubtypeLabel (type: esriFieldTypeString, alias: SubtypeLabel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YearBuilt (type: esriFieldTypeDate, alias: YearBuilt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ServiceLife (type: esriFieldTypeSmallInteger, alias: ServiceLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RemainingLife (type: esriFieldTypeSmallInteger, alias: RemainingLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Criticality (type: esriFieldTypeString, alias: Criticality, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OriginalCost (type: esriFieldTypeSmallInteger, alias: OriginalCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CurrentValue (type: esriFieldTypeSmallInteger, alias: CurrentValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReplacementCost (type: esriFieldTypeSmallInteger, alias: ReplacementCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SalvageValue (type: esriFieldTypeSmallInteger, alias: SalvageValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ECO (type: esriFieldTypeSmallInteger, alias: ECO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [JS: John Smith], [MC: McManus], [JF: John Foundry], ... 2 more ...)
• ManufactureDate (type: esriFieldTypeDate, alias: ManufactureDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BatchNumber (type: esriFieldTypeString, alias: BatchNumber, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• InteriorDiameter (type: esriFieldTypeDouble, alias: InteriorDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExteriorDiameter (type: esriFieldTypeDouble, alias: ExteriorDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UOM (type: esriFieldTypeString, alias: UOM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MANAGED_FLAG (type: esriFieldTypeString, alias: MANAGED_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GISOBJID (type: esriFieldTypeInteger, alias: GISOBJID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asset_MasterNbr (type: esriFieldTypeInteger, alias: Asset_MasterNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYSTEMCODE2 (type: esriFieldTypeString, alias: System Code 2 EAM, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Existing Charles County Water Main (16”)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Active
• ENABLED: 1
• WATERTYPE: Potable
• JOINTTYPE1: Flange
• UTILITYQUALITYLEVEL: D
• ADMINISTRATIVEAREA: Charles Utilities
• SUBTYPE: 5
• MATERIAL: PVC
• JOINTTYPE2: Flange
• DIAMETER: 12
• SOURCEDOCACCURACY: High

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/4/2025 3:38:51 AM

Schema Last Edit Date: 1/4/2025 3:38:51 AM

Data Last Edit Date: 1/4/2025 3:38:51 AM

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