Name: Hydrant Flow Tests

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d282e26a91e64f67a4953521bb35c4f6

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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

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: 10, defaultValue: null, modelName: ASSETID )
• TESTBY ( type: esriFieldTypeString, alias: Tested By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TESTBY )
• DATEFLOWED ( type: esriFieldTypeDate, alias: Date Flowed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEFLOWED )
• STATICPSI ( type: esriFieldTypeDouble, alias: Static PSI, editable: true, nullable: true, defaultValue: null, modelName: STATICPSI )
• FLOWPSI ( type: esriFieldTypeDouble, alias: Flow PSI, editable: true, nullable: true, defaultValue: null, modelName: FLOWPSI )
• FLOWGPM ( type: esriFieldTypeDouble, alias: Flow Rate (gpm), editable: true, nullable: true, defaultValue: null, modelName: FLOWGPM )
• GPM20 ( type: esriFieldTypeDouble, alias: GPM 20, editable: true, nullable: true, defaultValue: null, modelName: GPM20 )
• GPM10 ( type: esriFieldTypeDouble, alias: GPM 10, editable: true, nullable: true, defaultValue: null, modelName: GPM10 )
• GPM0 ( type: esriFieldTypeDouble, alias: GPM 0, editable: true, nullable: true, defaultValue: null, modelName: GPM0 )
• COEFF ( type: esriFieldTypeDouble, alias: Coefficient, editable: true, nullable: true, defaultValue: null, modelName: COEFF )
• FLOWDUR ( type: esriFieldTypeDouble, alias: Minutes Flowed, editable: true, nullable: true, defaultValue: null, modelName: FLOWDUR )
• FLOWQTY ( type: esriFieldTypeDouble, alias: Volume Flowed (gal), editable: true, nullable: true, defaultValue: null, modelName: FLOWQTY )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• HYDCLASS ( type: esriFieldTypeSmallInteger, alias: Hydrant Class, editable: true, nullable: true, defaultValue: null, modelName: HYDCLASS )
• OLDID ( type: esriFieldTypeString, alias: Old ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OLDID )
• OLDMFDID ( type: esriFieldTypeString, alias: Old MFD ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OLDMFDID )
• CREATOR ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CREATOR, required: true )
• CREATED ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED, required: true )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR, required: true )
• LASTEDITED ( type: esriFieldTypeDate, alias: Last Edited On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTEDITED, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• TESTTYPE ( type: esriFieldTypeString, alias: Test Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TESTTYPE , Coded Values: [Single Hydrant: Single Hydrant] , [Dual Hydrant: Dual Hydrant] )
• FLOWSTATUS ( type: esriFieldTypeString, alias: Flowed Status, editable: true, nullable: true, length: 40, defaultValue: null, modelName: FLOWSTATUS , Coded Values: [Flowed: Flowed] , [Hydrant Does Not Exist: Hydrant Does Not Exist] , [Not Flowed (Inoperable): Not Flowed (Inoperable)] , ...4 more... )
• PAINTNEEDED ( type: esriFieldTypeString, alias: Class Paint Needed, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PAINTNEEDED , Coded Values: [Silver (1 - 500 GPM): Silver (1 - 500 GPM)] , [Red (501 - 750 GPM): Red (501 - 750 GPM)] , [Orange (751 - 1,000 GPM): Orange (751 - 1,000 GPM)] , ...3 more... )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 7, defaultValue: null, modelName: MAINTREQUIRED , Coded Values: [No: No] , [Yes: Yes] , [Unknown: Unknown] , ...1 more... )

Templates:

• Name: Hydrant Flow Tests
  Description:
  Prototype:
  PAINTNEEDED: null
  ASSETID: null
  TESTBY: null
  DATEFLOWED: null
  STATICPSI: null
  FLOWPSI: null
  FLOWGPM: null
  GPM20: null
  GPM10: null
  GPM0: null
  COEFF: null
  FLOWDUR: null
  FLOWQTY: null
  NOTES: null
  HYDCLASS: null
  OLDID: null
  OLDMFDID: null
  FLOWSTATUS: null
  TESTTYPE: null
  MAINTREQUIRED: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DO.waterHydrants (0) -- Related To: Water Hydrants (78)

Capabilities: Query,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: CREATED
• Creator Field: CREATOR
• Edit Date Field: LASTEDITED
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata