Name: Fire Hydrant Maintenance Table

Display Field: DEFECT

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f995780d23224753a8186f69d1bd5ef8

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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 )
• HYDR_ID ( type: esriFieldTypeInteger, alias: Hydrant ID, editable: true, nullable: true, defaultValue: null, modelName: HYDR_ID )
• DEFECT ( type: esriFieldTypeString, alias: Defect Repaired, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEFECT , Coded Values: [BlackBag: "Black Bag" to MLGW] , [Cut: Cut away tree limbs/ weeds/ bushes] , [DigOut: Dig out debris] , ...18 more... )
• START_DATE ( type: esriFieldTypeDate, alias: Start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATE )
• END_DATE ( type: esriFieldTypeDate, alias: End, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_DATE )
• FLUSHED ( type: esriFieldTypeDate, alias: Flushed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLUSHED )
• SERVICED ( type: esriFieldTypeDate, alias: PM Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICED )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOTES )
• STAFF_ID ( type: esriFieldTypeString, alias: Staff ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STAFF_ID )
• SHIFT ( type: esriFieldTypeString, alias: Shift, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SHIFT , Coded Values: [A: A] , [B: B] , [C: C] )
• UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNIT , Coded Values: [PU001: PU001] , [RC001: RC001] , [PU002: PU002] , ...78 more... )
• STATION ( type: esriFieldTypeString, alias: Response Area, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATION , Coded Values: [AA01N: COUNTY] , [1: FS-01] , [2: FS-02] , ...59 more... )
• FIRE_ZONE ( type: esriFieldTypeString, alias: FMZ, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIRE_ZONE , Coded Values: [FMZ-0101: FMZ-0101] , [FMZ-0102: FMZ-0102] , [FMZ-0103: FMZ-0103] , ...494 more... )
• REPAIR_COST ( type: esriFieldTypeDouble, alias: Repair Cost, editable: true, nullable: true, defaultValue: null, modelName: REPAIR_COST )
• TRAFFIC_KIT ( type: esriFieldTypeInteger, alias: Traffic Kit, editable: true, nullable: true, defaultValue: 0, modelName: TRAFFIC_KIT , Coded Values: [0: 0] , [1: 1] )
• UPPER_STEM ( type: esriFieldTypeInteger, alias: Upper Stem, editable: true, nullable: true, defaultValue: 0, modelName: UPPER_STEM , Coded Values: [0: 0] , [1: 1] )
• OPER_NUT ( type: esriFieldTypeInteger, alias: Oper. Nut, editable: true, nullable: true, defaultValue: 0, modelName: OPER_NUT , Coded Values: [0: 0] , [1: 1] )
• LOCKDOWN_NUT ( type: esriFieldTypeInteger, alias: Lockdown Nut, editable: true, nullable: true, defaultValue: 0, modelName: LOCKDOWN_NUT , Coded Values: [0: 0] , [1: 1] )
• BONNET ( type: esriFieldTypeInteger, alias: Bonnet, editable: true, nullable: true, defaultValue: 0, modelName: BONNET , Coded Values: [0: 0] , [1: 1] )
• NOZZLE_25 ( type: esriFieldTypeInteger, alias: 2.5 Nozzle, editable: true, nullable: true, defaultValue: 0, modelName: NOZZLE_25 , Coded Values: [0: 0] , [1: 1] , [2: 2] )
• NOZZLE_40 ( type: esriFieldTypeInteger, alias: 4.0 Nozzle, editable: true, nullable: true, defaultValue: 0, modelName: NOZZLE_40 , Coded Values: [0: 0] , [1: 1] )
• CAPS_25 ( type: esriFieldTypeInteger, alias: 2.5 Cap, editable: true, nullable: true, defaultValue: 0, modelName: CAPS_25 , Coded Values: [0: 0] , [1: 1] , [2: 2] )
• CAPS_40 ( type: esriFieldTypeInteger, alias: 4.0 Cap, editable: true, nullable: true, defaultValue: 0, modelName: CAPS_40 , Coded Values: [0: 0] , [1: 1] )
• MAINVALVE ( type: esriFieldTypeInteger, alias: Main Valve, editable: true, nullable: true, defaultValue: 0, modelName: MAINVALVE , Coded Values: [0: 0] , [1: 1] )
• DRIPS ( type: esriFieldTypeInteger, alias: Drips, editable: true, nullable: true, defaultValue: 0, modelName: DRIPS , Coded Values: [0: 0] , [1: 1] , [2: 2] )
• GASKETSET ( type: esriFieldTypeInteger, alias: Gasket Set, editable: true, nullable: true, defaultValue: null, modelName: GASKETSET , Coded Values: [0: 0] , [1: 1] )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• 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 )
• LOC_GUID ( type: esriFieldTypeGUID, alias: LOC_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LOC_GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Fire Hydrant Maintenance Table
  Description:
  Prototype:
  LOC_GUID: null
  Y: null
  HYDR_ID: null
  DEFECT: null
  START_DATE: null
  END_DATE: null
  FLUSHED: null
  SERVICED: null
  NOTES: null
  STAFF_ID: null
  SHIFT: null
  UNIT: null
  STATION: null
  FIRE_ZONE: null
  REPAIR_COST: null
  TRAFFIC_KIT: 0
  UPPER_STEM: 0
  OPER_NUT: 0
  LOCKDOWN_NUT: 0
  BONNET: 0
  NOZZLE_25: 0
  NOZZLE_40: 0
  CAPS_25: 0
  CAPS_40: 0
  MAINVALVE: 0
  DRIPS: 0
  GASKETSET: null
  X: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Maint to Loc (0) -- Related To: Hydrant Location (0)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   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