All Layers and Tables (service_6b9b8b7f89424337a744d81b981c46f5)

Layers:

Layer: InspectionReport (0)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Relationships:

InspectionReport_photos (1) -- Related To: photos (1)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

photos (1)