STATION,Lon,Lat,Elevation);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE201','NE201','Botswana','Botswana','Africa',NOW(),600508600,23.93279,-24.515347,980);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE202','NE202','Botswana','Botswana','Africa',NOW(),600508600,21.78230,-24.113518,1153);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE203','NE203','Botswana','Botswana','Africa',NOW(),600508600,20.19555,-22.993069,1313);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE204','NE204','Botswana','Botswana','Africa',NOW(),600508600,21.33822,-18.539561,1060);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE205','NE205','Botswana','Botswana','Africa',NOW(),600508600,23.50048,-18.620888,961);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE206','NE206','Botswana','Botswana','Africa',NOW(),600508600,25.16189,-17.80017,1006);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE207','NE207','Botswana','Botswana','Africa',NOW(),600508600,21.17876,-19.531001,1094);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE208','NE208','Botswana','Botswana','Africa',NOW(),600508600,25.44691,-21.946406,1083);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE209','NE209','Botswana','Botswana','Africa',NOW(),600508600,23.77177,-21.40355,1005);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE210','NE210','Botswana','Botswana','Africa',NOW(),600508600,21.21571,-21.361916,1198);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE211','NE211','Botswana','Botswana','Africa',NOW(),600508600,22.20679,-22.853821,1153);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE212','NE212','Botswana','Botswana','Africa',NOW(),600508600,24.66079,-23.380394,1038);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE213','NE213','Botswana','Botswana','Africa',NOW(),600508600,22.85729,-25.475531,1030);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE214','NE214','Botswana','Botswana','Africa',NOW(),600508600,22.16247,-19.389189,985);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE215','NE215','Botswana','Botswana','Africa',NOW(),600508600,25.19642,-18.781,1035);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE216','NE216','Botswana','Botswana','Africa',NOW(),600508600,24.53719,-20.195683,956);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE217','NE217','Botswana','Botswana','Africa',NOW(),600508600,27.33424,-21.099676,1047);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE218','NE218','Botswana','Botswana','Africa',NOW(),600508600,26.21785,-20.562855,941);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE219','NE219','Botswana','Botswana','Africa',NOW(),600508600,27.44682,-22.569674,911);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE220','NE220','Botswana','Botswana','Africa',NOW(),600508600,25.85961,-23.363035,1020);
insert into isc.site (sta,staname,region,country,zone,lddate,reporter,lat,lon,elev) values ('NE221','NE221','Botswana','Botswana','Africa',NOW(),600508600,24.80085,-25.811854,1158.1);


Mon 10 Dec 07:49:41 GMT 2018

BEGIN WORK;
UPDATE site SET lon = 23.93279, lat = -24.515347 WHERE sta = 'NE201' AND net is NULL;
UPDATE site SET lon = 21.78230, lat = -24.113518 WHERE sta = 'NE202' AND net is NULL;
UPDATE site SET lon = 20.19555, lat = -22.993069 WHERE sta = 'NE203' AND net is NULL;
UPDATE site SET lon = 21.33822, lat = -18.539561 WHERE sta = 'NE204' AND net is NULL;
UPDATE site SET lon = 23.50048, lat = -18.620888 WHERE sta = 'NE205' AND net is NULL;
UPDATE site SET lon = 25.16189, lat = -17.80017  WHERE sta = 'NE206' AND net is NULL;
UPDATE site SET lon = 21.17876, lat = -19.531001 WHERE sta = 'NE207' AND net is NULL;
UPDATE site SET lon = 25.44691, lat = -21.946406 WHERE sta = 'NE208' AND net is NULL;
UPDATE site SET lon = 23.77177, lat = -21.40355  WHERE sta = 'NE209' AND net is NULL;
UPDATE site SET lon = 21.21571, lat = -21.361916 WHERE sta = 'NE210' AND net is NULL;
UPDATE site SET lon = 22.20679, lat = -22.853821 WHERE sta = 'NE211' AND net is NULL;
UPDATE site SET lon = 24.66079, lat = -23.380394 WHERE sta = 'NE212' AND net is NULL;
UPDATE site SET lon = 22.85729, lat = -25.475531 WHERE sta = 'NE213' AND net is NULL;
UPDATE site SET lon = 22.16247, lat = -19.389189 WHERE sta = 'NE214' AND net is NULL;
UPDATE site SET lon = 25.19642, lat = -18.781    WHERE sta = 'NE215' AND net is NULL;
UPDATE site SET lon = 24.53719, lat = -20.195683 WHERE sta = 'NE216' AND net is NULL;
UPDATE site SET lon = 27.33424, lat = -21.099676 WHERE sta = 'NE217' AND net is NULL;
UPDATE site SET lon = 26.21785, lat = -20.562855 WHERE sta = 'NE218' AND net is NULL;
UPDATE site SET lon = 27.44682, lat = -22.569674 WHERE sta = 'NE219' AND net is NULL;
UPDATE site SET lon = 25.85961, lat = -23.363035 WHERE sta = 'NE220' AND net is NULL;
UPDATE site SET lon = 24.80085, lat = -25.811854 WHERE sta = 'NE221' AND net is NULL;