Net  Code    Name                            Lat          Lon      Elev       Open Date    Close date    Agency
NP   5053   Calexico                       32.66950   -115.49250   2         1997-03-13                 U.S. Geological Survey
NP   5054   Holtville Bonds Crnr Olima     32.69323   -115.338188  9         1996-09-26                 U.S. Geological Survey
NP   5271   Bombay Beach                   33.35262   -115.73325   -96       1996-06-05    2014-03-27   U.S. Geological Survey
CI   BOMB   Bombay Beach                   33.36465   -115.72963   -54       2009/02/10                 Caltech and USGS
CI   CLI2   Calipatria 2                   33.12112   -115.58016   -60       2016/05/12                 Caltech and USGS
CI   SLVP   Salvation Pass                 33.23854   -115.30436   254       2018/09/27                 Caltech and USGS

insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,lddate,reporter) values ('5053','Calexico','California','U.S.A.','North America',32.66950,-115.49250,2.0,'1997-03-13',NOW(),600574978);
insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,lddate,reporter) values ('5054','Holtville Bonds Crnr Olima','California','U.S.A.','North America',32.69323,-115.338188,9.0,'1996-09-26',NOW(),600574978);
insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,close_date,lddate,reporter) values ('5271','Bombay Beach','California','U.S.A.','North America',33.35262,-115.73325,-96.0,'1996-06-05','2014-03-27',NOW(),600574978);
insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,lddate,reporter) values ('BOMB','Bombay Beach','California','U.S.A.','North America',33.36465,-115.72963,-54.0,'2009-02-10',NOW(),600574978);
insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,lddate,reporter) values ('CLI2','Calipatria 2','California','U.S.A.','North America',33.12112,-115.58016,-60.0,'2016-05-12',NOW(),600574978);
insert into isc.site (sta,staname,region,country,zone,lat,lon,elev,open_date,lddate,reporter) values ('SLVP','Salvation Pass','California','U.S.A.','North America',33.23854,-115.30436,254.0,'2018-09-27',NOW(),600574978);