Name: Production.LI.Public_Nitrate

Display Field: Name_of_Sampler

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2615caca8cff4d3ea4c1c99935e3f2f5

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

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 )
• SampleClassification ( type: esriFieldTypeString, alias: Sample Classification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SampleClassification , Coded Values: [Compliance: Compliance] , [Private: Private] )
• SampleSource ( type: esriFieldTypeString, alias: Sample Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SampleSource , Coded Values: [D - Distribution Well: D - Distribution Well] , [W - Well/Source: W - Well/Source] , [E - Entry Point: E - Entry Point] )
• SampleType ( type: esriFieldTypeString, alias: Sample Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SampleType , Coded Values: [A: Additional Routine] , [C: Confirmation (Check)] , [D: Compliance Sample] , ...7 more... )
• Sample_Collect_Date ( type: esriFieldTypeDate, alias: Sample Collection Date , editable: true, nullable: true, length: 8, defaultValue: null, modelName: Sample_Collect_Date )
• Sample_Collection_Address ( type: esriFieldTypeString, alias: Sample Collection Address , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sample_Collection_Address )
• Monitoring_PointID ( type: esriFieldTypeString, alias: Monitoring Point ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Approved_Monitoring_PointID )
• Monitoring_Point_Description ( type: esriFieldTypeString, alias: Monitoring Point Description , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Monitoring_Point_Description )
• Name_of_Sampler ( type: esriFieldTypeString, alias: Name of Sampler , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Name_of_Sampler )
• Sampler_Phone ( type: esriFieldTypeString, alias: Sampler Phone , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sampler_Phone )
• Lab_ID_Num ( type: esriFieldTypeString, alias: Laboratory ID Number , editable: true, nullable: true, length: 25, defaultValue: 105-499, modelName: Lab_ID_Num )
• Lab_Name ( type: esriFieldTypeString, alias: Laboratory Name , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lab_Name , Coded Values: [Walworth County Health and Human Services: Walworth County Health and Human Services] , [Wisconsin State Lab of Hygiene: Wisconsin State Lab of Hygiene] , [Suburban Laboratories: Suburban Laboratories] , ...1 more... )
• Date_Smple_Recieved ( type: esriFieldTypeDate, alias: Date Sample Recieved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Smple_Recieved )
• ChlorineResidual_in_Sample ( type: esriFieldTypeString, alias: Chlorine Residual in Sample, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ChlorineResidual_in_Sample , Coded Values: [Yes: Yes] , [No: No] )
• Laboratory_SampleID ( type: esriFieldTypeString, alias: Laboratory Sample ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Laboratory_SampleID )
• Cond_Sample_Upon_Reciept ( type: esriFieldTypeString, alias: Condition of Sample Upon Reciept / Other Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Cond_Sample_Upon_Reciept )
• Recieving_Lab_Official ( type: esriFieldTypeString, alias: Recieving Lab Official, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Recieving_Lab_Official )
• Date_Reported_to_PWS ( type: esriFieldTypeDate, alias: Date Reported to PWS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Reported_to_System )
• Storet_Code ( type: esriFieldTypeString, alias: Storet Code, editable: true, nullable: true, length: 50, defaultValue: 620, modelName: Total_Coliform_Storet )
• SDWA_Method ( type: esriFieldTypeString, alias: SDWA Method, editable: true, nullable: true, length: 20, defaultValue: 60005222, modelName: Total_Coliform_SDWA_Method )
• MDL ( type: esriFieldTypeString, alias: MDL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Total_Coliform_Result )
• MCL ( type: esriFieldTypeString, alias: MCL, editable: true, nullable: true, length: 20, defaultValue: 10, modelName: E_Coli_Result )
• Units ( type: esriFieldTypeString, alias: Units, editable: true, nullable: true, length: 20, defaultValue: mg/L, modelName: E_Coli_Units )
• SamplePreserved_in_Field ( type: esriFieldTypeString, alias: Sample Preserved in Field?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Qualifier_Code , Coded Values: [Yes: Yes] , [No: No] )
• QualifierCode ( type: esriFieldTypeString, alias: Qualifier Code, editable: true, nullable: true, length: 30, defaultValue: null, modelName: QualifierCode )
• GUI ( type: esriFieldTypeGUID, alias: GUI, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUI )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Parameter ( type: esriFieldTypeString, alias: Parameter, editable: true, nullable: true, length: 50, defaultValue: Nitrate as N, modelName: Parameter )
• Results ( type: esriFieldTypeDouble, alias: Nitrate Results, editable: true, nullable: true, defaultValue: null, modelName: Results )
• guid_copy ( type: esriFieldTypeString, alias: guid_copy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: guid_copy )

Templates:

• Name: Production.LI.Public_Nitrate
  Description:
  Prototype:
  Results: null
  Parameter: Nitrate as N
  SampleClassification: null
  SampleSource: null
  SampleType: null
  Sample_Collect_Date: null
  Sample_Collection_Address: null
  Monitoring_PointID: null
  Monitoring_Point_Description: null
  Name_of_Sampler: null
  Sampler_Phone: null
  Lab_ID_Num: 105-499
  Lab_Name: null
  Date_Smple_Recieved: null
  ChlorineResidual_in_Sample: null
  Laboratory_SampleID: null
  Cond_Sample_Upon_Reciept: null
  Recieving_Lab_Official: null
  Date_Reported_to_PWS: null
  Storet_Code: 620
  SDWA_Method: 60005222
  MDL: null
  MCL: 10
  Units: mg/L
  SamplePreserved_in_Field: null
  QualifierCode: null
  GUI: null
  guid_copy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PublicWaterWells (11) -- Related To: Production.LI.PublicWaterWells (1)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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