Name: InspectionReport
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 5000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"InspectionReport","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- header (type: esriFieldTypeString, alias: Inspection Report , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- scdot_pin (type: esriFieldTypeString, alias: SCDOT PIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contract_id (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_lat (type: esriFieldTypeDouble, alias: Latitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
- project_long (type: esriFieldTypeDouble, alias: Longitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
- city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- subregion (type: esriFieldTypeString, alias: subregion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county1 (type: esriFieldTypeString, alias: County (if multiple), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [na: N/A], [Abbeville: Abbeville], [Aiken: Aiken], ... 44 more ...)
- district (type: esriFieldTypeInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dot_consultant (type: esriFieldTypeString, alias: On-Call Environmental Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cec: CECS, INC], [oaks: 3-Oaks Engineering], [ice: ICE], ... 3 more ...)
- other_company (type: esriFieldTypeString, alias: Other Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- scdot_rce (type: esriFieldTypeString, alias: SCDOT RCE Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- other_rce (type: esriFieldTypeString, alias: Other RCE Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractor_name (type: esriFieldTypeString, alias: Contractor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- water_body (type: esriFieldTypeString, alias: Nearest Waterbody, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- permits (type: esriFieldTypeString, alias: Project Permits (note all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [emergency: Emergency Project], [safety: Safety Project], [interstate: Interstate Upgrades/Widening], ... 3 more ...)
- compliance_status (type: esriFieldTypeString, alias: Compliance Status (Old), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Green: Green], [Yellow: Yellow], [Orange: Orange], ... 1 more ...)
- inspection_date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_visit_date (type: esriFieldTypeDate, alias: Date of Last Visit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- weather (type: esriFieldTypeString, alias: Weather Conditions on Day of Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- work_performed (type: esriFieldTypeString, alias: Work Performed in Accordance with Project Permits, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- additional_commitments (type: esriFieldTypeString, alias: Any Additional Environmental Commitments Completed Since Previous Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- wetlands (type: esriFieldTypeString, alias: Wetlands on Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- jurisdictional (type: esriFieldTypeString, alias: Jurisdictional, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- critical_area (type: esriFieldTypeString, alias: Critical Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- visitors (type: esriFieldTypeString, alias: Regulatory Agency Visitors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
- agency (type: esriFieldTypeString, alias: Name of Regulatory Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- agency_visitor (type: esriFieldTypeString, alias: Names of Regulatory Agency Visitors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- offsite_impacts (type: esriFieldTypeString, alias: Observed Offsite Impacts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- offsite_num (type: esriFieldTypeInteger, alias: How Many Locations?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- offsite_impacts_desc (type: esriFieldTypeString, alias: Observed Offsite Impacts Location and Description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- other_impacts (type: esriFieldTypeString, alias: Observed Any Other Environmental Non-Compliance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- other_impacts_desc (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- impact_offsite (type: esriFieldTypeString, alias: Offsite and other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- mileage (type: esriFieldTypeDouble, alias: Vehicle Mileage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- hours_site (type: esriFieldTypeDouble, alias: Hours at Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
- arrive_time (type: esriFieldTypeString, alias: Arrival Time (12-hour), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- depart_time (type: esriFieldTypeString, alias: Departure Time (12-hour), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- total_hours (type: esriFieldTypeDouble, alias: Total Hours with Travel, SQL Type: sqlTypeOther, nullable: true, editable: true)
- url_link (type: esriFieldTypeString, alias: Please provide ProjectWise folder link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- general_comment (type: esriFieldTypeString, alias: General Comments, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- consultant_email (type: esriFieldTypeString, alias: Email of the Consultant, 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)
- desired_format (type: esriFieldTypeString, alias: Please select the desired report format, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [word: Word], [pdf: PDF], [not_need: Not Needed])
- consultant_name (type: esriFieldTypeString, alias: Name of Inspector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [wadeb: Wade Biltoft], [jessicaclark: Jessica Clark], [codyc: Cody Conner], ... 21 more ...)
- second_pin (type: esriFieldTypeString, alias: Secondary PIN (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- unresloved_impacts (type: esriFieldTypeString, alias: Previous Unresolved Impacts/Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- number_of_unresolved (type: esriFieldTypeInteger, alias: Number of Unresolved locations, SQL Type: sqlTypeOther, nullable: true, editable: true)
- unresolved_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- previous_unresloved_impacts (type: esriFieldTypeString, alias: Previous Unresolved Impacts/Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- number_of_unresolved_impacts (type: esriFieldTypeInteger, alias: Number of Unresolved locations, SQL Type: sqlTypeOther, nullable: true, editable: true)
- number_of_previous_unresolved_impacts (type: esriFieldTypeInteger, alias: Number of Previous Unresolved Impacts, SQL Type: sqlTypeOther, nullable: true, editable: true)
- previous_unresolved_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inspection_status (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- clearing_status (type: esriFieldTypeString, alias: Clearing Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [not_start: Not Started], [ongoing: Ongoing], [complete: Complete])
- acreage (type: esriFieldTypeString, alias: Acreage to be cleared, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- clearing_complete (type: esriFieldTypeString, alias: Approximate % Clearing Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [25: <25%], [50: 25% - 50%], [75: 50% - 75%], ... 1 more ...)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- InspectionReport_photos (1) -- Related To: photos (1)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/18/2025 8:25:53 PM
Schema Last Edit Date: 8/18/2025 8:25:53 PM
Data Last Edit Date: 8/18/2025 8:25:53 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat