SCDOT ------------------------------------------------------------------------------- DISCLAIMER - The South Carolina Department of Transportation makes no representation or warranties, implied or expressed, concerning the accuracy completeness, reliability, or suitability for any particular purpose of the information and data contained herein. ------------------------------------------------------------------------------- RECORD LAYOUT: DELIMITED BY COMA WITH QUOTATIONS AROUND CHARACTER DATA FIELD COLUMN FIELD FIELD NAME POSITION LENGTH TYPE ----------------- ---------- ------ --------- COUNTY 1-2 2 NUMERIC STATION 4-7 4 NUMERIC ROUTE DESIGNATION 9-10 2 NUMERIC ROUTE NUMBER 12-15 4 NUMERIC ROUTE AUXILIARY 17-18 2 NUMERIC AADT 20-25 6 NUMERIC YEAR COUNT 27-30 4 NUMERIC LOCATION 33-66 34 CHARACTER (without quotes) TABLES: COUNTY TABLE ----------------------------------- | COUNTY NUMBER | COUNTY NAME | |-----------------|---------------| | 01 | ABBEVILLE | | 02 | AIKEN | | 03 | ALLENDALE | | 04 | ANDERSON | | 05 | BAMBERG | | 06 | BARNWELL | | 07 | BEAUFORT | | 08 | BERKELEY | | 09 | CALHOUN | | 10 | CHARLESTON | | 11 | CHEROKEE | | 12 | CHESTER | | 13 | CHESTERFIELD | | 14 | CLARENDON | | 15 | COLLETON | | 16 | DARLINGTON | | 17 | DILLON | | 18 | DORCHESTER | | 19 | EDGEFIELD | | 20 | FAIRFIELD | | 21 | FLORENCE | | 22 | GEORGETOWN | | 23 | GREENVILLE | | 24 | GREENWOOD | | 25 | HAMPTON | | 26 | HORRY | | 27 | JASPER | | 28 | KERSHAW | | 29 | LANCASTER | | 30 | LAURENS | | 31 | LEE | | 32 | LEXINGTON | | 33 | MCCORMICK | | 34 | MARION | | 35 | MARLBORO | | 36 | NEWBERRY | | 37 | OCONEE | | 38 | ORANGEBURG | | 39 | PICKENS | | 40 | RICHLAND | | 41 | SALUDA | | 42 | SPARTANBURG | | 43 | SUMTER | | 44 | UNION | | 45 | WILLIAMSBURG | | 46 | YORK | ----------------------------------- ROUTE DESIGNATION TABLE ------------------------------------- | ROUTE | ROUTE | | DESIGNATION | DESIGNATION | | CODE | DESCRIPTION | |----------------|------------------| | 1 | INTERSTATE (I-) | | 2 | PRIMARY (US) | | 4 | PRIMARY (SC) | | 7 | SECONDARY (S-) | | 9 | LOCAL (L-) | ------------------------------------- ROUTE AUXILIARY TABLE ------------------------------------ | ROUTE | ROUTE | | AUXILIARY | AUXILIARY | | CODE | DESCRIPTION | |-------------|--------------------| | 0 | MAINLINE | | 2 | ALTERNATE | | 3 | MAINLINE COUPLET | | 4 | BUSINESS COUPLET | | 5 | SPUR | | 6 | CONNECTOR | | 7 | BUSINESS | | 8 | BY-PASS | | 48 | BUSINESS1 | | 49 | BUSINESS2 | | 50 | CONNECTOR1 | | 52 | CONNECTOR2 | | 82 | OTHER | ------------------------------------ FIELD POSITION SCALE ------------------------------------------------------------------- 1 2 3 4 5 6 1234567890123456789012345678901234567890123456789012345678901234567 ------------------------------------------------------------------- SAMPLE TRAFFIC DATA FOLLOWS: 1, 100, 4, 185, 0, 1100,2004,"Anderson Co. TO S.C. 20 " 1, 101, 2, 178, 0, 4600,2004,"Anderson Co. Line TO S-166 " 1, 103, 2, 178, 0, 5100,2004,"S-166 TO S.C. 184 " 1, 105, 2, 178, 0, 3600,2004,"S.C. 184 TO Greenwood Co. " 1, 107, 4, 20, 0, 6300,2004,"S.C. 72 TO Pickens Street " 1, 109, 4, 20, 0, 6900,2004,"Pickens Street TO S.C. 71 " SEE FILE: 04TRAF.TXT FOR COMPLETE 2004 COUNT YEAR TRAFFIC DATA