{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 12,
 "name": "Production.LI.Private_Bacteria",
 "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": "SmpleC_or_R_Pos_smple_Date",
   "type": "esriFieldTypeDate",
   "alias": "Sample Type C or R Positive Sample Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "SmpleC_or_R_Pos_smple_ID",
   "type": "esriFieldTypeString",
   "alias": "Sample Type C or R Positive Sample ID\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "WI_Unique_Well_Num",
   "type": "esriFieldTypeString",
   "alias": "WI Unique Well Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "Entry_Pnt_ID",
   "type": "esriFieldTypeString",
   "alias": "Entry Point ID\n",
   "length": 50,
   "domain": null
  },
  {
   "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": "Approved_Monitoring_PointID",
   "type": "esriFieldTypeString",
   "alias": "Approved Monitoring Point ID\n\n",
   "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_System",
   "type": "esriFieldTypeDate",
   "alias": "Date Reported to System",
   "length": 8,
   "domain": null
  },
  {
   "name": "Total_Coliform_Storet",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Storet",
   "length": 50,
   "domain": null
  },
  {
   "name": "Total_Coliform_Description",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "Total_Coliform_SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform SDWA Method",
   "length": 50,
   "domain": null
  },
  {
   "name": "Total_Coliform_Result",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Result",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Absent_Present",
    "description": "Absent or Present",
    "codedValues": [
     {
      "name": "Absent",
      "code": "Absent"
     },
     {
      "name": "Present",
      "code": "Present"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Total_Coliform_Units",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Units",
   "length": 50,
   "domain": null
  },
  {
   "name": "E_Coli_Storet",
   "type": "esriFieldTypeString",
   "alias": "E Coli Storet",
   "length": 50,
   "domain": null
  },
  {
   "name": "E_Coli_Description",
   "type": "esriFieldTypeString",
   "alias": "E Coli Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "E_Coli_SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "E Coli SDWA Method",
   "length": 50,
   "domain": null
  },
  {
   "name": "E_Coli_Result",
   "type": "esriFieldTypeString",
   "alias": "E Coli Result",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Absent_Present",
    "description": "Absent or Present",
    "codedValues": [
     {
      "name": "Absent",
      "code": "Absent"
     },
     {
      "name": "Present",
      "code": "Present"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "E_Coli_Units",
   "type": "esriFieldTypeString",
   "alias": "E Coli Units",
   "length": 50,
   "domain": null
  },
  {
   "name": "Qualifier_Code",
   "type": "esriFieldTypeString",
   "alias": "Qualifier Code",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Bact_Qual_Code",
    "description": "Qualifier Code",
    "codedValues": [
     {
      "name": "0- Non-Numeric/Not Verified",
      "code": "0- Non-Numeric/Not Verified"
     },
     {
      "name": "1-Normal(No Problem with sample)",
      "code": "1-Normal(No Problem with sample)"
     },
     {
      "name": "2- Non-Detect",
      "code": "2- Non-Detect"
     },
     {
      "name": "3- Between LOD and LOQ",
      "code": "3- Between LOD and LOQ"
     },
     {
      "name": "5- Too much contaminant to quantify",
      "code": "5- Too much contaminant to quantify"
     },
     {
      "name": "6-Screen Detect",
      "code": "6-Screen Detect"
     },
     {
      "name": "F- Field Result",
      "code": "F- Field Result"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GUI",
   "type": "esriFieldTypeGUID",
   "alias": "GUI",
   "length": 38,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "SampleType",
   "type": "esriFieldTypeString",
   "alias": "Sample Type",
   "length": 200,
   "domain": {
    "type": "codedValue",
    "name": "PrivateStatusTypes",
    "description": "Private Status Types",
    "codedValues": [
     {
      "name": "Urban Air",
      "code": "UA"
     },
     {
      "name": "Annual Test",
      "code": "A"
     },
     {
      "name": "Real Estate",
      "code": "E"
     },
     {
      "name": "Pump Work - Existing Well",
      "code": "KE"
     },
     {
      "name": "Pump Work - New Well",
      "code": "KN"
     },
     {
      "name": "Previous Unsafe Following Pump Work",
      "code": "KU"
     },
     {
      "name": "New Well or New Construction",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "guid_copy",
   "type": "esriFieldTypeString",
   "alias": "guid_copy",
   "length": 100,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R763_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_763",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G3102GUI",
   "fields": "GUI",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_763",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "PrivateWaterWells",
   "relatedTableId": 0,
   "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"
}