Spreadsheet: 053cb53b-473a-4b43-9d9b-4c0660926b9d
Sheet: Format Requirements

Field Name | Definition | Allowable Values | Comments/Description | Example Value
SP_NUMBER | VARCHAR2(20) |  | Diplays the Primary State Project Number | 2771-31
DATE_STRIPED | DATE |  | Displays the date when the line was installed. | 2007-06-25 00:00:00
BEGIN_TIME | HH:MM:SS |  | Displays the time that striping started. | 13:24:45
END_TIME | HH:MM:SS |  | Displays the time that striping ended. | 15:28:30
ROUTE_SYSTEM_ABBR | VARCHAR2(2) | I = Interstate US = US Trunk MN = Minnesota Trunk | Displays the route system class. | MN
ROUTE_NUMBER | VARCHAR2(4) |  | Displays the route number with system type. | 210
DIRECTION | VARCHAR2(1) | I = Increasing D = Decreasing | Direction of travel on roadway. | I
STRIPER_CODE | NUMBER(2) | 0 = Other 1 = MNDOT CENTRAL STRIPING 2 = AAA 3 = HIGHWAY TECHNOLOGIES 4 = CENTURY FENCE  5 = TRAFFIC MARKING SERVICES 6 = SWANSON 7 = GEYER SIGNAL 8 = SAFETY SIGNS 9 = WEST RIVER 10 = NORTHSTAR SAFETY 11 = HIGHWAY SOLUTIONS 12 = AMES 13 = UNITED RENTALS 14 = DAMINCK 15 = MCLAUGHLIN & SCHULTZ 16 = PCI 17 = HAMMERHAD 18 = MATHIOWETZ 19 = DAKOTA TRAFFIC 20 = LUNDA CONSTRUCTION 21 = DALCHN TRAFFIC | Displays the facility that installed the line.  Entered at the Upload screen via dropdown selection. | 2
LINE_TYPE_CODE | VARCHAR2(3) | CL = Center Line REL = Right Edge Line LEL = Left Edge Line LL = [NAME] (White) 1LL = First Lane Line (White - Multilane) 2LL = Second Lane Line (White - Multilane) 3LL = Third Lane Line (White - Multilane) | Marking line type. | REL
MARKING_TYPE_CODE | VARCHAR2(3) | E = Epoxy Paint L = Latex Paint T = Tape TH = Thermoplastic PU = Polyurea Paint MMA = Methyl Methacrylate | Marking material type. | E
[NAME] | NUMBER(2) | 0 = Other 1 = Ennis Paint, Inc. 2 = Epoplex 3 = IPS 4 = Poly-Carb, Inc. 5 = [NAME]6 = Diamond Vogel Paints 7 = 3M Corporation |  | 4
QPL_PAINT_PRODUCT | NUMBER(2) | 0 = Other 1 = HPS-2 (Slow-Dry Epoxy) 2 = HPS-3 (Fast Dry Epoxy) 3 = HPS-4 (Ultra Fast Dry Epoxy) 4 = LS-50 (Fast Dry Epoxy) 5 = LS-60 (Slow-Dry Epoxy) 6 = LS-65 (Slow-Dry Epoxy) 7 = [NAME] (Slow-Dry Epoxy) 8 = [NAME] (Fast Dry Epoxy) 9 = [NAME] (Slow-Dry Epoxy) 20 = MNW-21-M-1 White 982301 (Latex Paint) 21 = MNW-25-M-1 White 982311 (Latex Paint) 22 = MNY-21-M-1 Yellow 982302 (Latex Paint) 23 = MNY-25-M-1 Yellow 982312 (Latex Paint) 24 = TM 2306 White (Latex Paint) 25 = TM 2307 Yellow (Latex Paint) 26 = UC-1515 White (Latex Paint) 27 = UC-3590 Yellow (Latex Paint) 28 = WX23L002 [NAME] (Latex Paint) 29 = WX23W002 White 982321 (Latex Paint) 30 =  MNW-HD21-M-1 White 982321 (High Build Latex Paint) 31 = MNY-HD21-M-1 Yellow 982322 (High Build Latex Paint) 32 = All Weather Paint (High Build Latex Paint) 33 = High Build [NAME] (High Build Latex Paint) 34 = High Build [NAME] (High Build Latex Paint) 40 = HPS-5 (Polyurea) 41 = LS-90 (Polyurea) 42 = LPM 1200 (Polyurea) 50 = UC-1525 [NAME] (Late Season Latex Paint) 51 = UC-3595 [NAME] (Late Season Latex Paint) 60 = Pathfinder (MMA) |  | 7
BEAD_TYPE_CODE | NUMBER(3) | 0 = Other 1 = Flex-o-[NAME] Beads 2 = Potter's Standard Highway Safety Marking Spheres 3 = Swarco Beads 4 = 3M All Weather Elements Series 70E 5 = Potter's Visimax Plus Type IV EC/AC White and [NAME] Beads | Bead ID.  If using single drop bead system, enter code for bead in this field.  If using double drop bead system, enter bead type code for Bead 1 in this field. | 1
BEAD_TYPE_CODE_2 | NUMBER(3) | 0 = Other 1 = Flex-o-[NAME] Beads 2 = Potter's Standard Highway Safety Marking Spheres 3 = Swarco Beads 4 = 3M All Weather Elements Series 70E 5 = Potter's Visimax Plus Type IV EC/AC White and [NAME] Beads | Bead ID of second bead in double drop system (if used).  If using single drop bead system, leave field empty.
LOT_NUMBER_BEAD_1 | VARCHAR2(20) |  | Lot number of Bead 1  If using single drop bead system, enter bead lot number in this field.
LOT_NUMBER_BEAD_2 | VARCHAR2(20) |  | Lot number of Bead 2  If using single drop bead system, leave field empty.
TOTAL_BEADS_LBS | NUMBER(6,3) |  | Displays the total pounds of beads used. | 921.954
BEAD_1_LBS | NUMBER(6,3) |  | Displays the total pounds of Bead 1 in double drop system (if used).  If using single drop bead system, leave field empty. | 737.563
BEAD_2_LBS | NUMBER(6,3) |  | Displays the total pounds of [NAME] in double drop system (if used).  If using single drop bead system, leave field empty. | 184.391
GROOVED | VARCHAR2(3) | Yes/No | Displays the presence of a pavement groove.
RUMBLE_STRIPE | VARCHAR2(3) | Yes/No | Displays the presence of a pavement rumble stripe.
FROM_REF_POST_OFFSET | VARCHAR2(10) |  | Displays the starting reference post number with offset value where line installation starts. | 196+00.245
TO_REF_POST_OFFSET | VARCHAR2(10) |  | Displays the ending reference post number with offset value where line installation ends. | 216+00.518
MILES_OF_PAINT | NUMBER(6,3) |  | Displays the number of miles a pavement marking is installed (not centerline miles, but actual length of marking). | 16.124
BATCH_NUMBER_PAINT | VARCHAR2(20) |  | Displays the batch number of the paint system.
GALLONS_OF_PAINT | NUMBER(6,3) |  | Displays total gallons of liquid material used. | 500.24
FROM_LONGITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the starting point location. | -93.1179478
FROM_LATITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the starting point location. | 44.9389797
TO_LONGITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the ending point location. | -93.1349833
TO_LATITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the ending point location. | 44.931421
YEAR_ROADWAY_BUILT | NUMBER(4) |  | Displays the year the roadway was constructed - current year for new construction. | 2001
COMMENTS | VARCHAR2(100) |  | Displays commentary about the roadway or collection process. | 0915-29
LINE_WIDTH | NUMBER(2) |  | Value in inches | 4
AVG_MILS | NUMBER(3,1) |  | Value in mils - calculated per drive mile installed | 16
AVG_BEADS_LBS_PER_GAL_PAINT | NUMBER(3,1) |  | Displays the average of (ratio of reflective material used per liquid material used) per drive mile installed | 8.2
AVG_MPH | NUMBER(3,1) |  | Average speed of vehicle during application (to the nearest 0.1 MPH) - calculated per drive mile installed | 12.1
[NAME] | NUMBER(3,1) |  | Average humidity during application - calculated per drive mile | 54
AVG_DEWPOINT | NUMBER(3,1) |  | Average dew point during application - calculated per drive mile | 63
AVG_AIR_TEMP | NUMBER(3,1) |  | Average air temperature during application - calculated per drive mile | 80
AVG_ROAD_SURFACE_TEMP | NUMBER(3,1) |  | Average road surface temperature during application - calculated per drive mile | 96