Name: BMPInspectionTable

Display Field: AssetID

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

Description:

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• 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: esriFieldTypeGlobalID, 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)

Templates:

Name: BMPInspectionTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Creator_1:
• AssetID:
• Inspector:
• Inspector_other:
• InspectionType:
• InspectionOther:
• TodayWeather:
• Sediment:
• SedimentComment:
• Trash:
• TrashComment:
• Erosion:
• ErosionComment:
• Structures:
• StructuresComment:
• Flow:
• FlowComment:
• Vegetation:
• VegetationComment:
• Recommendations:
• Editor_1:

Relationships:

• (1) -- Related To: Photographs (1)
• (0) -- Related To: BMP Locations (0)

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: 8/23/2024 2:29:23 PM

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

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat