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

  CREATE TABLE "STORETW"."MD_COOP_ADDRESS" 
   (	"PK_ISN" NUMBER(12,0), 
	"COOP_ADDR_IS_NUMBER" NUMBER(12,0), 
	"ORGANIZATION_ID" VARCHAR2(256 BYTE), 
	"COOP_ADDR_TYPE" VARCHAR2(256 CHAR), 
	"ADDRESS_ONE_TEXT" VARCHAR2(256 CHAR), 
	"ADDRESS_TWO_TEXT" VARCHAR2(256 CHAR), 
	"ADDRESS_THREE_TEXT" VARCHAR2(256 CHAR), 
	"ADDRESS_FOUR_TEXT" VARCHAR2(256 CHAR), 
	"COUNTRY_CODE" VARCHAR2(256 CHAR), 
	"START_DATE" DATE, 
	"COOP_ORG_IS_NUMBER" NUMBER(12,0), 
	"FK_COOP" NUMBER(12,0), 
	"SOURCE_SYSTEM" VARCHAR2(256 CHAR), 
	"SOURCE_UID" NUMBER(20,0)
   ) 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"."MD_COOP_ADDRESS"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_COOP_ADDRESS.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."COOP_ADDR_IS_NUMBER" IS 'Cooperating organization address internal serial number';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."ORGANIZATION_ID" IS 'The user-defined code that uniquely identifies an Organization.  Organization IDs are registered centrally with STORET so that they are guaranteed to be unique on the National level.  They become part of the Oracle Key on every row in the STORET database that belongs to the Organization.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."COOP_ADDR_TYPE" IS 'cooperating address type';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."ADDRESS_ONE_TEXT" IS 'The first line of an Address which usually denotes the company or individual name.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."ADDRESS_TWO_TEXT" IS 'The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also contain company name in addition.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."ADDRESS_THREE_TEXT" IS 'The third line of an Address usually denotes the street address including street name and type, house/office number, or sector designation.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."ADDRESS_FOUR_TEXT" IS 'Cooperating address text line 4';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."COUNTRY_CODE" IS 'The 2-character Federal Information Processing Standard (FIPS) code (ref FIPS Pub 10-3) representing the Country.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."START_DATE" IS 'The date (in format MM-DD-YYYY) on which a Project or Survey is scheduled to begin.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."COOP_ORG_IS_NUMBER" IS 'cooperating org internal serial number';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."FK_COOP" IS 'Foreign Key referencing DI_COOP.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."SOURCE_SYSTEM" IS 'Metadata source system acronym';
   COMMENT ON COLUMN "STORETW"."MD_COOP_ADDRESS"."SOURCE_UID" IS 'Metadata source record unique identifier';
   COMMENT ON TABLE "STORETW"."MD_COOP_ADDRESS"  IS 'Cooperating Organization address metadata table';
REM INSERTING into STORETW.MD_COOP_ADDRESS
SET DEFINE OFF;
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (1,2,'AWC_WQ','Mailing   ','300 North Water Works Drive','Belleville, IL 62223-9040',null,null,'US',null,1,7,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (5,10,'1111REG1','Mailing   ','NEIWPCC','Boott Mills South','100 Foot of John Street., 1st Floor','Lowell, MA 01852-1124','US',to_date('04-APR-02','DD-MON-RR'),2,31,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (6,2,'21FLTBW','Located at','5300 West Cypress Suite 200','Tampa, FL 33607',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),1,62,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (7,6,'21FLNWFD','Located at','81 Water Management Drive','U.S. Highway 90, 10 miles west of  Tall.','Havana, Florida 32333',' ','US',to_date('01-JAN-01','DD-MON-RR'),1,68,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (8,4,'21FLNWFD','Located at','2400 Blairestone Road','Tallahassee, Florida 32301',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),2,69,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (9,5,'21FLNWFD','Located at','2400 Blairstone Road','Tallahassee, Florida 32301',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),4,71,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (10,7,'LAKELAND','Mailing   ','620 Broad Street,Suite 100','St. Jeseph, MI 49085','616-983-3654',' ','US',to_date('01-JAN-01','DD-MON-RR'),6,79,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (13,3,'MNPCA1','Located at','500 Lafayette Rd N','St. Paul, MN 55155',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),2,199,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (14,6,'MNPCA1','Located at','230 East 5th Street','St. Paul, MN 55101-1626',' ',' ','US',to_date('10-OCT-02','DD-MON-RR'),3,200,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (15,2,'1117MBR','Located at','Geological Survey Bureau','109 Trowbridge Hall','Iowa City, IA 52242-1319',' ','US',to_date('28-JUN-00','DD-MON-RR'),1,226,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (16,4,'1117MBR','Located at','205 Jefferson St.','Jefferson City, MO 65102',' ',' ','US',to_date('28-JUN-00','DD-MON-RR'),2,227,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (17,3,'1117MBR','Mailing   ','P.O. Box 176','Jefferson City, MO 65102',' ',' ','US',to_date('28-JUN-00','DD-MON-RR'),2,227,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (18,5,'1117MBR','Mailing   ','P.O. Box 98922','Lincoln, NE 68509-8922',' ',' ','US',to_date('28-JUN-00','DD-MON-RR'),3,228,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (19,6,'1117MBR','Located at','Forbes Field (Bldg #740)','Topeka, KS 66620',' ',' ','US',to_date('28-JUN-00','DD-MON-RR'),4,229,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (20,9,'1117MBR','Located at','Fisheries Research Section','Fish & Wildlife Research Center','1110 S. College Ave.','Columbia, MO 65201','US',to_date('01-JAN-01','DD-MON-RR'),5,234,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (21,8,'1117MBR','Located at','Foley Hall, 2041','Constant Ave.','Lawrence, KS  66047',' ','US',to_date('07-DEC-00','DD-MON-RR'),6,235,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (22,2,'MEDEP','Mailing   ','Maine Volunteer Lake Monitoring Program',' ',' ','Turner, ME','US',to_date('01-JAN-01','DD-MON-RR'),1,259,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (24,3,'MRSENVMB','Located at','4350 Transport St., Unit 107','Ventura CA 93003',' ',' ','US',to_date('13-APR-05','DD-MON-RR'),1,330,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (25,2,'QUAPAWTR','Mailing   ','PO Box 765, Quapaw, OK  74363',null,null,null,'US',null,1,331,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (26,7,'21NEB001','Located at','Kansas State University',' ',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),4,335,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (27,4,'MRSENVMB','Located at','4100 Atlas Court','Bakersfield, CA 93308-4150',' ',' ','US',to_date('13-APR-05','DD-MON-RR'),2,337,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (28,5,'MRSENVMB','Located at','5070 Robert J. Mathews Parkway','El Daodo Hills, CA 95762',' ',' ','US',to_date('13-APR-05','DD-MON-RR'),3,338,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (29,7,'MRSENVMB','Mailing   ','City of Morro Bay','Wastewater Treatment Plant','955 Shasta Avenue','Morro Bay , CA 93442','US',to_date('13-APR-05','DD-MON-RR'),4,339,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (30,6,'MRSENVMB','Located at','160 Atascadero Road','Morro Bay, CA 934442',' ',' ','US',to_date('13-APR-05','DD-MON-RR'),4,339,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (31,59,'21NJDEP1','Mailing   ','327 East Ridgewood Avenue','Paramus, NJ 07652-4895',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),2,340,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (32,55,'21NJDEP1','Located at','810 Bear Tavern Road, Suite 206','West Trenton, NJ 08628',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),1,341,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (33,54,'21NJDEP1','Mailing   ','New Jersey District Chief','810 Bear Tavern Road, Suite 206','West Trenton, NJ 08628',' ','US',to_date('01-JAN-01','DD-MON-RR'),1,341,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (34,57,'21NJDEP1','Located at','9 Ewing Street, Floor 2','Trenton, NJ 08625-0424',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),6,345,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (35,56,'21NJDEP1','Mailing   ','PO Box 424','9 Ewing Street, Floor 2','Trenton, NJ 08625-0424',' ','US',to_date('01-JAN-01','DD-MON-RR'),6,345,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (36,8,'SRMTAKNY','Located at','2190 Technology Drive','Schenectady, NY','12308',' ','US',to_date('01-JAN-01','DD-MON-RR'),1,347,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (37,7,'SRMTAKNY','Located at','P.O. Box 704','131 St. Lawrence Avenue','Waddington, NY','13694','US',to_date('01-JAN-01','DD-MON-RR'),2,348,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (38,9,'SRMTAKNY','Located at','P.O. Box 40','5611 Water Street','Middlesex, NY','14507','US',to_date('01-JAN-01','DD-MON-RR'),4,350,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (39,2,'AWC','Mailing   ','300 North Water Works Drive','Belleville, IL 62223-9040',null,null,'US',null,1,353,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (40,58,'21NJDEP1','Mailing   ','201 South Shore Road','Northfield, NJ 08225',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),9,358,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (41,60,'21NJDEP1','Mailing   ','Raphael Meadow Health Center','15 Pioneer Blvd','PO Box 6000','Westhampton, NJ 08060','US',to_date('01-JAN-01','DD-MON-RR'),10,359,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (42,61,'21NJDEP1','Mailing   ','Jefferson House, Lakeland Road','PO Box 9, 3rd Floor','Blackwood, NJ 08012-0009',' ','US',to_date('01-JAN-01','DD-MON-RR'),11,360,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (43,62,'21NJDEP1','Mailing   ','4 Moore Road','Cape May Court House, NJ 08210-1601',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),12,361,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (44,63,'21NJDEP1','Mailing   ','790 East Commerce Street','Bridgeton, NJ 08302',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),13,362,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (45,64,'21NJDEP1','Mailing   ','160 Fries Mill Road','Turnersville, NJ 08012',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),14,363,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (46,65,'21NJDEP1','Mailing   ','Administration Building','71 Main Street','Flemington, NJ 08822',' ','US',to_date('01-JAN-01','DD-MON-RR'),15,364,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (47,66,'21NJDEP1','Mailing   ','116 Paronage Drive','Edison, New Jersey 08837',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),16,365,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (48,67,'21NJDEP1','Mailing   ','3435 Highway 9','Freehold, NJ 07728-1255',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),17,366,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (49,68,'21NJDEP1','Mailing   ','311 Pennsylvania Avenue','Room 201','Paterson, NJ 07503',' ','US',to_date('01-JAN-01','DD-MON-RR'),18,367,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (50,69,'21NJDEP1','Mailing   ','98 Market Street','Salem, NJ 08079-1995',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),19,368,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (51,70,'21NJDEP1','Mailing   ','1 Cochran Plaza','Newton, NJ 07860',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),20,369,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (52,71,'21NJDEP1','Mailing   ','300 North Avenue-East','Westfield, NJ 07090',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),21,370,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (53,72,'21NJDEP1','Mailing   ','319 West Washington Avene, Suite 1','Washington, NJ 07882',' ',' ','US',to_date('01-JAN-01','DD-MON-RR'),22,371,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (54,16,'11NPSWRD','Located at','U.S. Geological Survey Headquarters','John W. Powell Federal Building','12201 Sunrise Valley Drive','Reston, Virginia 20192','US',to_date('01-JAN-01','DD-MON-RR'),1,394,null,null);
Insert into STORETW.MD_COOP_ADDRESS (PK_ISN,COOP_ADDR_IS_NUMBER,ORGANIZATION_ID,COOP_ADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,ADDRESS_THREE_TEXT,ADDRESS_FOUR_TEXT,COUNTRY_CODE,START_DATE,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (55,105,'11NPSWRD','Located at','Department of Environmental Sciences','University of Virginia - Clark Hall','P.O. Box 4000123','Charlottesville, VA 2290','US',to_date('01-JAN-01','DD-MON-RR'),3,396,null,null);
--------------------------------------------------------
--  DDL for Index IACOOP
--------------------------------------------------------

  CREATE INDEX "STORETW"."IACOOP" ON "STORETW"."MD_COOP_ADDRESS" ("FK_COOP") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 589824 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 PK_CO_OP_ADDR
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_CO_OP_ADDR" ON "STORETW"."MD_COOP_ADDRESS" ("PK_ISN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 327680 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 IACOORGID
--------------------------------------------------------

  CREATE INDEX "STORETW"."IACOORGID" ON "STORETW"."MD_COOP_ADDRESS" ("ORGANIZATION_ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 589824 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 MD_COOP_ADDRESS
--------------------------------------------------------

  ALTER TABLE "STORETW"."MD_COOP_ADDRESS" ADD CONSTRAINT "PK_CO_OP_ADDR" PRIMARY KEY ("PK_ISN")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 327680 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;
  ALTER TABLE "STORETW"."MD_COOP_ADDRESS" MODIFY ("COOP_ADDR_TYPE" NOT NULL ENABLE);
  ALTER TABLE "STORETW"."MD_COOP_ADDRESS" MODIFY ("ORGANIZATION_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table MD_COOP_ADDRESS
--------------------------------------------------------

  ALTER TABLE "STORETW"."MD_COOP_ADDRESS" ADD CONSTRAINT "FK_MD_ACOOP" FOREIGN KEY ("FK_COOP")
	  REFERENCES "STORETW"."MD_COOP" ("PK_ISN") ENABLE;
