Name: Structural BMP Inspections

Display Field: DATE

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• DATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: Structural BMP Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sump: Sump], [Rain Garden: Rain Garden], [Infiltration Trench: Infiltration Trench], ... 8 more ...)
• CONDITION (type: esriFieldTypeString, alias: Structural BMP Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clear / Functional *****: Clear / Functional *****], [Needs Maintenance / Cleaning ****: Needs Maintenance / Cleaning ****], [Needs Repair ***: Needs Repair ***], ... 2 more ...)
• TRASH (type: esriFieldTypeString, alias: Trash or Debris Present, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor], [Severe: Severe])
• DAMAGE (type: esriFieldTypeString, alias: Physical damage to BMP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor], [Severe: Severe])
• EROSION (type: esriFieldTypeString, alias: Erosion around BMP area or banks, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor], [Severe: Severe])
• SEDIMENT (type: esriFieldTypeString, alias: Sediment buildup in the BMP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor], [Severe: Severe])
• VEGETATION (type: esriFieldTypeString, alias: Vegetation overgrowth, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor], [Severe: Severe])
• DISCHARGE (type: esriFieldTypeString, alias: Illicit discharge present, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MAINTENANCE (type: esriFieldTypeString, alias: Maintenance Needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• COMMENTS (type: esriFieldTypeString, alias: Maintenance Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAINDATE (type: esriFieldTypeDate, alias: Maintenance Completed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTOR (type: esriFieldTypeString, alias: Inspector's Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Kirby Templin: Kirby Templin], [Keith Raines: Keith Raines], [Lindsey Vugteveen: Lindsey Vugteveen], ... 2 more ...)
• INSPECTEXT (type: esriFieldTypeString, alias: Inspector's Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• swSTRUCTGUID (type: esriFieldTypeGUID, alias: swSTRUCTGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• MAINCOMMENTS (type: esriFieldTypeString, alias: Maintenance Completed Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAINCOMPLETE (type: esriFieldTypeString, alias: Maintenance Completed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PHOTO (type: esriFieldTypeString, alias: Add Photo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DEPTH (type: esriFieldTypeString, alias: Full Sump Depth, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1 Foot: 1 Foot], [2 Feet: 2 Feet], [3 Feet: 3 Feet], ... 3 more ...)
• ILLICITDISCHARG (type: esriFieldTypeString, alias: Illicit Discharge Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: Structural BMP Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• swStructuralBMPs (1) -- Related To: Structural BMPs (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/20/2024 2:36:16 PM

Schema Last Edit Date: 11/20/2024 2:36:16 PM

Data Last Edit Date: 11/20/2024 2:36:16 PM

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