Name: ProjectTracking

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":"ProjectTracking","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: false

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: Project Tracking, 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)
• district (type: esriFieldTypeInteger, alias: District, SQL Type: sqlTypeOther, 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)
• 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 ...)
• initial_date (type: esriFieldTypeDate, alias: Initial Letting Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• revisied_date (type: esriFieldTypeDate, alias: Revised Letting Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scdot_issue (type: esriFieldTypeString, alias: Issue(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notes_issue (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• issue_summary (type: esriFieldTypeString, alias: Summary, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• issue_resolved (type: esriFieldTypeString, alias: Issue(s) Resolved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
• review_date (type: esriFieldTypeDate, alias: Latest Review Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• checklist_complete (type: esriFieldTypeString, alias: Checklist Complete?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [quick: Quick Review], [partial: Partial], ... 1 more ...)
• actual_date (type: esriFieldTypeDate, alias: Actual Letting Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• usace_ace (type: esriFieldTypeString, alias: USACE Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Unknown])
• expiration_date (type: esriFieldTypeDate, alias: USACE Permit Expiration Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• us_ace (type: esriFieldTypeString, alias: USACE Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [gp: GP], [nwp: NWP], [ip: IP])
• usace_nav (type: esriFieldTypeString, alias: Navigational Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Unknown])
• nav_date (type: esriFieldTypeDate, alias: Navigational Permit Expiration Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• us_nav (type: esriFieldTypeString, alias: Navigational Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [scdhec: SCDHEC], [uscg: USCG])
• usace_nepa (type: esriFieldTypeString, alias: NEPA Document?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Unknown])
• nepa_date (type: esriFieldTypeDate, alias: NEPA Completion Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• us_nepa (type: esriFieldTypeString, alias: NEPA Document Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ce: CE], [ea: EA/FONSI], [rod: ROD])
• credit_complete (type: esriFieldTypeString, alias: Mitigation Credits Complete?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
• monitoring_required (type: esriFieldTypeString, alias: Compliance Monitoring Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Unknown])
• commitment_log (type: esriFieldTypeString, alias: Commitment Log Completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
• precon_date (type: esriFieldTypeDate, alias: Pre-construction Meeting Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contractor (type: esriFieldTypeString, alias: Prime Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• visits (type: esriFieldTypeString, alias: USDA visits required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• project_status (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [precons: Pre-Construction], [active: Active (In Construction)], [near: Near Completion], ... 2 more ...)
• usace_phase (type: esriFieldTypeString, alias: Phase and USACE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [both: Both], ... 1 more ...)
• dot_consultant (type: esriFieldTypeString, alias: Name of the Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [roberth: Robert Hibbits], [jeffs: Jeff Sieckman], [jkallm: Kall McCormick], ... 5 more ...)
• consultant_email (type: esriFieldTypeString, alias: Email of the Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dot_staff (type: esriFieldTypeString, alias: SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [chrisn: Chris Neely], [jessicak: Jessica Kennedy], [michaelj: Michael Queen])
• email (type: esriFieldTypeString, alias: Email of the SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• links (type: esriFieldTypeString, alias: Please list the links for the ProjectWise, 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:

• ProjectTracking_take_note (1) -- Related To: take_note (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2023 5:51:49 PM

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

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

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat