{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 8,
 "name": "Linear Treatment 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": "InspectionDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "PrimaryInspector",
   "type": "esriFieldTypeString",
   "alias": "PrimaryInspector",
   "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": "SecondaryInspector",
   "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": "InspectionType",
   "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": "DateLastPrecipitation",
   "length": 8,
   "domain": null
  },
  {
   "name": "QuantityLastPrecipitation",
   "type": "esriFieldTypeDouble",
   "alias": "QuantityLastPrecipitation",
   "domain": null
  },
  {
   "name": "AestheticsCondition",
   "type": "esriFieldTypeString",
   "alias": "AestheticsCondition",
   "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": "AestheticsComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "HydraulicRecoveryCondition",
   "type": "esriFieldTypeString",
   "alias": "HydraulicRecoveryCondition",
   "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": "HydraulicRecoveryComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "VegetationCondition",
   "type": "esriFieldTypeString",
   "alias": "VegetationCondition",
   "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": "VegetationComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "StructuralCondition",
   "type": "esriFieldTypeString",
   "alias": "StructuralCondition",
   "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": "StructuralComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "WaterCondition",
   "type": "esriFieldTypeString",
   "alias": "WaterCondition",
   "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": "WaterComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "ErosionCondition",
   "type": "esriFieldTypeString",
   "alias": "ErosionCondition",
   "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": "ErosionComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "OverallPondCondition",
   "type": "esriFieldTypeString",
   "alias": "OverallPondCondition",
   "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": "OverallPondComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "PublicSafetyHazards",
   "type": "esriFieldTypeString",
   "alias": "PublicSafetyHazards",
   "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": "PublicSafetyComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "SuspectedIDDE",
   "type": "esriFieldTypeString",
   "alias": "SuspectedIDDE",
   "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": "SuspectedIDDEComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "InspectionResult",
   "type": "esriFieldTypeString",
   "alias": "InspectionResult",
   "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": "InspectionResultComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "ReviewerName",
   "type": "esriFieldTypeString",
   "alias": "ReviewerName",
   "length": 50,
   "domain": null
  },
  {
   "name": "ReviewDate",
   "type": "esriFieldTypeDate",
   "alias": "ReviewDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "QAStatus",
   "type": "esriFieldTypeString",
   "alias": "QAStatus",
   "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": "QAComments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "InspectionReviewNeeded",
   "type": "esriFieldTypeString",
   "alias": "InspectionReviewNeeded",
   "length": 4,
   "domain": null
  },
  {
   "name": "MaintenanceReviewNeeded",
   "type": "esriFieldTypeString",
   "alias": "MaintenanceReviewNeeded",
   "length": 4,
   "domain": null
  },
  {
   "name": "Report",
   "type": "esriFieldTypeString",
   "alias": "Report",
   "length": 1073741822,
   "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": "MaintenanceRequired",
   "length": 4,
   "domain": null
  },
  {
   "name": "OrigParentGUIDText",
   "type": "esriFieldTypeString",
   "alias": "OrigParentGUIDText",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "OrigInspectionGUIDText",
   "type": "esriFieldTypeString",
   "alias": "OrigInspectionGUIDText",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "ParentGUID",
   "type": "esriFieldTypeGUID",
   "alias": "ParentGUID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R199_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G1189ParentGUID",
   "fields": "ParentGUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_199",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 6,
   "name": "D5LTreatmentMaintenanceNeeds",
   "relatedTableId": 9,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{2C59A320-CEDF-4C36-B5D1-DB83C35FA638}"
  },
  {
   "id": 3,
   "name": "D5LinearTreatment",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "ParentGUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{75EF4609-D750-4A67-BD0F-6186BAD5F58A}"
  }
 ],
 "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": "02d09fe5f6794803b3449ba1df1d8162"
}