Layers:

Layer: InspectionReport (0)


Name: InspectionReport

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

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

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: Inspection Status, 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: 5000, 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: 10000, 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)
• esrignss_speed (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_direction (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrisnsr_azimuth (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_positionsourcetype (type: esriFieldTypeInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 3 more ...)
• esrignss_receiver (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• esrignss_h_rms (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_v_rms (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_altitude (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_pdop (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_hdop (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_vdop (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_fixtype (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NoFix], [1: GPS], [2: DifferentialGPS], ... 3 more ...)
• esrignss_correctionage (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_stationid (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_numsats (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
• esrignss_fixdatetime (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• esrignss_avg_h_rms (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_v_rms (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_positions (type: esriFieldTypeInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_h_stddev (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)

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: 7/27/2023 5:44:54 PM

Schema Last Edit Date: 7/27/2023 5:44:49 PM

Data Last Edit Date: 7/27/2023 5:44:49 PM

Tables:

photos (1)


Name: photos

Display Field: objectid

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• pin_pin (type: esriFieldTypeString, alias: Pin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• station (type: esriFieldTypeString, alias: Station, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• station_offset (type: esriFieldTypeString, alias: Offset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [left: Left], [right: Right], [center: Center])
• location_status (type: esriFieldTypeString, alias: Location Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [blank: N/A], [Green: Green], [Yellow: Yellow], ... 2 more ...)
• photo_desc (type: esriFieldTypeString, alias: Photograph Name/Title, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• sum_inner (type: esriFieldTypeInteger, alias: Inner repeats, SQL Type: sqlTypeOther, nullable: true, editable: true)
• remarks (type: esriFieldTypeString, alias: Remarks (Issue and Possible Resolution), SQL Type: sqlTypeOther, length: 437, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• InspectionReport_photos (1) -- Related To: InspectionReport (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2023 5:44:54 PM

Schema Last Edit Date: 7/27/2023 5:44:49 PM

Data Last Edit Date: 7/27/2023 5:44:49 PM