Posted By

tclancy on 04/09/08


Tagged

mysql db zipcodes


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

dantreacy
kubaitis
virendrakryadav


MySQL Zip Code Table Structure


 / Published in: MySQL
 

  1. CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_zips` (
  2. `detail_cd` CHAR(5) DEFAULT NULL,
  3. `zip_code` VARCHAR(10) NOT NULL,
  4. `city_st_key` VARCHAR(20) DEFAULT NULL,
  5. `zip_class` CHAR(5) DEFAULT NULL,
  6. `city_st_name` VARCHAR(200) DEFAULT NULL,
  7. `city_abbreviation` VARCHAR(50) DEFAULT NULL,
  8. `fac_cd` CHAR(5) DEFAULT NULL,
  9. `mail_name` VARCHAR(50) DEFAULT NULL,
  10. `ll_city_key` VARCHAR(20) DEFAULT NULL,
  11. `ll_city` VARCHAR(200) DEFAULT NULL,
  12. `city_delv` CHAR(5) DEFAULT NULL,
  13. `crrt_mail` CHAR(5) DEFAULT NULL,
  14. `unique_zip` VARCHAR(10) DEFAULT NULL,
  15. `fin_no` VARCHAR(10) DEFAULT NULL,
  16. `state` CHAR(3) DEFAULT NULL,
  17. `fips` TINYINT(3) UNSIGNED DEFAULT NULL,
  18. `county` VARCHAR(200) DEFAULT NULL,
  19. `latitude` DOUBLE DEFAULT NULL,
  20. `longitude` DOUBLE DEFAULT NULL,
  21. `area_code` VARCHAR(3) DEFAULT NULL,
  22. `t_z` TINYINT(4) DEFAULT NULL,
  23. `elevation` INT(11) DEFAULT NULL,
  24. `perns_hous` VARCHAR(50) DEFAULT NULL,
  25. `population_2000` DOUBLE UNSIGNED DEFAULT NULL,
  26. `area_square_miles` DOUBLE UNSIGNED DEFAULT NULL,
  27. `households` INT(10) UNSIGNED DEFAULT NULL,
  28. `white` INT(10) UNSIGNED DEFAULT NULL,
  29. `black` INT(10) UNSIGNED DEFAULT NULL,
  30. `hispanic` INT(10) UNSIGNED DEFAULT NULL,
  31. `household_income` DOUBLE UNSIGNED DEFAULT NULL,
  32. `house_value` VARCHAR(50) DEFAULT NULL,
  33. KEY `zip_code` (`zip_code`)
  34. ) TYPE=INNODB /*!40100 DEFAULT CHARSET=latin1*/;

Report this snippet  

You need to login to post a comment.