View In:   ArcGIS Online Map Viewer

Name: Stormwater Control Measure

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This layer is part of MassDOT's Stormwater Asset Database used to map MassDOT's drainage network assets. </SPAN></P></DIV></DIV></DIV>

Copyright Text: This data is in the public domain and therefore can be used by anyone for any purpose. MassDOT shall not be held liable for any errors in this data. This includes errors of omission, commission, errors concerning the content of the data, and relative and positional accuracy of the data. This data cannot be construed to be a legal document. Primary sources from which this data was compiled must be consulted for verification of information contained in this data.

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 279098.7283427448

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 55450.430500000715
YMin: 814180.7164000012
XMax: 327966.61680000275
YMax: 946738.0174999982
Spatial Reference: 26986  (26986)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEGACYID )
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WBID )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 10, defaultValue: null, modelName: District , Coded Values: [District 1: District 1] , [District 2: District 2] , [District 3: District 3] , ...3 more... )
• Municipality ( type: esriFieldTypeString, alias: Town, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Municipality )
• BMPType ( type: esriFieldTypeString, alias: SCM Type, editable: true, nullable: true, length: 35, defaultValue: null, modelName: BMPType , Coded Values: [Bioretention Area: Bioretention Area] , [Bioretention Linear Practice: Bioretention Linear Practice] , [Constructed Stormwater Wetland: Constructed Stormwater Wetland] , ...17 more... )
• SCM_Status ( type: esriFieldTypeString, alias: SCM Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SCM_Status , Coded Values: [25 Percent: 25 Percent] , [75 Percent: 75 Percent] , [Active: Active] , ...6 more... )
• Lined ( type: esriFieldTypeString, alias: Is SCM Lined?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Lined , Coded Values: [Yes: Yes] , [No: No] )
• Underdrain ( type: esriFieldTypeString, alias: Has Underdrain?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Underdrain , Coded Values: [Yes: Yes] , [No: No] )
• StaffGauge ( type: esriFieldTypeString, alias: Has Staff Gauge?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: StaffGauge , Coded Values: [Yes: Yes] , [No: No] )
• FlowPath ( type: esriFieldTypeString, alias: FlowPath, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FlowPath , Coded Values: [Direct: Direct] , [Indirect: Indirect] )
• AccessNotes ( type: esriFieldTypeString, alias: Access Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: AccessNotes )
• BMPNotes ( type: esriFieldTypeString, alias: SCM Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: BMPNotes )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• OWNEDBY ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OWNEDBY , Coded Values: [MassDOT: MassDOT] , [Private Utility: Private Utility] , [Municipality: Municipality] , ...3 more... )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MAINTBY , Coded Values: [MassDOT: MassDOT] , [Private Utility: Private Utility] , [Municipality: Municipality] , ...3 more... )
• SoilType ( type: esriFieldTypeString, alias: Soil Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SoilType , Coded Values: [Sandy Clay Loam: Sandy Clay Loam] , [Silt Loam: Silt Loam] , [Loam: Loam] , ...8 more... )
• SCM_Vol ( type: esriFieldTypeDouble, alias: Storage Volume (ft^3), editable: true, nullable: true, defaultValue: null, modelName: SCM_Vol )
• BMP_WS_ac ( type: esriFieldTypeDouble, alias: DOT Watershed to SCM (Acres), editable: true, nullable: true, defaultValue: null, modelName: BMP_WS_ac )
• IC_WS_ac ( type: esriFieldTypeDouble, alias: IC Watershed to SCM (Acres), editable: true, nullable: true, defaultValue: null, modelName: IC_WS_ac )
• TreatDepth ( type: esriFieldTypeDouble, alias: Treatment Depth (in), editable: true, nullable: true, defaultValue: null, modelName: TreatDepth )
• IC_pct_Red ( type: esriFieldTypeDouble, alias: Annual IC Percent Reduction (%), editable: true, nullable: true, defaultValue: null, modelName: IC_pct_Red )
• Red_IC_Des ( type: esriFieldTypeDouble, alias: Effective IC Reduced by SCM (Acres), editable: true, nullable: true, defaultValue: null, modelName: Red_IC_Des )
• P_pct_Red ( type: esriFieldTypeDouble, alias: Annual P Percent Reduction (%), editable: true, nullable: true, defaultValue: null, modelName: P_pct_Red )
• Red_P_Des ( type: esriFieldTypeDouble, alias: P Reduced by SCM (Lbs/Year), editable: true, nullable: true, defaultValue: null, modelName: Red_P_Des )
• N_pct_Red ( type: esriFieldTypeDouble, alias: Annual N Percent Reduction (%), editable: true, nullable: true, defaultValue: null, modelName: N_pct_Red )
• Red_N_Des ( type: esriFieldTypeDouble, alias: N Reduced by SCM (Lbs/Year), editable: true, nullable: true, defaultValue: null, modelName: Red_N_Des )
• TSS_pct_Red ( type: esriFieldTypeDouble, alias: Annual TSS Percent Reduction (%), editable: true, nullable: true, defaultValue: null, modelName: TSS_pct_Red )
• Red_TSS_Des ( type: esriFieldTypeDouble, alias: TSS Reduced by SCM (Lbs/Year), editable: true, nullable: true, defaultValue: null, modelName: Red_TSS_Des )
• Source ( type: esriFieldTypeString, alias: Source of Data, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Source , Coded Values: [WQDF Online: WQDF Online] , [WQDF Excel: WQDF Excel] , [IWP Consultant: IWP Consultant] , ...4 more... )
• ProjectNum ( type: esriFieldTypeDouble, alias: Project Number, editable: true, nullable: true, defaultValue: null, modelName: ProjectNum )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• SubmitBy ( type: esriFieldTypeString, alias: Submitted By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SubmitBy )
• SubmitDate ( type: esriFieldTypeDate, alias: Date Submitted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmitDate )
• ReviewBy ( type: esriFieldTypeString, alias: MassDOT Reviewer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReviewBy )
• ReviewDate ( type: esriFieldTypeDate, alias: Review Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReviewDate )
• PhotoPath ( type: esriFieldTypeString, alias: Photo Path, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PhotoPath )
• RecordPlans ( type: esriFieldTypeString, alias: Link to Record Plans, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RecordPlans )
• Plans ( type: esriFieldTypeString, alias: Plan Sheet Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Plans )
• ServiceStatus ( type: esriFieldTypeString, alias: Service Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceStatus , Coded Values: [In Service: In Service] , [Proposed Installation: Proposed Installation] , [Proposed Retirement: Proposed Retirement] , ...1 more... )
• created_date ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: last_edited_user )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AssetID ( type: esriFieldTypeString, alias: SCM ID, editable: false, nullable: true, length: 20, defaultValue: null, modelName: BMPID )

Templates:

• Name: Stormwater Control Measure
  Description:
  Prototype:
  ServiceStatus: null
  LEGACYID: null
  WBID: null
  District: null
  Municipality: null
  BMPType: null
  SCM_Status: null
  Lined: null
  Underdrain: null
  StaffGauge: null
  FlowPath: null
  AccessNotes: null
  BMPNotes: null
  InstallDate: null
  OWNEDBY: null
  MAINTBY: null
  SoilType: null
  SCM_Vol: null
  BMP_WS_ac: null
  IC_WS_ac: null
  TreatDepth: null
  IC_pct_Red: null
  Red_IC_Des: null
  P_pct_Red: null
  Red_P_Des: null
  N_pct_Red: null
  Red_N_Des: null
  TSS_pct_Red: null
  Red_TSS_Des: null
  Source: null
  ProjectNum: null
  ProjectName: null
  SubmitBy: null
  SubmitDate: null
  ReviewBy: null
  ReviewDate: null
  PhotoPath: null
  RecordPlans: null
  Plans: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• swSCMInspectionForm (0) -- Related To: swSCMInspectionForm (9)

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata