{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 5,
 "name": "Inspections",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "INSPECTR",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "SWMFAC_GUID",
   "type": "esriFieldTypeGUID",
   "alias": "SWMFAC_GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "DATE_INSP",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPECTR",
   "type": "esriFieldTypeString",
   "alias": "Inspector Name(s)",
   "length": 255,
   "domain": null
  },
  {
   "name": "DATE_STORM",
   "type": "esriFieldTypeDate",
   "alias": "Date of Last Storm Event",
   "length": 8,
   "domain": null
  },
  {
   "name": "MOW",
   "type": "esriFieldTypeString",
   "alias": "Ability to mow designation areas",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "d_Mowability_Rating",
    "description": "Mowability Note side slopes in comments",
    "codedValues": [
     {
      "name": "0 - NO Mowing Required",
      "code": "0"
     },
     {
      "name": "1 - Slopes 4:1 or flatter or tractor.",
      "code": "1"
     },
     {
      "name": "2 - Emb./Spillway/Outfall flat. Other components are too steep.",
      "code": "2"
     },
     {
      "name": "3 - Same as above but too steep to be kept clear w/o hand equipment.",
      "code": "3"
     },
     {
      "name": "4 - All components are too steep.",
      "code": "4"
     },
     {
      "name": "5 - All components are too steep. Large Specialized equipment required.",
      "code": "5"
     },
     {
      "name": "NR - Could NOT Inspect",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MOW_COM",
   "type": "esriFieldTypeString",
   "alias": "Comment - Mowing",
   "length": 255,
   "domain": null
  },
  {
   "name": "ACCESS_FACILITY",
   "type": "esriFieldTypeString",
   "alias": "Access to and around the facility",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "d_Access_Rating",
    "description": "Vegetation is an obstruction for ALL",
    "codedValues": [
     {
      "name": "0 - NOT part of design",
      "code": "0"
     },
     {
      "name": "1 - 5 Criteria Met",
      "code": "1"
     },
     {
      "name": "2 -  4 Criteria Met",
      "code": "2"
     },
     {
      "name": "3 - 3 Criteria Met",
      "code": "3"
     },
     {
      "name": "4 - 1 or 2 Criteria Met",
      "code": "4"
     },
     {
      "name": "5 - 0 Criteria Met",
      "code": "5"
     },
     {
      "name": "NR - Could NOT Inspect",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COM_ACCESS",
   "type": "esriFieldTypeString",
   "alias": "Comment - Access",
   "length": 255,
   "domain": null
  },
  {
   "name": "WILDLIFE_EXISTS",
   "type": "esriFieldTypeString",
   "alias": "Signs of Wildlife Activity",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D_BooleanValues",
    "description": "Numeric Value 1 = True, 2 = False",
    "codedValues": [
     {
      "name": "True",
      "code": "1"
     },
     {
      "name": "False",
      "code": "2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WILDLIFE_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "Comment - Wildlife",
   "length": 255,
   "domain": null
  },
  {
   "name": "OUTFALL",
   "type": "esriFieldTypeString",
   "alias": "Outfall of the principal spillway",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "d_Spillway_Outfall_Rating",
    "description": "Blockage at Outfall plus 25\u2019",
    "codedValues": [
     {
      "name": "1 - No stream erosion. Stable channel invert/slopes. No debris.",
      "code": "1"
     },
     {
      "name": "2 - 0 to 25%; Minor erosion. Stable channel invert/ slopes.",
      "code": "2"
     },
     {
      "name": "3 - 26 to 50%; Moderate/Active erosion bottom/slopes. RRP Minor relocation.",
      "code": "3"
     },
     {
      "name": "4 - 51 to 75%; Major/Unstable. RRP Major relocation. Maint. Immediately",
      "code": "4"
     },
     {
      "name": "5 - 75 to 100%; Severe/NO veg. w/ Major RRP relocation. Maint. Immediately",
      "code": "5"
     },
     {
      "name": "0 - NOT part of design",
      "code": "0"
     },
     {
      "name": "NR - Could NOT Inspect",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OUTFALL_COM",
   "type": "esriFieldTypeString",
   "alias": "Comment - Outfall",
   "length": 255,
   "domain": null
  },
  {
   "name": "DS_CONDITION",
   "type": "esriFieldTypeString",
   "alias": "Overall condition downstream of outfall",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "d_DS_Condition",
    "description": "Downstream Channel Condition",
    "codedValues": [
     {
      "name": "0 - Not part of design",
      "code": "0"
     },
     {
      "name": "1 - Absent of erosion.",
      "code": "1"
     },
     {
      "name": "2 - Minor - Stable. No headcutting",
      "code": "2"
     },
     {
      "name": "3 - Major but not affecting veg and unstable. Headcut forming",
      "code": "3"
     },
     {
      "name": "4 - Major with veg loss and unstable. Fallen trees and major headcut",
      "code": "4"
     },
     {
      "name": "5 - Completely eroded and unstable. Major headcut. Maint Immediately",
      "code": "5"
     },
     {
      "name": "NR - Could NOT Inspect",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DS_CONDITION_COM",
   "type": "esriFieldTypeString",
   "alias": "Comment - Downstream Condition",
   "length": 255,
   "domain": null
  },
  {
   "name": "RED_FLAG",
   "type": "esriFieldTypeString",
   "alias": "Does the site require immediate attention?",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "D_BooleanValues",
    "description": "Numeric Value 1 = True, 2 = False",
    "codedValues": [
     {
      "name": "True",
      "code": "1"
     },
     {
      "name": "False",
      "code": "2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RED_FLAG_COM",
   "type": "esriFieldTypeString",
   "alias": "Comment - Red Flag",
   "length": 255,
   "domain": null
  },
  {
   "name": "RATING",
   "type": "esriFieldTypeString",
   "alias": "Rating",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "d_Pond_Perform_Rating",
    "description": "Pond Performance Rating",
    "codedValues": [
     {
      "name": "0 - NOT part of design                                       ",
      "code": "0"
     },
     {
      "name": "A - Functioning as designed - NO problems.",
      "code": "A"
     },
     {
      "name": "B - Minor issues - Functioning, may require annual inspection",
      "code": "B"
     },
     {
      "name": "C - Moderate issues - Functioning, performance compromised. Sched. Maint",
      "code": "C"
     },
     {
      "name": "D - Major issues - NOT Functioning. Failure Possible. Maint. immed.",
      "code": "D"
     },
     {
      "name": "E - Severe issues - NOT Functioning. Impending failure. Maint. immed.",
      "code": "E"
     },
     {
      "name": "NR - Insuff. Inspect./ No Access",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GEN_COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "Comments - General",
   "length": 255,
   "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_edited_user",
   "type": "esriFieldTypeString",
   "alias": "Last Edited User",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "Last Edited Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "QC_Complete",
   "type": "esriFieldTypeString",
   "alias": "QC Complete",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_Boolean",
    "description": "Boolean (Yes/No/NA",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     },
     {
      "name": "N/A",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "QC_initials",
   "type": "esriFieldTypeString",
   "alias": "QC Initials",
   "length": 32,
   "domain": null
  },
  {
   "name": "inspection_type",
   "type": "esriFieldTypeString",
   "alias": "Inspection Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "dInspectionType_1",
    "description": "Type of Inspection",
    "codedValues": [
     {
      "name": "New Inspection",
      "code": "N"
     },
     {
      "name": "Re-Inspection",
      "code": "R"
     },
     {
      "name": "Maintenance Re-Inspection",
      "code": "M"
     },
     {
      "name": "Do Not Inspect",
      "code": "D"
     },
     {
      "name": "NR Re-Inspection",
      "code": "NR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "fiscal_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Fiscal Year",
   "domain": null
  },
  {
   "name": "STRU_NOa",
   "type": "esriFieldTypeString",
   "alias": "Structure ID",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPECTION_GUID",
   "type": "esriFieldTypeGUID",
   "alias": "INSPECTION_GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "BMP_TYPE2",
   "type": "esriFieldTypeString",
   "alias": "BMP Type",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "dBMPType_1",
    "description": "MDE BMP Type",
    "codedValues": [
     {
      "name": "Green Roof - Extensive",
      "code": "AGRE"
     },
     {
      "name": "Green Roof - Intensive",
      "code": "AGRI"
     },
     {
      "name": "Permeable Pavements",
      "code": "APRP"
     },
     {
      "name": "Reinforced Turf",
      "code": "ARTF"
     },
     {
      "name": "Bio-Reactor Carbon Filter",
      "code": "BRCT"
     },
     {
      "name": "Disconnection of Illicit Discharges",
      "code": "DID"
     },
     {
      "name": "Education",
      "code": "EDU"
     },
     {
      "name": "Bioretention",
      "code": "FBIO"
     },
     {
      "name": "Organic Filter (Peat Filter)",
      "code": "FORG"
     },
     {
      "name": "Perimeter (Sand) Filter",
      "code": "FPER"
     },
     {
      "name": "Floodplain Restoration",
      "code": "FPRES"
     },
     {
      "name": "Sand Filter",
      "code": "FSND"
     },
     {
      "name": "Underground Filter",
      "code": "FUND"
     },
     {
      "name": "Infiltration Basin",
      "code": "IBAS"
     },
     {
      "name": "Infiltration Trench",
      "code": "ITRN"
     },
     {
      "name": "Enhanced Filters",
      "code": "MENF"
     },
     {
      "name": "Infiltration Berms",
      "code": "MIBR"
     },
     {
      "name": "Dry Well",
      "code": "MIDW"
     },
     {
      "name": "Landscape infiltration",
      "code": "MILS"
     },
     {
      "name": "Micro-Bioretention",
      "code": "MMBR"
     },
     {
      "name": "Rain Gardens",
      "code": "MRNG"
     },
     {
      "name": "Rainwater Harvesting",
      "code": "MRWH"
     },
     {
      "name": "Submerged Gravel Wetlands",
      "code": "MSGW"
     },
     {
      "name": "Bio-Swale",
      "code": "MSWB"
     },
     {
      "name": "Grass Swale",
      "code": "MSWG"
     },
     {
      "name": "Wet Swale",
      "code": "MSWW"
     },
     {
      "name": "Disconnection of Non-Rooftop Runoff",
      "code": "NDNR"
     },
     {
      "name": "Disconnection of Rooftop Runoff",
      "code": "NDRR"
     },
     {
      "name": "Sheetflow to Conservation Areas",
      "code": "NSCA"
     },
     {
      "name": "Dry Swale",
      "code": "ODSW"
     },
     {
      "name": "Pet Waste Management",
      "code": "PET"
     },
     {
      "name": "Micropool Extended Detention Pond",
      "code": "PMED"
     },
     {
      "name": "Multiple Pond System",
      "code": "PMPS"
     },
     {
      "name": "Pocket Pond",
      "code": "PPKT"
     },
     {
      "name": "Extended Detention Structure, Wet",
      "code": "PWED"
     },
     {
      "name": "Retention Pond (Wet Pond)",
      "code": "PWET"
     },
     {
      "name": "River Bank Stabilization",
      "code": "RBS"
     },
     {
      "name": "Step Pool Storm Conveyance",
      "code": "SPSC"
     },
     {
      "name": "Sub-Soiling",
      "code": "SUB"
     },
     {
      "name": "Trash Removal",
      "code": "TRA"
     },
     {
      "name": "Extended Detention - Wetland",
      "code": "WEDW"
     },
     {
      "name": "Pocket Wetland",
      "code": "WPKT"
     },
     {
      "name": "Wet Pond - Wetland",
      "code": "WPWS"
     },
     {
      "name": "Shallow Marsh",
      "code": "WSHW"
     },
     {
      "name": "Extended Detention Structure, Dry",
      "code": "XDED"
     },
     {
      "name": "Detention Structure (Dry Pond)",
      "code": "XDPD"
     },
     {
      "name": "Flood Management Area",
      "code": "XFLD"
     },
     {
      "name": "Oil Grit separator",
      "code": "XOGS"
     },
     {
      "name": "Other",
      "code": "OTH"
     },
     {
      "name": "Unknown",
      "code": "UNK"
     },
     {
      "name": "Does Not Exist",
      "code": "DNE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R666_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_666",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G5322SWMFAC_GUID",
   "fields": "SWMFAC_GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G5322INSPECTION_",
   "fields": "INSPECTION_GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 12,
   "name": "SWMFAC_INSPECTIONS_ACTIONS",
   "relatedTableId": 12,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{50E1B0EB-0D98-4AF8-849B-1061223A0F48}"
  },
  {
   "id": 8,
   "name": "SWMFAC_INSPECTIONS_OBSERVATIONWELLS",
   "relatedTableId": 11,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{661AFA17-D1ED-4420-9FC1-192872AB955B}"
  },
  {
   "id": 11,
   "name": "SWMFAC_SUB_INSP_SWALES",
   "relatedTableId": 7,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{9B1C4A23-601E-43AF-B34C-34D2923F991C}"
  },
  {
   "id": 9,
   "name": "SWMFAC_SUB_INSP_UNDERGROUND",
   "relatedTableId": 10,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{0CB5E96D-804C-4CE2-B8D1-6E4AFD389440}"
  },
  {
   "id": 6,
   "name": "SWMFAC_SUB_INSP_PONDS",
   "relatedTableId": 6,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{03979293-D72A-4B3B-AEB4-898CC6F10DCD}"
  },
  {
   "id": 7,
   "name": "SWMFAC_INSPECTIONS_INFLOWS",
   "relatedTableId": 13,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{F2167004-84FF-40FF-B64C-8CCCB1A3D34D}"
  },
  {
   "id": 4,
   "name": "SWMFAC_SUB_INSP_FILTERINGSYSTEMS",
   "relatedTableId": 9,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{A6EE4DEB-508D-4421-B157-9DCFF6FEEA0B}"
  },
  {
   "id": 5,
   "name": "SWMFAC_SUB_INSP_INFILTRATIONFACILITY",
   "relatedTableId": 8,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{432811FB-A9F0-4970-B5D8-E133AF308FD3}"
  },
  {
   "id": 3,
   "name": "SWMFAC",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "SWMFAC_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{F621B05E-A5D6-4F61-9A8B-8058CC3DB1F5}"
  }
 ],
 "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": "e56c8123e4b84bc382817a49aa247c06"
}