Layers:

Layer: wHydrant (0)

Name: wHydrant

Display Field: YearInstalled

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: -123407700
YMin: -86123500
XMax: 2516019.97128205
YMax: 6868156.369989812
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: InspectionStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Inspected
  Label: Inspected
  Description: N/A
  Symbol:
  
• Value: Need to Inspect
  Label: Need to Inspect
  Description: N/A
  Symbol:
  
• Value: Operational but needs further maintenance
  Label: Operational but needs further maintenance
  Description: N/A
  Symbol:
  
• Value: Out of Service
  Label: Out of Service
  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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: InspectionStatus

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HYD_col ( type: esriFieldTypeInteger, alias: HYD_col, editable: true, nullable: true, defaultValue: null, modelName: HYD_col )
• YearInstalled ( type: esriFieldTypeString, alias: Year Installed, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearInstalled )
• HydrantID ( type: esriFieldTypeString, alias: Hydrant ID, editable: true, nullable: true, length: 6, defaultValue: null, modelName: HydrantID )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• ORIG_ID ( type: esriFieldTypeInteger, alias: ORIG_ID, editable: true, nullable: true, defaultValue: null, modelName: ORIG_ID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• Enabled ( type: esriFieldTypeInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: Enabled )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: false, length: 50, defaultValue: null, modelName: InspectionStatus , Coded Values: [Inspected: Inspected] , [Need to Inspect: Need to Inspect] , [Out of Service: Out of Service] , ...1 more... )
• Greased ( type: esriFieldTypeString, alias: Greased Req'd?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Greased , Coded Values: [Yes: Yes] , [No: No] )
• LubricationRequired ( type: esriFieldTypeString, alias: Lubrication Req'd?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: LubricationRequired , Coded Values: [Yes: Yes] , [No: No] )
• PaintRequired ( type: esriFieldTypeString, alias: Paint Req'd?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: PaintRequired , Coded Values: [Yes: Yes] , [No: No] )
• MarkerRequired ( type: esriFieldTypeString, alias: Marker Req'd?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: MarkerRequired , Coded Values: [Yes: Yes] , [No: No] )
• MaintenanceRequired ( type: esriFieldTypeString, alias: Maintenance Req'd?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: MaintenanceRequired , Coded Values: [Yes: Yes] , [No: No] )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inspector )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Notes )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Owner )
• Unit_Price ( type: esriFieldTypeDouble, alias: Unit_Price, editable: true, nullable: true, defaultValue: null, modelName: Unit_Price )
• Maint_Type ( type: esriFieldTypeString, alias: Maint_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Maint_Type )
Types:
ID: Inspected
Name: Inspected
Domains:
• InspectionStatus:
  Inherited
• Greased:
  Inherited
• LubricationRequired:
  Inherited
• PaintRequired:
  Inherited
• MarkerRequired:
  Inherited
• MaintenanceRequired:
  Inherited
Templates:
• Name: Inspected
  Description:
  Prototype:
  Unit_Price: null
  Owner: null
  HYD_col: null
  YearInstalled: null
  HydrantID: null
  InspectionDate: null
  ORIG_ID: null
  POINT_X: null
  POINT_Y: null
  Enabled: null
  InspectionStatus: Inspected
  Greased:
  LubricationRequired:
  PaintRequired:
  MarkerRequired:
  MaintenanceRequired:
  Inspector: null
  Maint_Type: null
  Notes: null
  AssetID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Need to Inspect
Name: Need to Inspect
Domains:
• InspectionStatus:
  Inherited
• Greased:
  Inherited
• LubricationRequired:
  Inherited
• PaintRequired:
  Inherited
• MarkerRequired:
  Inherited
• MaintenanceRequired:
  Inherited
Templates:
• Name: Need to Inspect
  Description:
  Prototype:
  Unit_Price: null
  Owner: null
  HYD_col: null
  YearInstalled: null
  HydrantID: null
  InspectionDate: null
  ORIG_ID: null
  POINT_X: null
  POINT_Y: null
  Enabled: null
  InspectionStatus: Need to Inspect
  Greased:
  LubricationRequired:
  PaintRequired:
  MarkerRequired:
  MaintenanceRequired:
  Inspector: null
  Maint_Type: null
  Notes: null
  AssetID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Operational but needs further maintenance
Name: Operational but needs further maintenance
Domains:
• InspectionStatus:
  Inherited
• Greased:
  Inherited
• LubricationRequired:
  Inherited
• PaintRequired:
  Inherited
• MarkerRequired:
  Inherited
• MaintenanceRequired:
  Inherited
Templates:
• Name: Operational but needs further maintenance
  Description:
  Prototype:
  Unit_Price: null
  Owner: null
  HYD_col: null
  YearInstalled: null
  HydrantID: null
  InspectionDate: null
  ORIG_ID: null
  POINT_X: null
  POINT_Y: null
  Enabled: null
  InspectionStatus: Operational but needs further maintenance
  Greased:
  LubricationRequired:
  PaintRequired:
  MarkerRequired:
  MaintenanceRequired:
  Inspector: null
  Maint_Type: null
  Notes: null
  AssetID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Out of Service
Name: Out of Service
Domains:
• InspectionStatus:
  Inherited
• Greased:
  Inherited
• LubricationRequired:
  Inherited
• PaintRequired:
  Inherited
• MarkerRequired:
  Inherited
• MaintenanceRequired:
  Inherited
Templates:
• Name: Out of Service
  Description:
  Prototype:
  Unit_Price: null
  Owner: null
  HYD_col: null
  YearInstalled: null
  HydrantID: null
  InspectionDate: null
  ORIG_ID: null
  POINT_X: null
  POINT_Y: null
  Enabled: null
  InspectionStatus: Out of Service
  Greased:
  LubricationRequired:
  PaintRequired:
  MarkerRequired:
  MaintenanceRequired:
  Inspector: null
  Maint_Type: null
  Notes: null
  AssetID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• DBO.HydrantInspection (0) -- Related To: HydrantInspection (1)

Tables:

Table: HydrantInspection (1)

Name: HydrantInspection

Display Field: StartDate

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StartDate ( type: esriFieldTypeDate, alias: StartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• GPM ( type: esriFieldTypeSmallInteger, alias: GPM, editable: true, nullable: true, defaultValue: null, modelName: GPM )
• FinishChlorineResidual ( type: esriFieldTypeDouble, alias: FinishChlorineResidual, editable: true, nullable: true, defaultValue: null, modelName: FinishChlorineResidual )
• Pressure ( type: esriFieldTypeSmallInteger, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: Pressure )
• FinishDate ( type: esriFieldTypeDate, alias: FinishDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FinishDate )
• Operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operator )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Notes )
• TotalTimeFlushed ( type: esriFieldTypeDouble, alias: TotalTimeFlushed, editable: true, nullable: true, defaultValue: null, modelName: TotalTimeFlushed )
• TotalGallonsFlushed ( type: esriFieldTypeDouble, alias: TotalGallonsFlushed, editable: true, nullable: true, defaultValue: null, modelName: TotalGallonsFlushed )
• Size ( type: esriFieldTypeDouble, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: Size )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: HydrantInspection
  Description:
  Prototype:
  GUID: null
  AssetID: null
  StartDate: null
  GPM: null
  FinishChlorineResidual: null
  Pressure: null
  FinishDate: null
  Operator: null
  Notes: null
  TotalTimeFlushed: null
  TotalGallonsFlushed: null
  Size: null
  Material: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.wHydrant (0) -- Related To: wHydrant (0)