{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 1,
 "name": "Storm Catchbasin Inspections",
 "type": "Table",
 "description": null,
 "copyrightText": null,
 "hasAttachments": true,
 "attachmentProperties": [
  {
   "name": "id",
   "fieldName": "ATTACHMENTID",
   "isEnabled": true
  },
  {
   "name": "globalid",
   "fieldName": "GLOBALID",
   "isEnabled": true
  },
  {
   "name": "keywords",
   "fieldName": "KEYWORDS",
   "isEnabled": false
  },
  {
   "name": "name",
   "fieldName": "ATT_NAME",
   "isEnabled": true
  },
  {
   "name": "contentType",
   "fieldName": "CONTENT_TYPE",
   "isEnabled": true
  },
  {
   "name": "size",
   "fieldName": "DATA_SIZE",
   "isEnabled": true
  },
  {
   "name": "exifInfo",
   "fieldName": "EXIFINFO",
   "isEnabled": false
  }
 ],
 "attachmentFields": [
  {
   "name": "ATTACHMENTID",
   "type": "esriFieldTypeOID",
   "alias": "ATTACHMENTID",
   "editable": false,
   "nullable": false,
   "length": 4,
   "domain": null
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GLOBALID",
   "editable": false,
   "nullable": false,
   "length": 38,
   "domain": null
  },
  {
   "name": "ATT_NAME",
   "type": "esriFieldTypeString",
   "alias": "ATT_NAME",
   "editable": true,
   "nullable": false,
   "length": 250,
   "domain": null
  },
  {
   "name": "CONTENT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "CONTENT_TYPE",
   "editable": true,
   "nullable": false,
   "length": 150,
   "domain": null
  },
  {
   "name": "DATA_SIZE",
   "type": "esriFieldTypeInteger",
   "alias": "DATA_SIZE",
   "editable": true,
   "nullable": false,
   "length": 4,
   "domain": null
  }
 ],
 "supportsAttachmentsResizing": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Inspector_Name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "CB_ID",
   "type": "esriFieldTypeString",
   "alias": "CB_ID",
   "length": 500,
   "domain": null
  },
  {
   "name": "CB_Size",
   "type": "esriFieldTypeString",
   "alias": "CB_Size",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "CB_Size",
    "description": "",
    "codedValues": [
     {
      "name": "Single",
      "code": "Single"
     },
     {
      "name": "Double",
      "code": "Double"
     },
     {
      "name": "Quad",
      "code": "Quad"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Clean_Complete",
   "type": "esriFieldTypeString",
   "alias": "Cleanout Completed",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "CB_CleaningStatus",
    "description": "",
    "codedValues": [
     {
      "name": "Yes - Completed",
      "code": "Yes - Completed"
     },
     {
      "name": "No - Lid Opened - Not Required",
      "code": "No - Lid Opened - Not Required"
     },
     {
      "name": "No - Lid Defect",
      "code": "No - Lid Defect"
     },
     {
      "name": "No - Not Accessible",
      "code": "No - Not Accessible"
     },
     {
      "name": "No - Manhole",
      "code": "No - Manhole"
     },
     {
      "name": "No - Could Not Locate - Further Inspection Required",
      "code": "No - Could Not Locate - Further Inspection Required"
     },
     {
      "name": "No - Does Not Exist",
      "code": "No - Does Not Exist"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Cleanout_Date",
   "type": "esriFieldTypeDate",
   "alias": "Cleanout Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Inspected_By",
   "type": "esriFieldTypeString",
   "alias": "Inspected By",
   "length": 1073741822,
   "domain": {
    "type": "codedValue",
    "name": "Inspector",
    "description": "",
    "codedValues": [
     {
      "name": "Engineering",
      "code": "Engineering"
     },
     {
      "name": "Stormwater - Derek Laforge",
      "code": "Stormwater - Derek Laforge"
     },
     {
      "name": "Stormwater - Mike Smithson",
      "code": "Stormwater - Mike Smithson"
     },
     {
      "name": "Stormwater - Morgan Van Laeken",
      "code": "Stormwater - Morgan Van Laeken"
     },
     {
      "name": "Stormwater - Chris Dunn",
      "code": "Stormwater - Chris Dunn"
     },
     {
      "name": "Stormwater - Student",
      "code": "Stormwater - Student"
     },
     {
      "name": "Roads",
      "code": "Roads"
     },
     {
      "name": "Municipal Drainage",
      "code": "Municipal Drainage"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Inspection_Date",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Inspection_Type",
   "type": "esriFieldTypeString",
   "alias": "Inspection Type",
   "length": 1073741822,
   "domain": {
    "type": "codedValue",
    "name": "CB_InspType",
    "description": "",
    "codedValues": [
     {
      "name": "Field Verification",
      "code": "Field Verification"
     },
     {
      "name": "Maintenance/Repair",
      "code": "Maintenance/Repair Activity"
     },
     {
      "name": "Post-Maintenance/Repair Inspection",
      "code": "Post-Maintenance/Repair Inspection"
     },
     {
      "name": "Routine Condition/Performance",
      "code": "Routine Condition/Performance Assessment"
     },
     {
      "name": "Detailed Asset Inventory",
      "code": "Detailed Asset Inventory"
     },
     {
      "name": "Special Request",
      "code": "Special Request"
     },
     {
      "name": "Service Request/Complaint Follow-up",
      "code": "Service Request/Complaint Follow-up"
     },
     {
      "name": "CB Cleaning Program",
      "code": "CB Cleaning Program"
     },
     {
      "name": "Construction",
      "code": "Construction"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Overall_Condition",
   "type": "esriFieldTypeString",
   "alias": "Overall Condition",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "CUL_Condition",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "New",
      "code": "New"
     },
     {
      "name": "Critical",
      "code": "Critical"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Service_Provider",
   "type": "esriFieldTypeString",
   "alias": "Inspector_Name",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "Service Provider",
    "description": "",
    "codedValues": [
     {
      "name": "Derek Laforge",
      "code": "Derek Laforge"
     },
     {
      "name": "Mike Smithson",
      "code": "Mike Smithson"
     },
     {
      "name": "Morgan Van Laeken",
      "code": "Morgan Van Laeken"
     },
     {
      "name": "Chris Dunn",
      "code": "Chris Dunn"
     },
     {
      "name": "Stormwater Staff - Multiple",
      "code": "Stormwater Staff - Multiple"
     },
     {
      "name": "Municipal Drainage",
      "code": "Municipal Drainage"
     },
     {
      "name": "Roads",
      "code": "Roads"
     },
     {
      "name": "Contractor",
      "code": "Contractor"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Maint_Repair_Date",
   "type": "esriFieldTypeDate",
   "alias": "Maint_Repair_Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Capacity",
   "type": "esriFieldTypeString",
   "alias": "Capacity",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "Condition Good,Fair,Poor,Critical",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Critical",
      "code": "Critical"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Condition",
   "type": "esriFieldTypeString",
   "alias": "Structure_Condition",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "CUL_Condition",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "New",
      "code": "New"
     },
     {
      "name": "Critical",
      "code": "Critical"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Contractor",
   "type": "esriFieldTypeString",
   "alias": "Contractor",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "Last_Rain_Event",
   "type": "esriFieldTypeString",
   "alias": "Last_Rain_Event",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "Last_Rain_Event",
    "description": "Last Rain Event",
    "codedValues": [
     {
      "name": "0-12 Hours",
      "code": "0-12 Hours"
     },
     {
      "name": "13-24 Hours",
      "code": "13-24 Hours"
     },
     {
      "name": "25-48 Hours",
      "code": "25-48 Hours"
     },
     {
      "name": "49-72 Hours",
      "code": "49-72 Hours"
     },
     {
      "name": ">72 Hours",
      "code": ">72 Hours"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CB_Size_mm",
   "type": "esriFieldTypeString",
   "alias": "CB_Size_mm",
   "length": 255,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "gdb_ct3_82",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_1277_CB_ID",
   "fields": "CB_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "StormWater.DBO.Catchbasins",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{FF7D07EF-CA56-4DD4-B252-894C50614EE0}"
  }
 ],
 "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,
  "supportsQueryAttachments": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1734380609000
 },
 "serviceItemId": "e4c609a4aba6492ca49089a6a6a38e0d"
}