Name: Discharge Inspection

Display Field: inspector

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a52bd7d99f9446118ae4747906fb089e

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 )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector )
• inspectdt ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectdt )
• dryweather ( type: esriFieldTypeSmallInteger, alias: Dry Weather Inspection?, editable: true, nullable: true, defaultValue: null, modelName: dryweather )
• dateprecip ( type: esriFieldTypeDate, alias: Date of Last Precipitation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateprecip )
• amountprecip ( type: esriFieldTypeDouble, alias: Amount of Last Precipitation, editable: true, nullable: true, defaultValue: null, modelName: amountprecip )
• flow ( type: esriFieldTypeSmallInteger, alias: Flow Present?, editable: true, nullable: true, defaultValue: null, modelName: flow )
• flowrate ( type: esriFieldTypeSmallInteger, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: flowrate )
• flowcolor ( type: esriFieldTypeSmallInteger, alias: Flow contains color?, editable: true, nullable: true, defaultValue: null, modelName: flowcolor )
• colordesc ( type: esriFieldTypeSmallInteger, alias: Color Description, editable: true, nullable: true, defaultValue: null, modelName: colordesc )
• colordesc_other ( type: esriFieldTypeString, alias: Specify other., editable: true, nullable: true, length: 50, defaultValue: null, modelName: colordesc_other )
• flowodor ( type: esriFieldTypeSmallInteger, alias: Flow contains odor?, editable: true, nullable: true, defaultValue: null, modelName: flowodor )
• odordesc ( type: esriFieldTypeSmallInteger, alias: Odor Description, editable: true, nullable: true, defaultValue: null, modelName: odordesc )
• odordesc_other ( type: esriFieldTypeString, alias: Specify other., editable: true, nullable: true, length: 50, defaultValue: null, modelName: odordesc_other )
• flowfloatable ( type: esriFieldTypeSmallInteger, alias: Flow contains floatables?, editable: true, nullable: true, defaultValue: null, modelName: flowfloatable )
• floatabledesc ( type: esriFieldTypeSmallInteger, alias: Floatable Description, editable: true, nullable: true, defaultValue: null, modelName: floatabledesc )
• floatabledesc_other ( type: esriFieldTypeString, alias: Specify other., editable: true, nullable: true, length: 50, defaultValue: null, modelName: floatabledesc_other )
• recievingwater ( type: esriFieldTypeSmallInteger, alias: Change in recieving water?, editable: true, nullable: false, defaultValue: null, modelName: recieivingwater )
• recievingwaterdesc ( type: esriFieldTypeString, alias: Description of Change, editable: true, nullable: true, length: 150, defaultValue: null, modelName: recievingwaterdesc )
• illicitdischarge ( type: esriFieldTypeSmallInteger, alias: Is Flow Illicit Discharge?, editable: true, nullable: true, defaultValue: null, modelName: illicitdischarge )
• illicitdischargesource ( type: esriFieldTypeString, alias: Efforts to determine source., editable: true, nullable: true, length: 150, defaultValue: null, modelName: illicitdischargesource )
• illicitdischargeaction ( type: esriFieldTypeString, alias: Corrective Action Taken, editable: true, nullable: true, length: 150, defaultValue: null, modelName: illicitdischargeaction )
• notes ( type: esriFieldTypeString, alias: Notes., editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• assetguid ( type: esriFieldTypeGUID, alias: Asset GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: assetguid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: creationdate )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: creator )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: lastupdate )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: updatedby )

Templates:

• Name: Discharge Inspection
  Description:
  Prototype:
  assetguid: null
  notes: null
  inspector: null
  inspectdt: null
  dryweather: null
  dateprecip: null
  amountprecip: null
  flow: null
  flowrate: null
  flowcolor: null
  colordesc: null
  colordesc_other: null
  flowodor: null
  odordesc: null
  odordesc_other: null
  flowfloatable: null
  floatabledesc: null
  floatabledesc_other: null
  recievingwater: 0
  recievingwaterdesc: null
  illicitdischarge: null
  illicitdischargesource: null
  illicitdischargeaction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• StormwaterDevice (2) -- Related To: Stormwater Device (2)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract,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: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: UPDATEDBY

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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