create table ecs_sf_sites (
       id char(12) primary key,
       site_name varchar(255),
       street_addr varchar(255),
       city	   varchar(255),
       state	   varchar(255),
       zip	   varchar(255),
       county	   varchar(255),
       site_smsa   varchar(255),
       fed_facil   char(1),
       npl_stat	   char(1),
       corp_link   varchar(255),
       rod_link	   varchar(255),
       latitude	   float,
       longitude   float,
       ownership   varchar(255),
       site_incident varchar(255) 
);

insert into ecs_sf_sites values('SC0002408383','ADAMS AUTO PARTS','415 OLD EASLEY HIGHWAY','GREENVILLE','SC','29611','GREENVILLE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD047563614','ADMIRAL HOME APPLIANCES','INDUSTRIAL BLVD;(SEE CM FORM)','WILLISTON','SC','29853','BARNWELL','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD062701487','AMERICAN DEVELOPMENT CORPORATION','2399 AIR PARK ROAD','CHARLESTON','SC','29405','CHARLESTON','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD058754789','AQUA-TECH ENVIRONMENTAL INC (GROCE LABS)','340 ROBINSON ROAD','GREER','SC','29651','SPARTANBURG','3160','N','C',null,null,'34.9328','-82.1725','Other','');
insert into ecs_sf_sites values('SC0002333227','ARKWRIGHT DUMP','HILLTOP LANE','SPARTANBURG','SC','29302','SPARTANBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0001645373','ASHEPOO PHOSPHATE/FERTILIZER WORKS','BRASWELL STREET','CHARLESTON','SC','29405','CHARLESTON','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD003339561','ASTEN-HILL MFG. COMPANY/ASTEN GROUP','.7MI N OF SR64 ON E SIDE OF HWY 15','WALTERBORO','SC','29488','COLLETON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002332815','ATLANTIC PHOSPHATE WORKS','HAGOOD AVENUE @ ASHLEY RIVER','CHARLESTON','SC','29405','CHARLESTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD062690557','AVX CORPORATION','17TH AVENUE, SOUTH','MYRTLE BEACH','SC','29577','HORRY','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD981929672','BABB DRUMS','BABB ROAD','LITTLE CHICAGO','SC','29316','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980843965','BARNWELL TOWN DUMP','SR 607','BARNWELL','SC','29812','BARNWELL','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD000447268','BEAUNIT CORP. (CIRCULAR KNIT & DYEING PLANT)','206 GEORGIA AVE','FOUNTAIN INN','SC','29644','GREENVILLE','3160','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403207.htm','34.698061','-82.216111','Other','');
insert into ecs_sf_sites values('SCD982147894','BESTEEL INDUSTRIES','320 RECOLD ROAD','WALTERBORO','SC','29488','COLLETON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCSFN0406921','BLACKBERRY VALLEY DRUM SITE','BLACKBERRY VALLEY ROAD','GREENVILLE','SC','29611','GREENVILLE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD981028517','BLACKBERRY VALLEY LANDFILL','GROCE RD.','GREENVILLE','SC','29602','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0001097963','BOBBY MILLER JUNKYARD','ROYLE ROAD','SUMMERVILLE','SC','29483','BERKELEY','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD003339082','BORO WOOD PRODUCTS','MAPLE STREET','BENNETTSVILLE','SC','29512','MARLBORO','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987577913','BREWER GOLD MINE DAM FAILURE','1/2 MI. N.OFINTERSECTION OF SR 265&CR110','JEFFERSON','SC','29718','CHESTERFIELD','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980842629','BUFF ( C D ) SITE','JCT HWY 65 & 561','SPARTANBURG','SC','29306','SPARTANBURG','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD981024094','BURKETTE PROPERTIES','4201 & 4211 SCOTT STREET','CHARLESTON','SC','29418','CHARLESTON','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987581337','CALHOUN PARK AREA','CALHOUN AT CONCORD STREET','CHARLESTON','SC','29401','CHARLESTON','1440','N','N',null,'http://www.epa.gov/superfund/sites/rodsites/0405666.htm','','','Unknown','');
insert into ecs_sf_sites values('SCSFN0406965','CARDENLE CHEMICAL FIRE','','COLUMBIA','SC','','RICHLAND','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCSFN0406925','CARLISLE TIRE FIRE','','AIKEN','SC','','AIKEN','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980558316','CAROLAWN, INC.','S. OF SC HWY 9 ON CO. RD 841','FORT LAWN','SC','29714','CHESTER','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403388.htm','34.686111','-80.94305','Other','');
insert into ecs_sf_sites values('SCD003339991','CAROLINA CHEMICALS INC','QUARTERMASTER ST & COLUMBIA ST','WEST COLUMBIA','SC','29169','LEXINGTON','1760','N','N',null,null,'','','Private','');
insert into ecs_sf_sites values('SCD003351970','CAROLINA PLATING & STAMPING','4404 WHITE HORSE RD','GREENVILLE','SC','29611','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD980559926','CAROLINA STEEL DRUM CORP','PORTER RD','ROCKHILL','SC','29730','YORK','6885','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD043980069','CCX FIBERGLASS PRODUCTS','1.3MI E OF HWY 15 ON N SIDE OF SR 459','WALTERBORO','SC','29488','COLLETON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD078067915','CELOTEX CORP','US HWY 301','SELLERS','SC','29592','MARION','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCN000407330','CHARLESTON HARBOR','CHARLESTON HARBOR-BARGE','CHARLESTON','SC','','','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987570645','CHEMURGY PRODUCTS PLANT','101 CONGAREE RD (WOODS LAKE RD)','GREENVILLE','SC','29606','GREENVILLE','3160','N','N',null,null,'','','Private','Non-Oil Spill');
insert into ecs_sf_sites values('SCN000407222','CHEROKEE CO COGEN & PART','','GAFFNEY','SC','','CHEROKEE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0001411040','CHEROKEE COUNTY LANDFILL','NEAR I-85, HWY 18 FRONTAGE ROAD','GAFFNEY','SC','29340','CHEROKEE','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002394070','CHESTER SANITARY LANDFILL','SCOOT ROAD','CHESTER','SC','29706','CHESTER','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD003303120','CLEARWATER FINISHING SITE','SC RD 126 AT US HWY 1/78','CLEARWATER','SC','29822','AIKEN','0600','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0002394104','CLINTON LANDFILL','S-30-308- LOCATED','CLINTON','SC','29325','LAURENS','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980079479','CLINTON MILLS - PLANTS   1 & 2','600 ACADEMY STREET','CLINTON','SC','29325','LAURENS','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0001040393','COLUMBIA NITROGEN','WEST END OF MILFORD ST','CHARLESTON','SC','29405','CHARLESTON','1440','N','N',null,null,'','','Unknown','Non-Oil Spill');
insert into ecs_sf_sites values('SCD003358744','CONE MILLS CORP/UNION BLEACHERY PLT','3335 OLD BUNCOMBE RD','GREENVILLE','SC','29602','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD053336194','DIAMANT BOART AMERICA','10250 TWO NOTCH ROAD','COLUMBIA','SC','29223','RICHLAND','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980710644','DIVEX','MONTGOMERY HWY, ROUTE 1','COLUMBIA','SC','29203','RICHLAND','1760','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0001093475','DIVEX/LEWAND DRIVE','LEWAND DRIVE','COLUMBIA','SC','29203','RICHLAND','1760','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0000368233','DONWAL SITE','125 INDUSTRIAL PARK RD.','SUMMERVILLE','SC','29483','DORCHESTER','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980512834','DORCHESTER LDFL','WEST OF HWY 78','DORCHESTER','SC','29437','DORCHESTER','1440','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD980839575','DREYFUS STREET SITE','DREFUS ST & ASSEMBLY ST','COLUMBIA','SC','29201','RICHLAND','1760','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD001463884','DUBOIS DYING CO','GEORGETOWN N AVE','JOHNSONVILLE','SC','29555','FLORENCE','2655','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0001098292','DUNCAN DRUM BURIAL SITE','WEST BRIGHT ROAD','DUNCAN','SC','29334','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD003344363','DUPONT EI DE NEMOURS & CO','US 1','CAMDEN','SC','29020','KERSHAW','','N','N','//www.epa.gov/enviro/html/disclaimer/dupont.html',null,'','','Other','');
insert into ecs_sf_sites values('SCD981757206','EARL BREWER PROPERTY','KITTY WAKE ROAD','LEXINGTON','SC','29072','LEXINGTON','1760','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0001409002','EDGEFIELD COUNTY LANDFILL','','EDGEFIELD','SC','29824','EDGEFIELD','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980839542','ELMORE WASTE DISPOSAL','117 HIGHLAND AVE','GREER','SC','29651','SPARTANBURG','3160','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403409.htm','34.935905','-82.216599','Other','');
insert into ecs_sf_sites values('SCD987572682','EMILE AVE DRUMS SITE','EMILE AVE AND ALMA AVE','BEREA COMMUNITY','SC','29611','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980491369','ESTECH GENERAL CHEMICALS CORP','1150 SHOP RD','COLUMBIA','SC','29205','RICHLAND','1760','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0002394112','ETIWAN PHOSPHATE COMPANY','MILFORD STREET','CHARLESTON','SC','29405','CHARLESTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD981024193','FED SERV, INC.','MILFORD ROAD','CHARLESTON','SC','29407','CHARLESTON','1440','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD069313781','FIBER INDUSTRIES/PALMETTO PLT','E MCIVER RD','DARLINGTON','SC','29532','DARLINGTON','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0002394369','FIRST UNITED PENTECOSTAL CHURCH','2608 BELHAVEN ROAD','ANDERSON','SC','29621','ANDERSON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCN000407195','FOWLER\'S RADIATOR SHOP','2928 CHEROKEE AVENUE','GAFFNEY','SC','29340','CHEROKEE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980711279','GEIGER (C & M OIL)','OFF SC RT 162','RANTOULES','SC','29494','CHARLESTON','1440','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403400.htm','32.773611','-80.159161','Other','');
insert into ecs_sf_sites values('SC0001442268','GLENN\'S TRAPP DYNAMITE','5731 GOLF COURSE ROAD','GREAT FALLS','SC','29055','CHESTER','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980799456','GOLDEN STRIP SEPTIC TANK SERVICE','ROUTE 1 ADAMS MILL RD','SIMPSONVILLE','SC','29681','GREENVILLE','1440','N','D',null,'http://www.epa.gov/superfund/sites/rodsites/0403404.htm','34.785','-82.2466','Other','');
insert into ecs_sf_sites values('SCD003343191','GRACE, W.R. & CO, AG CHEM GROUP','HARMON & ELGIN STS','CHARLESTON','SC','29402','CHARLESTON','1440','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD062626106','GRANITEVILLE CO/LAGOON','MARSHALL ST','GRANITEVILLE','SC','29829','AIKEN','0600','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD980558399','GRANITEVILLE CO/VAUCLUSE LDFL','HWY 191 (SENN ST)','VAUCLUSE','SC','29850','AIKEN','0600','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987589371','GROCE FARM SITE','HWY 14 GOWENSVILLE','GOWENSVILLE','SC','29651','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD030111348','HELENA CHEMICAL CO','HWY 176','CAMERON','SC','29030','CALHOUN','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD030110373','HELENA CHEMICAL CO','HWY 76 E','MAYESVILLE','SC','29104','SUMTER','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD058753971','HELENA CHEMICAL CO. LANDFILL','HWY 321 S','FAIRFAX','SC','29829','ALLENDALE','0600','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403309.htm','32.9412','-81.239','Other','');
insert into ecs_sf_sites values('SC0002394351','HENRY WOOD PRESERVING','HWY 512 --7 MILES S OF HEMINGWAY','HEMINGWAY','SC','29554','WILLIAMSBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0002190338','HIGHWAY 178 DUMP SITE','HWY 178 & MIDWAY ROAD','PICKENS','SC','29671','PICKENS','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987566726','HINSON CHEMICAL','HIGHWAY 49','LAKE WYLIE','SC','29710','YORK','6885','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002325231','HOLLIS ROAD CONTAMINATION','HOLLIS ROAD (PERIMETER)','LEXINGTON','SC','29073','LEXINGTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987595485','I-85 DISTRIBUTION CENTER','I-85 AND SIGBEE RD','SPARTANBURG','SC','29305','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD042633008','INA BEARING CO., INC.','1298 NEW CUT RD.','SPARTANBURG','SC','29304','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD004773644','INDEPENDENT NAIL CO.','HWY 86 & 21','BEAUFORT','SC','29902','BEAUFORT','','N','D',null,'http://www.epa.gov/superfund/sites/rodsites/0403262.htm','32.466389','-80.741111','Other','');
insert into ecs_sf_sites values('SCD003350493','INTERNATIONAL MINERALS AND CHEMICALS (IMC)','515 NORTH STREET EXT.','SPARTANBURG','SC','29302','SPARTANBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD982161465','J&H SMITH MANUFACTURING','114 WEST PEARL STREET','LAMAR','SC','29069','DARLINGTON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCSFN0406948','JACKSON ROAD AREA WELLS SITE','143 FULLER STREET','SPARTANBURG','SC','29306','SPARTANBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCSFN0406901','JOHN DEERE PLATING SHOP','306 SOUTH BUNCOMBE ROAD','GREER','SC','29651','GREENVILLE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980519383','JOHNSON BRONZE COMPANY','215 INDUSTRIAL PARK ROAD','SUMMERVILLE','SC','29483','DORCHESTER','1440','N','N',null,null,'','','Unknown','Non-Oil Spill');
insert into ecs_sf_sites values('SCD094995503','KALAMA SPECIALTY CHEMICALS','PO BOX 908','BEAUFORT','SC','29902','BEAUFORT','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403343.htm','32.4734','-80.7401','Other','');
insert into ecs_sf_sites values('SC0000554964','KELLETT PROPERTY','230 E. STANDING SPRINGS RD','SIMPSONVILLE','SC','29681','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD044939833','KING\'S LABORATORY, INC.','0.25 MI E OF I 77, N OF BLYTHEWOOD RD','BLYTHEWOOD','SC','29016','RICHLAND','1760','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980310239','KOPPERS CO., INC. (CHARLESTON PLANT)','CHARLESTON HEIGHTS','CHARLESTON','SC','29405','CHARLESTON','1440','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403350.htm','32.822083','-79.958333','Other','');
insert into ecs_sf_sites values('SCD003353026','KOPPERS CO., INC. (FLORENCE PLANT)','KOPPERS RD','FLORENCE','SC','29503','FLORENCE','2655','N','C',null,null,'34.2022','-79.7229','Other','');
insert into ecs_sf_sites values('SCD982119414','LANGLEY POND','S.C. 421 & CO. RD. 254','AIKEN','SC','29801','AIKEN','0600','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD982119422','LEAD MINE ROAD/WEATHERFORD SITE','COUNTY ROAD 285','GAFFNEY','SC','29340','CHEROKEE','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD991279324','LEONARD CHEMICAL CO., INC.','COURETON FERRY RD','ROCK HILL','SC','29704','YORK','6885','N','C',null,null,'34.851669','-80.904169','Other','');
insert into ecs_sf_sites values('SCD980558043','LEXINGTON COUNTY LANDFILL AREA','US 321 1 MILE S OF I-26','CAYCE','SC','29033','LEXINGTON','1760','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403362.htm','33.919581','-81.074169','Other','');
insert into ecs_sf_sites values('SCD987584653','LYMAN DYEING AND FINISHING','BEHIND WAMSUTTA DYEHOUSE','LYMAN','SC','29365','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCSFN0407078','LYMAN W ASTEWATER TREATMENT PLANT','WEST SITE OF GROCE ROAD','LYMAN','SC','29365','SPARTANBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD003360476','MACALLOY CORPORATION','1800 PITTSBURGH AVENUE','NORTH CHARLESTON','SC','29405','CHARLESTON','','N','C',null,null,'32.838056','-79.951194','','');
insert into ecs_sf_sites values('SCD003162914','MANETTA MILLS/LANDO DUMP SITE','HWY 901','LANDO','SC','29724','CHESTER','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0001098318','MARSHALL MOORE DRUM FACILITY','CORNERS OF SCHOOL AND RIVER ST S.MOREO','DUNCAN','SC','29334','SPARTANBURG','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980558142','MEDLEY FARM DRUM DUMP','SC HIGHWAY 18','GAFFNEY','SC','29340','CHEROKEE','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403371.htm','34.9805','-81.6685','Other','');
insert into ecs_sf_sites values('SC0001408707','MURDEN LAGOON/UTICA TOOLS','SECONDARY ROAD 1153 (HIGH STREET)','ORANGEBURG','SC','29115','ORANGEBURG','','N','N',null,null,'','','Private','');
insert into ecs_sf_sites values('SC0001406834','MURRELS INLET DRUM SITE','804 INLET SQUARE DRIVE','MURRELLS INLET','SC','295767810','HORRY','','N','N',null,null,'','','Private','');
insert into ecs_sf_sites values('SCD062640263','NATIONAL GALVANIZING INC','HWY 276 W','TRAVELERS REST','SC','29690','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987566411','NATIONAL REALTY SALES CORPORATION','VENEER AVENUE(NEXT TO BURKETTE PROPERTY)','CHARLESTON HEIGHTS','SC','29418','CHARLESTON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0170022560','NAVAL SHIPYARD - CHARLESTON','VIADUCT ROAD','CHARLESTON','SC','29405','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SC8170022620','NAVAL WEAPONS STATION - CHARLESTON','REDBANK ROAD','CHARLESTON','SC','29405','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SCD044940369','NUCOR STEEL','HWY 52 NORTH','DARLINGTON','SC','29532','DARLINGTON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD069314292','NYTRONICS COMPONENTS GROUP, INC','700 ORANGE STREET','DARLINGTON','SC','29532','DARLINGTON','','N','N',null,null,'','','Private','');
insert into ecs_sf_sites values('SCN000407186','ODUM BUFKIN','4145 NORTH GREEN SEA ROAD','GREEN SEA','SC','29545','HORRY','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD982119356','OLD MANNING SCHOOL PROPERTY','S.C. 57 & COUNTY ROAD 292','DILLON','SC','29536','DILLON','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD981474893','OLD SIMPSONVILLE DUMP #2','COUNTY RD. 542','SIMPSONVILLE','SC','29681','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD003349982','OWENS CORNING FIBERGLASS CORP','HWY 81 S','ANDERSON','SC','29622','ANDERSON','0405','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD980558274','OWENS-CORNING FIBERGLASS LDFL','HAYES RD','ANDERSON','SC','29622','ANDERSON','0405','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0002332799','PACIFIC GUANO','1505 KING STREET EXTENSION','CHARLESTON','SC','29405','CHARLESTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCSFN0406828','PALMETTO HARDWOOD CORP','P.O. BOX 441','MULLINS','SC','29574','MARION','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD037398120','PALMETTO RECYCLING, INC.','531 KOON STORE RD','COLUMBIA','SC','29203','RICHLAND','3160','N','D',null,'http://www.epa.gov/superfund/sites/rodsites/0403274.htm','34.1228','-81.0117','Other','');
insert into ecs_sf_sites values('SCD003362217','PALMETTO WOOD PRESERVING','DIXIANNA RD','DIXIANA','SC','29033','LEXINGTON','1760','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403259.htm','33.920831','-81.060281','Other','');
insert into ecs_sf_sites values('SCD002601656','PARA-CHEM SOUTHERN, INC.','HWY 145','SIMPSONVILLE','SC','29681','GREENVILLE','3160','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403224.htm','34.7134','-82.233','Other','');
insert into ecs_sf_sites values('SC6170022762','PARRIS ISLAND MARINE CORPS RECRUIT DEPOT','MARINE CORPS RECRUIT DEPOT','PARRIS ISLAND','SC','29902','BEAUFORT','','Y','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403488.htm','32.3528','-80.7031','Federally Owned','');
insert into ecs_sf_sites values('SC0000363689','PEARCE PROPERTY','SC 135 AND COUNTY 35','EASLEY','SC','29640','PICKENS','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCN000407332','PINEBROOK SUBDIVISION CHEMICAL SPILL','216 CHERRYSTONE DRIVE','COLUMBIA','SC','29201','RICHLAND','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0002329860','POINSETT HWY SITE','101 POINSETT HWY','GREENVILLE','SC','296095440','GREENVILLE','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980840284','POLYSAR INC','STATE HWYS 101 & 290 E','GREER','SC','29651','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0002406155','POWDER HOUSE ROAD PESTICIDE SHACK','POWDER HOUSE ROAD','AIKEN','SC','29801','AIKEN','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD086862950','R-M INDUSTRIES INC','BANKS STREET EXTN','FORT MILL','SC','29715','YORK','6885','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987598299','ROBERT THORNHILL PROPERTY','ROUTE 1, BOX 478','PROSPERITY','SC','29127','NEWBERRY','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD980840698','ROCHESTER PROPERTY','JCT LEDBETTER & WHITE HORSE ROAD','TRAVELERS REST','SC','29690','GREENVILLE','3160','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403415.htm','34.9719','-82.5015','Other','');
insert into ecs_sf_sites values('SCD980844005','ROCK HILL CHEMICAL CO.','NORTH CHERRY RD','ROCK HILL','SC','29730','YORK','1760','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403425.htm','34.9661','-80.9985','Other','');
insert into ecs_sf_sites values('SCD987588183','ROYAL PINES SUBDIVISION','US 1, FORE AVE.','COLUMBIA','SC','29223','RICHLAND','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0001097955','RUT ROAD SITE','RUT ROAD, GOOSE CREEK AREA','GOOSE CREEK','SC','29445','BERKELEY','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD082228347','SANDOZ INC/SANDOZ COLORS & CHEMS','HWY 102','MARTIN','SC','29836','ALLENDALE','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD003354412','SANGAMO WESTON, INC./TWELVE-MILE CREEK/LAKE HARTWE','SANGAMO RD','PICKENS','SC','29671','PICKENS','2560','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403252.htm','34.895','-82.7232','Other','');
insert into ecs_sf_sites values('SCD981029713','SARRATT PROPERTY','205 LEACH STREET','GREER','SC','29651','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD001863620','SAVANNAH RIVER PLANT/ADMINISTRATION BLDG','SC HWY 19, 15 MI S OF AIKEN','AIKEN','SC','29801','AIKEN','0600','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC1890008989','SAVANNAH RIVER SITE (USDOE)','BETWEEN SC 125 & US 278','AIKEN','SC','29802','AIKEN, BARNWELL, ALLENDAL','0600','Y','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403485.htm','33.348889','-81.737781','Federally Owned','');
insert into ecs_sf_sites values('SCD000622787','SCRDI BLUFF ROAD','321 BLUFF RD S','COLUMBIA','SC','29209','RICHLAND','1760','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403212.htm','33.885419','-80.90875','Other','');
insert into ecs_sf_sites values('SCD980711394','SCRDI DIXIANA','OFF SC HWY 321','CAYCE','SC','29033','LEXINGTON','1760','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403402.htm','33.90445','-81.063889','Other','');
insert into ecs_sf_sites values('SCD987598182','SHADY DEALS','10260 TWO NOTCH RD (US#1), BEHIND CHEERS','COLUMBIA','SC','29223','RICHLAND','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC7570024466','SHAW AIR FORCE BASE','363CSG/DE','SHAW AFB','SC','29152','SUMTER','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SCD003357589','SHURON INC.','100 CLINTON ST','BARNWELL','SC','29812','BARNWELL','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0405643.htm','33.236694','-81.375778','Private','Non-Oil Spill');
insert into ecs_sf_sites values('SCD981029770','SIMPSONVILLE (OLD) DUMP','S-453 (3 MI FROM INT. OF S-55)','SIMPSONVILLE','SC','29681','GREENVILLE','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD003352515','SOUTHERN AGRICULTURAL CHEMICAL PLANT','111 DENNIS STREET','KINGSTREE','SC','29556','WILLIAMSBURG','','N','N',null,null,'','','Private','Non-Oil Spill');
insert into ecs_sf_sites values('SC0001986801','SOUTHERN ASBESTOS','SALEM ROAD - U.S. HWY 15','BENNETTSVILLE','SC','29512','MARLBORO','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987581253','SOUTHERN SLAG AGGREGATE OF SC','1316 SAVANNAH HWY','SWANSEA','SC','29160','LEXINGTON','1760','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCN000407183','SPARTANBURG TRANSFORMERS','STATE ROUTE 292 AT INTERSECTION I-26','SPARTANBURG','SC','','SPARTANBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD981028707','SPRINGS MILLS (CHANEY BROTHERS)','HWY 76 & SC 41','MULLINS','SC','29574','MARION','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD000420141','STATEWIDE WASTE OIL & CHEMICAL CO','FARMOUNT RD','WELLFORD','SC','29385','SPARTANBURG','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987591815','STOLLER CHEMICAL CO. - CHARLESTON','U.S. HIGHWAY 17','CHARLESTON','SC','29407','CHARLESTON','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002316404','STONO PHOSPHATE WORKS','2079 AUSTIN AVENUE','CHARLESTON','SC','29405','CHARLESTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980801179','SULFOLK CHEMICAL CO','50 MI N OF US76 ON CO RD 82','CHAPIN','SC','29036','LEXINGTON','1760','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0001408970','SUMTER COUNTY LANDFILL','UNKNOWN','SUMTER','SC','29150','SUMTER','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD003164662','SUN CHEMICAL CORPORATION','1 SEQUA DRIVE','CHESTER','SC','29706','CHESTER','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD987595980','SUNNYSIDE DUMP','SUNNYSIDE DRIVE OFF HWY 290','GREER','SC','29651','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0001577048','SWEET GUM VALLEY ROAD SITE','GREENVILLE CTY (MIDNIGHT DUMP)','GREENVILLE','SC','29602','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD058181991','SWIFT AGRI-CHEM CORP','2750 SPEISSEGGER DRIVE','CHARLESTON','SC','29405','CHARLESTON','1440','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC8690390002','TEXACO FACILITY','CHARLESTON COUNTY','NORTH CHARLESTON','SC','294053113','CHARLESTON','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD000792671','TEXACO TERMINAL','OLD UNION RD','SPARTANBURG','SC','29304','SPARTANBURG','3160','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCN000407324','TIN PRODUCTS FIRE','','LEXINGTON','SC','','LEXINGTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCSFN0407133','TIN PRODUCTS RED BANK CREEK','1000 BONHOMME RICHARD ROAD','LEXINGTON','SC','','LEXINGTON','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD980558050','TOWNSEND SAW CHAIN CO.','STATE ROUTE 53 & I-20','PONTIAC','SC','29045','RICHLAND','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403363.htm','34.10625','-80.834169','Other','');
insert into ecs_sf_sites values('SC0000363275','TRAVELERS REST GRANITE QUARRY','ROCK QUARRY ROAD','TRAVELERS REST','SC','29690','GREENVILLE','3160','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002408367','TURKEY CREEK','HIGHWAY 501','SUMTER','SC','29150','SUMTER','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD987591948','US STEEL AGRICHEM/OLD BLUE CHEMICAL','CORNER OF SUMTER & 17TH STREETS','FAIRFAX','SC','29827','ALLENDALE','','N','N',null,null,'','','Unknown','Non-Oil Spill');
insert into ecs_sf_sites values('SC7210020189','USA CHARLESTON ARMY DEPOT','REMOUNT ROAD','NORTH CHARLESTON','SC','29406','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SC7570024821','USAF MYRTLE BEACH AFB','HWY 17','MYRTLE BEACH','SC','29577','HORRY','','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SC9570024332','USDOD DEF FUEL SUPPORT PT CHAS','N RHETT AVE','HANAHAN','SC','29406','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SCD987572674','USDOI CHARLESTON HARBOR SITE','CONCORD ST AT END OF CALHOUN ST','CHARLESTON','SC','29401','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','Non-Oil Spill');
insert into ecs_sf_sites values('SCD987566346','USPS N. CHARLESTON P.O.','RIVERS AVENUE, .7 MI. N OF AVIATION','NORTH CHARLESTON','SC','29405','CHARLESTON','1440','Y','N',null,null,'','','Federally Owned','');
insert into ecs_sf_sites values('SC0001824077','VEREEN\'S FERTILIZER','HIGHWAY 52 NORTH','KINGSTREE','SC','29556','WILLIAMSBURG','','N','N',null,null,'','','Private','');
insert into ecs_sf_sites values('SCSFN0406866','WALLACE ROAD DRUM','WALLACE ROAD','BENNETTSVILLE','SC','29512','MARLBORO','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD037405362','WAMCHEM, INC.','US HWY 21 N OF AIR BASE','BURTON','SC','29902','BEAUFORT','','N','C',null,'http://www.epa.gov/superfund/sites/rodsites/0403275.htm','32.497219','-80.741669','Other','');
insert into ecs_sf_sites values('SCD003512829','WARE SHOALS DYEING AND PRINTING','MAIN STREET','WARE SHOALS','SC','29692','GREENWOOD','','N','N',null,null,'','','Unknown','Non-Oil Spill');
insert into ecs_sf_sites values('SCD987566122','WATEREE CHEMICAL COMPANY-LUGOFF PLANT','1 MILE SW OF LUGOFF TO LEFT OF US 1','LUGOFF','SC','29078','KERSHAW','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002003564','WAYSIDE OIL /PANTRY PLUS','US HWY 501','AYNOR','SC','29511','HORRY','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SC0000487678','WESTGATE MOBILE HOME','105 OLD CHICK SPRING ROAD','GREER','SC','29650','GREENVILLE','','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SCD003358322','WESTVACO','VIRGINA AVENUE','NORTH CHARLESTON','SC','294060207','CHARLESTON','1440','N','N',null,null,'','','Unknown','');
insert into ecs_sf_sites values('SC0002408391','WHETSELL FARM SITE','ROUTE 2','BOWMAN','SC','29018','ORANGEBURG','','N','N',null,null,'','','','');
insert into ecs_sf_sites values('SCD981474786','WILLIAMSBURG CNTY.IND.LDFL #1','N. ON CO RD (SEE CM FORM)','KINGSTREE','SC','29566','HORRY','','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SCD073731721','WOODBURN ANALYTICAL LAB 7/FIELDING CHEM','NORTH BELHAVEN RD/SR 474','ANDERSON','SC','29621','ANDERSON','0405','N','N',null,null,'','','Other','');
insert into ecs_sf_sites values('SC0001409515','YORK COUNTY LANDFILL','SC HWY 5 EAST','YORK','SC','29745','YORK','6885','N','N',null,null,'','','Unknown','');