--------------------------------------------------------
--  File created - Wednesday-September-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table LU_ESTRY_PRIMARY
--------------------------------------------------------

  CREATE TABLE "STORETW"."LU_ESTRY_PRIMARY" 
   (	"PK_ISN" NUMBER(12,0), 
	"PRIMARY_ESTUARY" VARCHAR2(30 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 90 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETDATA_STORMODP" ;

   COMMENT ON COLUMN "STORETW"."LU_ESTRY_PRIMARY"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_ESTRY_PRIMARY.';
   COMMENT ON COLUMN "STORETW"."LU_ESTRY_PRIMARY"."PRIMARY_ESTUARY" IS 'primary estuary name';
   COMMENT ON TABLE "STORETW"."LU_ESTRY_PRIMARY"  IS 'Primary estuary lookup table';
REM INSERTING into STORETW.LU_ESTRY_PRIMARY
SET DEFINE OFF;
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (1,'Absecon Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (2,'Agana Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (3,'Agat Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (4,'Agua Hedionda');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (5,'Alazan Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (6,'Albemarle Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (7,'Albion River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (8,'Alsea Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (9,'Altamaha River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (10,'Anclote River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (11,'Andrews Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (12,'Apalachee Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (13,'Apalachicola Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (14,'Aransas Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (15,'Arthur Kill');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (16,'Assawoman Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (17,'Atchafalaya Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (18,'Back Bay of Bilox');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (19,'Baffins Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (20,'Bahia Algodones');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (21,'Bahia Montalva');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (22,'Bahia Salinas');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (23,'Bahia Sucia');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (24,'Bahia de Boqueron');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (25,'Bahia de Guanica');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (26,'Bahia de Guayanilla');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (27,'Bahia de Jobos');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (28,'Bahia de Mayaguez');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (29,'Bahia de Rincon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (30,'Bahia de San Juan');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (31,'Bahia de Tallaboa');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (32,'Banana River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (33,'Barataria Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (34,'Barnegat Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (35,'Barnes Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (36,'Batiquitos Lagoon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (37,'Bear River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (38,'Benner Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (39,'Big Lagoon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (40,'Big Lake');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (41,'Biscayne Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (42,'Blackwater Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (43,'Blue Hill Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (44,'Bodega Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (45,'Bogue Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (46,'Bolinas Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (47,'Bon Secour Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (48,'Brazos River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (49,'Breton Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (50,'Bulls Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (51,'Burtons Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (52,'Buzzards Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (53,'Calcasieu Lake');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (54,'Caloosahatchee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (55,'Caminada Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (56,'Cape Cod Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (57,'Cape Fear River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (58,'Carmans River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (59,'Carmel Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (60,'Casco Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (61,'Casper Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (62,'Channel Islands Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (63,'Charleston Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (64,'Charlotte Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (65,'Chassahowitzka Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (66,'Chesapeake Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (67,'Chincoteague Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (68,'Choctawhatchee Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (69,'Cinnamon Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (70,'Cobscook Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (71,'Columbia River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (72,'Conner Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (73,'Cook Inlet');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (74,'Coos Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (75,'Copano Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (76,'Core Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (77,'Corpus Christi Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (78,'Croatan Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (79,'Crystal Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (80,'Cumberland Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (81,'Currituck Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (82,'Dana Point Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (83,'Deadman Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (84,'Delaware Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (85,'Delaware River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (86,'Drakes Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (87,'East Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (88,'East River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (89,'Eel River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (90,'Elk Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (91,'Ensenada Honda');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (92,'Ensenada de Boca Vieja');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (93,'Espiritu Santo Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (94,'Everglades');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (95,'Fenholloway River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (96,'Florida Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (97,'Fonte River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (98,'Galveston Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (99,'Garcia River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (100,'Gardiners Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (101,'Grand Lake');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (102,'Grays Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (103,'Great Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (104,'Great Egg Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (105,'Great South Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (106,'Gulf of Mexico');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (107,'Hanalei Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (108,'Hare Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (109,'Hillsboro River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (110,'Hilo Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (111,'Hog Island Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (112,'Homosassa Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (113,'Horseshoe Cove');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (114,'Hudson River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (115,'Humboldt Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (116,'Inarajan Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (117,'Indian River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (118,'Indian River Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (119,'Intracoastal Waterway');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (120,'Isle of Wight Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (121,'Jamaica Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (122,'James River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (123,'Kahana Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (124,'Kahului Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (125,'Kalalock Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (126,'Kaneohe Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (127,'Kawaihae Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (128,'Kealakekua Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (129,'Keehi Lagoon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (130,'Klamath River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (131,'Laguna Madre');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (132,'Laguna San Jose');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (133,'Laguna de Alvarado');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (134,'Laguna de Tamiahua');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (135,'Lake Borgne');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (136,'Lake Felicity');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (137,'Lake Pontchartrain');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (138,'Lavaca Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (139,'Little Neck Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (140,'Little River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (141,'Long Island Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (142,'Lynn Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (143,'Mad River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (144,'Manasquan River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (145,'Manele Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (146,'Manhasset Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (147,'Matagorda Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (148,'Matanzas River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (149,'Mendocino Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (150,'Mission Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (151,'Mississippi Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (152,'Mobile Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (153,'Monterey Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (154,'Moriches Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (155,'Morro Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (156,'Mosquito Lagoon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (157,'Mukkaw Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (158,'Muscongus Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (159,'Narragansett Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (160,'Nassau River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (161,'Nawiliwili Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (162,'Nehalem Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (163,'Nestucca Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (164,'Netarts Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (165,'New River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (166,'Newark Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (167,'Newport Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (168,'North Santee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (169,'Noyo Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (170,'Nueces Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (171,'Ochlockonee Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (172,'Ossabaw Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (173,'Other Estuary');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (174,'Ozette River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (175,'Pago Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (176,'Pamlico Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (177,'Patuxent River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (178,'Pearl Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (179,'Pearl River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (180,'Pee Dee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (181,'Penobscot Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (182,'Pensacola Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (183,'Perdido Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (184,'Pine Island Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (185,'Piscataqua River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (186,'Pithlachascotee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (187,'Point Mugu Lagoon');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (188,'Ponce de Leon Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (189,'Poponesset Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (190,'Port Royal Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (191,'Potomac River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (192,'Prince William Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (193,'Puerto Medio Mundo');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (194,'Puerto Patillas');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (195,'Puerto Yabucoa');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (196,'Puget Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (197,'Quinault River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (198,'Quonochontaug Pond');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (199,'Raft River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (200,'Rappahannock River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (201,'Raritan Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (202,'Redwood River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (203,'Resurrection Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (204,'Rio Grande');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (205,'Roanoke Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (206,'Rock Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (207,'Rogue River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (208,'Russian River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (209,'Sabine Lake');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (210,'Saco Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (211,'Salmon River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (212,'Salt Pond');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (213,'San Antonio Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (214,'San Diego Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (215,'San Diego River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (216,'San Francisco Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (217,'San Luis Obispo Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (218,'San Pedro Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (219,'Sandy Hook Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (220,'Santa Barbara Harbor');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (221,'Santa Clara River (SoCal)');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (222,'Santa Margarita River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (223,'Santa Monica Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (224,'Santa Ynez River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (225,'Sarasota Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (226,'Satilla River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (227,'Savannah River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (228,'Siletz Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (229,'Sinepuxent Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (230,'Siuslaw River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (231,'Smith River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (232,'South Santee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (233,'St. Andrew Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (234,'St. Andrews Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (235,'St. George Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (236,'St. Helena Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (237,'St. Johns River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (238,'St. Joseph Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (239,'St. Louis Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (240,'St. Marys River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (241,'Strait of Juan de Fuca');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (242,'Suwannee River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (243,'Suwannee Sound');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (244,'Talofofo Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (245,'Tampa Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (246,'Tijuana River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (247,'Tillamook Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (248,'Timbalier Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (249,'Togcha Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (250,'Toguan Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (251,'Tolomato River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (252,'Tomales Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (253,'Umpqua River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (254,'Ventura River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (255,'Vermilion Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (256,'Waccasassa Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (257,'West Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (258,'West Cote Blanche Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (259,'Whitewater Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (260,'Willapa Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (261,'Wilson Creek');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (262,'Yachats River');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (263,'Yakutat Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (264,'Yaquina Bay');
Insert into STORETW.LU_ESTRY_PRIMARY (PK_ISN,PRIMARY_ESTUARY) values (265,'York River');
--------------------------------------------------------
--  DDL for Index PK_ESTRY_PRIMARY
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_ESTRY_PRIMARY" ON "STORETW"."LU_ESTRY_PRIMARY" ("PK_ISN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  DDL for Index IESTRY_PRIMARY01
--------------------------------------------------------

  CREATE INDEX "STORETW"."IESTRY_PRIMARY01" ON "STORETW"."LU_ESTRY_PRIMARY" ("PRIMARY_ESTUARY") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table LU_ESTRY_PRIMARY
--------------------------------------------------------

  ALTER TABLE "STORETW"."LU_ESTRY_PRIMARY" ADD CONSTRAINT "PK_ESTRY_PRIMARY" PRIMARY KEY ("PK_ISN")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP"  ENABLE;
