Layers:

Layer: BMP's (0)

Name: BMP's

Display Field: PROJ_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 55450.430522851646
YMin: 820701.1666358933
XMax: 325809.08651872724
YMax: 946736.9366093129
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 15 )
• BMP_ID ( type: esriFieldTypeString, alias: BMP ID, length: 50 )
• PROJ_NO ( type: esriFieldTypeDouble, alias: Project Number )
• PROJ_NAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• DISTRICT ( type: esriFieldTypeSmallInteger, alias: MassDOT District , Range: [1, 6] )
• MUNICIP ( type: esriFieldTypeString, alias: Municipality, length: 25 )
• ROUTENAME ( type: esriFieldTypeString, alias: MassDOT Roadway, length: 30 )
• OWNER ( type: esriFieldTypeString, alias: BMP Ownership, length: 15 , Coded Values: [MassDOT: MassDOT] , [Municipality: Municipality] , [Other Agency: Other Agency] , ...1 more... )
• BMP_TYPE ( type: esriFieldTypeString, alias: Type of BMP, length: 45 , Coded Values: [Infiltration Basin: Infiltration Basin] , [Leaching Catch Basin: Leaching Catch Basin] , [Infiltration Swale: Infiltration Swale] , ...9 more... )
• BMP_Notes ( type: esriFieldTypeString, alias: BMP Notes, length: 255 )
• BMP_WS_ac ( type: esriFieldTypeDouble, alias: DOT watershed to BMP (acres) )
• IC_WS_ac ( type: esriFieldTypeDouble, alias: IC watershed to BMP (acres) )
• Red_IC_Des ( type: esriFieldTypeDouble, alias: Effective IC reduced by BMP (acres) )
• P_LOAD_lbs ( type: esriFieldTypeDouble, alias: P load of watershed to BMP (lbs/yr) )
• Red_P_Des ( type: esriFieldTypeDouble, alias: P reduced by BMP (lbs/yr) )
• N_Load_lbs ( type: esriFieldTypeDouble, alias: N load of watershed to BMP (lbs/yr) )
• Red_N_Des ( type: esriFieldTypeDouble, alias: N reduced by BMP (lbs/yr) )
• CSTDATE ( type: esriFieldTypeDate, alias: Date of construction, length: 8 )
• CSTNOTES ( type: esriFieldTypeString, alias: Construction Notes, length: 255 )
• Source ( type: esriFieldTypeString, alias: Source of Data, length: 15 , Coded Values: [WQDF Online: WQDF Online] , [WQDF Excel: WQDF Excel] , [IWP Consultant: IWP Consultant] , ...2 more... )
• SUB_BY ( type: esriFieldTypeString, alias: Submitted By, length: 25 )
• SUB_DATE ( type: esriFieldTypeDate, alias: Date Submitted, length: 8 )
• REV_BY ( type: esriFieldTypeString, alias: MassDOT Reviewer, length: 25 )
• REV_DATE ( type: esriFieldTypeDate, alias: Review Date, length: 8 )
• Record_Plans ( type: esriFieldTypeString, alias: Link to Record Plans, length: 255 )
• Treat_Depth_in ( type: esriFieldTypeDouble, alias: Treat_Depth_in )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FLOW_PATH ( type: esriFieldTypeString, alias: FLOW_PATH, length: 50 , Coded Values: [Direct: Direct] , [Indirect: Indirect] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• Impaired_Waters_Streams (2) -- Related To: Impaired Streams (2)
• Impaired_Waters_Lakes (1) -- Related To: Impaired Lakes (3)
• MassDOT_IWP_Projects (0) -- Related To: IWP Projects (1)

Layer: IWP Projects (1)

Name: IWP Projects

Display Field: PROJ_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 90536.09301953763
YMin: 820899.9375800788
XMax: 325948.75371886045
YMax: 947274.2936658151
Spatial Reference: 26986  (26986)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 1
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• PROJ_NO ( type: esriFieldTypeDouble, alias: Project Number )
• PROJ_NAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 15 )
• ROUTENAME ( type: esriFieldTypeString, alias: MassDOT Roadway, length: 50 )
• TYPE ( type: esriFieldTypeString, alias: Project Type, length: 25 , Coded Values: [Stormwater Retrofit: Stormwater Retrofit] , [Resurfacing: Resurfacing] , [Bridge: Bridge] , ...4 more... )
• OWNER ( type: esriFieldTypeString, alias: Project Area Ownership, length: 15 , Coded Values: [MassDOT: MassDOT] , [Municipality: Municipality] , [Other Agency: Other Agency] , ...1 more... )
• DESIGNER ( type: esriFieldTypeString, alias: Designer, length: 25 )
• DSGN_CNTRC ( type: esriFieldTypeInteger, alias: Design Contract # )
• DISTRICT ( type: esriFieldTypeSmallInteger, alias: MassDOT District , Range: [1, 6] )
• CostDesign ( type: esriFieldTypeInteger, alias: Cost of Design )
• DsnAssigned ( type: esriFieldTypeDate, alias: Date Design Assigned, length: 8 )
• SUB25_75 ( type: esriFieldTypeDate, alias: Date of 25/75% submission, length: 8 )
• SUB100 ( type: esriFieldTypeDate, alias: Date of 100% submission, length: 8 )
• ADVDATE ( type: esriFieldTypeDate, alias: Advertising Date, length: 8 )
• COST_CST ( type: esriFieldTypeInteger, alias: Cost of construction project )
• CSTNOTES ( type: esriFieldTypeString, alias: Construction Notes, length: 255 )
• WPA_REQ ( type: esriFieldTypeString, alias: WPA Permit Filing, length: 15 , Coded Values: [None: None] , [RDA: RDA] , [NOI: Notice of Intent] , ...3 more... )
• DEP_FileNo ( type: esriFieldTypeInteger, alias: WPA Permit Number )
• WPA_Notes ( type: esriFieldTypeString, alias: WPA Notes, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status of Project, length: 15 , Coded Values: [Not Assigned: Not Assigned] , [In Design: In Design] , [Design Complete: Design Complete] , ...4 more... )
• Source ( type: esriFieldTypeString, alias: Source of Data, length: 15 , Coded Values: [WQDF Online: WQDF Online] , [WQDF Excel: WQDF Excel] , [IWP Consultant: IWP Consultant] , ...2 more... )
• Red_IC_ac ( type: esriFieldTypeDouble, alias: Effective IC reduced (acres) )
• Red_P_lbs ( type: esriFieldTypeDouble, alias: P reduced (lbs/yr) )
• Red_N_lbs ( type: esriFieldTypeDouble, alias: N reduced (lbs/yr) )
• BMPCOUNT ( type: esriFieldTypeSmallInteger, alias: Number of BMPs )
• SUB_BY ( type: esriFieldTypeString, alias: Submitted By, length: 25 )
• SUB_DATE ( type: esriFieldTypeDate, alias: Date Submitted, length: 8 , Range: [-2208988800000, 32503680000000] )
• REV_BY ( type: esriFieldTypeString, alias: MassDOT Reviewer, length: 25 )
• REV_DATE ( type: esriFieldTypeDate, alias: Review Date, length: 8 , Range: [-2208988800000, 32503680000000] )
• Project_Notes ( type: esriFieldTypeString, alias: Project Notes, length: 250 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Geotech_Date ( type: esriFieldTypeDate, alias: Geotech_Date, length: 8 , Range: [-2208988800000, 32503680000000] )
• Survey_Date ( type: esriFieldTypeDate, alias: Survey_Date, length: 8 )
• PreCon_Meeting_Date ( type: esriFieldTypeDate, alias: PreCon_Meeting_Date, length: 8 )
• Date_Utilities_Sub ( type: esriFieldTypeDate, alias: Date_Utilities_Sub, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• MassDOT_BMPs (0) -- Related To: BMP's (0)
• Impaired_Waters_Streams (4) -- Related To: Impaired Streams (2)
• Impaired_Waters_Lakes (3) -- Related To: Impaired Lakes (3)

Layer: Impaired Streams (2)

Name: Impaired Streams

Display Field: WB_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 36453.582121156156
YMin: 787946.3124613762
XMax: 325905.3125668168
YMax: 959664.687277358
Spatial Reference: 26986  (26986)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [122, 142, 245, 255]
Width: 1
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 20 )
• WB_NAME ( type: esriFieldTypeString, alias: Waterbody Name, length: 50 )
• WS_NAME ( type: esriFieldTypeString, alias: Watershed Name, length: 30 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 2 , Coded Values: [2: category 2] , [3: category 3] , [5: category 5] , ...2 more... )
• POL_2012_1 ( type: esriFieldTypeString, alias: 2012 Impairments, length: 255 )
• POL_2012_2 ( type: esriFieldTypeString, alias: 2012 Impairments (continued), length: 255 )
• TMDL_CNT ( type: esriFieldTypeDouble, alias: Number of TMDLs )
• TMDL_POL ( type: esriFieldTypeString, alias: TMDL Pollutants, length: 150 )
• WSAreaTOT ( type: esriFieldTypeDouble, alias: Total Watershed area (acres) )
• WSAreaSUB ( type: esriFieldTypeDouble, alias: Subwatershed area (acres) )
• WS_PercIC ( type: esriFieldTypeDouble, alias: Subwatershed IC (Percent) )
• DIR_WS_Ac ( type: esriFieldTypeDouble, alias: MassDOT directly draining (DD) area (acres) )
• DIR_IC_Ac ( type: esriFieldTypeDouble, alias: MassDOT DD IC area (acres) )
• RedTarg_IC ( type: esriFieldTypeDouble, alias: Effective IC reduction target (acres) )
• RedFinalIC ( type: esriFieldTypeDouble, alias: Effective IC reduction achieved (acres) )
• DIR_P_LOAD ( type: esriFieldTypeDouble, alias: MassDOT DD P Load (lbs/yr) )
• RedTarg_P ( type: esriFieldTypeDouble, alias: P reduction target (lbs/yr) )
• RedFinal_P ( type: esriFieldTypeDouble, alias: P reduction achieved (lbs/yr) )
• DIR_N_LOAD ( type: esriFieldTypeDouble, alias: MassDOT DD N Load (lbs/yr) )
• RedTarg_N ( type: esriFieldTypeDouble, alias: N reduction target (lbs/yr) )
• RedFinal_N ( type: esriFieldTypeDouble, alias: N reduction achieved (lbs/yr) )
• L1_Update ( type: esriFieldTypeString, alias: Included in updated L1 List (2013), length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Retained: Retained] )
• L1 ( type: esriFieldTypeString, alias: Included in L1 List (2008), length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Retained: Retained] )
• ASSM_TYPE ( type: esriFieldTypeString, alias: Assessment Type, length: 150 , Coded Values: [7R: TMDL Method] , [<9%: Less than 9% impervious] , [7U: IC Method] , ...14 more... )
• AssmConsult ( type: esriFieldTypeString, alias: Assessment Consultant, length: 50 )
• ASSM_NOTES ( type: esriFieldTypeString, alias: Assessment Notes, length: 255 )
• DEGN_REQ ( type: esriFieldTypeString, alias: Design Stage Required, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ProgLink ( type: esriFieldTypeString, alias: Progress Report Link, length: 255 )
• FinalLink ( type: esriFieldTypeString, alias: Final Report Link, length: 255 )
• SummLink ( type: esriFieldTypeString, alias: Summary Sheet Link, length: 255 )
• ProjRepSub ( type: esriFieldTypeDate, alias: Date of progress report assessment submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• FinalSub ( type: esriFieldTypeDate, alias: Date of final assessment submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• SummarySub ( type: esriFieldTypeDate, alias: Date of project summary sheet submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• PROGRESS ( type: esriFieldTypeString, alias: Assessment Progress, length: 40 , Coded Values: [Not Submitted: Not Submitted] , [In Progress-Programmed Proj: In Progress-Programmed Proj] , [In Progress: In Progress] , ...2 more... )
• PRJCOUNT ( type: esriFieldTypeSmallInteger, alias: Number of Projects )
• SUB_BY ( type: esriFieldTypeString, alias: Submitted By, length: 25 )
• SUB_DATE ( type: esriFieldTypeDate, alias: Date Submitted, length: 8 , Range: [-2208988800000, 32503680000000] )
• REV_BY ( type: esriFieldTypeString, alias: MassDOT Reviewer, length: 25 )
• REV_DATE ( type: esriFieldTypeDate, alias: Review Date, length: 8 , Range: [-2208988800000, 32503680000000] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• MassDOT_IWP_Projects (4) -- Related To: IWP Projects (1)
• MassDOT_BMPs (2) -- Related To: BMP's (0)
• TMDL_Table (6) -- Related To: MASSDOT.DBO.TMDL_Table (5)
• WQDF_Projects (5) -- Related To: MASSDOT.DBO.WQDF_Projects (4)

Layer: Impaired Lakes (3)

Name: Impaired Lakes

Display Field: WB_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 38527.61706708372
YMin: 777968.1873960793
XMax: 330564.87429916114
YMax: 956817.6011947058
Spatial Reference: 26986  (26986)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [115, 178, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 20 )
• WB_NAME ( type: esriFieldTypeString, alias: Waterbody Name, length: 50 )
• WS_NAME ( type: esriFieldTypeString, alias: Watershed Name, length: 30 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 2 , Coded Values: [2: category 2] , [3: category 3] , [5: category 5] , ...2 more... )
• POL_2012_1 ( type: esriFieldTypeString, alias: 2012 Impairments, length: 255 )
• POL_2012_2 ( type: esriFieldTypeString, alias: 2012 Impairments (continued), length: 255 )
• TMDL_CNT ( type: esriFieldTypeDouble, alias: Number of TMDLs )
• TMDL_POL ( type: esriFieldTypeString, alias: TMDL Pollutants, length: 150 )
• WSAreaTOT ( type: esriFieldTypeDouble, alias: Total watershed area (acres) )
• WSAreaSUB ( type: esriFieldTypeDouble, alias: Subwatershed area (acres) )
• WS_PercIC ( type: esriFieldTypeDouble, alias: Subwatershed IC (percent) , Range: [0, 0] )
• DIR_WS_Ac ( type: esriFieldTypeDouble, alias: MassDOT directly draining (DD) area (acres) )
• DIR_IC_Ac ( type: esriFieldTypeDouble, alias: MassDOT DD IC area (acres) )
• RedTarg_IC ( type: esriFieldTypeDouble, alias: Effective IC Reduction target (acres) )
• RedFinalIC ( type: esriFieldTypeDouble, alias: Effective IC reduction achieved (acres) )
• DIR_P_LOAD ( type: esriFieldTypeDouble, alias: MassDOT DD P Load (lbs/yr) )
• RedTarg_P ( type: esriFieldTypeDouble, alias: P Reduction target (lbs/yr) )
• RedFinal_P ( type: esriFieldTypeDouble, alias: P Reduction achieved (lbs/yr) )
• DIR_N_LOAD ( type: esriFieldTypeDouble, alias: MassDOT DD N Load (lbs/yr) )
• RedTarg_N ( type: esriFieldTypeDouble, alias: N reduction target (lbs/yr) )
• RedFinal_N ( type: esriFieldTypeDouble, alias: N reduction achieved (lbs/yr) )
• L1_Update ( type: esriFieldTypeString, alias: Included in updated L1 list (2013), length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Retained: Retained] )
• L1 ( type: esriFieldTypeString, alias: Included in L1 List (2008), length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Retained: Retained] )
• ASSM_TYPE ( type: esriFieldTypeString, alias: Assessment Type, length: 150 , Coded Values: [7R: TMDL Method] , [<9%: Less than 9% impervious] , [7U: IC Method] , ...14 more... )
• AssmConslt ( type: esriFieldTypeString, alias: Assessment Consultant, length: 50 )
• ASSM_NOTES ( type: esriFieldTypeString, alias: Assessment Notes, length: 255 )
• DSGN_REQ ( type: esriFieldTypeString, alias: Design Stage Required, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ProgLink ( type: esriFieldTypeString, alias: Progress Report Link, length: 255 )
• FinalLink ( type: esriFieldTypeString, alias: Final Report Link, length: 255 )
• SummLink ( type: esriFieldTypeString, alias: Summary Report Link, length: 255 )
• ProgRepSub ( type: esriFieldTypeDate, alias: Date of progress report assessment submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• FinalSub ( type: esriFieldTypeDate, alias: Date of final assessment submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• SummarySub ( type: esriFieldTypeDate, alias: Date of project summary sheet submittal to EPA, length: 8 , Range: [-2208988800000, 32503680000000] )
• PROGRESS ( type: esriFieldTypeString, alias: Assessment Progress, length: 40 , Coded Values: [Not Submitted: Not Submitted] , [In Progress-Programmed Proj: In Progress-Programmed Proj] , [In Progress: In Progress] , ...2 more... )
• PRJCOUNT ( type: esriFieldTypeSmallInteger, alias: Number of Projects )
• SUB_BY ( type: esriFieldTypeString, alias: Submitted By, length: 25 )
• SUB_DATE ( type: esriFieldTypeDate, alias: Date Submitted, length: 8 , Range: [-2208988800000, 32503680000000] )
• REV_BY ( type: esriFieldTypeString, alias: MassDOT Reviewer, length: 25 )
• REV_DATE ( type: esriFieldTypeDate, alias: Date Reviewed, length: 8 , Range: [-2208988800000, 32503680000000] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• WQDF_Projects (8) -- Related To: MASSDOT.DBO.WQDF_Projects (4)
• TMDL_Table (7) -- Related To: MASSDOT.DBO.TMDL_Table (5)
• MassDOT_BMPs (1) -- Related To: BMP's (0)
• MassDOT_IWP_Projects (3) -- Related To: IWP Projects (1)

Tables:

Table: MASSDOT.DBO.WQDF_Projects (4)

Name: MASSDOT.DBO.WQDF_Projects

Display Field: PROJ_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PROJ_NO ( type: esriFieldTypeDouble, alias: Project Number )
• PROJ_NAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 15 )
• MUNICIP ( type: esriFieldTypeString, alias: Municipality, length: 25 )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 15 , Coded Values: [MassDOT: MassDOT] , [Municipality: Municipality] , [Other Agency: Other Agency] , ...1 more... )
• DISTRICT ( type: esriFieldTypeDouble, alias: District )
• BMP_COUNT ( type: esriFieldTypeSmallInteger, alias: Number of BMPs )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 15 , Coded Values: [WQDF Online: WQDF Online] , [WQDF Excel: WQDF Excel] , [IWP Consultant: IWP Consultant] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• Impaired_Waters_Lakes (8) -- Related To: Impaired Lakes (3)
• Impaired_Waters_Streams (5) -- Related To: Impaired Streams (2)

Table: MASSDOT.DBO.TMDL_Table (5)

Name: MASSDOT.DBO.TMDL_Table

Display Field: TMDL_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TMDL_WS ( type: esriFieldTypeString, alias: TMDL Watershed, length: 100 )
• WBID ( type: esriFieldTypeString, alias: Waterbody ID, length: 20 )
• TMDL_Name ( type: esriFieldTypeString, alias: TMDL Name, length: 150 )
• TMDL_IMP ( type: esriFieldTypeString, alias: Impairments Addressed by TMDL, length: 150 )
• TMDL_POL ( type: esriFieldTypeString, alias: Pollutants Addressed by TMDL, length: 20 )
• Land_Use ( type: esriFieldTypeString, alias: Land Use Category which Includes MassDOT, length: 40 )
• WLA_kg ( type: esriFieldTypeDouble, alias: WLA for MassDOT Related Land Use (kg/yr) )
• WLA_lbs ( type: esriFieldTypeDouble, alias: WLA for MassDOT Related Land Use (lbs/yr) )
• LU_SqMi ( type: esriFieldTypeDouble, alias: Land Use Area in Watershed (sq mi) )
• WLA_lbacyr ( type: esriFieldTypeDouble, alias: Land Use Areal WLA (lbs/ac/yr) )
• BMPsRec ( type: esriFieldTypeString, alias: BMPS Recommended, length: 255 )
• Waterbody ( type: esriFieldTypeString, alias: Waterbody, length: 50 )
• CN ( type: esriFieldTypeString, alias: CN, length: 30 )
• Category ( type: esriFieldTypeString, alias: Category, length: 5 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• Impaired_Waters_Lakes (7) -- Related To: Impaired Lakes (3)
• Impaired_Waters_Streams (6) -- Related To: Impaired Streams (2)