NAME TRACKING & MAINTAINANCE  
KEY ADDRESS POLYGONAL BOUNDARIES  
  DESCRIPTIVE 9-1-1  USE  
       
         FINAL Road Fields for H-GAC STAR*Map &  911  
Field Name Type Length  Desciption 
STARMAP_ID L_Int 10 unique ID 
PREFIX String 2 N, S, E, W 
NAME String 60 road name (no abreviation)
ST_TYPE String 4 RD, ST, AVE, LN etc…
SUFFIX String 2 N, S, E, W 
FULL_NAME String 75 full name
ALIAS String 75 alias full name
LF_ADDR L_Int 10 left from address
LT_ADDR L_Int 10 left to address
RF_ADDR L_Int 10 right from address
RT_ADDR L_Int 10 right to address
LF_ACT L_Int 10 actual left from address
LT_ACT L_Int 10 actual left to address
RF_ACT L_Int 10 actual right from address
RT_ACT L_Int 10 actual right to address
ROAD_CLASS  String 8 road classification
PARITY_L String 1 left parity
PARITY_R String 1 right parity
BOUND String 2 bound direction
ONE_WAY String 2 FT TF N <null>
SPEED L_Int 10 speed limit
LANES L_Int 2 number of lanes
SOURCE String 6 source of data 
EDITOR String 35 name of editor
CREATED Date   date created
DATE_MOD Date   date modified
GDC_FLAG String 10 type of modification
SUBDIV String 80 subdivision
CITY_L String 35 city left
CITY_R String 35 city right
COUNTY_L String 35 county left
COUNTY_R String 35 county right
STATE_L String 15 state left
STATE_R String 15 state right
POSTAL_L String 35 postal community left
POSTAL_R String 35 postal community right
ZIP_R L_Int 5 zipcode left
ZIP_L L_Int 5 zipcode right
MSAG_NAME String 75 msag name
ESN_L String 5 emergency service zone left
ESN_R String 5 emergency service zone right
MSAG_COM_L String 35 MSAG community left
MSAG_COM_R String 35 MSAG community right
EXCHANGE_L String 5 exchange left
EXCHANGE_R String 5 exchange right
MSAG_VALID String 1 MSAG validation status