· 8 years ago · Mar 08, 2018, 01:12 PM
1-- Create the table
2CREATE TABLE IF NOT EXISTS `StateBoundaries` (
3 `State` varchar(10) DEFAULT NULL,
4 `Name` varchar(255) DEFAULT NULL,
5 `MinLat` varchar(50) DEFAULT NULL,
6 `MaxLat` varchar(50) DEFAULT NULL,
7 `MinLon` varchar(50) DEFAULT NULL,
8 `MaxLon` varchar(50) DEFAULT NULL
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11-- Insert the data
12REPLACE INTO `StateBoundaries` (`State`, `Name`, `MinLat`, `MaxLat`, `MinLon`, `MaxLon`) VALUES
13 ('AK', 'Alaska', '52.5964', '71.5232', '-169.9146', '-129.993'),
14 ('AL', 'Alabama', '30.1463', '35.0041', '-88.4743', '-84.8927'),
15 ('AR', 'Arkansas', '33.0075', '36.4997', '-94.6198', '-89.6594'),
16 ('AZ', 'Arizona', '31.3325', '37.0004', '-114.8126', '-109.0475'),
17 ('CA', 'California', '32.5121', '42.0126', '-124.6509', '-114.1315'),
18 ('CO', 'Colorado', '36.9949', '41.0006', '-109.0489', '-102.0424'),
19 ('CT', 'Connecticut', '40.9509', '42.0511', '-73.7272', '-71.7874'),
20 ('DE', 'Delaware', '38.4482', '39.8296', '-75.7919', '-74.8526'),
21 ('FL', 'Florida', '24.3959', '31.0035', '-87.6256', '-79.8198'),
22 ('GA', 'Georgia', '30.3575', '34.9996', '-85.6082', '-80.696'),
23 ('HI', 'Hawaii', '18.71', '22.3386', '-160.3922', '-154.6271'),
24 ('IA', 'Iowa', '40.3622', '43.5008', '-96.6357', '-90.1538'),
25 ('ID', 'Idaho', '41.9871', '49.0018', '-117.2372', '-111.0471'),
26 ('IL', 'Illinois', '36.9894', '42.5116', '-91.512', '-87.0213'),
27 ('IN', 'Indiana', '37.7718', '41.7611', '-88.098', '-84.809'),
28 ('KS', 'Kansas', '36.9927', '40.0087', '-102.0506', '-94.6046'),
29 ('KY', 'Kentucky', '36.4931', '39.1439', '-89.5372', '-82.0308'),
30 ('LA', 'Louisiana', '28.8832', '33.0225', '-94.043', '-88.7421'),
31 ('MA', 'Massachusetts', '41.159', '42.889', '-73.5081', '-69.7398'),
32 ('MD', 'Maryland', '37.8889', '39.722', '-79.4861', '-74.8581'),
33 ('ME', 'Maine', '42.9182', '47.455', '-71.0829', '-66.8628'),
34 ('MI', 'Michigan', '41.6965', '48.3042', '-90.4175', '-82.1221'),
35 ('MN', 'Minnesota', '43.5008', '49.3877', '-97.2304', '-89.4919'),
36 ('MO', 'Missouri', '35.9958', '40.6181', '-95.7527', '-89.1005'),
37 ('MS', 'Mississippi', '30.0905', '35.0075', '-91.6589', '-88.0994'),
38 ('MT', 'Montana', '44.3563', '48.9991', '-116.0458', '-104.0186'),
39 ('NC', 'North Carolina', '33.7666', '36.588', '-84.3201', '-75.4129'),
40 ('ND', 'North Dakota', '45.934', '48.9982', '-104.0501', '-96.5671'),
41 ('NE', 'Nebraska', '39.9992', '43.0006', '-104.0543', '-95.3091'),
42 ('NH', 'New Hampshire', '42.6986', '45.3058', '-72.5592', '-70.5583'),
43 ('NJ', 'New Jersey', '38.8472', '41.3593', '-75.5708', '-73.8885'),
44 ('NM', 'New Mexico', '31.3337', '36.9982', '-109.0489', '-103.0023'),
45 ('NV', 'Nevada', '35.003', '42.0003', '-120.0037', '-114.0436'),
46 ('NY', 'New York', '40.4772', '45.0153', '-79.7624', '-71.7517'),
47 ('OH', 'Ohio', '38.3761', '42.321', '-84.8172', '-80.5188'),
48 ('OK', 'Oklahoma', '33.6386', '37.0015', '-103.0064', '-94.4357'),
49 ('OR', 'Oregon', '41.9952', '46.2891', '-124.7305', '-116.4606'),
50 ('PA', 'Pennsylvania', '39.7199', '42.5167', '-80.5243', '-74.707'),
51 ('RI', 'Rhode Island', '41.1849', '42.0156', '-71.9041', '-71.0541'),
52 ('SC', 'South Carolina', '32.0453', '35.2075', '-83.3588', '-78.4836'),
53 ('SD', 'South Dakota', '42.4772', '45.9435', '-104.0529', '-96.438'),
54 ('TN', 'Tennessee', '34.9884', '36.6871', '-90.3131', '-81.6518'),
55 ('TX', 'Texas', '25.8419', '36.5008', '-106.6168', '-93.5074'),
56 ('UT', 'Utah', '36.9982', '41.9993', '-114.0504', '-109.0462'),
57 ('VA', 'Virginia', '36.5427', '39.4659', '-83.6753', '-74.9707'),
58 ('VT', 'Vermont', '42.7289', '45.0153', '-73.4381', '-71.4949'),
59 ('WA', 'Washington', '45.5439', '49.0027', '-124.8679', '-116.9165'),
60 ('WI', 'Wisconsin', '42.4954', '47.31', '-92.8564', '-86.2523'),
61 ('WV', 'West Virginia', '37.1953', '40.6338', '-82.6392', '-77.731'),
62 ('WY', 'Wyoming', '40.9986', '44.9998', '-111.0539', '-104.0556'),
63 ('AS', 'American Samoa', '-14.377579', '-14.221549', '-170.851479', '-170.539742'),
64 ('DC', 'District of Columbia', '38.79164435', '39.031386', '-77.11979522', '-76.867218'),
65 ('FM', 'Federated States of Micronesia', '6.673985', '7.202918', '157.651062', '158.595886'),
66 ('GU', 'Guam', '13.227058', '14.204108', '144.598961', '145.301743'),
67 ('MH', 'Marshall Islands', '1.7575', '17.9578', '157.4121', '175.5395'),
68 ('MP', 'Northern Mariana Islands', '14.834442', '15.300557', '145.530052', '145.836296'),
69 ('PW', 'Palau', '1.7355', '11.4584', '129.6166', '136.9116'),
70 ('PR', 'Puerto Rico', '17.904834', '18.520551', '-67.289886', '-65.177765'),
71 ('VI', 'Virgin Islands', '18.302014', '18.751244', '-64.861221', '-64.26384');