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

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:

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)
• 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: [caitlanb: Caitlan Bell], [wadeb: Wade Biltoft], [codyc: Cody Conner], ... 20 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: 4/11/2025 4:12:44 PM

Schema Last Edit Date: 4/11/2025 4:12:44 PM

Data Last Edit Date: 4/11/2025 4:12:44 PM

Supported Operations:   Query   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