Name: Waypoint_Analytical_Table

Display Field: Site_ID_Station

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f07888f828ad4de8b094324a403987a8

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: 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 )
• ActID ( type: esriFieldTypeDouble, alias: Activity ID, editable: true, nullable: true, defaultValue: null, modelName: ActID )
• Site_ID_Station ( type: esriFieldTypeString, alias: Site ID Station, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Site_ID_Station )
• Watershed ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Watershed )
• SampleDate ( type: esriFieldTypeDate, alias: Sample Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SampleDate )
• LabReportNum ( type: esriFieldTypeString, alias: Lab Report Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LabReportNum )
• LabSampleNum ( type: esriFieldTypeString, alias: Lab Sample Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LabSampleNum )
• FieldID ( type: esriFieldTypeString, alias: Field ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FieldID )
• EColi_MPN_100ml ( type: esriFieldTypeString, alias: E Coli MPN 100ml, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EColi_MPN_100ml )
• Nitrate_NO3_N_mgL ( type: esriFieldTypeString, alias: Nitrate NO3 N mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Nitrate_NO3_N_mgL )
• Nitrite_NO2_N_mgL ( type: esriFieldTypeString, alias: Nitrite NO2 N mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Nitrite_NO2_N_mgL )
• Nitrate_and_Nitrite_N_mgL ( type: esriFieldTypeString, alias: Nitrate and Nitrite N mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Nitrate_and_Nitrite_N_mgL )
• TotalSuspendedSolids_TSS_mgL ( type: esriFieldTypeString, alias: Total Suspended Solids TSS mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TotalSuspendedSolids_TSS_mgL )
• Phosphorus_mgL ( type: esriFieldTypeString, alias: Phosphorus mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Phosphorus_mgL )
• Calcium_mgL ( type: esriFieldTypeString, alias: Calcium mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Calcium_mgL )
• Copper_mgL ( type: esriFieldTypeString, alias: Copper mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Copper_mgL )
• Hardness_as_CaCO3_SM_2340B_mgL ( type: esriFieldTypeString, alias: Hardness as CaCO3_SM 2340B mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hardness_as_CaCO3_SM_2340B_mgL )
• Lead_mgL ( type: esriFieldTypeString, alias: Lead mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lead_mgL )
• Magnesium_mgL ( type: esriFieldTypeString, alias: Magnesium mgL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Magnesium_mgL )
• QAQC ( type: esriFieldTypeString, alias: QAQC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QAQC )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: Waypoint_Analytical_Table
  Description:
  Prototype:
  QAQC: null
  Magnesium_mgL: null
  ActID: null
  Site_ID_Station: null
  Watershed: null
  SampleDate: null
  LabReportNum: null
  LabSampleNum: null
  FieldID: null
  EColi_MPN_100ml: null
  Nitrate_NO3_N_mgL: null
  Nitrite_NO2_N_mgL: null
  Nitrate_and_Nitrite_N_mgL: null
  TotalSuspendedSolids_TSS_mgL: null
  Phosphorus_mgL: null
  Calcium_mgL: null
  Copper_mgL: null
  Hardness_as_CaCO3_SM_2340B_mgL: null
  Lead_mgL: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PW_GDB.PWGISEDITOR.Field_Sampling_Activity_Table (2) -- Related To: FIeld_Sampling_Activity_Table (4)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata