Name: DCR_Surface_BMP

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 51743.9064999968
YMin: 815051.057
XMax: 312434.424199998
YMax: 952792.849199999
Spatial Reference: 26986 (26986)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[225,179,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITYNAME (type: esriFieldTypeString, alias: Facility Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OWNEDBY (type: esriFieldTypeString, alias: BMP Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DCR: DCR], [Other State Agency: Other State Agency], [Private: Private], ... 3 more ...)
• MAINTBY (type: esriFieldTypeString, alias: BMP Maintainer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [DCR Engineering: DCR Engineering], [DCR Water Supply: DCR Water Supply], [Private: Private], ... 3 more ...)
• MAINTAGREE (type: esriFieldTypeString, alias: Maintenance Agreement in Place?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
• BMPTYPE (type: esriFieldTypeString, alias: Legacy BMP Type, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Wet Swale: Wet Swale], [Dry Swale: Dry Swale], [Bioretention: Bioretention], ... 13 more ...)
• ACCESS (type: esriFieldTypeString, alias: Access Notes, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BUILDSTATUS (type: esriFieldTypeString, alias: Status of BMP Construction, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Feasible: Not Feasible], [Potential: Potential], [In Design: In Design], ... 3 more ...)
• INSTALLDATE (type: esriFieldTypeDate, alias: Date Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WBID (type: esriFieldTypeString, alias: Waterbody ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WBNAME (type: esriFieldTypeString, alias: Receiving Waterbody Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• WBIMPAIR (type: esriFieldTypeString, alias: Waterbody Impairment, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NUMTMDL (type: esriFieldTypeDouble, alias: Number of TMDLs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TMDLID (type: esriFieldTypeString, alias: TMDL ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TMDLPOLLT (type: esriFieldTypeString, alias: TMDL Pollutant, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NUTRIENT_TMDL (type: esriFieldTypeString, alias: Within Nutrient TMDL Watershed?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
• BMPWS (type: esriFieldTypeDouble, alias: BMP Watershed (acres), SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPRVACRES (type: esriFieldTypeDouble, alias: Impervious Acres to BMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DCRBMPWA (type: esriFieldTypeDouble, alias: DCR-Owned BMP Watershed (acres), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DCRIMPACRES (type: esriFieldTypeDouble, alias: DCR-Owned Impervious Watershed (acres), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RUNOFFTREAT_cuft (type: esriFieldTypeDouble, alias: BMP Water Quality Volume (cuft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOILTYPE (type: esriFieldTypeString, alias: Soil Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Sandy Clay Loam: Sandy Clay Loam], [Silt Loam: Silt Loam], [Loam: Loam], ... 9 more ...)
• SOILSOURCE (type: esriFieldTypeString, alias: Soil Type Data Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Field Geotech: Field Geotech], [NRCS Data Layer: NRCS Data Layer], [Other: Other (describe in notes)])
• RED_N (type: esriFieldTypeDouble, alias: Nitrogen Reduction (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RED_TP (type: esriFieldTypeDouble, alias: Phosphorus Reduction (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RED_TSS (type: esriFieldTypeDouble, alias: TSS Reduction (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERCONNECTION (type: esriFieldTypeString, alias: Interconnection to other system, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [No: No], [Not Entered: Not Entered], [Suspected: Suspected], ... 4 more ...)
• CONNECTION_OWNER (type: esriFieldTypeString, alias: Interconnecting owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Municipality: Municipality], [Other: Other (describe in notes)], [Other State Agency: Other State Agency], ... 2 more ...)
• CONNECTION_DIRECTION (type: esriFieldTypeString, alias: Interconnection Incoming or Outgoing, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [To DCR: To DCR], [From DCR: From DCR], [Unknown: Unknown])
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Plans: Plans], [2006-07 Survey: 2006-07 Survey], [2005 Survey: 2005 Survey], ... 24 more ...)
• PLAN_NAME (type: esriFieldTypeString, alias: Plan Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ENSR_ID (type: esriFieldTypeDouble, alias: ENSR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STRUCTURE_ID (type: esriFieldTypeDouble, alias: Structure ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHANGE_TYPE (type: esriFieldTypeString, alias: Change feature type to, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Delete: Delete], [Inlet: Inlet], [Manhole: Manhole], ... 5 more ...)
• CHANGE_NOTES (type: esriFieldTypeString, alias: Feature type change notes, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• WS_ID (type: esriFieldTypeString, alias: Watershed ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BMPTYPE_NEW (type: esriFieldTypeString, alias: BMP Type, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Infiltration Basin/Swale: Infiltration Basin/Swale], [Wet Basin/Swale: Wet Basin/Swale], [Other: Other], ... 14 more ...)
• BMPTYPE_NEW_SOURCE (type: esriFieldTypeString, alias: New BMP Type Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [2021 Desktop Review: 2021 Desktop Review], [Plan Review: Plan Review], [VHB Field Inspection: VHB Field Inspection], ... 1 more ...)
• SEARCH_ID (type: esriFieldTypeString, alias: Search ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RUNOFFTREAT_in (type: esriFieldTypeDouble, alias: Design Runoff Treatment Depth (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FILTER_DEPTH_in (type: esriFieldTypeDouble, alias: Filter Depth (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOILTYPE_HSG (type: esriFieldTypeString, alias: Predominant HSG Soil Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LANDUSE (type: esriFieldTypeString, alias: Predominant Land Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• P_LOAD_RED_CALC_DATE (type: esriFieldTypeDate, alias: Date of Last P Load Reduction Calc, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• N_LOAD_RED_CALC_DATE (type: esriFieldTypeDate, alias: Date of Last N Load Reduction Calc, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• P_LOAD_BMP (type: esriFieldTypeDouble, alias: Phosphorus Load to BMP (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• N_LOAD_BMP (type: esriFieldTypeDouble, alias: Nitrogen Load to BMP (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RED_TP_PERC (type: esriFieldTypeDouble, alias: Phosphorus Load Reduction (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RED_TN_PERC (type: esriFieldTypeDouble, alias: Nitrogen Load Reduction (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GALLEY (type: esriFieldTypeInteger, alias: Number of Galleys/Chambers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAPACITY (type: esriFieldTypeInteger, alias: Holding Capacity of Structure (gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODEL (type: esriFieldTypeString, alias: Model name and number of structure, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WARRANTY (type: esriFieldTypeDate, alias: Date Warranty Ends, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: DCR_Surface_BMP
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2023 1:59:02 AM

Schema Last Edit Date: 7/29/2023 1:59:02 AM

Data Last Edit Date: 7/29/2023 12:38:47 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat