{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "Site Work Orders",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 3,
   "name": "ORDERS_TO_ACTIVITIES",
   "relatedTableId": 4,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleOrigin",
   "keyField": "ORACLE_ID",
   "composite": false,
   "catalogID": "{EFCDF906-15D9-4EAF-9AE8-6A7581EF803B}"
  },
  {
   "id": 0,
   "name": "ORDERS_TO_SITES",
   "relatedTableId": 0,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SITE_ID",
   "composite": false,
   "catalogID": "{A5F41CCC-335F-43E7-AB50-1D63ABE83F1D}"
  },
  {
   "id": 2,
   "name": "ORDERS_TO_SITES",
   "relatedTableId": 2,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SITE_ID",
   "composite": false,
   "catalogID": "{A5F41CCC-335F-43E7-AB50-1D63ABE83F1D}"
  }
 ],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "NAME",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "SITE_ID",
   "type": "esriFieldTypeDouble",
   "alias": "SITE_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "SITE_ID"
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "TYPE"
  },
  {
   "name": "ORACLE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "ORACLE_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ORACLE_ID"
  },
  {
   "name": "INCIDENT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "INCIDENT_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "INCIDENT_ID"
  },
  {
   "name": "ECP_REQ",
   "type": "esriFieldTypeString",
   "alias": "ECP_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ECP_REQ"
  },
  {
   "name": "ECP_APPROVED",
   "type": "esriFieldTypeString",
   "alias": "ECP_APPROVED",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ECP_APPROVED"
  },
  {
   "name": "PCRCP_REQ",
   "type": "esriFieldTypeString",
   "alias": "PCRCP_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PCRCP_REQ"
  },
  {
   "name": "PCRCP_APPROVED",
   "type": "esriFieldTypeString",
   "alias": "PCRCP_APPROVED",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PCRCP_APPROVED"
  },
  {
   "name": "CGP_REQ",
   "type": "esriFieldTypeString",
   "alias": "CGP_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CGP_REQ"
  },
  {
   "name": "TNR_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "TNR_NUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "TNR_NUMBER"
  },
  {
   "name": "ARAP_REQ",
   "type": "esriFieldTypeString",
   "alias": "ARAP_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ARAP_REQ"
  },
  {
   "name": "ARAP_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "ARAP_NUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ARAP_NUMBER"
  },
  {
   "name": "PD_SD",
   "type": "esriFieldTypeString",
   "alias": "PD_SD",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PD_SD"
  },
  {
   "name": "BMP_INSPECTION_REQ",
   "type": "esriFieldTypeString",
   "alias": "BMP_INSPECTION_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP_INSPECTION_REQ"
  },
  {
   "name": "CP_PENDING",
   "type": "esriFieldTypeString",
   "alias": "CP_PENDING",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CP_PENDING"
  },
  {
   "name": "CEASE_DESIST",
   "type": "esriFieldTypeString",
   "alias": "CP_DESIST",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CEASE_DESIST"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "INSPECTION_FREQ"
  },
  {
   "name": "DATE_OPENED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_OPENED",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DATE_OPENED"
  },
  {
   "name": "DATE_CLOSED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_CLOSED",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DATE_CLOSED"
  },
  {
   "name": "DATE_REMOVED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_REMOVED",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DATE_REMOVED"
  },
  {
   "name": "CONST_COMPLETED",
   "type": "esriFieldTypeString",
   "alias": "CONST_COMPLETED",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CONST_COMPLETED"
  },
  {
   "name": "DISCHARGE",
   "type": "esriFieldTypeString",
   "alias": "DISCHARGE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "DISCHARGE"
  },
  {
   "name": "DISTURBED_ACRES",
   "type": "esriFieldTypeDouble",
   "alias": "DISTURBED_ACRES",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "DISTURBED_ACRES"
  },
  {
   "name": "SITE_NAME",
   "type": "esriFieldTypeString",
   "alias": "SITE_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SITE_NAME"
  },
  {
   "name": "HISTORICAL_SITE",
   "type": "esriFieldTypeString",
   "alias": "HISTORICAL_SITE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "HISTORICAL_SITE"
  },
  {
   "name": "BMP_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP_NAME"
  },
  {
   "name": "HISTORICAL_BMP",
   "type": "esriFieldTypeString",
   "alias": "HISTORICAL_BMP",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "HISTORICAL_BMP"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP_QUANT"
  },
  {
   "name": "BMP_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP_TYPE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP_TYPE"
  },
  {
   "name": "COMMENT",
   "type": "esriFieldTypeString",
   "alias": "COMMENT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 2000,
   "defaultValue": null,
   "modelName": "COMMENT"
  },
  {
   "name": "BMP_MAINT_STATUS",
   "type": "esriFieldTypeString",
   "alias": "MAINT_STATUS",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "MAINT_STATUS"
  },
  {
   "name": "BMP_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP_LAT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP_LAT"
  },
  {
   "name": "BMP_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP_LON",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP_LON"
  },
  {
   "name": "APPROVAL_DATE",
   "type": "esriFieldTypeDate",
   "alias": "APPROVAL_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "APPROVAL_DATE"
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "STATUS"
  },
  {
   "name": "PLAN_NAME",
   "type": "esriFieldTypeString",
   "alias": "PLAN_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PLAN_NAME"
  },
  {
   "name": "ID",
   "type": "esriFieldTypeString",
   "alias": "ID",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ID"
  },
  {
   "name": "AN",
   "type": "esriFieldTypeString",
   "alias": "AN",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "AN"
  },
  {
   "name": "NAME",
   "type": "esriFieldTypeString",
   "alias": "NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "NAME"
  },
  {
   "name": "COMPLAINT_SOURCE",
   "type": "esriFieldTypeString",
   "alias": "COMPLAINT_SOURCE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "COMPLAINT_SOURCE"
  },
  {
   "name": "RP_NAME",
   "type": "esriFieldTypeString",
   "alias": "RP_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "RP_NAME"
  },
  {
   "name": "RP_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "RP_ADDRESS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "RP_ADDRESS"
  },
  {
   "name": "RP_CITY",
   "type": "esriFieldTypeString",
   "alias": "RP_CITY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "RP_CITY"
  },
  {
   "name": "RP_PHONE",
   "type": "esriFieldTypeString",
   "alias": "RP_PHONE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "RP_PHONE"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MATERIAL"
  },
  {
   "name": "CODE",
   "type": "esriFieldTypeString",
   "alias": "CODE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CODE"
  },
  {
   "name": "SW_FEE_APPLIED",
   "type": "esriFieldTypeString",
   "alias": "SW_FEE_APPLIED",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SW_FEE_APPLIED"
  },
  {
   "name": "SW_STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SW_STATUS"
  },
  {
   "name": "BMP_INSP_REQ",
   "type": "esriFieldTypeString",
   "alias": "BMP_INSP_REQ",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP_INSP_REQ"
  },
  {
   "name": "IMPERVIOUS_AREA",
   "type": "esriFieldTypeDouble",
   "alias": "IMPERVIOUS_AREA",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "IMPERVIOUS_AREA"
  },
  {
   "name": "CGP_RECEIPT",
   "type": "esriFieldTypeString",
   "alias": "CGP_RECEIPT",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CGP_RECEIPT"
  },
  {
   "name": "REC_EDIT_MODE",
   "type": "esriFieldTypeString",
   "alias": "REC_EDIT_MODE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "REC_EDIT_MODE"
  },
  {
   "name": "BMP2_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP2_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP2_NAME"
  },
  {
   "name": "BMP2_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP2_LAT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP2_LAT"
  },
  {
   "name": "BMP2_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP2_LON",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP2_LON"
  },
  {
   "name": "BMP2_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP2_TYPE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP2_TYPE"
  },
  {
   "name": "BMP2_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "BMP2_COMMENT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 500,
   "defaultValue": null,
   "modelName": "BMP2_COMMENT"
  },
  {
   "name": "BMP3_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP3_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP3_NAME"
  },
  {
   "name": "BMP3_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "BMP3_LAT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP3_LAT"
  },
  {
   "name": "BMP3_LON",
   "type": "esriFieldTypeDouble",
   "alias": "BMP3_LON",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BMP3_LON"
  },
  {
   "name": "BMP3_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP3_TYPE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BMP3_TYPE"
  },
  {
   "name": "BMP3_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "BMP3_COMMENT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 500,
   "defaultValue": null,
   "modelName": "BMP3_COMMENT"
  },
  {
   "name": "NEXT_INSPECTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "NEXT_INSPECTION_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "NEXT_INSPECTION_DATE"
  },
  {
   "name": "SW_ZONE",
   "type": "esriFieldTypeString",
   "alias": "SW_ZONE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SW_ZONE"
  },
  {
   "name": "LAST_INSPECTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_INSPECTION_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "LAST_INSPECTION_DATE"
  },
  {
   "name": "Acres",
   "type": "esriFieldTypeDouble",
   "alias": "Acres",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Acres"
  },
  {
   "name": "C90_INSPECTION_REQ",
   "type": "esriFieldTypeString",
   "alias": "C90_INSPECTION_REQ",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "C90_INSPECTION_REQ"
  },
  {
   "name": "ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "ADDRESS"
  },
  {
   "name": "SPLIT_ZN_INITIALS",
   "type": "esriFieldTypeString",
   "alias": "SPLIT_ZN_INITIALS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "SPLIT_ZN_INITIALS"
  },
  {
   "name": "ACCELA_NUM",
   "type": "esriFieldTypeString",
   "alias": "ACCELA_NUM",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ACCELA_NUM"
  }
 ],
 "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": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Site Work Orders",
   "description": "",
   "prototype": {
    "attributes": {
     "SPLIT_ZN_INITIALS": null,
     "ACCELA_NUM": null,
     "SITE_ID": null,
     "TYPE": null,
     "ORACLE_ID": null,
     "INCIDENT_ID": null,
     "ECP_REQ": null,
     "ECP_APPROVED": null,
     "PCRCP_REQ": null,
     "PCRCP_APPROVED": null,
     "CGP_REQ": null,
     "TNR_NUMBER": null,
     "ARAP_REQ": null,
     "ARAP_NUMBER": null,
     "PD_SD": null,
     "BMP_INSPECTION_REQ": null,
     "CP_PENDING": null,
     "CEASE_DESIST": null,
     "INSPECTION_FREQ": null,
     "DATE_OPENED": null,
     "DATE_CLOSED": null,
     "DATE_REMOVED": null,
     "CONST_COMPLETED": null,
     "DISCHARGE": null,
     "DISTURBED_ACRES": null,
     "SITE_NAME": null,
     "HISTORICAL_SITE": null,
     "BMP_NAME": null,
     "HISTORICAL_BMP": null,
     "BMP_QUANT": null,
     "BMP_TYPE": null,
     "COMMENT": null,
     "BMP_MAINT_STATUS": null,
     "BMP_LAT": null,
     "BMP_LON": null,
     "APPROVAL_DATE": null,
     "STATUS": null,
     "PLAN_NAME": null,
     "ID": null,
     "AN": null,
     "NAME": null,
     "COMPLAINT_SOURCE": null,
     "RP_NAME": null,
     "RP_ADDRESS": null,
     "RP_CITY": null,
     "RP_PHONE": null,
     "MATERIAL": null,
     "CODE": null,
     "SW_FEE_APPLIED": null,
     "SW_STATUS": null,
     "BMP_INSP_REQ": null,
     "IMPERVIOUS_AREA": null,
     "CGP_RECEIPT": null,
     "REC_EDIT_MODE": null,
     "BMP2_NAME": null,
     "BMP2_LAT": null,
     "BMP2_LON": null,
     "BMP2_TYPE": null,
     "BMP2_COMMENT": null,
     "BMP3_NAME": null,
     "BMP3_LAT": null,
     "BMP3_LON": null,
     "BMP3_TYPE": null,
     "BMP3_COMMENT": null,
     "NEXT_INSPECTION_DATE": null,
     "SW_ZONE": null,
     "LAST_INSPECTION_DATE": null,
     "Acres": null,
     "C90_INSPECTION_REQ": null,
     "ADDRESS": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "a67272d575bc452bbc960d45d79e7dd0"
}