CREATE TABLE ZIPCODE (
	zipcode	char(5) PRIMARY KEY NOT NULL,
	state	char(2),
	city	char(30),
	lon	float(4,6),
	lat	float(4,6)
)