{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 4,
 "name": "Production.LI.Public_Nitrate",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Name_of_Sampler",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SampleClassification",
   "type": "esriFieldTypeString",
   "alias": "Sample Classification",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_SampleClassification",
    "description": "Sample Classification",
    "codedValues": [
     {
      "name": "Compliance",
      "code": "Compliance"
     },
     {
      "name": "Private",
      "code": "Private"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SampleSource",
   "type": "esriFieldTypeString",
   "alias": "Sample Source",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Sampl_Source",
    "description": "Bacteria Sample Source",
    "codedValues": [
     {
      "name": "D - Distribution Well",
      "code": "D - Distribution Well"
     },
     {
      "name": "W - Well/Source",
      "code": "W - Well/Source"
     },
     {
      "name": "E - Entry Point",
      "code": "E - Entry Point"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SampleType",
   "type": "esriFieldTypeString",
   "alias": "Sample Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PublicStatusTypes",
    "description": "Public Status Types",
    "codedValues": [
     {
      "name": "Additional Routine",
      "code": "A"
     },
     {
      "name": "Confirmation (Check)",
      "code": "C"
     },
     {
      "name": "Compliance Sample",
      "code": "D"
     },
     {
      "name": "Grab Sample",
      "code": "G"
     },
     {
      "name": "Investigation",
      "code": "I"
     },
     {
      "name": "Other Compliance",
      "code": "O"
     },
     {
      "name": "Repeat",
      "code": "R"
     },
     {
      "name": "Triggered Source Water",
      "code": "T"
     },
     {
      "name": "Unknown",
      "code": "U"
     },
     {
      "name": "Raw Water Sample",
      "code": "W"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Sample_Collect_Date",
   "type": "esriFieldTypeDate",
   "alias": "Sample Collection Date\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "Sample_Collection_Address",
   "type": "esriFieldTypeString",
   "alias": "Sample Collection Address\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "Monitoring_PointID",
   "type": "esriFieldTypeString",
   "alias": "Monitoring Point ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "Monitoring_Point_Description",
   "type": "esriFieldTypeString",
   "alias": "Monitoring Point Description\n\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "Name_of_Sampler",
   "type": "esriFieldTypeString",
   "alias": "Name of Sampler\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "Sampler_Phone",
   "type": "esriFieldTypeString",
   "alias": "Sampler Phone\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "Lab_ID_Num",
   "type": "esriFieldTypeString",
   "alias": "Laboratory ID Number\n",
   "length": 25,
   "domain": null
  },
  {
   "name": "Lab_Name",
   "type": "esriFieldTypeString",
   "alias": "Laboratory Name\n",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Laboratory Name",
    "description": "Lab Name",
    "codedValues": [
     {
      "name": "Walworth County Health and Human Services",
      "code": "Walworth County Health and Human Services"
     },
     {
      "name": "Wisconsin State Lab of Hygiene",
      "code": "Wisconsin State Lab of Hygiene"
     },
     {
      "name": "Suburban Laboratories",
      "code": "Suburban Laboratories"
     },
     {
      "name": "TGA Laboratories",
      "code": "TGA Laboratories"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Date_Smple_Recieved",
   "type": "esriFieldTypeDate",
   "alias": "Date Sample Recieved",
   "length": 8,
   "domain": null
  },
  {
   "name": "ChlorineResidual_in_Sample",
   "type": "esriFieldTypeString",
   "alias": "Chlorine Residual in Sample",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Yes_No",
    "description": "Yes_No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Laboratory_SampleID",
   "type": "esriFieldTypeString",
   "alias": "Laboratory Sample ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "Cond_Sample_Upon_Reciept",
   "type": "esriFieldTypeString",
   "alias": "Condition of  Sample Upon Reciept / Other Comment",
   "length": 50,
   "domain": null
  },
  {
   "name": "Recieving_Lab_Official",
   "type": "esriFieldTypeString",
   "alias": "Recieving Lab Official",
   "length": 50,
   "domain": null
  },
  {
   "name": "Date_Reported_to_PWS",
   "type": "esriFieldTypeDate",
   "alias": "Date Reported to PWS",
   "length": 8,
   "domain": null
  },
  {
   "name": "Storet_Code",
   "type": "esriFieldTypeString",
   "alias": "Storet Code",
   "length": 50,
   "domain": null
  },
  {
   "name": "SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "SDWA Method",
   "length": 20,
   "domain": null
  },
  {
   "name": "MDL",
   "type": "esriFieldTypeString",
   "alias": "MDL",
   "length": 50,
   "domain": null
  },
  {
   "name": "MCL",
   "type": "esriFieldTypeString",
   "alias": "MCL",
   "length": 20,
   "domain": null
  },
  {
   "name": "Units",
   "type": "esriFieldTypeString",
   "alias": "Units",
   "length": 20,
   "domain": null
  },
  {
   "name": "SamplePreserved_in_Field",
   "type": "esriFieldTypeString",
   "alias": "Sample Preserved in Field?",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Yes_No",
    "description": "Yes_No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "QualifierCode",
   "type": "esriFieldTypeString",
   "alias": "Qualifier Code",
   "length": 30,
   "domain": null
  },
  {
   "name": "GUI",
   "type": "esriFieldTypeGUID",
   "alias": "GUI",
   "length": 38,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Parameter",
   "type": "esriFieldTypeString",
   "alias": "Parameter",
   "length": 50,
   "domain": null
  },
  {
   "name": "Results",
   "type": "esriFieldTypeDouble",
   "alias": "Nitrate Results",
   "domain": null
  },
  {
   "name": "guid_copy",
   "type": "esriFieldTypeString",
   "alias": "guid_copy",
   "length": 100,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R753_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_753",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G3092GUI",
   "fields": "GUI",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_753",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 10,
   "name": "PublicWaterWells",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "GUI",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "77185000662a4ed79aa70dd9f3cff930"
}