All Layers and Tables (ProjectTracking)

Layers:

Layer: ProjectTracking (0)

Name:

Display Field:

Type:

Geometry Type:

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

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

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

take_note (1)