{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 6,
 "name": "Production.LI.Public_Bacteria",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 7,
   "name": "PublicWaterWells",
   "relatedTableId": 1,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "GUI",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "Name_of_Sampler",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "SampleClassification",
   "type": "esriFieldTypeString",
   "alias": "Sample Classification",
   "domain": {
    "type": "codedValue",
    "name": "Bact_SampleClassification",
    "description": "Sample Classification",
    "codedValues": [
     {
      "name": "Compliance",
      "code": "Compliance"
     },
     {
      "name": "Private",
      "code": "Private"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SampleClassification"
  },
  {
   "name": "SampleSource",
   "type": "esriFieldTypeString",
   "alias": "Sample Source",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SampleSource"
  },
  {
   "name": "SmpleC_or_R_Pos_smple_Date",
   "type": "esriFieldTypeDate",
   "alias": "Sample Type C or R Positive Sample Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "SmpleC_or_R_Pos_smple_Date"
  },
  {
   "name": "SmpleC_or_R_Pos_smple_ID",
   "type": "esriFieldTypeString",
   "alias": "Sample Type C or R Positive Sample ID\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SmpleC_or_R_Pos_smple_ID"
  },
  {
   "name": "WI_Unique_Well_Num",
   "type": "esriFieldTypeString",
   "alias": "WI Unique Well Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "WI_Unique_Well_Num"
  },
  {
   "name": "Entry_Pnt_ID",
   "type": "esriFieldTypeString",
   "alias": "Entry Point ID\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Entry_Pnt_ID"
  },
  {
   "name": "Sample_Collect_Date",
   "type": "esriFieldTypeDate",
   "alias": "Sample Collection Date\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Sample_Collect_Date"
  },
  {
   "name": "Sample_Collection_Address",
   "type": "esriFieldTypeString",
   "alias": "Sample Collection Address\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Sample_Collection_Address"
  },
  {
   "name": "Approved_Monitoring_PointID",
   "type": "esriFieldTypeString",
   "alias": "Approved Monitoring Point ID\n\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Approved_Monitoring_PointID"
  },
  {
   "name": "Monitoring_Point_Description",
   "type": "esriFieldTypeString",
   "alias": "Monitoring Point Description\n\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Monitoring_Point_Description"
  },
  {
   "name": "Name_of_Sampler",
   "type": "esriFieldTypeString",
   "alias": "Name of Sampler\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Name_of_Sampler"
  },
  {
   "name": "Sampler_Phone",
   "type": "esriFieldTypeString",
   "alias": "Sampler Phone\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Sampler_Phone"
  },
  {
   "name": "Lab_ID_Num",
   "type": "esriFieldTypeString",
   "alias": "Laboratory ID Number\n",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": "105-499",
   "modelName": "Lab_ID_Num"
  },
  {
   "name": "Lab_Name",
   "type": "esriFieldTypeString",
   "alias": "Laboratory Name\n",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Lab_Name"
  },
  {
   "name": "Date_Smple_Recieved",
   "type": "esriFieldTypeDate",
   "alias": "Date Sample Recieved",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Date_Smple_Recieved"
  },
  {
   "name": "ChlorineResidual_in_Sample",
   "type": "esriFieldTypeString",
   "alias": "Chlorine Residual in Sample",
   "domain": {
    "type": "codedValue",
    "name": "Bact_Yes_No",
    "description": "Yes_No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ChlorineResidual_in_Sample"
  },
  {
   "name": "Laboratory_SampleID",
   "type": "esriFieldTypeString",
   "alias": "Laboratory Sample ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Laboratory_SampleID"
  },
  {
   "name": "Cond_Sample_Upon_Reciept",
   "type": "esriFieldTypeString",
   "alias": "Condition of  Sample Upon Reciept / Other Comment",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Cond_Sample_Upon_Reciept"
  },
  {
   "name": "Recieving_Lab_Official",
   "type": "esriFieldTypeString",
   "alias": "Recieving Lab Official",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Recieving_Lab_Official"
  },
  {
   "name": "Date_Reported_to_System",
   "type": "esriFieldTypeDate",
   "alias": "Date Reported to System",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Date_Reported_to_System"
  },
  {
   "name": "Total_Coliform_Storet",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Storet",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "99190",
   "modelName": "Total_Coliform_Storet"
  },
  {
   "name": "Total_Coliform_Description",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "Colisure Presence/Absence",
   "modelName": "Total_Coliform_Description"
  },
  {
   "name": "Total_Coliform_SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform SDWA Method",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "9223B",
   "modelName": "Total_Coliform_SDWA_Method"
  },
  {
   "name": "Total_Coliform_Result",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Result",
   "domain": {
    "type": "codedValue",
    "name": "Bact_Absent_Present",
    "description": "Absent or Present",
    "codedValues": [
     {
      "name": "Absent",
      "code": "Absent"
     },
     {
      "name": "Present",
      "code": "Present"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Total_Coliform_Result"
  },
  {
   "name": "Total_Coliform_Units",
   "type": "esriFieldTypeString",
   "alias": "Total Coliform Units",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "/100ML",
   "modelName": "Total_Coliform_Units"
  },
  {
   "name": "E_Coli_Storet",
   "type": "esriFieldTypeString",
   "alias": "E Coli Storet",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "98931",
   "modelName": "E_Coli_Storet"
  },
  {
   "name": "E_Coli_Description",
   "type": "esriFieldTypeString",
   "alias": "E Coli Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "Colisure Presence / Absence",
   "modelName": "E_Coli_Description"
  },
  {
   "name": "E_Coli_SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "E Coli SDWA Method",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "9223B",
   "modelName": "E_Coli_SDWA_Method"
  },
  {
   "name": "E_Coli_Result",
   "type": "esriFieldTypeString",
   "alias": "E Coli Result",
   "domain": {
    "type": "codedValue",
    "name": "Bact_Absent_Present",
    "description": "Absent or Present",
    "codedValues": [
     {
      "name": "Absent",
      "code": "Absent"
     },
     {
      "name": "Present",
      "code": "Present"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "E_Coli_Result"
  },
  {
   "name": "E_Coli_Units",
   "type": "esriFieldTypeString",
   "alias": "E Coli Units",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "/100ML",
   "modelName": "E_Coli_Units"
  },
  {
   "name": "Qualifier_Code",
   "type": "esriFieldTypeString",
   "alias": "Qualifier Code",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Qualifier_Code"
  },
  {
   "name": "GUI",
   "type": "esriFieldTypeGUID",
   "alias": "GUI",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 38,
   "defaultValue": null,
   "modelName": "GUI"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  },
  {
   "name": "SampleType",
   "type": "esriFieldTypeString",
   "alias": "Sample Type",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 200,
   "defaultValue": null,
   "modelName": "SampleType"
  },
  {
   "name": "guid_copy",
   "type": "esriFieldTypeString",
   "alias": "guid_copy",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "guid_copy"
  }
 ],
 "indexes": [
  {
   "name": "R752_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_752",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G3091GUI",
   "fields": "GUI",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_752",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Production.LI.Public_Bacteria",
   "description": "",
   "prototype": {
    "attributes": {
     "SampleType": null,
     "guid_copy": null,
     "SampleClassification": null,
     "SampleSource": null,
     "SmpleC_or_R_Pos_smple_Date": null,
     "SmpleC_or_R_Pos_smple_ID": null,
     "WI_Unique_Well_Num": null,
     "Entry_Pnt_ID": null,
     "Sample_Collect_Date": null,
     "Sample_Collection_Address": null,
     "Approved_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_System": null,
     "Total_Coliform_Storet": "99190",
     "Total_Coliform_Description": "Colisure Presence/Absence",
     "Total_Coliform_SDWA_Method": "9223B",
     "Total_Coliform_Result": null,
     "Total_Coliform_Units": "/100ML",
     "E_Coli_Storet": "98931",
     "E_Coli_Description": "Colisure Presence / Absence",
     "E_Coli_SDWA_Method": "9223B",
     "E_Coli_Result": null,
     "E_Coli_Units": "/100ML",
     "Qualifier_Code": null,
     "GUI": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "2615caca8cff4d3ea4c1c99935e3f2f5"
}