美国邮编对应洲城市 mysql数据集

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : s_wms Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2024-05-08 16:01:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for us_codes -- ---------------------------- DROP TABLE IF EXISTS `us_codes`; CREATE TABLE `us_codes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) DEFAULT NULL, `latitude` varchar(255) DEFAULT NULL COMMENT '维度', `longitude` varchar(255) DEFAULT NULL COMMENT '经度', `city` varchar(255) DEFAULT NULL COMMENT '城市', `state` varchar(255) DEFAULT NULL COMMENT '州(简称)', `county` varchar(255) DEFAULT NULL COMMENT '县', `type` varchar(255) DEFAULT NULL COMMENT '市', PRIMARY KEY (`id`), KEY `ZIP` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=42742 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of us_codes -- ---------------------------- INSERT INTO `us_codes` VALUES ('1', '00501', '+40.922326', '-072.637078', 'HOLTSVILLE', 'NY', 'SUFFOLK', 'UNIQUE'); INSERT INTO `us_codes` VALUES ('2', '00544', '+40.922326', '-072.637078', 'HOLTSVILLE', 'NY', 'SUFFOLK', 'UNIQUE'); INSERT INTO `us_codes` VALUES ('3', '00601', '+18.165273', '-066.722583', 'ADJUNTAS', 'PR', 'ADJUNTAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('4', '00602', '+18.393103', '-067.180953', 'AGUADA', 'PR', 'AGUADA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('5', '00603', '+18.455913', '-067.145780', 'AGUADILLA', 'PR', 'AGUADILLA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('6', '00604', '+18.493520', '-067.135883', 'AGUADILLA', 'PR', 'AGUADILLA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('7', '00605', '+18.465162', '-067.141486', 'AGUADILLA', 'PR', 'AGUADILLA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('8', '00606', '+18.172947', '-066.944111', 'MARICAO', 'PR', 'MARICAO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('9', '00610', '+18.288685', '-067.139696', 'ANASCO', 'PR', 'ANASCO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('10', '00611', '+18.279531', '-066.802170', 'ANGELES', 'PR', 'UTUADO', 'PO BOX ONLY'); INSERT INTO `us_codes` VALUES ('11', '00612', '+18.450674', '-066.698262', 'ARECIBO', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('12', '00613', '+18.458093', '-066.732732', 'ARECIBO', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('13', '00614', '+18.429675', '-066.674506', 'ARECIBO', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('14', '00616', '+18.444792', '-066.640678', 'BAJADERO', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('15', '00617', '+18.447092', '-066.544255', 'BARCELONETA', 'PR', 'BARCELONETA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('16', '00622', '+17.998531', '-067.187318', 'BOQUERON', 'PR', 'CABO ROJO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('17', '00623', '+18.062201', '-067.149541', 'CABO ROJO', 'PR', 'CABO ROJO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('18', '00624', '+18.023535', '-066.726156', 'PENUELAS', 'PR', 'PENUELAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('19', '00627', '+18.477891', '-066.854770', 'CAMUY', 'PR', 'CAMUY', 'STANDARD'); INSERT INTO `us_codes` VALUES ('20', '00631', '+18.269187', '-066.864993', 'CASTANER', 'PR', 'LARES', 'STANDARD'); INSERT INTO `us_codes` VALUES ('21', '00636', '+18.113284', '-067.039706', 'ROSARIO', 'PR', 'SAN GERMAN', 'STANDARD'); INSERT INTO `us_codes` VALUES ('22', '00637', '+18.087322', '-066.934911', 'SABANA GRANDE', 'PR', 'SABANA GRANDE', 'STANDARD'); INSERT INTO `us_codes` VALUES ('23', '00638', '+18.336160', '-066.472087', 'CIALES', 'PR', 'CIALES', 'STANDARD'); INSERT INTO `us_codes` VALUES ('24', '00641', '+18.250027', '-066.698957', 'UTUADO', 'PR', 'UTUADO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('25', '00646', '+18.436060', '-066.281954', 'DORADO', 'PR', 'DORADO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('26', '00647', '+17.969594', '-066.939754', 'ENSENADA', 'PR', 'GUANICA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('27', '00650', '+18.360125', '-066.562311', 'FLORIDA', 'PR', 'FLORIDA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('28', '00652', '+18.457254', '-066.603358', 'GARROCHALES', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('29', '00653', '+17.972468', '-066.898661', 'GUANICA', 'PR', 'GUANICA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('30', '00656', '+18.023280', '-066.786909', 'GUAYANILLA', 'PR', 'GUAYANILLA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('31', '00659', '+18.481391', '-066.808696', 'HATILLO', 'PR', 'HATILLO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('32', '00660', '+18.145486', '-067.135323', 'HORMIGUEROS', 'PR', 'HORMIGUEROS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('33', '00662', '+18.480285', '-067.028155', 'ISABELA', 'PR', 'ISABELA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('34', '00664', '+18.217606', '-066.598306', 'JAYUYA', 'PR', 'JAYUYA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('35', '00667', '+18.015099', '-067.055973', 'LAJAS', 'PR', 'LAJAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('36', '00669', '+18.295952', '-066.881925', 'LARES', 'PR', 'LARES', 'STANDARD'); INSERT INTO `us_codes` VALUES ('37', '00670', '+18.252135', '-066.990967', 'LAS MARIAS', 'PR', 'LAS MARIAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('38', '00674', '+18.445530', '-066.490268', 'MANATI', 'PR', 'MANATI', 'STANDARD'); INSERT INTO `us_codes` VALUES ('39', '00676', '+18.383727', '-067.080799', 'MOCA', 'PR', 'MOCA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('40', '00677', '+18.335781', '-067.252547', 'RINCON', 'PR', 'RINCON', 'STANDARD'); INSERT INTO `us_codes` VALUES ('41', '00678', '+18.453030', '-066.933689', 'QUEBRADILLAS', 'PR', 'QUEBRADILLAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('42', '00680', '+18.219023', '-067.508068', 'MAYAGUEZ', 'PR', 'MAYAGUEZ', 'STANDARD'); INSERT INTO `us_codes` VALUES ('43', '00681', '+18.219023', '-067.508068', 'MAYAGUEZ', 'PR', 'MAYAGUEZ', 'STANDARD'); INSERT INTO `us_codes` VALUES ('44', '00682', '+18.219023', '-067.508068', 'MAYAGUEZ', 'PR', 'MAYAGUEZ', 'STANDARD'); INSERT INTO `us_codes` VALUES ('45', '00683', '+18.113284', '-067.039706', 'SAN GERMAN', 'PR', 'SAN GERMAN', 'STANDARD'); INSERT INTO `us_codes` VALUES ('46', '00685', '+18.323600', '-066.972227', 'SAN SEBASTIAN', 'PR', 'SAN SEBASTIAN', 'STANDARD'); INSERT INTO `us_codes` VALUES ('47', '00687', '+18.316976', '-066.415207', 'MOROVIS', 'PR', 'MOROVIS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('48', '00688', '+18.429675', '-066.674506', 'SABANA HOYOS', 'PR', 'ARECIBO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('49', '00690', '+18.476196', '-067.139597', 'SAN ANTONIO', 'PR', 'AGUADILLA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('50', '00692', '+18.435818', '-066.338523', 'VEGA ALTA', 'PR', 'VEGA ALTA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('51', '00693', '+18.443109', '-066.398302', 'VEGA BAJA', 'PR', 'VEGA BAJA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('52', '00694', '+18.443109', '-066.398302', 'VEGA BAJA', 'PR', 'VEGA BAJA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('53', '00698', '+18.061040', '-066.861164', 'YAUCO', 'PR', 'YAUCO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('54', '00703', '+18.250398', '-066.128450', 'AGUAS BUENAS', 'PR', 'AGUAS BUENAS', 'STANDARD'); INSERT INTO `us_codes` VALUES ('55', '00704', '+17.992290', '-066.139253', 'AGUIRRE', 'PR', 'GUAYAMA', 'STANDARD'); INSERT INTO `us_codes` VALUES ('56', '00705', '+18.128092', '-066.268717', 'AIBONITO', 'PR', 'AIBONITO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('57', '00707', '+18.007014', '-065.898719', 'MAUNABO', 'PR', 'MAUNABO', 'STANDARD'); INSERT INTO `us_codes` VALUES ('58', '00714', '+17.967510', '-066.041380', 'ARROYO', 'PR', 'ARROYO', 'STANDARD'); INSERT INTO `us_cod