View In:   ArcGIS Online Map Viewer

Name: PortalMFRDHydrantLayer1.1

Display Field: Service_Status

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 10b89e65bfa3487f998f6eb1ac8bb9d4

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -9631243.6769
YMin: 4267996.106299996
XMax: -9610217.0559
YMax: 4292915.841799997
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Current_Hydrant_Color
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: all other values
UniqueValueInfos:
• Value: Blue
  Label: Blue
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Green
  Label: Green
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Orange
  Label: Orange
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Red
  Label: Red
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: MD
  Label: Flow Data Missing DO NOT Paint
  Description: N/A
  Symbol:
  
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: Current_Hydrant_Color

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Service_Status ( type: esriFieldTypeString, alias: Service Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Service_Status , Coded Values: [IS: In Service] , [OS: Out of Service] )
• SystemOperator ( type: esriFieldTypeString, alias: System Operator, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SystemOperator , Coded Values: [CUD: CUD] , [MWSD: MWSD] , [PRIV: Private] )
• ImportHydrantColor2021 ( type: esriFieldTypeString, alias: Previous Year Hydrant Color, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ImportHydrantColor2021 )
• Current_Hydrant_Color ( type: esriFieldTypeString, alias: Current Hydrant Color, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Current_Hydrant_Color , Coded Values: [Red: Red] , [Orange: Orange] , [Green: Green] , ...2 more... )
• Hydrant_Number ( type: esriFieldTypeString, alias: Hydrant Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Hydrant_Number )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LocationDescription )
• SubZone ( type: esriFieldTypeString, alias: SubZone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubZone )
• Responsible_Station ( type: esriFieldTypeString, alias: Responsible Station, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Responsible_Station , Coded Values: [1: Station 1] , [2: Station 2] , [3: Station 3] , ...9 more... )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Import_ObservedFlow_2021 ( type: esriFieldTypeDouble, alias: Previous Year Observed Flow, editable: true, nullable: true, defaultValue: null, modelName: Import_ObservedFlow_2021 )
• Import_Available_Fire_Flow_2021 ( type: esriFieldTypeDouble, alias: Previous Year Available Flow , editable: true, nullable: true, defaultValue: null, modelName: Import_Available_Fire_Flow_2021 )
• WaterMainSize ( type: esriFieldTypeString, alias: Water Main Size, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WaterMainSize )
• ImportInspectionDate2021 ( type: esriFieldTypeDate, alias: Previous Year Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ImportInspectionDate2021 )
• ImportInspectionType2021 ( type: esriFieldTypeString, alias: Previous Year Inspection Tyep, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ImportInspectionType2021 , Coded Values: [FLUSH: Flush] , [FLOW: Flow Test] , [IN: Inspection Needed] , ...1 more... )
• MaintenancReq ( type: esriFieldTypeString, alias: Maintenanc Request, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaintenancReq , Coded Values: [Y: Yes] , [N: No] )
• MaintenaneReqInfo ( type: esriFieldTypeString, alias: Maintenane Request Info, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaintenaneReqInfo )
• InspectionPF ( type: esriFieldTypeString, alias: Inspection Pass/Fail, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InspectionPF , Coded Values: [PASS: Inspection Passed] , [FAIL: Inspection Failed] )
• InspectionFailInfo ( type: esriFieldTypeString, alias: Inspection Fail Info, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InspectionFailInfo )
• MaintEmail ( type: esriFieldTypeString, alias: MaintEmail, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaintEmail )
• CurrentObservedFlow ( type: esriFieldTypeDouble, alias: Current Year Observed Flow, editable: true, nullable: true, defaultValue: null, modelName: CurrentObservedFlow )
• CurrentAvailFlow ( type: esriFieldTypeDouble, alias: Current Year Available Flow, editable: true, nullable: true, defaultValue: null, modelName: CurrentAvailFlow )
• AssignmentDate ( type: esriFieldTypeDate, alias: Inspection Assignment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AssignmentDate )
• AssignmentDueDate ( type: esriFieldTypeDate, alias: Inspection Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AssignmentDueDate )
• InspectionType ( type: esriFieldTypeString, alias: Current Inspection Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionType , Coded Values: [FLUSH: Flush] , [FLOW: Flow Test] , [IN: Inspection Needed] , ...1 more... )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient, editable: true, nullable: true, defaultValue: 0.9, modelName: Coefficient )
• DischargeDiam ( type: esriFieldTypeDouble, alias: Discharge Diam, editable: true, nullable: true, defaultValue: 2.5, modelName: DischargeDiam )
• PitotPressure ( type: esriFieldTypeDouble, alias: Pitot Pressure, editable: true, nullable: true, defaultValue: null, modelName: PitotPressure )
• StaticPressure ( type: esriFieldTypeDouble, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: StaticPressure )
• ResidualPressure ( type: esriFieldTypeDouble, alias: Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: ResidualPressure )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• AvailFlowCopy ( type: esriFieldTypeString, alias: AvailFlowCopy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AvailFlowCopy )
• InspectionCompDate ( type: esriFieldTypeDate, alias: Current Inspection Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionCompDate )
• InspectioCompBy ( type: esriFieldTypeString, alias: Inspection Completed By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectioCompBy , Coded Values: [22-3309: ABERCROMBIE, DALEON (COY)] , [22-2102: ABURTO, GAVINO] , [22-6422: ADAM, JEFFREY] , ...280 more... )
• PreYearPitot ( type: esriFieldTypeDouble, alias: Previous Year Pitot Pressure, editable: true, nullable: true, defaultValue: null, modelName: PreYearPitot )
• PreYearStatic ( type: esriFieldTypeDouble, alias: Previous Year Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: PreYearStatic )
• PreYearResd ( type: esriFieldTypeDouble, alias: Previous Year Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: PreYearResd )

Types:

ID: Blue
Name: Blue
Domains:
• Service_Status:
  Inherited
• SystemOperator:
  Inherited
• Current_Hydrant_Color:
  Inherited
• Responsible_Station:
  Inherited
• ImportInspectionType2021:
  Inherited
• MaintenancReq:
  Inherited
• InspectionPF:
  Inherited
• InspectionType:
  Inherited
• InspectioCompBy:
  Inherited
Templates:
• Name: Blue
  Description:
  Prototype:
  PreYearStatic: null
  PreYearPitot: null
  Service_Status: null
  SystemOperator: null
  ImportHydrantColor2021: null
  Current_Hydrant_Color: Blue
  Hydrant_Number: null
  LocationDescription: null
  SubZone: null
  Responsible_Station: null
  Latitude: null
  Longitude: null
  Import_ObservedFlow_2021: null
  Import_Available_Fire_Flow_2021: null
  WaterMainSize: null
  ImportInspectionDate2021: null
  ImportInspectionType2021: null
  MaintenancReq: null
  MaintenaneReqInfo: null
  InspectionPF: null
  InspectionFailInfo: null
  MaintEmail: null
  CurrentObservedFlow: null
  CurrentAvailFlow: null
  AssignmentDate: null
  AssignmentDueDate: null
  InspectionType: null
  Coefficient: 0.9
  DischargeDiam: 2.5
  PitotPressure: null
  StaticPressure: null
  ResidualPressure: null
  PreYearResd: null
  InspectioCompBy: null
  InspectionCompDate: null
  AvailFlowCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Green
Name: Green
Domains:
• Service_Status:
  Inherited
• SystemOperator:
  Inherited
• Current_Hydrant_Color:
  Inherited
• Responsible_Station:
  Inherited
• ImportInspectionType2021:
  Inherited
• MaintenancReq:
  Inherited
• InspectionPF:
  Inherited
• InspectionType:
  Inherited
• InspectioCompBy:
  Inherited
Templates:
• Name: Green
  Description:
  Prototype:
  PreYearStatic: null
  PreYearPitot: null
  Service_Status: null
  SystemOperator: null
  ImportHydrantColor2021: null
  Current_Hydrant_Color: Green
  Hydrant_Number: null
  LocationDescription: null
  SubZone: null
  Responsible_Station: null
  Latitude: null
  Longitude: null
  Import_ObservedFlow_2021: null
  Import_Available_Fire_Flow_2021: null
  WaterMainSize: null
  ImportInspectionDate2021: null
  ImportInspectionType2021: null
  MaintenancReq: null
  MaintenaneReqInfo: null
  InspectionPF: null
  InspectionFailInfo: null
  MaintEmail: null
  CurrentObservedFlow: null
  CurrentAvailFlow: null
  AssignmentDate: null
  AssignmentDueDate: null
  InspectionType: null
  Coefficient: 0.9
  DischargeDiam: 2.5
  PitotPressure: null
  StaticPressure: null
  ResidualPressure: null
  PreYearResd: null
  InspectioCompBy: null
  InspectionCompDate: null
  AvailFlowCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Orange
Name: Orange
Domains:
• Service_Status:
  Inherited
• SystemOperator:
  Inherited
• Current_Hydrant_Color:
  Inherited
• Responsible_Station:
  Inherited
• ImportInspectionType2021:
  Inherited
• MaintenancReq:
  Inherited
• InspectionPF:
  Inherited
• InspectionType:
  Inherited
• InspectioCompBy:
  Inherited
Templates:
• Name: Orange
  Description:
  Prototype:
  PreYearStatic: null
  PreYearPitot: null
  Service_Status: null
  SystemOperator: null
  ImportHydrantColor2021: null
  Current_Hydrant_Color: Orange
  Hydrant_Number: null
  LocationDescription: null
  SubZone: null
  Responsible_Station: null
  Latitude: null
  Longitude: null
  Import_ObservedFlow_2021: null
  Import_Available_Fire_Flow_2021: null
  WaterMainSize: null
  ImportInspectionDate2021: null
  ImportInspectionType2021: null
  MaintenancReq: null
  MaintenaneReqInfo: null
  InspectionPF: null
  InspectionFailInfo: null
  MaintEmail: null
  CurrentObservedFlow: null
  CurrentAvailFlow: null
  AssignmentDate: null
  AssignmentDueDate: null
  InspectionType: null
  Coefficient: 0.9
  DischargeDiam: 2.5
  PitotPressure: null
  StaticPressure: null
  ResidualPressure: null
  PreYearResd: null
  InspectioCompBy: null
  InspectionCompDate: null
  AvailFlowCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Red
Name: Red
Domains:
• Service_Status:
  Inherited
• SystemOperator:
  Inherited
• Current_Hydrant_Color:
  Inherited
• Responsible_Station:
  Inherited
• ImportInspectionType2021:
  Inherited
• MaintenancReq:
  Inherited
• InspectionPF:
  Inherited
• InspectionType:
  Inherited
• InspectioCompBy:
  Inherited
Templates:
• Name: Red
  Description:
  Prototype:
  PreYearStatic: null
  PreYearPitot: null
  Service_Status: null
  SystemOperator: null
  ImportHydrantColor2021: null
  Current_Hydrant_Color: Red
  Hydrant_Number: null
  LocationDescription: null
  SubZone: null
  Responsible_Station: null
  Latitude: null
  Longitude: null
  Import_ObservedFlow_2021: null
  Import_Available_Fire_Flow_2021: null
  WaterMainSize: null
  ImportInspectionDate2021: null
  ImportInspectionType2021: null
  MaintenancReq: null
  MaintenaneReqInfo: null
  InspectionPF: null
  InspectionFailInfo: null
  MaintEmail: null
  CurrentObservedFlow: null
  CurrentAvailFlow: null
  AssignmentDate: null
  AssignmentDueDate: null
  InspectionType: null
  Coefficient: 0.9
  DischargeDiam: 2.5
  PitotPressure: null
  StaticPressure: null
  ResidualPressure: null
  PreYearResd: null
  InspectioCompBy: null
  InspectionCompDate: null
  AvailFlowCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MD
Name: Flow Data Missing DO NOT Paint
Domains:
• Service_Status:
  Inherited
• SystemOperator:
  Inherited
• Current_Hydrant_Color:
  Inherited
• Responsible_Station:
  Inherited
• ImportInspectionType2021:
  Inherited
• MaintenancReq:
  Inherited
• InspectionPF:
  Inherited
• InspectionType:
  Inherited
• InspectioCompBy:
  Inherited
Templates:
• Name: MD
  Description:
  Prototype:
  PreYearStatic: null
  PreYearPitot: null
  Service_Status: null
  SystemOperator: null
  ImportHydrantColor2021: null
  Current_Hydrant_Color: MD
  Hydrant_Number: null
  LocationDescription: null
  SubZone: null
  Responsible_Station: null
  Latitude: null
  Longitude: null
  Import_ObservedFlow_2021: null
  Import_Available_Fire_Flow_2021: null
  WaterMainSize: null
  ImportInspectionDate2021: null
  ImportInspectionType2021: null
  MaintenancReq: null
  MaintenaneReqInfo: null
  InspectionPF: null
  InspectionFailInfo: null
  MaintEmail: null
  CurrentObservedFlow: null
  CurrentAvailFlow: null
  AssignmentDate: null
  AssignmentDueDate: null
  InspectionType: null
  Coefficient: 0.9
  DischargeDiam: 2.5
  PitotPressure: null
  StaticPressure: null
  ResidualPressure: null
  PreYearResd: null
  InspectioCompBy: null
  InspectionCompDate: null
  AvailFlowCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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