{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 8,
 "name": "Conversion Of Existing BMP",
 "type": "Table",
 "description": "This table is used to track the retrofit of existing SWM facilities to restore the watershed, by adding WQv to the existing facility.  MDE GDB requires two fields to be populated where CON_PURPOSE \u2013 Conversion of Existing BMP.  These two fields are:  CONVERTED_FROM:   If conversion of existing BMP, then prior BMP Type is required; Conditional if CON_PURPOSE = CONV. and PE_PRE_CONV:  PE Treated prior to conversion; Conditional on CON_PURPOSE = CONV and PERMIT_ISSUANCE_YR_CREDIT is current permit or later The Conversion of existing BMP table will contain the Original PE and Original BMP Type, and will relate to both records in ESD Structural based on Structure ID. In ESD and Structural BMP, there will be two records when a retrofit project begins.  They will both have the same Structure ID (1234-001), but the existing SWM Facility will have an As Built Date and Project Status will be Permit Closed, whereas the proposed retrofit will not have an As Built Date and Project Status will be Design. The existing SWM BMP will have MDE GDB as PG99BMP000001 and the proposed retrofit will have MDE GDB as PG22RST000001.  See MDE GDB Guidance for more information on how the unique IDs are concatenated. When the retrofit is completed, the existing SWM BMP will be archived and removed, leaving only the retrofit with Structure ID: 1234-001 and MDE GDB PG22RST000001, new As Built Date and Project Status Permit Closed. ",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 4,
   "name": "ESDandS_BMP",
   "relatedTableId": 1,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "STRU_NO",
   "composite": false,
   "catalogID": "{2EA9AD09-5020-45F1-B080-D0DB30FEF102}"
  }
 ],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsFullTextSearch": true,
  "fullTextSearchCapabilities": {
   "supportsSearchOperator": true,
   "supportsOperator": false,
   "supportsSqlExpressionInFullText": true
  },
  "fullTextSearchableFields": [],
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsReturningGeometryEnvelope": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true,
  "supportsQueryWithCacheHint": false
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON,PBF"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "STRU_NO",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "STRU_NO",
   "type": "esriFieldTypeString",
   "alias": "Structure ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "STRU_NO"
  },
  {
   "name": "OrigBMP_Type",
   "type": "esriFieldTypeString",
   "alias": "Original BMP Type",
   "domain": {
    "type": "codedValue",
    "name": "dBMPType",
    "description": "Type of BMP",
    "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": "No Data",
      "code": "ND"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 5,
   "defaultValue": null,
   "modelName": "OrigBMP_Type"
  },
  {
   "name": "OriginalWQv",
   "type": "esriFieldTypeDouble",
   "alias": "Original WQv",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "OriginalWQv"
  },
  {
   "name": "AddtionalWQv",
   "type": "esriFieldTypeDouble",
   "alias": "Addtional WQv provided by retrofit",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "AddtionalWQv"
  },
  {
   "name": "ORIG_BMP_PE",
   "type": "esriFieldTypeDouble",
   "alias": "ORIG_BMP_PE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ORIG_BMP_PE"
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "General comments",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 250,
   "defaultValue": null,
   "modelName": "COMMENTS"
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "Created by",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "Date created",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "Last edited by",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "Last edited date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  }
 ],
 "indexes": [
  {
   "name": "R486_SDE_ROWID_UK",
   "isAscending": true,
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID"
  },
  {
   "name": "UUID_486",
   "isAscending": true,
   "isUnique": true,
   "description": "",
   "fields": "GlobalID"
  },
  {
   "name": "GDB_3012_STRU_NO",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "STRU_NO"
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "timeZoneIANA": "Etc/UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Conversion Of Existing BMP",
   "description": "",
   "prototype": {
    "attributes": {
     "ORIG_BMP_PE": null,
     "COMMENTS": null,
     "STRU_NO": null,
     "OrigBMP_Type": null,
     "OriginalWQv": null,
     "AddtionalWQv": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "supportsAppend": true,
 "supportedAppendFormats": "FILEGDB,PBF",
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1
}