{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "MDE TableB1a All BMPs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "BMP_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "BMP_ID", "type": "esriFieldTypeString", "alias": "BMP ID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "BMP_ID" }, { "name": "REPORTING_YEAR", "type": "esriFieldTypeString", "alias": "State Fiscal Year", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "REPORTING_YEAR" }, { "name": "PERMIT_NUM", "type": "esriFieldTypeString", "alias": "General Discharge Permit Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": "13-SF_5501", "modelName": "PERMIT_NUM" }, { "name": "LOCAL_BMP_ID", "type": "esriFieldTypeString", "alias": "Local Project Approval Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LOCAL_BMP_ID" }, { "name": "BMP_NAME", "type": "esriFieldTypeString", "alias": "BMP Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BMP_NAME" }, { "name": "BMP_CLASS", "type": "esriFieldTypeString", "alias": "BMP Class", "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" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BMP_CLASS" }, { "name": "BMP_TYPE", "type": "esriFieldTypeString", "alias": "BMP Type", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "BMP_TYPE" }, { "name": "CON_PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CON_PURPOSE" }, { "name": "LAST_INSP_DATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_INSP_DATE" }, { "name": "BMP_STATUS", "type": "esriFieldTypeString", "alias": "BMP Inspection Status", "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" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BMP_STATUS" }, { "name": "MAIN_DATE", "type": "esriFieldTypeDate", "alias": "Last Date of Maintenance", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAIN_DATE" }, { "name": "REINSP_DATE", "type": "esriFieldTypeDate", "alias": "Next Planned Inspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REINSP_DATE" }, { "name": "REINSP_STATUS", "type": "esriFieldTypeString", "alias": "Reinspection Status", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "REINSP_STATUS" }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "General Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GEN_COMMENTS" }, { "name": "MD_NORTH", "type": "esriFieldTypeDouble", "alias": "MD_NORTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MD_NORTH" }, { "name": "MD_EAST", "type": "esriFieldTypeDouble", "alias": "MD_EAST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MD_EAST" }, { "name": "temp_calc", "type": "esriFieldTypeString", "alias": "temp_calc", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "temp_calc" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "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" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "MDE TableB1a All BMPs", "description": "", "prototype": { "attributes": { "temp_calc": null, "MD_EAST": null, "BMP_ID": null, "REPORTING_YEAR": null, "PERMIT_NUM": "13-SF_5501", "LOCAL_BMP_ID": null, "BMP_NAME": null, "BMP_CLASS": null, "BMP_TYPE": null, "CON_PURPOSE": null, "LAST_INSP_DATE": null, "BMP_STATUS": null, "MAIN_DATE": null, "REINSP_DATE": null, "REINSP_STATUS": null, "GEN_COMMENTS": null, "MD_NORTH": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }