Name: NBGIS.GISDATA.WaterHydrantMaintFieldHistory

Display Field: ACTION_DATE

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GIS_TAG ( type: esriFieldTypeString, alias: GIS ID, editable: false, nullable: true, length: 15, defaultValue: null, modelName: GIS_TAG )
• HYDRANTID ( type: esriFieldTypeString, alias: Hydrant Number, editable: false, nullable: true, length: 20, defaultValue: null, modelName: HYDRANTID )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: false, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [Jones A: Jones A] , [LB Iron Works: LB Iron Works] , [Greenberg: Greenberg] , ...19 more... )
• BARRELTYPE ( type: esriFieldTypeString, alias: Barrel Type, editable: false, nullable: true, length: 15, defaultValue: null, modelName: BARRELTYPE , Coded Values: [W: Wet Barrel] , [D: Dry Barrel] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Date Install/Replace, editable: false, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• STATICPSI ( type: esriFieldTypeSmallInteger, alias: Static PSI, editable: false, nullable: true, defaultValue: null, modelName: STATICPSI )
• PORTS2IN ( type: esriFieldTypeSmallInteger, alias: 2.5 Inch Outlets, editable: false, nullable: true, defaultValue: null, modelName: PORTS2IN )
• PORTS4IN ( type: esriFieldTypeSmallInteger, alias: 4 Inch Outlets, editable: false, nullable: true, defaultValue: null, modelName: PORTS4IN )
• FRESHLYPAINTED ( type: esriFieldTypeString, alias: Freshly Painted, editable: false, nullable: true, length: 10, defaultValue: null, modelName: FRESHLYPAINTED , Coded Values: [YES: YES] , [NO: NO] )
• DATEPAINTED ( type: esriFieldTypeDate, alias: Date Last Painted, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEPAINTED )
• INSERVICE ( type: esriFieldTypeString, alias: In Service, editable: false, nullable: true, length: 10, defaultValue: null, modelName: INSERVICE , Coded Values: [YES: YES] , [NO: NO] )
• OPERATIONCOMMENTS ( type: esriFieldTypeString, alias: Comments, editable: false, nullable: true, length: 100, defaultValue: null, modelName: OPERATIONCOMMENTS )
• CREW_UPDATE_BY ( type: esriFieldTypeString, alias: Crew Update, editable: false, nullable: true, length: 25, defaultValue: null, modelName: CREW_UPDATE_BY , Coded Values: [asanchez: asanchez] , [dhill: dhill] , [gpichardo: gpichardo] , ...8 more... )
• ACTION_DATE ( type: esriFieldTypeDate, alias: Updated Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ACTION_DATE )
• CHECK_VALVE ( type: esriFieldTypeString, alias: Check Valve, editable: false, nullable: true, length: 10, defaultValue: null, modelName: CHECK_VALVE , Coded Values: [YES: YES] , [NO: NO] )
• CHECK_VALVE_TYPE ( type: esriFieldTypeString, alias: Check Valve Type, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CHECK_VALVE_TYPE , Coded Values: [AVK: AVK] , [Clow: Clow] )
• HYD_MAIN_INSPECT ( type: esriFieldTypeString, alias: Hydrant Maintained and Inspected?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYD_MAIN_INSPECT , Coded Values: [NA: NA] , [NO: NO] , [YES: YES] )
• HYD_FLUSH ( type: esriFieldTypeString, alias: Hydrant Flush?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYD_FLUSH , Coded Values: [NA: NA] , [NO: NO] , [YES: YES] )

Templates:

• Name: NBGIS.GISDATA.WaterHydrantMaintFieldHistory
  Description:
  Prototype:
  HYD_MAIN_INSPECT: null
  HYD_FLUSH: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• WaterHydrantMaintField (1) -- Related To: Hydrant (1)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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