Name: SamplingActivity

Display Field: SITE_NAME

Type: Table

Geometry Type: N/A

Description:

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

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 )
• CODE ( type: esriFieldTypeString, alias: CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODE )
• SITE_NAME ( type: esriFieldTypeString, alias: SITE_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_NAME )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• SAMPLE_LOCATION ( type: esriFieldTypeString, alias: SAMPLE_LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAMPLE_LOCATION )
• TOTAL ( type: esriFieldTypeDouble, alias: TOTAL, editable: true, nullable: true, defaultValue: null, modelName: TOTAL )
• FREE ( type: esriFieldTypeDouble, alias: FREE, editable: true, nullable: true, defaultValue: null, modelName: FREE )
• COMBINED ( type: esriFieldTypeDouble, alias: COMBINED, editable: true, nullable: true, defaultValue: null, modelName: COMBINED )
• AF_TOTAL ( type: esriFieldTypeDouble, alias: AF_TOTAL, editable: true, nullable: true, defaultValue: null, modelName: AF_TOTAL )
• AF_FREE ( type: esriFieldTypeDouble, alias: AF_FREE, editable: true, nullable: true, defaultValue: null, modelName: AF_FREE )
• AF_COMBINED ( type: esriFieldTypeDouble, alias: AF_COMBINED, editable: true, nullable: true, defaultValue: null, modelName: AF_COMBINED )
• SAMPLED_BY ( type: esriFieldTypeString, alias: SAMPLED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAMPLED_BY )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LastActivity, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastActivity , Coded Values: [INSP: Chlorine Monitoring] , [MCFA: Monochloramine / FA] , [ATP: ATP Sampling] , ...4 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATEDBY )
• MONOCHLORAMINE ( type: esriFieldTypeDouble, alias: MONOCHLORAMINE, editable: true, nullable: true, defaultValue: null, modelName: MONOCHLORAMINE )
• FREE_AMMONIA ( type: esriFieldTypeDouble, alias: FREE_AMMONIA, editable: true, nullable: true, defaultValue: null, modelName: FREE_AMMONIA )
• SAMPLE_TIME ( type: esriFieldTypeSingle, alias: SAMPLE_TIME, editable: true, nullable: true, defaultValue: null, modelName: SAMPLE_TIME )
• CONDUCTIVITY ( type: esriFieldTypeSingle, alias: CONDUCTIVITY, editable: true, nullable: true, defaultValue: null, modelName: CONDUCTIVITY )
• PH ( type: esriFieldTypeSingle, alias: PH, editable: true, nullable: true, defaultValue: null, modelName: PH )
• TEMPERATURE ( type: esriFieldTypeSingle, alias: TEMPERATURE, editable: true, nullable: true, defaultValue: null, modelName: TEMPERATURE )
• WAIT_TIME ( type: esriFieldTypeSingle, alias: WAIT_TIME, editable: true, nullable: true, defaultValue: null, modelName: WAIT_TIME )
• ULTRACHECK_RLU ( type: esriFieldTypeInteger, alias: ULTRACHECK_RLU, editable: true, nullable: true, defaultValue: null, modelName: ULTRACHECK_RLU )
• ATP_RLU ( type: esriFieldTypeSmallInteger, alias: ATP_RLU, editable: true, nullable: true, defaultValue: null, modelName: ATP_RLU )
• VOLUME_FILTERED ( type: esriFieldTypeSmallInteger, alias: VOLUME_FILTERED, editable: true, nullable: true, defaultValue: null, modelName: VOLUME_FILTERED )
• ANALYZED_BY ( type: esriFieldTypeString, alias: ANALYZED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ANALYZED_BY , Coded Values: [Andy Turner: Andy Turner] , [Dave Herzing: Dave Herzing] , [Jaclyn Varga: Jaclyn Varga] , ...16 more... )
• CATP ( type: esriFieldTypeDouble, alias: CATP, editable: true, nullable: true, defaultValue: null, modelName: CATP )
• CELL_COUNT ( type: esriFieldTypeDouble, alias: CELL_COUNT, editable: true, nullable: true, defaultValue: null, modelName: CELL_COUNT )
• HT_PLATE_CNT ( type: esriFieldTypeSmallInteger, alias: HT_PLATE_CNT, editable: true, nullable: true, defaultValue: null, modelName: HT_PLATE_CNT )
• PA_ECOLI ( type: esriFieldTypeString, alias: PA_ECOLI, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PA_ECOLI )
• PA_TC ( type: esriFieldTypeString, alias: PA_TC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PA_TC )
• PRESENCE_ABSENCE ( type: esriFieldTypeString, alias: PRESENCE_ABSENCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESENCE_ABSENCE )
• LOAD_DATE ( type: esriFieldTypeDate, alias: LOAD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LOAD_DATE )
• RECORD_NUMBER ( type: esriFieldTypeString, alias: RECORD_NUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RECORD_NUMBER )
• AF_TIME ( type: esriFieldTypeSingle, alias: AF_TIME, editable: true, nullable: true, defaultValue: null, modelName: AF_TIME )
• FL_START_TIME ( type: esriFieldTypeDouble, alias: FL_START_TIME, editable: true, nullable: true, defaultValue: null, modelName: FL_START_TIME )
• FL_FINISH_TIME ( type: esriFieldTypeDouble, alias: FL_FINISH_TIME, editable: true, nullable: true, defaultValue: null, modelName: FL_FINISH_TIME )
• TEST_TYPE ( type: esriFieldTypeString, alias: TEST_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TEST_TYPE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• FLOW_RATE ( type: esriFieldTypeSmallInteger, alias: FLOW_RATE, editable: true, nullable: true, defaultValue: null, modelName: FLOW_RATE )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID, editable: true, nullable: true, defaultValue: null, modelName: ASSET_ID )
• SAMPLINGLOC_GUID ( type: esriFieldTypeGUID, alias: SAMPLINGLOC_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SAMPLINGLOC_GUID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• TS_FL_FINISH_TIME ( type: esriFieldTypeDate, alias: TS_FL_FINISH_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TS_FL_FINISH_TIME )
• TS_SAMPLE_TIME ( type: esriFieldTypeDate, alias: TS_SAMPLE_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TS_SAMPLE_TIME )
• T_FL_START_TIME ( type: esriFieldTypeDate, alias: T_FL_START_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: T_FL_START_TIME )
• TS_AF_TIME ( type: esriFieldTypeDate, alias: TS_AF_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TS_AF_TIME )

Templates:

• Name: SamplingActivity
  Description:
  Prototype:
  T_FL_START_TIME: null
  TS_SAMPLE_TIME: null
  CODE: null
  SITE_NAME: null
  ADDRESS: null
  SAMPLE_LOCATION: null
  TOTAL: null
  FREE: null
  COMBINED: null
  AF_TOTAL: null
  AF_FREE: null
  AF_COMBINED: null
  SAMPLED_BY: null
  ACTIVITYID: null
  LASTACTIVITY: null
  DATESTAMP: null
  OPTIME: null
  COMPUTERNAME: null
  OPERATEDBY: null
  MONOCHLORAMINE: null
  FREE_AMMONIA: null
  SAMPLE_TIME: null
  CONDUCTIVITY: null
  PH: null
  TEMPERATURE: null
  WAIT_TIME: null
  ULTRACHECK_RLU: null
  ATP_RLU: null
  VOLUME_FILTERED: null
  ANALYZED_BY: null
  CATP: null
  CELL_COUNT: null
  HT_PLATE_CNT: null
  PA_ECOLI: null
  PA_TC: null
  PRESENCE_ABSENCE: null
  LOAD_DATE: null
  RECORD_NUMBER: null
  AF_TIME: null
  FL_START_TIME: null
  FL_FINISH_TIME: null
  TEST_TYPE: null
  COMMENTS: null
  FLOW_RATE: null
  ASSET_ID: null
  SAMPLINGLOC_GUID: null
  TS_AF_TIME: null
  TS_FL_FINISH_TIME: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE_USER.wSamplingLocations (0) -- Related To: SamplingLocations (1)
• SDE_USER.wSamplingLocations (1) -- Related To: SamplingLocations (1)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

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