Name: Construction Site Inspections

Display Field: InspectorName

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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspectorName ( type: esriFieldTypeString, alias: Inspector’s Name, length: 25 )
• InspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• LastInspection ( type: esriFieldTypeDate, alias: Date of Last Inspection, length: 8 )
• StartTime ( type: esriFieldTypeString, alias: Start Time, length: 10 )
• EndTime ( type: esriFieldTypeString, alias: EndTime, length: 10 )
• USEPAPermit ( type: esriFieldTypeString, alias: Subject to USEPA Construction General Permit?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• NOI ( type: esriFieldTypeString, alias: Has NOI been approved?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• InspectionType ( type: esriFieldTypeString, alias: Type of Inspection, length: 25 , Coded Values: [Regular: Regular] , [Pre-Storm Event: Pre-Storm Event] , [During Storm Event: During Storm Event] , ...1 more... )
• Weather ( type: esriFieldTypeString, alias: Describe the weather conditions at time of inspection, length: 25 , Coded Values: [Mostly Sunny: Mostly Sunny] , [Mostly Cloudy: Mostly Cloudy] , [Light Rain: Light Rain] , ...3 more... )
• Phase ( type: esriFieldTypeString, alias: Describe the current phase of construction, length: 25 , Coded Values: [Excavation: Excavation] , [Foundation: Foundation] )
• BMPDesc1 ( type: esriFieldTypeString, alias: BMP Description 1, length: 50 )
• BMPInstalled1 ( type: esriFieldTypeString, alias: BMP 1 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction1 ( type: esriFieldTypeString, alias: BMP 1 Corrective Action Needed, length: 100 )
• BMPDesc2 ( type: esriFieldTypeString, alias: BMP Description 2, length: 50 )
• BMPInstalled2 ( type: esriFieldTypeString, alias: BMP 2 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction2 ( type: esriFieldTypeString, alias: BMP 2 Corrective Action Needed, length: 100 )
• BMPDesc3 ( type: esriFieldTypeString, alias: BMP Description 3, length: 50 )
• BMPInstalled3 ( type: esriFieldTypeString, alias: BMP 3 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction3 ( type: esriFieldTypeString, alias: BMP 3 Corrective Action Needed, length: 100 )
• BMPDesc4 ( type: esriFieldTypeString, alias: BMP Description 4, length: 50 )
• BMPInstalled4 ( type: esriFieldTypeString, alias: BMP 4 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction4 ( type: esriFieldTypeString, alias: BMP 4 Corrective Action Needed, length: 100 )
• BMPDesc5 ( type: esriFieldTypeString, alias: BMP Description 5, length: 50 )
• BMPInstalled5 ( type: esriFieldTypeString, alias: BMP 5 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction5 ( type: esriFieldTypeString, alias: BMP 5 Corrective Action Needed, length: 100 )
• BMPDesc6 ( type: esriFieldTypeString, alias: BMP Description 6, length: 50 )
• BMPInstalled6 ( type: esriFieldTypeString, alias: BMP 6 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction6 ( type: esriFieldTypeString, alias: BMP 6 Corrective Action Needed, length: 100 )
• BMPDesc7 ( type: esriFieldTypeString, alias: BMP Description 7, length: 50 )
• BMPInstalled7 ( type: esriFieldTypeString, alias: BMP 7 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction7 ( type: esriFieldTypeString, alias: BMP 7 Corrective Action Needed, length: 100 )
• BMPDesc8 ( type: esriFieldTypeString, alias: BMP Description 8, length: 50 )
• BMPInstalled8 ( type: esriFieldTypeString, alias: BMP 8 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction8 ( type: esriFieldTypeString, alias: BMP 8 Corrective Action Needed, length: 100 )
• BMPDesc9 ( type: esriFieldTypeString, alias: BMP Description 9, length: 50 )
• BMPInstalled9 ( type: esriFieldTypeString, alias: BMP 9 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction9 ( type: esriFieldTypeString, alias: BMP 9 Corrective Action Needed, length: 100 )
• BMPDesc10 ( type: esriFieldTypeString, alias: BMP Description 10, length: 50 )
• BMPInstalled10 ( type: esriFieldTypeString, alias: BMP 10 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction10 ( type: esriFieldTypeString, alias: BMP 10 Corrective Action Needed, length: 100 )
• BMPDesc11 ( type: esriFieldTypeString, alias: BMP Description 11, length: 50 )
• BMPInstalled11 ( type: esriFieldTypeString, alias: BMP 11 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction11 ( type: esriFieldTypeString, alias: BMP 11 Corrective Action Needed, length: 100 )
• BMPDesc12 ( type: esriFieldTypeString, alias: BMP Description 12, length: 50 )
• BMPInstalled12 ( type: esriFieldTypeString, alias: BMP 12 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction12 ( type: esriFieldTypeString, alias: BMP 12 Corrective Action Needed, length: 100 )
• BMPDesc13 ( type: esriFieldTypeString, alias: BMP Description 13, length: 50 )
• BMPInstalled13 ( type: esriFieldTypeString, alias: BMP 13 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction13 ( type: esriFieldTypeString, alias: BMP 13 Corrective Action Needed, length: 100 )
• BMPDesc14 ( type: esriFieldTypeString, alias: BMP Description 14, length: 50 )
• BMPInstalled14 ( type: esriFieldTypeString, alias: BMP 14 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction14 ( type: esriFieldTypeString, alias: BMP 14 Corrective Action Needed, length: 100 )
• BMPDesc15 ( type: esriFieldTypeString, alias: BMP Description 15, length: 50 )
• BMPInstalled15 ( type: esriFieldTypeString, alias: BMP 15 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction15 ( type: esriFieldTypeString, alias: BMP 15 Corrective Action Needed, length: 100 )
• BMPDesc16 ( type: esriFieldTypeString, alias: BMP Description 16, length: 50 )
• BMPInstalled16 ( type: esriFieldTypeString, alias: BMP 16 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction16 ( type: esriFieldTypeString, alias: BMP 16 Corrective Action Needed, length: 100 )
• BMPDesc17 ( type: esriFieldTypeString, alias: BMP Description 17, length: 50 )
• BMPInstalled17 ( type: esriFieldTypeString, alias: BMP 17 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction17 ( type: esriFieldTypeString, alias: BMP 17 Corrective Action Needed, length: 100 )
• BMPDesc18 ( type: esriFieldTypeString, alias: BMP Description 18, length: 50 )
• BMPInstalled18 ( type: esriFieldTypeString, alias: BMP 18 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction18 ( type: esriFieldTypeString, alias: BMP 18Corrective Action Needed, length: 100 )
• BMPDesc19 ( type: esriFieldTypeString, alias: BMP Description 19, length: 50 )
• BMPInstalled19 ( type: esriFieldTypeString, alias: BMP 19 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction19 ( type: esriFieldTypeString, alias: BMP 19 Corrective Action Needed, length: 100 )
• BMPDesc20 ( type: esriFieldTypeString, alias: BMP Description 20, length: 50 )
• BMPInstalled20 ( type: esriFieldTypeString, alias: BMP 20 Installed and operating properly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• BMPAction20 ( type: esriFieldTypeString, alias: BMP 20 Corrective Action Needed, length: 100 )
• ESCFeatures ( type: esriFieldTypeString, alias: Have all ESC features been constructed before initiating other construction activities?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ESCFeaturesAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• ESCDevices ( type: esriFieldTypeString, alias: Is the contractor inspecting and maintaining ESC devices regularly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ESCDevicesAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• VegetationMaintained ( type: esriFieldTypeString, alias: Is existing vegetation maintained on the site as long as possible?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• VegetationAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Staging ( type: esriFieldTypeString, alias: Is construction staged so as to minimize exposed soil and disturbed areas?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• StagingAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• DisturbanceRestoration ( type: esriFieldTypeString, alias: Are disturbed areas restored as soon as possible after work is completed?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DisturbanceAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• WaterDiversion ( type: esriFieldTypeString, alias: Is clean water being diverted away from the site?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• WaterDiversionAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• SedimentClean ( type: esriFieldTypeString, alias: Are sediment traps and sediment barriers cleaned regularly?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SedimentCleanAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• ProtectedBuffers ( type: esriFieldTypeString, alias: Are vegetated and wooded buffers protected and left undistrurbed?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ProtectedBuffersAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• SoilStability ( type: esriFieldTypeString, alias: Are soils stabilized by mulching and/or seeding when they are exposed for a long time?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SoilStabilityAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• VegEstablish ( type: esriFieldTypeString, alias: Has vegetation been allowed to establish itself before flows are introduced to channels?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• VegEstablishAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• DustControl ( type: esriFieldTypeString, alias: Is regular, light watering used for dust control?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DustControlAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Compaction ( type: esriFieldTypeString, alias: Is excessive soil compaction with heavy machinery avoided, to the extent possible?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• CompactionAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• ErosionControl ( type: esriFieldTypeString, alias: Are erosion control blankets used when seeding slopes?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ErosionControlAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• TreesRetained ( type: esriFieldTypeString, alias: Are trees and vegetation that are to be retained during contruction adequately protected?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• TreesRetainedAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• OffLimitAreas ( type: esriFieldTypeString, alias: Are areas designated as off-limits to construction equipment flagged or easily distinguishable?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• OffLimitAreasAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• TopsoilProtect ( type: esriFieldTypeString, alias: If excavated topsoil has been salvaged and stockpiled for later use on the project, are stockpiles adequately protected?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• TopsoilAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• SlopeDrain ( type: esriFieldTypeString, alias: Are temporary slope drains or chutes used to transport water down steep slopes?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SlopeDrainAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Sewer ( type: esriFieldTypeString, alias: Do all entrances to the storm sewer system have adequate protection?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SewerAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• SlopeStability ( type: esriFieldTypeString, alias: Are slopes and disturbed areas not being actively worked properly stabilized?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SlopeStabilityAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• StockpileProtect ( type: esriFieldTypeString, alias: Are material stockpiles covered or protected when not in use?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• StockpileAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• NatResources ( type: esriFieldTypeString, alias: Are natural resource areas protected with sediment barriers or other BMPs?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• NatResourcesAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• PerimeterControl ( type: esriFieldTypeString, alias: Are perimeter controls and sediment barriers installed and maintained?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PerimeterControlAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Discharge ( type: esriFieldTypeString, alias: Are discharge points and receiving waters free of sediments deposits and turbidity?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DischargeAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Inlets ( type: esriFieldTypeString, alias: Are storm drain inlets properly protected?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• InletsAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• StreetSediment ( type: esriFieldTypeString, alias: Is there evidence of sediment being tracked into streets?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• StreetSedimentAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Trash ( type: esriFieldTypeString, alias: Is trash/litter from the construction site collected and placed in dumpsters?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• TrashAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• GasLeaks ( type: esriFieldTypeString, alias: Are vehicle/equipment fueling and maintenance areas free of spills and leaks?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• GasLeaksAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Contaminants ( type: esriFieldTypeString, alias: Are potential stormwater contaminants protected inside or under cover?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ContaminantsAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Dewatering ( type: esriFieldTypeString, alias: Is dewatering from site properly controlled?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DewateringAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Restrooms ( type: esriFieldTypeString, alias: Are portable restroom facilities properly sited and maintained?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• RestroomsAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• HazMatStorage ( type: esriFieldTypeString, alias: Are all hazardous materials and wastes stored in accordance with local regulations?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• HazMatStorageAction ( type: esriFieldTypeString, alias: Corrective Action Needed, length: 100 )
• Notes ( type: esriFieldTypeString, alias: Inspection Notes, length: 200 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• RELATEGlobalID ( type: esriFieldTypeGUID, alias: Related GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Creator, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Editor, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited, length: 8 )

Relationships:

• ConstructionSites (0) -- Related To: Construction Site Locations (0)

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

  Iteminfo   Thumbnail   Metadata