Table Name

Field Name

Definition

Valid Values

Description
roads.aat        
  FNAME 30,30,C   Displays the name portion of the STREET_NAM. In the example: "N Jackson St W", the FNAME would be "Jackson". No periods are used and normally abbreviated words like Saint and Fort are spelled out.
      Any legitimate name in the State of Minnesota as defined in the description field.  
  FDPRE 2,2,C   Displays the prefix portion of the STREET_NAM. In the example: "N Jackson St W", the FDPRE would be "N". No periods are used.
      N North
      S South
      E East
      W West
      NW Northwest
      NE Northeast
      SW Southwest
      SE Southeast
  FTYPE 4,4,C   Displays the type portion of the STREET_NAM. In the example: "N Jackson St W", the FTYPE would be "St". No periods are used.
      Abby Abbey
      Alc Alcove
      Ave Avenue
      Bay Bay
      Bch Beach
      Bend Bend
      Bluf Bluff
      Blvd Boulevard
      Brdg Bridge
      Chas Chase
      Cir Circle
      Ct Court
      Cts Courts
      Cove Cove
      Cr Creek
      Crsc Crescent
      Crst Crest
      Crs Cross
      Cro Crossing
      Crsd Crossroad
      Cruz Cruz
      Cv Curve
      Dwns Downs
      Draw Draw
      Dr Drive
      East East
      Echo Echo
      Edge Edge
      End End
      Ent Entrance
      Ext Extension
      Frwy Freeway
      Gar Gardens
      Gate Gate
      Glad Glade
      Glen Glen
      Grn Green
      Grv Grove
      Hts Heights
      Hwy Highway
      Hill Hill
      Holw Hollow
      Horn Horn
      Inn Inn
      Kn Knoll
      Lndg Landing
      La Lane
      Line Line
      Loop Loop
      Mall Mall
      Manr Manor
      Mdw Meadow
      Mews Mews
      Mill Mill
      Moor Moor
      Oaks Oaks
      Ovlk Overlook
      Park Park
      Pkwy Parkway
      Pass Pass
      Ptch Patch
      Path Path
      Pl Place
      Plz Plaza
      Pt Point
      Pte Pointe
      Pnds Ponds
      Port Port
      Rdg Ridge
      Rise Rise
      Rd Road
      Rte Route
      Row Row
      Run Run
      Shr Shore
      Shrs Shores
      Spur Spur
      Sq Square
      St Street
      Strp Strip
      Ter Terrace
      Trce Trace
      Tr Trail
      Turn Turn
      Tpke Turnpike
      View View
      Vsta Vista
      Walk Walk
      Way Way
      Ways Ways
      West West
      Wood Wood
      Wds Woods
  FDSUF 2,2,C   Displays the suffix portion of the STREET_NAM. In the example: "N Jackson St W", the FDSUF would be "W". No periods are used.
      N North
      S South
      E East
      W West
      NW Northwest
      NE Northeast
      SW Southwest
      SE Southeast
  STREET_NAM 35,35,C   Displays the full street name. This is concatenated from FDPRE, FNAME, FTYPE and FDSUF.
      Possible values are defined by the FDPRE, FNAME, FTYPE and FDSUF fields.  
  STREETNAM2 35,35,C   Displays the full secondary street name if one exists. This field is in the same format as STREET_NAM, using FDPRE, FNAME, FTYPE and FDSUF.
      Possible values are defined by the FDPRE, FNAME, FTYPE and FDSUF fields.  
  STREETNAM3 35,35,C   Displays the full tertiary street name if one exists. This field is in the same format as STREET_NAM, using FDPRE, FNAME, FTYPE and FDSUF.
      Possible values are defined by the FDPRE, FNAME, FTYPE and FDSUF fields.  
  STREETNAM4 35,35,C   Displays the full quaternary street name if one exists. This field is in the same format as STREET_NAM, using FDPRE, FNAME, FTYPE and FDSUF.
      Possible values are defined by the FDPRE, FNAME, FTYPE and FDSUF fields.  
  CODE 2,2,C   Displays the code for the class of the road.
      01 Interstate Trunk Highway
      02 U. S. Trunk Highway
      03 Minnesota Trunk Highway
      04 County State-aid Highway
      05 Municipal State-aid Street
      07 County Road
      08 Township Road
      09 Unorganized Township Road
      10 Municipal Street
      11 National Park Road
      12 National Forest Development Road
      13 Indian Reservation Road
      14 State Forest Road
      15 State Park Road
      16 Military Road
      17 National Monument Road
      18 National Wildlife Refuge Road
      19 Frontage Road
      20 State Game Preserve Road
      22 Ramp
      23 Private Jurisdiction Road
  ROAD_NUM 10,10,C   This displays the number or letter of the road. For example, the road number for "County Road 22" would be "22", and the road number for "County Road F" would be "F". The ROAD_NUM field also includes trailing letters. For example, the road number for "Interstate 35W" would be "35W".
      Any number between 1 and 999, any single letter from A to Z, or a combination of a number and a single letter.  
  ROUTE_DIR 2,2,C   This displays the direction of increasing mileposts as defined by the Mn/DOT Office of Transportation Data & Analysis’ Transportation Information System (TIS).
      I Direction of increasing mileage
      D Direction of decreasing mileage
  COUNTYNAME 20,20,C   Displays the name(s) of the county(ies) that the road falls within.
      Aitkin  
      Anoka  
      Becker  
      Beltrami  
      Benton  
      Big Stone  
      Blue Earth  
      Brown  
      Carlton  
      Carver  
      Cass  
      Chippewa  
      Chisago  
      Clay  
      Clearwater  
      Cook  
      Cottonwood  
      Crow Wing  
      Dakota  
      Dodge  
      Douglas  
      Faribault  
      Fillmore  
      Freeborn  
      Goodhue  
      Grant   
      Hennepin  
      Houston  
      Hubbard  
      Isanti  
      Itasca  
      Jackson  
      Kanabec  
      Kandiyohi  
      Kittson  
      Koochiching  
      Lac Qui Parle  
      Lake  
      Lake of the Woods  
      Le Sueur  
      Lincoln  
      Lyon  
      McLeod  
      Mahnomen  
      Marshall  
      Martin  
      Meeker  
      Mille Lacs  
      Morrison  
      Mower  
      Murray  
      Nicollet  
      Nobles  
      Norman  
      Olmsted  
      Otter Tail  
      Pennington  
      Pine  
      Pipestone  
      Polk  
      Pope  
      Ramsey  
      Red Lake  
      Redwood  
      Renville  
      Rice  
      Rock  
      Roseau  
      Saint Louis  
      Scott  
      Sherburne  
      Sibley  
      Stearns  
      Steele  
      Stevens  
      Swift  
      Todd  
      Traverse  
      Wabasha  
      Wadena  
      Waseca  
       Washington  
      Watonwan  
      Wilkin  
      Winona  
      Wright  
      Yellow Medicine  
  COUNTY_NUM 5,5,C   Displays the number(s) of the county(ies) that the road falls within.
      01 Aitkin
      02 Anoka
      03 Becker
      04 Beltrami
      05 Benton
      06 Big Stone
      07 Blue Earth
      08 Brown
      09 Carlton
      10 Carver
      11 Cass
      12 Chippewa
      13 Chisago
      14 Clay
      15 Clearwater
      16 Cook
      17 Cottonwood
      18 Crow Wing
      19 Dakota
      20 Dodge
      21 Douglas
      22 Faribault
      23 Fillmore
      24 Freeborn
      25 Goodhue
      26 Grant 
      27 Hennepin
      28 Houston
      29 Hubbard
      30 Isanti
      31 Itasca
      32 Jackson
      33 Kanabec
      34 Kandiyohi
      35 Kittson
      36 Koochiching
      37 Lac Qui Parle
      38 Lake
      39 Lake of the Woods
      40 Le Sueur
      41 Lincoln
      42 Lyon
      43 McLeod
      44 Mahnomen
      45 Marshall
      46 Martin
      47 Meeker
      48 Mille Lacs
      49 Morrison
      50 Mower
      51 Murray
      52 Nicollet
      53 Nobles
      54 Norman
      55 Olmsted
      56 Otter Tail
      57 Pennington
      58 Pine
      59 Pipestone
      60 Polk
      61 Pope
      62 Ramsey
      63 Red Lake
      64 Redwood
      65 Renville
      66 Rice
      67 Rock
      68 Roseau
      69 Saint Louis
      70 Scott
      71 Sherburne
      72 Sibley
      73 Stearns
      74 Steele
      75 Stevens
      76 Swift
      77 Todd
      78 Traverse
      79 Wabasha
      80 Wadena
      81 Waseca
      82 Washington
      83 Watonwan
      84 Wilkin
      85 Winona
      86 Wright
      87 Yellow Medicine
  MUNI_MCD 4,4,C   Displays the MCD (Minor Civil Division) number(s) of the municipality(ies) that road falls within.
      The MCD (Minor Civil Division) number of any of the 854 municipalities in Minnesota  
  TIS_CODE 11,11,C   Displays the concatenation of the CODE, COUNTY_NUM or MUNI_MCD, and ROAD_NUM fields.
      Possible values are defined by the CODE, COUNTY_NUM, MUNI_MCD and ROAD_NUM fields.  
  GIS_ROUTE 15, 15, C   Displays the "GIS Route number" for the road. This number is a carryover from BaseMap ’99 hwy coverage, and is intended to help users convert their data to these new coverages. GIS_ROUTE is only populated on the increasing mileage portion of the route. The GIS_ROUTE field is created by combining an abbreviation of the CODE field plus the ROAD_NUM field. In the cases of MSAS and municipal roads, the GIS_ROUTE field is created by combining an abbreviation of the CODE field, plus the MCD_CODE field, plus the ROAD_NUM field. Examples of GIS_ROUTEs for each possible CODE are listed below.
      If CODE = "01", then

GIS_ROUTE = "I(ROAD_NUM)"

 Example: I94
      If CODE = "02", then

GIS_ROUTE = "US(ROAD_NUM)"

 Example: US94
      If CODE = "03", then

GIS_ROUTE = "MN(ROAD_NUM)"

 Example: MN94
      If CODE = "04", then

GIS_ROUTE = "CSAH(ROAD_NUM)"

 Example: CSAH94
      If CODE = "05", then

GIS_ROUTE = "MSAS(MUNI_MCD)

_(ROAD_NUM)"

 Example: MSAS0045_94

This would mean MSAS 94 in the city of Albert Lea.
      If CODE = "07", then

GIS_ROUTE = "CR(ROAD_NUM)"

 Example: CR94
      If CODE = "08", then

GIS_ROUTE = "T(ROAD_NUM)"

 Example: T94
      If CODE = "09", then

GIS_ROUTE = "UT(ROAD_NUM)"

 Example: UT94
      If CODE = "10", then

GIS_ROUTE = "M (MUNI_MCD)

_(ROAD_NUM)"

 Example: M0045_94

This would mean M 94 in the city of Albert Lea.
      If CODE = "11", then

GIS_ROUTE = "NPR(ROAD_NUM)"

 Example: NPR94
      If CODE = "12", then

GIS_ROUTE = "NFR(ROAD_NUM)"

 Example: NFR94
      If CODE = "13", then

GIS_ROUTE = "ISR(ROAD_NUM)"

 Example: ISR94
      If CODE = "14", then

GIS_ROUTE = "SFR(ROAD_NUM)"

 Example: SFR94
      If CODE = "15", then

GIS_ROUTE = "SPR(ROAD_NUM)"

 Example: SPR94
      If CODE = "16", then

GIS_ROUTE = "MIL(ROAD_NUM)"

 Example: MIL94
      If CODE = "17", then

GIS_ROUTE = "NMR(ROAD_NUM)"

 Example: NMR94
      If CODE = "18", then

GIS_ROUTE = "NWR(ROAD_NUM)"

 Example: NWR94
      If CODE = "19", then

GIS_ROUTE = "Frontage(ROAD_NUM)"

 Example: Frontage94
      If CODE = "20", then

GIS_ROUTE = "SGP(ROAD_NUM)"

 Example: SGP94
      If CODE = "22", then

GIS_ROUTE = "RAMP"

 Example: RAMP

(Ramps do not have an entry in the ROAD_NUM field)
      If CODE = "23", then

GIS_ROUTE = "Private Road(ROAD_NUM)"

 Example: Private Road94
  RDWY_NAME 16, 16, C   Displays the "Roadway name" for the road. This number is a carryover from BaseMap ’99 rdwy coverage, and is intended to help users convert their data to these new coverages. RDWY_NAMW is populated on both the increasing and decreasing mileage portions of the route. The RDWY_NAME field is created by taking the GIS_ROUTE number for the road and adding

"-I" if it’s on the direction of increasing mileage and "-D" if it’s on the direction of decreasing mileage. For example, Interstate 94 would have two RDWY_NAME entries: I94-I and I94-D.
      Possible value are any GIS_ROUTE value followed by "-I" or "-D".