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

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