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

  CREATE TABLE "STORETW"."MT_ATTRIBUTE_MAP" 
   (	"PK_ISN" NUMBER, 
	"MAPPING_FIELD" VARCHAR2(256 CHAR), 
	"STORET_NAME" VARCHAR2(256 CHAR), 
	"STORET_NAME2" VARCHAR2(256 CHAR), 
	"WQX_NAME" VARCHAR2(256 CHAR), 
	"WQX_NAME2" VARCHAR2(256 CHAR), 
	"SORT_ORDER" NUMBER, 
	"STATUS" CHAR(1 CHAR), 
	"ATTR_1" VARCHAR2(256 CHAR), 
	"ATTR_2" VARCHAR2(256 CHAR), 
	"ATTR_3" VARCHAR2(256 CHAR), 
	"ATTR_DESCRIPTION" VARCHAR2(1000 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"."MT_ATTRIBUTE_MAP"."PK_ISN" IS 'Primary Key. Generated using sequence object';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."MAPPING_FIELD" IS 'Mapping Field';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."STORET_NAME" IS 'Storet Name';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."STORET_NAME2" IS 'Secondary STORET Name ';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."WQX_NAME" IS 'WQX Name';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."WQX_NAME2" IS 'Secondary WQX Name';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."SORT_ORDER" IS 'Sort Order';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."STATUS" IS 'Status';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."ATTR_1" IS 'Attribute One';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."ATTR_2" IS 'Attribute Two';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."ATTR_3" IS 'Attribute Three';
   COMMENT ON COLUMN "STORETW"."MT_ATTRIBUTE_MAP"."ATTR_DESCRIPTION" IS 'Attribute Description';
REM INSERTING into STORETW.MT_ATTRIBUTE_MAP
SET DEFINE OFF;
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (1,'STATION_TYPES','River/Stream','None','River/Stream',null,1,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (2,'STATION_TYPES','Lake','None','Lake',null,2,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (3,'STATION_TYPES','Great Lake','None','Great Lake',null,3,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (4,'STATION_TYPES','Ocean','None','Ocean',null,7,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (5,'STATION_TYPES','Estuary','None','Estuary',null,8,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (6,'STATION_TYPES','Well','None','Well',null,4,'Y','G',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (7,'STATION_TYPES','Spring','None','Spring',null,11,'Y','G',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (8,'STATION_TYPES','Cave','None','Cave',null,12,'Y','G',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (9,'STATION_TYPES','Land','None','Land',null,17,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (57,'STATION_TYPES','BEACH Program Site','Channelized stream','BEACH Program Site-Channelized stream',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (58,'STATION_TYPES','BEACH Program Site','Estuary','BEACH Program Site-Estuary',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (59,'STATION_TYPES','BEACH Program Site','Great Lake','BEACH Program Site-Great Lake',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (60,'STATION_TYPES','BEACH Program Site','Lake','BEACH Program Site-Lake',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (61,'STATION_TYPES','BEACH Program Site','Land runoff','BEACH Program Site-Land runoff',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (62,'STATION_TYPES','BEACH Program Site','Land','BEACH Program Site-Land',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (63,'STATION_TYPES','BEACH Program Site','Ocean','BEACH Program Site-Ocean',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (64,'STATION_TYPES','BEACH Program Site','River/Stream','BEACH Program Site-River/Stream',null,28,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (10,'STATION_TYPES','Wetland','Estuarine, emergent','Wetland Estuarine-Emergent',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (11,'STATION_TYPES','Wetland','Estuarine, scrub-shrub','Wetland Estuarine-Scrub-Shrub',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (12,'STATION_TYPES','Wetland','Estuarine, forested','Wetland Estuarine-Forested',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (13,'STATION_TYPES','Wetland','Riverine, emergent','Wetland Riverine-Emergent',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (14,'STATION_TYPES','Wetland','Lacustrine, emergent','Wetland Lacustrine-Emergent',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (15,'STATION_TYPES','Wetland','Palustrine, moss-lichen','Wetland Palustrine-Moss-Lichen',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (16,'STATION_TYPES','Wetland','Palustrine, emergent','Wetland Palustrine-Emergent',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (17,'STATION_TYPES','Wetland','Palustrine, shrub-scrub','Wetland Palustrine-Shrub-Scrub',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (18,'STATION_TYPES','Wetland','Palustrine, forested','Wetland Palustrine-Forested',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (19,'STATION_TYPES','Canal','Irrigation','Canal Irrigation',null,10,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (20,'STATION_TYPES','Canal','Drainage','Canal Drainage',null,10,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (21,'STATION_TYPES','Canal','Transport','Canal Transport',null,10,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (22,'STATION_TYPES','Facility','Industrial','Facility Industrial',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (23,'STATION_TYPES','Facility','Municipal Sewage (POTW)','Facility Municipal Sewage (POTW)',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (24,'STATION_TYPES','Facility','Municipal Water Supply (PWS)','Facility Public Water Supply (PWS)',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (25,'STATION_TYPES','Facility','Privately Owned non-industrial','Facility Privately Owned Non-industrial',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (26,'STATION_TYPES','Facility','Other/combined','Facility Other',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (27,'STATION_TYPES','Constructed Wetland','None','Constructed Wetland',null,14,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (28,'STATION_TYPES','Mine/mine discharge','None','Mine/Mine Discharge',null,24,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (29,'STATION_TYPES','Channelized stream','None','Channelized Stream',null,9,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (30,'STATION_TYPES','Storm sewer','None','Storm Sewer',null,21,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (31,'STATION_TYPES','Waste sewer','None','Waste Sewer',null,22,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (32,'STATION_TYPES','Combined sewer','None','Combined Sewer',null,23,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (33,'STATION_TYPES','Reservoir','None','Reservoir',null,15,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (34,'STATION_TYPES','Riverine impoundment','None','Riverine Impoundment',null,16,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (35,'STATION_TYPES','Landfill','None','Landfill',null,19,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (36,'STATION_TYPES','Gallery','None','Gallery',null,25,'Y','G',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (37,'STATION_TYPES','Waste pit','None','Waste Pit',null,20,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (38,'STATION_TYPES','Land runoff','None','Land Runoff',null,18,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (39,'STATION_TYPES','CERCLA Superfnd Site','None','CERCLA Superfund Site',null,6,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (40,'STATION_TYPES','Wetland','Undifferentiated','Wetland Undifferentiated',null,13,'Y','S',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (41,'STATION_TYPES','Mine/mine discharge','Adit (mine entrance)','Mine/Mine Discharge Adit (Mine Entrance)',null,24,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (42,'STATION_TYPES','Mine/mine discharge','Tailings Pile','Mine/Mine Discharge Tailings Pile',null,24,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (43,'STATION_TYPES','Mine/mine discharge','Waste Rock Pile','Mine/Mine Discharge Waste Rock Pile',null,24,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (44,'STATION_TYPES','CERCLA Superfnd Site','Survey Monument','CERCLA Superfund Site Survey Monument',null,6,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (45,'STATION_TYPES','CERCLA Superfnd Site','Spigot / Faucet','CERCLA Superfund Site Spigot / Faucet',null,6,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (46,'STATION_TYPES','CERCLA Superfnd Site','Borehole','CERCLA Superfund Site Borehole',null,6,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (47,'STATION_TYPES','CERCLA Superfnd Site','Test Pit','CERCLA Superfund Site Test Pit',null,6,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (48,'STATION_TYPES','Land','Flood Plain','Land Flood Plain',null,17,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (49,'STATION_TYPES','Floodwater','None','Floodwater',null,null,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (50,'STATION_TYPES','Floodwater','Urban','Floodwater Urban',null,null,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (51,'STATION_TYPES','Floodwater','Non Urban','Floodwater Non Urban',null,null,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (52,'STATION_TYPES','Floodwater','Debris','Floodwater Debris',null,null,'Y',null,null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (53,'STATION_TYPES','Facility','Community PWS','Facility Community PWS',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (54,'STATION_TYPES','Facility','Non-transient PWS','Facility Non-transient PWS',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (55,'STATION_TYPES','Facility','Transient PWS','Facility Transient PWS',null,5,'Y','O',null,null,'Attr_1 is SGO/Indicator');
Insert into STORETW.MT_ATTRIBUTE_MAP (PK_ISN,MAPPING_FIELD,STORET_NAME,STORET_NAME2,WQX_NAME,WQX_NAME2,SORT_ORDER,STATUS,ATTR_1,ATTR_2,ATTR_3,ATTR_DESCRIPTION) values (56,'STATION_TYPES','Land','Glacier','Land Glacier',null,17,'Y','O',null,null,'Attr_1 is SGO/Indicator');
--------------------------------------------------------
--  DDL for Index I_MT_ATTR_02
--------------------------------------------------------

  CREATE INDEX "STORETW"."I_MT_ATTR_02" ON "STORETW"."MT_ATTRIBUTE_MAP" ("MAPPING_FIELD", "STORET_NAME", "STORET_NAME2") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 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 "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  DDL for Index PK_MT_ATTR_MAP
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_MT_ATTR_MAP" ON "STORETW"."MT_ATTRIBUTE_MAP" ("PK_ISN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 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 "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table MT_ATTRIBUTE_MAP
--------------------------------------------------------

  ALTER TABLE "STORETW"."MT_ATTRIBUTE_MAP" ADD CONSTRAINT "PK_MT_ATTR_MAP" PRIMARY KEY ("PK_ISN")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 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 "STORETINDX_STORMODP"  ENABLE;
