View In:   ArcGIS Online Map Viewer

Name: wHydrant

Display Field: YearInstalled

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata