{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 3,
 "name": "MDE TableB1a All BMPs",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "BMP_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "BMP_ID",
   "type": "esriFieldTypeString",
   "alias": "BMP ID",
   "length": 13,
   "domain": null
  },
  {
   "name": "REPORTING_YEAR",
   "type": "esriFieldTypeString",
   "alias": "State Fiscal Year",
   "length": 4,
   "domain": null
  },
  {
   "name": "PERMIT_NUM",
   "type": "esriFieldTypeString",
   "alias": "General Discharge Permit Number",
   "length": 10,
   "domain": null
  },
  {
   "name": "LOCAL_BMP_ID",
   "type": "esriFieldTypeString",
   "alias": "Local Project Approval Number",
   "length": 25,
   "domain": null
  },
  {
   "name": "BMP_NAME",
   "type": "esriFieldTypeString",
   "alias": "BMP Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "BMP_CLASS",
   "type": "esriFieldTypeString",
   "alias": "BMP Class",
   "length": 1,
   "domain": {
    "type": "codedValue",
    "name": "BMP_CLASS",
    "description": "BMP Classification Category (E,S or A)",
    "codedValues": [
     {
      "name": "E - ESD",
      "code": "E"
     },
     {
      "name": "S - Structural",
      "code": "S"
     },
     {
      "name": "A - Alternative",
      "code": "A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BMP_TYPE",
   "type": "esriFieldTypeString",
   "alias": "BMP Type",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "BMP_TYPE",
    "description": "Type of BMP",
    "codedValues": [
     {
      "name": "Stream Restoration",
      "code": "STRE"
     },
     {
      "name": "Outfall Stabilization",
      "code": "OUT"
     },
     {
      "name": "Regenerative Step Pool Storm Conveyance",
      "code": "SPSC"
     },
     {
      "name": "Underground Detention Facility",
      "code": "UGVT"
     },
     {
      "name": "AGRE - Green Roof - Extensive",
      "code": "AGRE"
     },
     {
      "name": "AGRI - Green Roof - Intensive",
      "code": "AGRI"
     },
     {
      "name": "APRP - Permeable Pavements",
      "code": "APRP"
     },
     {
      "name": "ARTF - Reinforced Turf",
      "code": "ARTF"
     },
     {
      "name": "NDRR - Disconnection of Rooftop Runoff",
      "code": "NDRR"
     },
     {
      "name": "NDNR - Disconnection of Non-Rooftop Runoff",
      "code": "NDNR"
     },
     {
      "name": "NSCA - Sheetflow to Conservation Areas",
      "code": "NSCA"
     },
     {
      "name": "MRWH - Rainwater Harvesting",
      "code": "MRWH"
     },
     {
      "name": "MSGW - Submerged Gravel Wetlands",
      "code": "MSGW"
     },
     {
      "name": "MILS - Landscape Infiltration",
      "code": "MILS"
     },
     {
      "name": "MIBR - Infiltration Berms",
      "code": "MIBR"
     },
     {
      "name": "MIDW - Dry Wells",
      "code": "MIDW"
     },
     {
      "name": "MMBR - Micro-Bioretention",
      "code": "MMBR"
     },
     {
      "name": "MRNG - Rain Gardens",
      "code": "MRNG"
     },
     {
      "name": "MSWG - Grass Swale",
      "code": "MSWG"
     },
     {
      "name": "MSWW - Wet Swale",
      "code": "MSWW"
     },
     {
      "name": "MSWB - Bio-Swale",
      "code": "MSWB"
     },
     {
      "name": "MENF - Enhanced Filters",
      "code": "MENF"
     },
     {
      "name": "PWED - Extended Detention Structure, Wet",
      "code": "PWED"
     },
     {
      "name": "PWET - Retention Pond (Wet Pond)",
      "code": "PWET"
     },
     {
      "name": "PMPS - Multiple Pond System",
      "code": "PMPS"
     },
     {
      "name": "PPKT - Pocket Pond",
      "code": "PPKT"
     },
     {
      "name": "PMED - Micropool Extended Detention Pond",
      "code": "PMED"
     },
     {
      "name": "WSHW - Shallow Marsh",
      "code": "WSHW"
     },
     {
      "name": "WEDW - Wetland",
      "code": "WEDW"
     },
     {
      "name": "WPWS - Wet Pond - Wetland",
      "code": "WPWS"
     },
     {
      "name": "IBAS - Infiltration Basin",
      "code": "IBAS"
     },
     {
      "name": "ITRN - Infiltration Trench",
      "code": "ITRN"
     },
     {
      "name": "FBIO - Bioretention",
      "code": "FBIO"
     },
     {
      "name": "FSND - Sand Filter",
      "code": "FSND"
     },
     {
      "name": "FUND - Underground Filter",
      "code": "FUND"
     },
     {
      "name": "FPER - Perimeter (Sand) Filter",
      "code": "FPER"
     },
     {
      "name": "FORG - Organic Filter (Peat Filter)",
      "code": "FORG"
     },
     {
      "name": "ODSW - Dry Swale",
      "code": "ODSW"
     },
     {
      "name": "OWSW - Wet Swale",
      "code": "OWSW"
     },
     {
      "name": "XDPD - Detention Structure (Dry Pond)",
      "code": "XDPD"
     },
     {
      "name": "XDED - Extended Detention Structure, Dry",
      "code": "XDED"
     },
     {
      "name": "XFLD - Flood Management Area",
      "code": "XFLD"
     },
     {
      "name": "XOGS - Oil Grit Separator",
      "code": "XOGS"
     },
     {
      "name": "XOTH - Other",
      "code": "XOTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CON_PURPOSE",
   "type": "esriFieldTypeString",
   "alias": "Purpose",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "CON_PURPOSE",
    "description": "Construction purpose",
    "codedValues": [
     {
      "name": "New Development",
      "code": "NEWD"
     },
     {
      "name": "Redevelopment",
      "code": "REDE"
     },
     {
      "name": "Restoration",
      "code": "REST"
     },
     {
      "name": "Retrofit",
      "code": "RETR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LAST_INSP_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "BMP_STATUS",
   "type": "esriFieldTypeString",
   "alias": "BMP Inspection Status",
   "length": 1,
   "domain": {
    "type": "codedValue",
    "name": "BMP_STATUS",
    "description": "Status of BMP",
    "codedValues": [
     {
      "name": "P - Passed",
      "code": "P"
     },
     {
      "name": "F - Failed",
      "code": "F"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MAIN_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Date of Maintenance",
   "length": 8,
   "domain": null
  },
  {
   "name": "REINSP_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Next Planned Inspection",
   "length": 8,
   "domain": null
  },
  {
   "name": "REINSP_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Reinspection Status",
   "length": 1,
   "domain": null
  },
  {
   "name": "GEN_COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "General Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "MD_NORTH",
   "type": "esriFieldTypeDouble",
   "alias": "MD_NORTH",
   "domain": null
  },
  {
   "name": "MD_EAST",
   "type": "esriFieldTypeDouble",
   "alias": "MD_EAST",
   "domain": null
  },
  {
   "name": "temp_calc",
   "type": "esriFieldTypeString",
   "alias": "temp_calc",
   "length": 50,
   "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
  }
 ],
 "indexes": [
  {
   "name": "R1930_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_21734_BMP_ID",
   "fields": "BMP_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "RockGIS.DPWSWM.swm_MDE_TableB1b_drainage_areas",
   "relatedTableId": 4,
   "role": "esriRelRoleOrigin",
   "keyField": "BMP_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": true
 },
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}