{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 10,
 "name": "Production.LI.Private_Nitrate",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 3,
   "name": "PrivateWaterWells",
   "relatedTableId": 0,
   "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": "SampleType",
   "type": "esriFieldTypeString",
   "alias": "Sample Type",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SampleType"
  },
  {
   "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": "Monitoring_PointID",
   "type": "esriFieldTypeString",
   "alias": "Monitoring Point ID",
   "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_PWS",
   "type": "esriFieldTypeDate",
   "alias": "Date Reported to PWS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Date_Reported_to_System"
  },
  {
   "name": "Storet_Code",
   "type": "esriFieldTypeString",
   "alias": "Storet Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "620",
   "modelName": "Total_Coliform_Storet"
  },
  {
   "name": "SDWA_Method",
   "type": "esriFieldTypeString",
   "alias": "SDWA Method",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": "60005222",
   "modelName": "Total_Coliform_SDWA_Method"
  },
  {
   "name": "MDL",
   "type": "esriFieldTypeString",
   "alias": "MDL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Total_Coliform_Result"
  },
  {
   "name": "MCL",
   "type": "esriFieldTypeString",
   "alias": "MCL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": "10",
   "modelName": "E_Coli_Result"
  },
  {
   "name": "Units",
   "type": "esriFieldTypeString",
   "alias": "Units",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": "mg/L",
   "modelName": "E_Coli_Units"
  },
  {
   "name": "SamplePreserved_in_Field",
   "type": "esriFieldTypeString",
   "alias": "Sample Preserved in Field?",
   "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": 15,
   "defaultValue": null,
   "modelName": "Qualifier_Code"
  },
  {
   "name": "QualifierCode",
   "type": "esriFieldTypeString",
   "alias": "Qualifier Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "QualifierCode"
  },
  {
   "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": "Parameter",
   "type": "esriFieldTypeString",
   "alias": "Parameter",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": "Nitrate as N",
   "modelName": "Parameter"
  },
  {
   "name": "Results",
   "type": "esriFieldTypeDouble",
   "alias": "Nitrate Results",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Results"
  },
  {
   "name": "guid_copy",
   "type": "esriFieldTypeString",
   "alias": "guid_copy",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "guid_copy"
  }
 ],
 "indexes": [
  {
   "name": "R767_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_767",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G3106GUI",
   "fields": "GUI",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_767",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Production.LI.Private_Nitrate",
   "description": "",
   "prototype": {
    "attributes": {
     "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
    }
   },
   "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"
}