Name: BMP_Join_View_Layer

Display Field: AssetID

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Mark Hemmerlein: Mark Hemmerlein], [Bill Arcieri: Bill Arcieri], [other: Other])
• Inspector_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: Inspection Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Routine: Routine Annual], [PostStorm: Post Storm-Related], [Other: Other])
• InspectionOther (type: esriFieldTypeString, alias: If Other, Describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TodayWeather (type: esriFieldTypeString, alias: Today's Weather:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [S: Sunny], [Other: Overcast], [C: Cloudy], ... 2 more ...)
• Sediment (type: esriFieldTypeString, alias: Sediment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Sediment)], [Fair: Fair (Some sediment within the structure but not affecting operation)], [Poor: Poor (Sediment is affecting the effectiveness of the structure)], ... 1 more ...)
• SedimentComment (type: esriFieldTypeString, alias: Sediment Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Trash (type: esriFieldTypeString, alias: Trash Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Trash Present)], [Fair: Fair (Some, but Some, but not affecting the effectiveness)], [Poor: Poor (Affecting the effectiveness of the structure)], ... 1 more ...)
• TrashComment (type: esriFieldTypeString, alias: Trash Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Erosion (type: esriFieldTypeString, alias: Erosion Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Erosion)], [Fair: Fair (Some erosion within the structure but not affecting operation)], [Poor: Poor (Erosion is affecting the effectiveness of the structure)], ... 1 more ...)
• ErosionComment (type: esriFieldTypeString, alias: Erosion Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Structures (type: esriFieldTypeString, alias: Structural Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (Some wear with little or no deterioration)], [Fair: Fair (Some deterioration but could be easily maintained)], [Poor: Poor (Structural damage that renders the structure inoperable)], ... 1 more ...)
• StructuresComment (type: esriFieldTypeString, alias: Structures Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flow (type: esriFieldTypeString, alias: Flow Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Obstructions)], [Fair: Fair (Low Flow Obstructed)], [Poor: Poor (The Spillway is being utilized)], ... 1 more ...)
• FlowComment (type: esriFieldTypeString, alias: Flow Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Vegetation (type: esriFieldTypeString, alias: Vegetation Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Woody vegetation present )], [Fair: Fair (Some woody vegetation within the structure but not affecting operation)], [Poor: Poor (Heavy Woody vegetation is affecting the effectiveness of the structure)], ... 1 more ...)
• VegetationComment (type: esriFieldTypeString, alias: Vegetation Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Recommendations (type: esriFieldTypeString, alias: Other Comments/Recommendations:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Structures_1697655212017 (type: esriFieldTypeString, alias: Structures, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Construction: Construction])
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Inv_Date (type: esriFieldTypeDate, alias: Inv_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inv_Crew (type: esriFieldTypeString, alias: Inv_Crew, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Asset_Id (type: esriFieldTypeString, alias: Asset_Id, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• In_Service (type: esriFieldTypeDate, alias: In_Service, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Contract (type: esriFieldTypeString, alias: Contract, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BMPType (type: esriFieldTypeString, alias: BMPType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Buffer: Buffer], [Constructed Wetland: Constructed Wetland], [Dry Detention: Dry Detention], ... 7 more ...)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [District 1: District 1], [District 2: District 2], [District 3: District 3], ... 4 more ...)
• GlobalID_1697655212017 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1697655212017 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1697655212017 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1697655212017 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1697655212017 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• InspectionComplete (type: esriFieldTypeString, alias: InspectionComplete, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2025 4:29:02 PM

Schema Last Edit Date: 10/18/2023 6:50:27 PM

Data Last Edit Date: 10/18/2023 6:50:27 PM

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