CREATE TABLE us_address_fabric
(
	pbkey char(12),
	add_number varchar (11),   
	streetname varchar(60),   
	unit_des varchar(11),   
	unit_num varchar(11),   
	city varchar(30),   
	state char(2),
	zipcode char(5),
	plus4 char(4),  
	loc_code char(3),   
	geoid varchar(15),  
	lat decimal(9,6),   
	lon decimal(11,6),    
	parent char(12),   
	prop_type char(1),
	fips varchar(5)
)