{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 23,
 "name": "Pond Inspections",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ReviewerName",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "InspectionDate",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PrimaryInspector",
   "type": "esriFieldTypeString",
   "alias": "Primary Inspector",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "D5Inspectors",
    "description": "D5Inspectors",
    "codedValues": [
     {
      "name": "Robert Potts",
      "code": "Robert Potts"
     },
     {
      "name": "Andrew Allan",
      "code": "Andrew Allan"
     },
     {
      "name": "Craig Eudell",
      "code": "Craig Eudell"
     },
     {
      "name": "Leilani Ferrell",
      "code": "Leilani Ferrell"
     },
     {
      "name": "Esteban Lopez",
      "code": "Esteban Lopez"
     },
     {
      "name": "Edward Northey",
      "code": "Edward Northey"
     },
     {
      "name": "Emily Rogers",
      "code": "Emily Rogers"
     },
     {
      "name": "Lisa Bally",
      "code": "Lisa Bally"
     },
     {
      "name": "Jennifer Cappelleti",
      "code": "Jennifer Cappelleti"
     },
     {
      "name": "Daryl Meyers",
      "code": "Daryl Myers"
     },
     {
      "name": "Brian McKee",
      "code": "Brian McKee"
     },
     {
      "name": "Dustin Hampton",
      "code": "Dustin Hampton"
     },
     {
      "name": "Chris Thompson",
      "code": "Chris Thompson"
     },
     {
      "name": "Carlos Colon",
      "code": "Carlos Colon"
     },
     {
      "name": "Richard Wawrzyniak",
      "code": "Richard Wawrzyniak"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SecondaryInspector",
   "type": "esriFieldTypeString",
   "alias": "Secondary Inspector",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "D5Inspectors",
    "description": "D5Inspectors",
    "codedValues": [
     {
      "name": "Robert Potts",
      "code": "Robert Potts"
     },
     {
      "name": "Andrew Allan",
      "code": "Andrew Allan"
     },
     {
      "name": "Craig Eudell",
      "code": "Craig Eudell"
     },
     {
      "name": "Leilani Ferrell",
      "code": "Leilani Ferrell"
     },
     {
      "name": "Esteban Lopez",
      "code": "Esteban Lopez"
     },
     {
      "name": "Edward Northey",
      "code": "Edward Northey"
     },
     {
      "name": "Emily Rogers",
      "code": "Emily Rogers"
     },
     {
      "name": "Lisa Bally",
      "code": "Lisa Bally"
     },
     {
      "name": "Jennifer Cappelleti",
      "code": "Jennifer Cappelleti"
     },
     {
      "name": "Daryl Meyers",
      "code": "Daryl Myers"
     },
     {
      "name": "Brian McKee",
      "code": "Brian McKee"
     },
     {
      "name": "Dustin Hampton",
      "code": "Dustin Hampton"
     },
     {
      "name": "Chris Thompson",
      "code": "Chris Thompson"
     },
     {
      "name": "Carlos Colon",
      "code": "Carlos Colon"
     },
     {
      "name": "Richard Wawrzyniak",
      "code": "Richard Wawrzyniak"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "InspectionType",
   "type": "esriFieldTypeString",
   "alias": "Inspection Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "InspectionType",
    "description": "Inspection Types",
    "codedValues": [
     {
      "name": "Routine",
      "code": "Routine"
     },
     {
      "name": "Annual",
      "code": "Annual"
     },
     {
      "name": "Return - Field Inspection",
      "code": "Return - Field Inspection"
     },
     {
      "name": "Return - Desktop Inspection",
      "code": "Return - Desktop Inspection"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DateLastPrecipitation",
   "type": "esriFieldTypeDate",
   "alias": "Date Last Precipitation",
   "length": 8,
   "domain": null
  },
  {
   "name": "QuantityLastPrecipitation",
   "type": "esriFieldTypeDouble",
   "alias": "Quantity Last Precipitation (in)",
   "domain": {
    "type": "range",
    "name": "RainfallInches",
    "description": "Rainfall Range",
    "range": [
     0,
     50
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "AestheticsCondition",
   "type": "esriFieldTypeString",
   "alias": "Aesthetics Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "AestheticsComments",
   "type": "esriFieldTypeString",
   "alias": "Aesthetics Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "HydraulicRecoveryCondition",
   "type": "esriFieldTypeString",
   "alias": "Hydraulic Recovery Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "HydraulicRecoveryComments",
   "type": "esriFieldTypeString",
   "alias": "Hydraulic Recovery Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "VegetationCondition",
   "type": "esriFieldTypeString",
   "alias": "Vegetation Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "VegetationComments",
   "type": "esriFieldTypeString",
   "alias": "Vegetation Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "StructuralCondition",
   "type": "esriFieldTypeString",
   "alias": "Structural Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "StructuralComments",
   "type": "esriFieldTypeString",
   "alias": "Structural Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "WaterCondition",
   "type": "esriFieldTypeString",
   "alias": "Water Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WaterComments",
   "type": "esriFieldTypeString",
   "alias": "Water Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "ErosionCondition",
   "type": "esriFieldTypeString",
   "alias": "Erosion Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ErosionComments",
   "type": "esriFieldTypeString",
   "alias": "Erosion Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "OverallPondCondition",
   "type": "esriFieldTypeString",
   "alias": "Overall Pond Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ratings",
    "description": "Ratings",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OverallPondComments",
   "type": "esriFieldTypeString",
   "alias": "Overall Pond Condition Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "PublicSafetyHazards",
   "type": "esriFieldTypeString",
   "alias": "Public Safety Hazards",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Selections",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PublicSafetyComments",
   "type": "esriFieldTypeString",
   "alias": "Public Safety Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "SuspectedIDDE",
   "type": "esriFieldTypeString",
   "alias": "Suspected IDDE",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Selections",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SuspectedIDDEComments",
   "type": "esriFieldTypeString",
   "alias": "Suspected IDDE Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "InspectionResult",
   "type": "esriFieldTypeString",
   "alias": "Inspection Result",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "InspectionResult",
    "description": "Inspection Result",
    "codedValues": [
     {
      "name": "Performing as designed and permitted",
      "code": "Performing as designed and permitted"
     },
     {
      "name": "Not performing as designed and permitted",
      "code": "Not performing as designed and permitted"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "InspectionResultComments",
   "type": "esriFieldTypeString",
   "alias": "Inspection Result Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "ReviewerName",
   "type": "esriFieldTypeString",
   "alias": "Reviewer Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "ReviewDate",
   "type": "esriFieldTypeDate",
   "alias": "Review Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "QAStatus",
   "type": "esriFieldTypeString",
   "alias": "QA Status",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "QAStatus",
    "description": "QA Status",
    "codedValues": [
     {
      "name": "Passed",
      "code": "Passed"
     },
     {
      "name": "Requires Edits",
      "code": "Requires Edits"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "QAComments",
   "type": "esriFieldTypeString",
   "alias": "QA Comments",
   "length": 600,
   "domain": null
  },
  {
   "name": "Report",
   "type": "esriFieldTypeString",
   "alias": "Inspection Report",
   "length": 256,
   "domain": null
  },
  {
   "name": "InspectionReviewNeeded",
   "type": "esriFieldTypeString",
   "alias": "Inspection Review Needed",
   "length": 4,
   "domain": null
  },
  {
   "name": "MaintenanceReviewNeeded",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Review Needed",
   "length": 4,
   "domain": null
  },
  {
   "name": "OrigParentGUIDText",
   "type": "esriFieldTypeString",
   "alias": "OrigParentGUIDText",
   "length": 256,
   "domain": null
  },
  {
   "name": "OrigInspectionGUIDText",
   "type": "esriFieldTypeString",
   "alias": "OrigInspectionGUIDText",
   "length": 256,
   "domain": null
  },
  {
   "name": "ParentGUID",
   "type": "esriFieldTypeGUID",
   "alias": "ParentGUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Created_User",
   "type": "esriFieldTypeString",
   "alias": "Created User",
   "length": 255,
   "domain": null
  },
  {
   "name": "Created_Date",
   "type": "esriFieldTypeDate",
   "alias": "Created Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Last_Editor",
   "type": "esriFieldTypeString",
   "alias": "Last Editor",
   "length": 255,
   "domain": null
  },
  {
   "name": "Last_Edited_Date",
   "type": "esriFieldTypeDate",
   "alias": "Last Edited Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "MaintenanceRequired",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Required",
   "length": 4,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R51_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G107ParentGUID",
   "fields": "ParentGUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_51",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 13,
   "name": "D5PondMaintenanceNeeds",
   "relatedTableId": 24,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{85E5C3BF-777C-49C5-B313-70E24B331592}"
  },
  {
   "id": 0,
   "name": "D5Ponds",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "ParentGUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{1E5216EE-5F1B-4A4E-98FE-F6530B985BF3}"
  },
  {
   "id": 5,
   "name": "D5Ponds",
   "relatedTableId": 9,
   "role": "esriRelRoleDestination",
   "keyField": "ParentGUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{1E5216EE-5F1B-4A4E-98FE-F6530B985BF3}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "643a046a13df40b7bf4c705dec8860a6"
}