-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlat_lon_districts.sql
34 lines (34 loc) · 3.41 KB
/
lat_lon_districts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
UPDATE locations SET latitude='-13.780878', longitude = '34.457050' WHERE level=3 AND name='Salima';
UPDATE locations SET latitude='-13.892793', longitude = '33.770097' WHERE level=3 AND name='Kanengo';
UPDATE locations SET latitude='-13.529906', longitude = '33.735816' WHERE level=3 AND name='Mponela';
UPDATE locations SET latitude='-12.931997', longitude = '34.282322' WHERE level=3 AND name='Nkhunga';
UPDATE locations SET latitude='-14.377644', longitude = '34.333437' WHERE level=3 AND name='Dedza';
UPDATE locations SET latitude='-14.377644', longitude = '33.936467' WHERE level=3 AND name='Dowa';
UPDATE locations SET latitude='-13.032900', longitude = '33.481650' WHERE level=3 AND name='Kasungu';
UPDATE locations SET latitude='-13.989684', longitude = '33.769991' WHERE level=3 AND name='Lilongwe';
UPDATE locations SET latitude='-13.800197', longitude = '32.894312' WHERE level=3 AND name='Mchinji';
UPDATE locations SET latitude='-12.932081', longitude = '34.282580' WHERE level=3 AND name='Nkhotakota';
UPDATE locations SET latitude='-14.822530', longitude = '34.642492' WHERE level=3 AND name='Ntcheu';
UPDATE locations SET latitude='-13.280610', longitude = '33.900964' WHERE level=3 AND name='Ntchisi';
UPDATE locations SET latitude='-15.176391', longitude = '35.299018' WHERE level=3 AND name='Machinga';
UPDATE locations SET latitude='-15.380241', longitude = '35.324248' WHERE level=3 AND name='Zomba';
UPDATE locations SET latitude='-14.486498', longitude = '35.253668' WHERE level=3 AND name='Mangochi';
UPDATE locations SET latitude='-14.990532', longitude = '34.960828' WHERE level=3 AND name='Balaka';
UPDATE locations SET latitude='-12.055848', longitude = '34.742030' WHERE level=3 AND name='Likoma';
UPDATE locations SET latitude='-11.902367', longitude = '33.600807' WHERE level=3 AND name='Mzimba';
UPDATE locations SET latitude='-11.608563', longitude = '34.295454' WHERE level=3 AND name='Nkhata Bay';
UPDATE locations SET latitude='-11.462452', longitude = '34.026393' WHERE level=3 AND name='Mzuzu';
UPDATE locations SET latitude='-9.952660', longitude = '33.926104' WHERE level=3 AND name='Karonga';
UPDATE locations SET latitude='-9.703176', longitude = '33.271366' WHERE level=3 AND name='Chitipa';
UPDATE locations SET latitude='-11.019719', longitude = '33.860772' WHERE level=3 AND name='Rumphi';
UPDATE locations SET latitude='-15.597249', longitude = '34.514296' WHERE level=3 AND name='Mwanza';
UPDATE locations SET latitude='-15.819141', longitude = '35.060168' WHERE level=3 AND name='Chileka';
UPDATE locations SET latitude='-15.806386', longitude = '35.057613' WHERE level=3 AND name='Limbe';
UPDATE locations SET latitude='-16.920479', longitude = '35.252982' WHERE level=3 AND name='Nsanje';
UPDATE locations SET latitude='-15.654597', longitude = '34.460863' WHERE level=3 AND name='Neno';
UPDATE locations SET latitude='-16.068083', longitude = '35.140543' WHERE level=3 AND name='Thyolo';
UPDATE locations SET latitude='-15.763422', longitude = '35.658137' WHERE level=3 AND name='Phalombe';
UPDATE locations SET latitude='-15.819234', longitude = '35.060179' WHERE level=3 AND name='Blantyre';
UPDATE locations SET latitude='-16.043373', longitude = '34.803446' WHERE level=3 AND name='Chikwawa';
UPDATE locations SET latitude='-15.676178', longitude = '35.142517' WHERE level=3 AND name='Chiradzulu';
UPDATE locations SET latitude='-16.026450', longitude = '35.504835' WHERE level=3 AND name='Mulanje';