{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "Site Work Orders",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SITE_ID",
   "type": "esriFieldTypeDouble",
   "alias": "SITE_ID",
   "domain": null
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SWTYPE",
    "description": "SWTYPE",
    "codedValues": [
     {
      "name": "ECP",
      "code": "ECP"
     },
     {
      "name": "BMP",
      "code": "BMP"
     },
     {
      "name": "IDDE",
      "code": "IDDE"
     },
     {
      "name": "PCRCP",
      "code": "PCRCP"
     },
     {
      "name": "CGP",
      "code": "CGP"
     },
     {
      "name": "CONTACT",
      "code": "CONTACT"
     },
     {
      "name": "SWPPP",
      "code": "SWPPP"
     },
     {
      "name": "ASD",
      "code": "ASD"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ORACLE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "ORACLE_ID",
   "domain": null
  },
  {
   "name": "INCIDENT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "INCIDENT_ID",
   "domain": null
  },
  {
   "name": "ECP_REQ",
   "type": "esriFieldTypeString",
   "alias": "ECP_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ECP_APPROVED",
   "type": "esriFieldTypeString",
   "alias": "ECP_APPROVED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PCRCP_REQ",
   "type": "esriFieldTypeString",
   "alias": "PCRCP_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PCRCP_APPROVED",
   "type": "esriFieldTypeString",
   "alias": "PCRCP_APPROVED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CGP_REQ",
   "type": "esriFieldTypeString",
   "alias": "CGP_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TNR_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "TNR_NUMBER",
   "length": 50,
   "domain": null
  },
  {
   "name": "ARAP_REQ",
   "type": "esriFieldTypeString",
   "alias": "ARAP_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ARAP_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "ARAP_NUMBER",
   "length": 50,
   "domain": null
  },
  {
   "name": "PD_SD",
   "type": "esriFieldTypeString",
   "alias": "PD_SD",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP_INSPECTION_REQ",
   "type": "esriFieldTypeString",
   "alias": "BMP_INSPECTION_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CP_PENDING",
   "type": "esriFieldTypeString",
   "alias": "CP_PENDING",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CEASE_DESIST",
   "type": "esriFieldTypeString",
   "alias": "CP_DESIST",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INSPECTION_FREQ",
   "type": "esriFieldTypeDouble",
   "alias": "INSPECTION_FREQ",
   "domain": {
    "type": "codedValue",
    "name": "SW_INSP_FREQ_DBL",
    "description": "Inspection_Frequency",
    "codedValues": [
     {
      "name": "1",
      "code": 1
     },
     {
      "name": "7",
      "code": 7
     },
     {
      "name": "14",
      "code": 14
     },
     {
      "name": "30",
      "code": 30
     },
     {
      "name": "60",
      "code": 60
     },
     {
      "name": "89",
      "code": 89
     },
     {
      "name": "180",
      "code": 180
     },
     {
      "name": "365",
      "code": 365
     },
     {
      "name": "730",
      "code": 730
     },
     {
      "name": "1095",
      "code": 1095
     },
     {
      "name": "1461",
      "code": 1461
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DATE_OPENED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_OPENED",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE_CLOSED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_CLOSED",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE_REMOVED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_REMOVED",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONST_COMPLETED",
   "type": "esriFieldTypeString",
   "alias": "CONST_COMPLETED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DISCHARGE",
   "type": "esriFieldTypeString",
   "alias": "DISCHARGE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SWDISCHARGE",
    "description": "SWDISCHARGE",
    "codedValues": [
     {
      "name": "Reported",
      "code": "P"
     },
     {
      "name": "Observed",
      "code": "O"
     },
     {
      "name": "Discharged",
      "code": "D"
     },
     {
      "name": "Possible",
      "code": "PS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DISTURBED_ACRES",
   "type": "esriFieldTypeDouble",
   "alias": "DISTURBED_ACRES",
   "domain": null
  },
  {
   "name": "SITE_NAME",
   "type": "esriFieldTypeString",
   "alias": "SITE_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "HISTORICAL_SITE",
   "type": "esriFieldTypeString",
   "alias": "HISTORICAL_SITE",
   "length": 50,
   "domain": null
  },
  {
   "name": "BMP_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "HISTORICAL_BMP",
   "type": "esriFieldTypeString",
   "alias": "HISTORICAL_BMP",
   "length": 50,
   "domain": null
  },
  {
   "name": "BMP_QUANT",
   "type": "esriFieldTypeInteger",
   "alias": "BMP_QUANT",
   "domain": {
    "type": "range",
    "name": "SW_COUNT_1",
    "description": "SW_COUNT",
    "range": [
     0,
     99
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP_TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_BMP_TYPE",
    "description": "SW_BMP_TYPE",
    "codedValues": [
     {
      "name": "SWALE",
      "code": "SWALE"
     },
     {
      "name": "DETENTION BASIN",
      "code": "DETENTION BASIN"
     },
     {
      "name": "RETENTION BASIN",
      "code": "RETENTION BASIN"
     },
     {
      "name": "UNDERGROUND DETENTION BASIN",
      "code": "UNDERGROUND DETENTION BASIN"
     },
     {
      "name": "BIOSWALE",
      "code": "BIOSWALE"
     },
     {
      "name": "INFILTRATION PERCULATION BASIN",
      "code": "INFILTRATION PERCULATION BASIN"
     },
     {
      "name": "POROUS PAVEMENT",
      "code": "POROUS PAVEMENT"
     },
     {
      "name": "CONSTRUCTED WETLAND",
      "code": "CONSTRUCTED WETLAND"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMMENT",
   "type": "esriFieldTypeString",
   "alias": "COMMENT",
   "length": 2000,
   "domain": null
  },
  {
   "name": "BMP_MAINT_STATUS",
   "type": "esriFieldTypeString",
   "alias": "MAINT_STATUS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_BMP_STATUS",
    "description": "SW_BMP_STATUS",
    "codedValues": [
     {
      "name": "MAINTAINED",
      "code": "MAINTAINED"
     },
     {
      "name": "UNMAINTAINED",
      "code": "UNMAINTAINED"
     },
     {
      "name": "CONSTRUCTION",
      "code": "CONSTRUCTION"
     },
     {
      "name": "UNDEVELOPED",
      "code": "UNDEVELOPED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP_LAT",
   "domain": null
  },
  {
   "name": "BMP_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP_LON",
   "domain": null
  },
  {
   "name": "APPROVAL_DATE",
   "type": "esriFieldTypeDate",
   "alias": "APPROVAL_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "DM_RequestStatus_1",
    "description": "Service Requests Ticket Status",
    "codedValues": [
     {
      "name": "Open",
      "code": "Open"
     },
     {
      "name": "Closed",
      "code": "Closed"
     },
     {
      "name": "In Progress",
      "code": "In Progress"
     },
     {
      "name": "Resolved",
      "code": "Resolved"
     },
     {
      "name": "Back to Department",
      "code": "Back to Department"
     },
     {
      "name": "Pending Litigation",
      "code": "Pending Litigation"
     },
     {
      "name": "Hold",
      "code": "Hold"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PLAN_NAME",
   "type": "esriFieldTypeString",
   "alias": "PLAN_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "ID",
   "type": "esriFieldTypeString",
   "alias": "ID",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "AN",
   "type": "esriFieldTypeString",
   "alias": "AN",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NAME",
   "type": "esriFieldTypeString",
   "alias": "NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "COMPLAINT_SOURCE",
   "type": "esriFieldTypeString",
   "alias": "COMPLAINT_SOURCE",
   "length": 50,
   "domain": null
  },
  {
   "name": "RP_NAME",
   "type": "esriFieldTypeString",
   "alias": "RP_NAME",
   "length": 100,
   "domain": null
  },
  {
   "name": "RP_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "RP_ADDRESS",
   "length": 100,
   "domain": null
  },
  {
   "name": "RP_CITY",
   "type": "esriFieldTypeString",
   "alias": "RP_CITY",
   "length": 50,
   "domain": null
  },
  {
   "name": "RP_PHONE",
   "type": "esriFieldTypeString",
   "alias": "RP_PHONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "MATERIAL",
   "type": "esriFieldTypeDouble",
   "alias": "MATERIAL",
   "domain": {
    "type": "codedValue",
    "name": "SWMATERIAL",
    "description": "SWMATERIAL",
    "codedValues": [
     {
      "name": "UNKNOWN",
      "code": 0
     },
     {
      "name": "TRASH",
      "code": 1
     },
     {
      "name": "CONSTRUCTION MATERIALS",
      "code": 2
     },
     {
      "name": "PETROLEUM PRODUCTS",
      "code": 3
     },
     {
      "name": "PAINT",
      "code": 10
     },
     {
      "name": "SOAP DETERGENT AMMONIA",
      "code": 15
     },
     {
      "name": "ANIMAL WASTE",
      "code": 19
     },
     {
      "name": "SANITARY SEWER",
      "code": 20
     },
     {
      "name": "FOOD WASTE",
      "code": 23
     },
     {
      "name": "LAWN WASTE",
      "code": 26
     },
     {
      "name": "SILT GRAVEL SEDIMENT",
      "code": 27
     },
     {
      "name": "CHEMICALS",
      "code": 29
     },
     {
      "name": "OTHER",
      "code": 99
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CODE",
   "type": "esriFieldTypeString",
   "alias": "CODE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_CODE",
    "description": "SW_CODE",
    "codedValues": [
     {
      "name": "Condo-Townhouse",
      "code": "U1"
     },
     {
      "name": "Apartment High-Rise",
      "code": "U2"
     },
     {
      "name": "Large SFR",
      "code": "U3"
     },
     {
      "name": "Medium SFT",
      "code": "U4"
     },
     {
      "name": "MF Home-Apartment",
      "code": "U5"
     },
     {
      "name": "Mobile Home",
      "code": "U6"
     },
     {
      "name": "Small SFR",
      "code": "U7"
     },
     {
      "name": "Commercial",
      "code": "U20"
     },
     {
      "name": "Exempt",
      "code": "U30"
     },
     {
      "name": "Not in Memphis",
      "code": "U90"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SW_FEE_APPLIED",
   "type": "esriFieldTypeString",
   "alias": "SW_FEE_APPLIED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SW_STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_STATUS",
    "description": "SW_STATUS",
    "codedValues": [
     {
      "name": "OPEN",
      "code": "OPEN"
     },
     {
      "name": "CLOSED",
      "code": "CLOSED"
     },
     {
      "name": "REVIEW",
      "code": "REVIEW"
     },
     {
      "name": "HOLD",
      "code": "HOLD"
     },
     {
      "name": "MONITOR",
      "code": "MONITOR"
     },
     {
      "name": "RESOLVED",
      "code": "RESOLVED"
     },
     {
      "name": "ADOPTED",
      "code": "ADOPTED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP_INSP_REQ",
   "type": "esriFieldTypeString",
   "alias": "BMP_INSP_REQ",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "IMPERVIOUS_AREA",
   "type": "esriFieldTypeDouble",
   "alias": "IMPERVIOUS_AREA",
   "domain": null
  },
  {
   "name": "CGP_RECEIPT",
   "type": "esriFieldTypeString",
   "alias": "CGP_RECEIPT",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REC_EDIT_MODE",
   "type": "esriFieldTypeString",
   "alias": "REC_EDIT_MODE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "REC_EDIT_MODE",
    "description": "Record Editing Mode",
    "codedValues": [
     {
      "name": "AUTOMATIC",
      "code": "AUTOMATIC"
     },
     {
      "name": "MANUAL",
      "code": "MANUAL"
     },
     {
      "name": "PROCESSED",
      "code": "PROCESSED"
     },
     {
      "name": "FAILED",
      "code": "FAILED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP2_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP2_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "BMP2_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP2_LAT",
   "domain": null
  },
  {
   "name": "BMP2_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP2_LON",
   "domain": null
  },
  {
   "name": "BMP2_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP2_TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_BMP_TYPE",
    "description": "SW_BMP_TYPE",
    "codedValues": [
     {
      "name": "SWALE",
      "code": "SWALE"
     },
     {
      "name": "DETENTION BASIN",
      "code": "DETENTION BASIN"
     },
     {
      "name": "RETENTION BASIN",
      "code": "RETENTION BASIN"
     },
     {
      "name": "UNDERGROUND DETENTION BASIN",
      "code": "UNDERGROUND DETENTION BASIN"
     },
     {
      "name": "BIOSWALE",
      "code": "BIOSWALE"
     },
     {
      "name": "INFILTRATION PERCULATION BASIN",
      "code": "INFILTRATION PERCULATION BASIN"
     },
     {
      "name": "POROUS PAVEMENT",
      "code": "POROUS PAVEMENT"
     },
     {
      "name": "CONSTRUCTED WETLAND",
      "code": "CONSTRUCTED WETLAND"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP2_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "BMP2_COMMENT",
   "length": 500,
   "domain": null
  },
  {
   "name": "BMP3_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP3_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "BMP3_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP3_LAT",
   "domain": null
  },
  {
   "name": "BMP3_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP3_LON",
   "domain": null
  },
  {
   "name": "BMP3_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP3_TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_BMP_TYPE",
    "description": "SW_BMP_TYPE",
    "codedValues": [
     {
      "name": "SWALE",
      "code": "SWALE"
     },
     {
      "name": "DETENTION BASIN",
      "code": "DETENTION BASIN"
     },
     {
      "name": "RETENTION BASIN",
      "code": "RETENTION BASIN"
     },
     {
      "name": "UNDERGROUND DETENTION BASIN",
      "code": "UNDERGROUND DETENTION BASIN"
     },
     {
      "name": "BIOSWALE",
      "code": "BIOSWALE"
     },
     {
      "name": "INFILTRATION PERCULATION BASIN",
      "code": "INFILTRATION PERCULATION BASIN"
     },
     {
      "name": "POROUS PAVEMENT",
      "code": "POROUS PAVEMENT"
     },
     {
      "name": "CONSTRUCTED WETLAND",
      "code": "CONSTRUCTED WETLAND"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP3_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "BMP3_COMMENT",
   "length": 500,
   "domain": null
  },
  {
   "name": "NEXT_INSPECTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "NEXT_INSPECTION_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "SW_ZONE",
   "type": "esriFieldTypeString",
   "alias": "SW_ZONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "LAST_INSPECTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_INSPECTION_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "Acres",
   "type": "esriFieldTypeDouble",
   "alias": "Acres",
   "domain": null
  },
  {
   "name": "C90_INSPECTION_REQ",
   "type": "esriFieldTypeString",
   "alias": "C90_INSPECTION_REQ",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "YesNoNAIndicator",
    "description": "Domain with Yes/No/NA options",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS",
   "length": 100,
   "domain": null
  },
  {
   "name": "SPLIT_ZN_INITIALS",
   "type": "esriFieldTypeString",
   "alias": "SPLIT_ZN_INITIALS",
   "length": 10,
   "domain": null
  },
  {
   "name": "ACCELA_NUM",
   "type": "esriFieldTypeString",
   "alias": "ACCELA_NUM",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R171_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G3253SITE_ID",
   "fields": "SITE_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G3253ORACLE_ID",
   "fields": "ORACLE_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "ORDERS_TO_ACTIVITIES",
   "relatedTableId": 4,
   "role": "esriRelRoleOrigin",
   "keyField": "ORACLE_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{EFCDF906-15D9-4EAF-9AE8-6A7581EF803B}"
  },
  {
   "id": 0,
   "name": "ORDERS_TO_SITES",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "SITE_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{A5F41CCC-335F-43E7-AB50-1D63ABE83F1D}"
  },
  {
   "id": 2,
   "name": "ORDERS_TO_SITES",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "SITE_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{A5F41CCC-335F-43E7-AB50-1D63ABE83F1D}"
  }
 ],
 "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": "d2e38ad636d044188f5e4762c6113073"
}