Name: Hydrant_Assessment

Display Field: exportappname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4861b3e0e59b44af8d0e7067cd0a234c

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• start ( modelName: start, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start, type: esriFieldTypeDate )
• end_ ( modelName: end_, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: End, type: esriFieldTypeDate )
• submissionnumber ( modelName: submissionnumber, nullable: true, editable: true, defaultValue: null, alias: SubmissionNumber, type: esriFieldTypeDouble )
• exportappname ( modelName: exportappname, nullable: true, editable: true, defaultValue: null, length: 255, alias: ExportAppName, type: esriFieldTypeString )
• username ( modelName: username, nullable: true, editable: true, defaultValue: null, length: 255, alias: Username, type: esriFieldTypeString )
• userlastname ( modelName: userlastname, nullable: true, editable: true, defaultValue: null, length: 255, alias: UserLastName, type: esriFieldTypeString )
• userfirstname ( modelName: userfirstname, nullable: true, editable: true, defaultValue: null, length: 255, alias: UserFirstName, type: esriFieldTypeString )
• responseid ( modelName: responseid, nullable: true, editable: true, defaultValue: null, length: 255, alias: ResponseID, type: esriFieldTypeString )
• responsedate_time ( modelName: responsedate_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ResponseDate_Time, type: esriFieldTypeDate )
• devicedate_time ( modelName: devicedate_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DeviceDate_Time, type: esriFieldTypeDate )
• submissionformname ( modelName: submissionformname, nullable: true, editable: true, defaultValue: null, length: 255, alias: SubmissionFormName, type: esriFieldTypeString )
• submissionformversion ( modelName: submissionformversion, nullable: true, editable: true, defaultValue: null, alias: SubmissionFormVersion, type: esriFieldTypeDouble )
• sectionname ( modelName: sectionname, nullable: true, editable: true, defaultValue: null, length: 255, alias: SectionName, type: esriFieldTypeString )
• client ( modelName: client, nullable: true, editable: true, defaultValue: null, length: 255, alias: Client, type: esriFieldTypeString )
• hydrant ( modelName: hydrant, nullable: true, editable: true, defaultValue: null, alias: Hydrant, type: esriFieldTypeDouble )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString )
• zipcode ( modelName: zipcode, nullable: true, editable: true, defaultValue: null, length: 255, alias: ZipCode, type: esriFieldTypeString )
• typeofhydrant ( modelName: typeofhydrant, nullable: true, editable: true, defaultValue: null, length: 255, alias: TypeofHydrant, type: esriFieldTypeString )
• assessmentphoto ( modelName: assessmentphoto, nullable: true, editable: true, defaultValue: null, length: 255, alias: AssessmentPhoto, type: esriFieldTypeString )
• summaryofhydrantdisfunction ( modelName: summaryofhydrantdisfunction, nullable: true, editable: true, defaultValue: null, length: 255, alias: SummaryofHydrantdisfunction, type: esriFieldTypeString )
• troublecodes ( modelName: troublecodes, nullable: true, editable: true, defaultValue: null, length: 255, alias: TroubleCodes, type: esriFieldTypeString )
• upperbarrel ( modelName: upperbarrel, nullable: true, editable: true, defaultValue: null, alias: UpperBarrel, type: esriFieldTypeSmallInteger )
• lowerbarrel ( modelName: lowerbarrel, nullable: true, editable: true, defaultValue: null, alias: LowerBarrel, type: esriFieldTypeSmallInteger )
• hydrantgreased ( modelName: hydrantgreased, nullable: true, editable: true, defaultValue: null, alias: HydrantGreased, type: esriFieldTypeSmallInteger )
• hydrantflushed ( modelName: hydrantflushed, nullable: true, editable: true, defaultValue: null, alias: HydrantFlushed, type: esriFieldTypeSmallInteger )
• hydrantpainted ( modelName: hydrantpainted, nullable: true, editable: true, defaultValue: null, alias: HydrantPainted, type: esriFieldTypeSmallInteger )
• commenthalls ( modelName: commenthalls, nullable: true, editable: true, defaultValue: null, length: 255, alias: CommentHalls, type: esriFieldTypeString )
• photohalls ( modelName: photohalls, nullable: true, editable: true, defaultValue: null, length: 255, alias: PhotoHalls, type: esriFieldTypeString )
• partsreplaced ( modelName: partsreplaced, nullable: true, editable: true, defaultValue: null, length: 255, alias: Partsreplaced, type: esriFieldTypeString )
• notes_comments ( modelName: notes_comments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes_Comments, type: esriFieldTypeString )
• technician ( modelName: technician, nullable: true, editable: true, defaultValue: null, length: 255, alias: Technician, type: esriFieldTypeString )
• projectmanager ( modelName: projectmanager, nullable: true, editable: true, defaultValue: null, length: 255, alias: ProjectManager, type: esriFieldTypeString )
• date ( modelName: date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• lat ( modelName: lat, nullable: true, editable: true, defaultValue: null, alias: Lat, type: esriFieldTypeDouble )
• lng ( modelName: lng, nullable: true, editable: true, defaultValue: null, alias: Lng, type: esriFieldTypeDouble )
• hydname ( modelName: hydname, nullable: true, editable: true, defaultValue: null, length: 50, alias: HydName, type: esriFieldTypeString )

Templates:

• Name: Hydrant_Assessment
  Description:
  Prototype:
  date: null
  userlastname: null
  submissionnumber: null
  city: null
  troublecodes: null
  userfirstname: null
  partsreplaced: null
  hydname: null
  end_: null
  typeofhydrant: null
  hydrantflushed: null
  hydrant: null
  responsedate_time: null
  assessmentphoto: null
  hydrantpainted: null
  client: null
  state: null
  photohalls: null
  lat: null
  responseid: null
  exportappname: null
  lowerbarrel: null
  submissionformversion: null
  notes_comments: null
  address: null
  lng: null
  devicedate_time: null
  start: null
  technician: null
  hydrantgreased: null
  projectmanager: null
  zipcode: null
  upperbarrel: null
  submissionformname: null
  commenthalls: null
  summaryofhydrantdisfunction: null
  sectionname: null
  username: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata