
INSERT INTO State_Master_new (country_code, state_code, state_name, boundary_start_of_latitude, boundary_end_of_latitude, boundary_start_of_longitude, boundary_end_of_longitude, time_correction_code, Zone) VALUES 
('Can.', 'Alta', 'Alberta', NULL, NULL, NULL, NULL, 'ALB001', '105W'),
('Can.', 'B.C.', 'Br. Col.', NULL, NULL, NULL, NULL, 'BC0001', '120W'),
('Can.', 'Man.', 'Manitoba', NULL, NULL, NULL, NULL, 'MAN001', '90W'),
('Can.', 'N.B.', 'New Brunswick', NULL, NULL, NULL, NULL, 'NB0001', '60W'),
('Can.', 'Nfld', 'NewfoundLand', NULL, NULL, NULL, NULL, 'NF0001', '52:30W'),
('Can.', 'NWT.', 'Northwest Terr', NULL, NULL, NULL, NULL, 'NT0001', '105W'),
('Can.', 'N.S.', 'Nova Scotia', NULL, NULL, NULL, NULL, 'NS0001', '60W'),
('Can.', 'Ont.', 'Ontario', NULL, NULL, NULL, NULL, 'ON0001', '75W'),
('Can.', 'P.E.', 'Pr. Edward Is.', NULL, NULL, NULL, NULL, 'PE0001', '60W'),
('Can.', 'Que.', 'Quebec', NULL, NULL, NULL, NULL, 'QU0001', '75W'),
('Can.', 'Sask', 'Saskatchewan', NULL, NULL, NULL, NULL, 'SAS001', '105W'),
('Can.', 'Y.T.', 'Yukon Terr.', NULL, NULL, NULL, '140W', 'YU0001', '120W'),
('USA', 'AL', 'Alabama', NULL, NULL, NULL, NULL, 'AL0001', '90W'),
('USA', 'AK', 'Alaska', NULL, NULL, NULL, NULL, 'AK0001', '150W'),
('USA', 'AZ', 'Arizona', NULL, NULL, NULL, NULL, 'AZ0001', '120W'),
('USA', 'AR', 'Arkansas', NULL, NULL, NULL, NULL, 'AR0001', '90W'),
('USA', 'CA', 'California', NULL, NULL, NULL, NULL, 'CA0001', '120W'),
('USA', 'CO', 'Colorado', NULL, NULL, NULL, NULL, 'CO0001', '105W'),
('USA', 'CT', 'Connecticut', NULL, NULL, NULL, NULL, 'CT0001', '75W'),
('USA', 'DE', 'Delaware', NULL, NULL, NULL, NULL, 'DE0001', '75W'),
('USA', 'DC', 'Dist. of Col.', NULL, NULL, NULL, NULL, 'DC0001', '75W'),
('USA', 'FL', 'Florida', NULL, NULL, NULL, NULL, 'FL0001', '75W'),
('USA', 'GA', 'Georgia', NULL, NULL, NULL, NULL, 'GA0001', '75W'),
('USA', 'HI', 'Hawaii', NULL, NULL, NULL, NULL, 'HI0001', '150W'),
('USA', 'ID', 'Idaho', NULL, NULL, NULL, NULL, 'ID0001', '105W'),
('USA', 'IL', 'Illinois', NULL, NULL, NULL, NULL, 'IL0001', '90W'),
('USA', 'IN', 'Indiana', NULL, NULL, NULL, NULL, 'IN0001', '75W'),
('USA', 'IA', 'Iowa', NULL, NULL, NULL, NULL, 'IA0002', '90W'),
('USA', 'KS', 'Kansas', NULL, NULL, NULL, NULL, 'KS0001', '90W'),
('USA', 'KY', 'Kentucky', NULL, NULL, NULL, NULL, 'KY0001', '75W'),
('USA', 'LA', 'Louisiana', NULL, NULL, NULL, NULL, 'LA0001', '90W'),
('USA', 'ME', 'Maine', NULL, NULL, NULL, NULL, 'ME0001', '75W'),
('USA', 'MD', 'Maryland', NULL, NULL, NULL, NULL, 'MD0001', '75W'),
('USA', 'MA', 'Massachusetts', NULL, NULL, NULL, NULL, 'MA0001', '75W'),
('USA', 'MI', 'Michigan', NULL, NULL, NULL, NULL, 'MI0001', '75W'),
('USA', 'MN', 'Minnesota', NULL, NULL, NULL, NULL, 'MN0001', '90W'),
('USA', 'MS', 'Mississippi', NULL, NULL, NULL, NULL, 'MS0001', '90W'),
('USA', 'MO', 'Missouri', NULL, NULL, NULL, NULL, 'MO0001', '90W'),
('USA', 'MT', 'Montana', NULL, NULL, NULL, NULL, 'MT0001', '105W'),
('USA', 'NE', 'Nebraska', NULL, NULL, NULL, NULL, 'NE0001', '90W'),
('USA', 'NV', 'Nevada', NULL, NULL, NULL, NULL, 'NV0001', '105W'),
('USA', 'NH', 'New Hampshire', NULL, NULL, NULL, NULL, 'NH0001', '75W'),
('USA', 'NJ', 'New Jersey', NULL, NULL, NULL, NULL, 'NJ0001', '75W'),
('USA', 'NM', 'New Mexico', NULL, NULL, NULL, NULL, 'NM0001', '105W'),
('USA', 'NY', 'New York', NULL, NULL, NULL, NULL, 'NY0001', '75W'),
('USA', 'NC', 'N. Carolina', NULL, NULL, NULL, NULL, 'NC0001', '75W'),
('USA', 'ND', 'North Dakota', NULL, NULL, NULL, NULL, 'ND0001', '90W'),
('USA', 'OH', 'Ohio', NULL, NULL, NULL, NULL, 'OH0001', '75W'),
('USA', 'OK', 'Oklahoma', NULL, NULL, NULL, NULL, 'OK0001', '90W'),
('USA', 'OR', 'Oregon', NULL, NULL, NULL, NULL, 'OR0001', '120W'),
('USA', 'PA', 'Pennsylvania', NULL, NULL, NULL, NULL, 'PA0001', '75W'),
('USA', 'RI', 'Rhode Island', NULL, NULL, NULL, NULL, 'RI0001', '75W'),
('USA', 'PR', 'Puerto Rico', NULL, NULL, NULL, NULL, 'PR0001', '60W'),
('USA', 'SC', 'S. Carolina', NULL, NULL, NULL, NULL, 'SC0001', '75W'),
('USA', 'SD', 'South Dakota', NULL, NULL, NULL, NULL, 'SD0001', '105W'),
('USA', 'TN', 'Tennessee', NULL, NULL, NULL, NULL, 'TN0001', '90W'),
('USA', 'TX', 'Texas', NULL, NULL, NULL, NULL, 'TX0001', '105W'),
('USA', 'UT', 'Utah', NULL, NULL, NULL, NULL, 'UT0001', '105W'),
('USA', 'VT', 'Vermont', NULL, NULL, NULL, NULL, 'VT0001', '75W'),
('USA', 'VA', 'Virginia', NULL, NULL, NULL, NULL, 'VA0001', '75W'),
('USA', 'WA', 'Washington', NULL, NULL, NULL, NULL, 'WA0001', '120W'),
('USA', 'WV', 'West Virginia', NULL, NULL, NULL, NULL, 'WV0001', '75W'),
('USA', 'WI', 'Wisconsin', NULL, NULL, NULL, NULL, 'WI0001', '90W'),
('USA', 'WY', 'Wyoming', NULL, NULL, NULL, NULL, 'WY0001', '105W'),
('Ind.', 'A.P.', 'Andra Pradesh', '12:45N', '77:30N', '72:42E', '88:40E', NULL, '82:30E'),
('Ind.', 'Aru.', 'Aru. Pradesh.', '27:02N', '27:58N', '92:18E', '96:51E', NULL, '82:30E'),
('Ind.', 'Ass.', 'Assam', '19:26N', '29:07N', '74:54E', '97:02E', NULL, '82:30E'),
('Ind.', 'Bih.', 'Bihar', '21:38N', '34:32N', '73:13E', '88:32E', NULL, '82:30E'),
('Ind.', 'Goa.', 'Goa', '15:13N', '15:37N', '73:50E', '74:10E', NULL, '82:30E'),
('Ind.', 'Guj.', 'Gujarat', '19:59N', '29:41N', '20:26E', '86E', NULL, '82:30E'),
('Ind.', 'Har.', 'Haryana', '25:52N', '31:04N', '74:40E', '77:42E', NULL, '82:30E'),
('Ind.', 'H.P.', 'H. P.', '30:27N', '33:08N', '66:57E', '78:44E', NULL, '82:30E'),
('Ind.', 'J&K.', 'J & K', '32:22N', '36:55N', '35:40E', '83:30E', NULL, '82:30E'),
('Ind.', 'Kar.', 'Karnataka', '8:54N', '18:17N', '74:06E', '78:24E', NULL, '82:30E'),
('Ind.', 'Ker.', 'Kerala', '8:26N', '18:38N', '74:53E', '77:24E', NULL, '82:30E'),
('Ind.', 'M.P.', 'M P', '18:03N', '30:51N', '74:10E', '88:08E', NULL, '82:30E'),
('Ind.', 'Mah.', 'Maharashtra', '15:13N', '27:49N', '69:08E', '94:05E', NULL, '82:30E'),
('Ind.', 'Man.', 'Manipur', '24:02N', '25:25N', '93:17E', '94:36E', NULL, '82:30E'),
('Ind.', 'Meg.', 'Meghlaya', '25:04N', '25:54N', '89:51E', '92:05E', NULL, '82:30E'),
('Ind.', 'Miz.', 'Mizoram', '22:25N', '24:14N', '92:25E', '93:57E', NULL, '82:30E'),
('Ind.', 'Nag.', 'Nagaland', '25:32N', '26:44N', '93:58E', '94:51E', NULL, '82:30E'),
('Ind.', 'Ori.', 'Orissa', '18:05N', '27:29N', '81:40E', '88:22E', NULL, '82:30E'),
('Ind.', 'Pun.', 'Punjab', '12:09N', '32:27N', '73:13E', '78:23E', NULL, '82:30E'),
('Ind.', 'Raj.', 'Rajasthan', '12:40N', '29:54N', '69:38E', '79:59E', NULL, '82:30E'),
('Ind.', 'Sik.', 'Sikkim', '27:09N', '27:58N', '88:32E', '88:51E', NULL, '82:30E'),
('Ind.', 'T.N.', 'Tamilnadu', '8:04N', '13:26N', '76:30E', '80:20E', NULL, '82:30E'),
('Ind.', 'Tri.', 'Tripura', '23:15N', '24:33N', '91:14E', '92:09E', NULL, '82:30E'),
('Ind.', 'U.P.', 'U P', '10:57N', '88:50N', '38:44E', '93:40E', NULL, '82:30E'),
('Ind.', 'W.B.', 'West Bengal', '20:40N', '27:15N', '82:12E', '89:44E', 'Ind002', '82:30E'),
('Ind.', 'A&N.', 'And.& Nicobar', '7:59N', '10:51N', '92:28E', '93:22E', NULL, '82:30E'),
('Ind.', 'Chd.', 'Chandigarh', NULL, NULL, NULL, NULL, NULL, '82:30E'),
('Ind.', 'D&N.', 'Dadra & Nagra', '20:12N', '20:22N', '72:48E', '73E', NULL, '82:30E'),
('Ind.', 'D&D.', 'Daman & Diu', NULL, NULL, NULL, NULL, NULL, '82:30E'),
('Ind.', 'Del.', 'Delhi', '28:32N', '28:50N', '73:13E', '77:18E', NULL, '82:30E'),
('Ind.', 'Lak.', 'Lakshadweep', NULL, NULL, NULL, NULL, NULL, '82:30E'),
('Ind.', 'Pon.', 'Pondicherry', NULL, NULL, NULL, NULL, NULL, '82:30E'),
('Astr', 'CTR', 'Capital Territory', NULL, NULL, NULL, NULL, 'CTR001', '150:00E'),
('Astr', 'NSW', 'New South Wales', NULL, NULL, NULL, NULL, 'NSW001', '150:30E'),
('Astr', 'NTR', 'Northern Territory', NULL, NULL, NULL, NULL, 'NTR001', '142:30E'),
('Astr', 'QLAND', 'Queensland', NULL, NULL, NULL, NULL, 'QLND01', '150:00E'),
('Astr', 'SAUS', 'South Australia', NULL, NULL, NULL, NULL, 'SAUS01', '142:30E'),
('Astr', 'TASM', 'Tasmania', NULL, NULL, NULL, NULL, 'TASM01', '150:00E'),
('Astr', 'VICT', 'Victoria', NULL, NULL, NULL, NULL, 'VICT01', '150:00E'),
('Astr', 'WAUS', 'Western Australia', NULL, NULL, NULL, NULL, 'WAUS01', '120:00E'),
('Astr', 'CHI', 'Christmas Island', NULL, NULL, NULL, NULL, 'CHI001', NULL),
('Astr', 'LHI', 'Lord Howe Island', NULL, NULL, NULL, NULL, 'LHI001', NULL),
('Ind.', 'Utr.', 'Uttaranchal', '10:57N', '88:50N', '38:44E', '93:40E', NULL, '82:30E'),
('Ind.', 'Chh.', 'Chhattisgarh', '18:03N', '30:51N', '74:10E', '88:08E', NULL, '82:30E'),
('Ind.', 'Jha.', 'Jharkhand', '21:38N', '34:32N', '73:13E', '88:32E', NULL, '82:30E');