Name: BMP Inspection

Display Field: ObjectID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• ObjectID ( type: esriFieldTypeDouble, alias: ObjectID )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, length: 255 )
• Structure_Number ( type: esriFieldTypeString, alias: Structure Number, length: 255 )
• Inspection_ID ( type: esriFieldTypeString, alias: Inspection ID, length: 255 )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Site_Address ( type: esriFieldTypeString, alias: Site Address, length: 255 )
• City ( type: esriFieldTypeString, alias: City, length: 255 )
• Zip ( type: esriFieldTypeString, alias: Zip, length: 255 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 255 )
• Current_Occupant ( type: esriFieldTypeString, alias: Current Occupant, length: 255 )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection Type, length: 255 , Coded Values: [1: Initial] , [2: Triennial] , [3: Complaint] )
• Re_Inspection_ID ( type: esriFieldTypeString, alias: Re-Inspection ID, length: 255 )
• Type_of_Facility ( type: esriFieldTypeString, alias: Type of Facility, length: 255 )
• Other_issues ( type: esriFieldTypeString, alias: Other issues, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected By, length: 255 )
• Phone_No_ ( type: esriFieldTypeString, alias: Phone No#, length: 255 )
• InspEmail ( type: esriFieldTypeString, alias: InspEmail, length: 255 )
• INSP_RES ( type: esriFieldTypeString, alias: Select one of the following:, length: 255 , Coded Values: [Access_ReInsp : Provide access to the SWMF so it may be inspected. Please contact the inspector to schedule a re-inspection.] , [Maint_Req: Perform maintenance/repairs identified below in the comments section to address the issues noted on page 2. Contact the inspector for re-inspection when work is completed.] , [No_Action_NA: Our records incorrectly identified this facility on your property. No action is required.] , ...2 more... )
• Compliance_Violation_ ( type: esriFieldTypeString, alias: Compliance Violation:, length: 255 , Coded Values: [Maj: Major] , [Min: Minor] , [N: None] )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 255 )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• FacDesRem ( type: esriFieldTypeString, alias: Facility destroyed or removed, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• AccFacObs ( type: esriFieldTypeString, alias: Access to facility is obstructed or limited, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• DefDamFenGat ( type: esriFieldTypeString, alias: Defective or damaged fence, gate or lock, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• DamMisDet ( type: esriFieldTypeString, alias: Damaged, misaligned, or deteriorated structure, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• AccCovDam ( type: esriFieldTypeString, alias: Access cover damaged or could not be opened, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• ObsMisIno ( type: esriFieldTypeString, alias: Observation well missing or inoperable, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• SoiSetSin ( type: esriFieldTypeString, alias: Soil settlement and/or sink holes observed, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• GraNotMow ( type: esriFieldTypeString, alias: Grassy areas are not mowed as required, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• TreStakRem ( type: esriFieldTypeString, alias: Tree stakes have not been removed, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• TreShrOve ( type: esriFieldTypeString, alias: Trees and/or shrubs are overgrown, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• PreNuiVeg ( type: esriFieldTypeString, alias: Predominance of nuisance vegetation, weeds, invasive species, or, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• LanBufPon ( type: esriFieldTypeString, alias: Landscape buffer around the pond is missing or inadequate, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• DeaDisDyi ( type: esriFieldTypeString, alias: Dead, diseased, or dying trees, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• EscAgaGro ( type: esriFieldTypeString, alias: Excessive agal growth in the permanent pool of wet pond, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• MulMisIns ( type: esriFieldTypeString, alias: Mulch layer missing or insufficient, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• VegSedBlo ( type: esriFieldTypeString, alias: Vegetation and/or sediment is blocking flow from entering, exiti, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• StaWatClo ( type: esriFieldTypeString, alias: Standing water indicated facility may be clogged, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• FacHolWat ( type: esriFieldTypeString, alias: Facility does not hold water, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• WatFloFac ( type: esriFieldTypeString, alias: Stormwater does not flow to the facility, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• PerPooDep ( type: esriFieldTypeString, alias: Permanent pool depth is at less than designed minimum, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• GrasCovIns ( type: esriFieldTypeString, alias: Grass cover insufficient for erosion control, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• MisInaRip ( type: esriFieldTypeString, alias: Missing or inadequate rip-rap protection, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• EviSloFai ( type: esriFieldTypeString, alias: Evidence of slope failure, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• EviPetCon ( type: esriFieldTypeString, alias: Evidence of petroleum contamination was observed in facility (oi, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• FouUnpOdo ( type: esriFieldTypeString, alias: Foul and/or unpleasant odors were detected, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• ExcAccSed ( type: esriFieldTypeString, alias: Excessive accumulation of sediment observed, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• ExcAccTra ( type: esriFieldTypeString, alias: Excessive accumulation of trash and debris observed, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• TreShrEmb ( type: esriFieldTypeString, alias: Trees and/or shrubs located on dam embankment, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• WatSeeDam ( type: esriFieldTypeString, alias: Water leaking / seeping from dam embankment, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• CraBulDam ( type: esriFieldTypeString, alias: Settlement, cracking, sliding, or bulging of dam embankment, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• AniBurEmb ( type: esriFieldTypeString, alias: Animal burrows on embankment, length: 4 , Coded Values: [yes: Yes] , [no: No] )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE GDB ID, length: 13 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )

Relationships:

• ESD_Structural_BMP (4) -- Related To: ESD and Structural BMP (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata