View In:   ArcGIS Online Map Viewer

Name: Water System Hydrant Lead

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 474075fb90a545ae80ce641350fa6551

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9027.977411

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8638364.682330124
YMin: 4502504.525291162
XMax: -8614648.868947353
YMax: 4523563.89128177
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LifeCycleStatus
Field 2: Subtype
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 92, 230, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: ,1
  Label: ,Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 1
• Value: Active,1
  Label: Active,Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 1
• Value: Active,2
  Label: Active,Transmission
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 178, 255, 255]
  Width: 1
• Value: Active,3
  Label: Active,Service
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [158, 215, 194, 255]
  Width: 1
• Value: Proposed,1
  Label: Proposed,Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: Proposed,2
  Label: Proposed,Transmission
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: Proposed,3
  Label: Proposed,Service
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 127, 127, 255]
  Width: 1
• Value: Unknown,1
  Label: Unknown,Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• EditBy ( type: esriFieldTypeString, alias: Edit By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 35, defaultValue: null, modelName: LifeCycleStatus , Coded Values: [Active: Active] , [Inactive: Inactive] , [Proposed: Proposed] , ...5 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallContractor ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InstallContractor , Coded Values: [AMERICAN INFRUSTRUCTURE: AMERICAN INFRUSTRUCTURE] , [CITY OF RICHMOND: CITY OF RICHMOND] , [CITY OF RICHMOND/HENKELS & MCCOY: CITY OF RICHMOND/HENKELS & MCCOY] , ...74 more... )
• ConstructionInspector ( type: esriFieldTypeString, alias: Construction Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionInspector , Coded Values: [ANTONIO TONY PYZOWSKI: ANTONIO TONY PYZOWSKI] , [BILLY OVERMAN: BILLY OVERMAN] , [BRADLEY JOHNSON: BRADLEY JOHNSON] , ...103 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• WorkOrderNumber ( type: esriFieldTypeString, alias: Work Order Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkOrderNumber )
• ConstructionDrawing ( type: esriFieldTypeString, alias: Construction Drawing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionDrawing )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: Subtype , Coded Values: [1: Distribution] , [2: Transmission] , [3: Service] )
• PressureGravity ( type: esriFieldTypeString, alias: Pressure or Gravity, editable: true, nullable: true, length: 10, defaultValue: Pressure, modelName: PressureGravity , Coded Values: [Gravity: Gravity] , [Pressure: Pressure] , [Unknown: Unknown] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Material , Coded Values: [Cast Concrete: Cast Concrete] , [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , ...3 more... )
• LiningMaterial ( type: esriFieldTypeString, alias: Lining Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LiningMaterial , Coded Values: [Cement: Cement] , [None: None] , [Unknown: Unknown] )
• PipeSize ( type: esriFieldTypeDouble, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: PipeSize , Coded Values: [0: Unknown] , [4: 4"] , [6: 6"] , ...1 more... )
• JointType_1 ( type: esriFieldTypeString, alias: Joint Type 1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: JointType_1 , Coded Values: [Cement: Cement] , [Compression Coupling: Compression Coupling] , [Flanged: Flanged] , ...6 more... )
• JointType_2 ( type: esriFieldTypeString, alias: Joint Type 2, editable: true, nullable: true, length: 30, defaultValue: null, modelName: JointType_2 , Coded Values: [Cement: Cement] , [Compression Coupling: Compression Coupling] , [Flanged: Flanged] , ...6 more... )
• MeasuredLength ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MeasuredLength )
• PublicPrivate ( type: esriFieldTypeString, alias: Public/Private, editable: true, nullable: true, length: 10, defaultValue: Public, modelName: PublicPrivate , Coded Values: [Private: Private] , [Public: Public] , [Unknown: Unknown] )
• CleanedLinedEndDate ( type: esriFieldTypeDate, alias: Cleaned and Lined End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CleanedLinedEndDate )
• CorrosiveSoil ( type: esriFieldTypeString, alias: Corrosive Soil, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CorrosiveSoil , Coded Values: [No: No] , [Unknown: Unknown] , [Yes: Yes] )
• ContaminatedSoil ( type: esriFieldTypeString, alias: Contaminated Soil, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ContaminatedSoil , Coded Values: [No: No] , [Unknown: Unknown] , [Yes: Yes] )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• WaterTraceWeight ( type: esriFieldTypeInteger, alias: WaterTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: WaterTraceWeight )
• OperatingPressure ( type: esriFieldTypeDouble, alias: OperatingPressure, editable: true, nullable: true, defaultValue: null, modelName: OperatingPressure )
• PipeStatusIndicator ( type: esriFieldTypeInteger, alias: PipeStatusIndicator, editable: true, nullable: true, defaultValue: null, modelName: PipeStatusIndicator , Coded Values: [0: Closed] , [1: Open] )
• PipeType ( type: esriFieldTypeString, alias: PipeType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeType , Coded Values: [NP: Non-Pinchable] , [P: Pinchable] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• InServiceDate ( type: esriFieldTypeDate, alias: In Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InServiceDate )
• AbandonedDate ( type: esriFieldTypeDate, alias: Abandoned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AbandonedDate )
• PressureZone ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureZone , Coded Values: [1 NORTH: 1 NORTH] , [1 SOUTH: 1 SOUTH] , [2 NORTH: 2 NORTH] , ...10 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: 1
Name: Distribution
Domains:
Templates:
• Name: , 1
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: null
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 1
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Active, 1
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Active
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 1
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Proposed, 1
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Proposed
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 1
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Unknown, 1
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Unknown
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 1
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Transmission
Domains:
Templates:
• Name: Active, 2
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Active
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 2
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Proposed, 2
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Proposed
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 2
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Service
Domains:
Templates:
• Name: Active, 3
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Active
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 3
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Proposed, 3
  Description:
  Prototype:
  PressureZone: null
  AbandonedDate: null
  AssetID: null
  Location: null
  InServiceDate: null
  LifeCycleStatus: Proposed
  InstallDate: null
  InstallContractor: null
  ConstructionInspector: null
  Comments: null
  WorkOrderNumber: null
  ConstructionDrawing: null
  Subtype: 3
  PressureGravity: null
  Material: null
  LiningMaterial: null
  PipeSize: null
  JointType_1: null
  JointType_2: null
  MeasuredLength: null
  PublicPrivate: null
  CleanedLinedEndDate: null
  CorrosiveSoil: null
  ContaminatedSoil: null
  Enabled: 1
  WaterTraceWeight: null
  OperatingPressure: null
  PipeStatusIndicator: null
  PipeType: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata