Name: ProjectTracking

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -83.163518035
YMin: 32.1042813560001
XMax: -78.728593761
YMax: 35.175950637
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: false

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: 8, nullable: true, editable: true)
• revisied_date (type: esriFieldTypeDate, alias: Revised Letting Date, SQL Type: sqlTypeOther, length: 8, 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: 1000000000, 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: 8, 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: 8, 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: Pending])
• expiration_date (type: esriFieldTypeDate, alias: USACE Permit Expiration Date, SQL Type: sqlTypeOther, length: 8, 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], [pending: Pending], ... 1 more ...)
• nav_date (type: esriFieldTypeDate, alias: Navigational Permit Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• us_nav (type: esriFieldTypeString, alias: Navigational Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [scdhec: DES], [uscg: USCG])
• usace_nepa (type: esriFieldTypeString, alias: NEPA Document?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [pending: Pending], ... 1 more ...)
• nepa_date (type: esriFieldTypeDate, alias: NEPA Completion Date, SQL Type: sqlTypeOther, length: 8, 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], [pending: Pending], ... 1 more ...)
• 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: 8, 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: [caitlanb: Caitlan Bell], [wadeb: Wade Biltoft], [codyc: Cody Conner], ... 12 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)
• funding_source (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [federal: Federal], [state: State], [ctc: CTC], ... 1 more ...)
• site_visit (type: esriFieldTypeDate, alias: Date of Last ESO Site Visit, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• second_pin (type: esriFieldTypeString, alias: Secondary PIN (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• initial_letting_date (type: esriFieldTypeDate, alias: Initial Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• revised_letting_date (type: esriFieldTypeDate, alias: Revised Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• actual_letting_date (type: esriFieldTypeDate, alias: Actual Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• latest_review_date (type: esriFieldTypeDate, alias: Latest Review Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• checklist_status (type: esriFieldTypeString, alias: Checklist Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• project_phase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• ProjectTracking_stop_work_order (1) -- Related To: stop_work_order (1)
• ProjectTracking_take_note (2) -- Related To: take_note (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/11/2025 7:02:36 PM

Schema Last Edit Date: 3/11/2025 2:32:56 PM

Data Last Edit Date: 4/11/2025 7:02:36 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