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

  CREATE TABLE "STORETW"."DI_STATN_TYPES" 
   (	"PK_ISN" NUMBER(12,0), 
	"PRIMARY_TYPE" VARCHAR2(256 BYTE), 
	"SECONDARY_TYPE" VARCHAR2(256 BYTE), 
	"SORT_ORDER" NUMBER, 
	"SGO_INDICATOR" CHAR(1 CHAR), 
	"STATION_GROUP_TYPE" VARCHAR2(256 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"."DI_STATN_TYPES"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_STATN_TYPES.';
   COMMENT ON COLUMN "STORETW"."DI_STATN_TYPES"."PRIMARY_TYPE" IS 'The code that represents the primary type designation of a Station.';
   COMMENT ON COLUMN "STORETW"."DI_STATN_TYPES"."SECONDARY_TYPE" IS 'The code that represents the secondary type designation of a Station.  Not every combination requires a Secondary Type.';
   COMMENT ON COLUMN "STORETW"."DI_STATN_TYPES"."SORT_ORDER" IS 'Sort order for station type selection box on web pages';
   COMMENT ON COLUMN "STORETW"."DI_STATN_TYPES"."SGO_INDICATOR" IS 'Surface, Ground, Other indicator. Each of the primary station types were mapped to one of these three values.';
   COMMENT ON COLUMN "STORETW"."DI_STATN_TYPES"."STATION_GROUP_TYPE" IS 'Station Group Type';
   COMMENT ON TABLE "STORETW"."DI_STATN_TYPES"  IS 'Station types dimension table';
REM INSERTING into STORETW.DI_STATN_TYPES
SET DEFINE OFF;
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (1,'BEACH Program Site-Estuary',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2,'BEACH Program Site-Great Lake',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (3,'BEACH Program Site-Lake',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (4,'BEACH Program Site-Ocean',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (5,'BEACH Program Site-River/Stream',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (6,'CERCLA Superfund Site',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (7,'Borehole',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (8,'Spigot / Faucet',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (9,'Survey Monument',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (10,'Test Pit',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (11,'Canal Drainage',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (12,'Canal Irrigation',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (13,'Canal Transport',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (14,'Cave',null,9,'G','Subsurface');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (15,'Channelized Stream',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (16,'Combined Sewer',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (17,'Constructed Wetland',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (18,'Estuary',null,5,'S','Estuary');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (19,'Facility Industrial',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (20,'Facility Municipal Sewage (POTW)',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (21,'Facility Other',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (22,'Facility Privately Owned Non-industrial',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (23,'Facility Public Water Supply (PWS)',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (24,'Floodwater',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (25,'Floodwater Urban',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (26,'Gallery',null,50,'G','Well');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (27,'Great Lake',null,3,'S','Lake, Reservoir, Impoundment');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (28,'Lake',null,2,'S','Lake, Reservoir, Impoundment');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (29,'Land',null,40,'O','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (30,'Land Flood Plain',null,40,'O','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (31,'Land Runoff',null,40,'O','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (32,'Landfill',null,40,'O','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (33,'Mine/Mine Discharge',null,9,'O','Subsurface');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (34,'Mine/Mine Discharge Adit (Mine Entrance)',null,9,'O','Subsurface');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (35,'Mine/Mine Discharge Tailings Pile',null,9,'O','Subsurface');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (36,'Mine/Mine Discharge Waste Rock Pile',null,9,'O','Subsurface');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (37,'Ocean',null,6,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (38,'Reservoir',null,3,'S','Lake, Reservoir, Impoundment');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (39,'River/Stream',null,1,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (40,'Riverine Impoundment',null,3,'S','Lake, Reservoir, Impoundment');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (41,'Spring',null,7,'G','Spring');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (42,'Storm Sewer',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (43,'Waste Pit',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (44,'Waste Sewer',null,8,'O','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (45,'Well',null,4,'G','Well');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (46,'Wetland Estuarine-Emergent',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (47,'Wetland Estuarine-Forested',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (48,'Wetland Lacustrine-Emergent',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (49,'Wetland Palustrine-Emergent',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (50,'Wetland Palustrine-Forested',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (51,'Wetland Palustrine-Moss-Lichen',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (52,'Wetland Palustrine-Shrub-Scrub',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (53,'Wetland Riverine-Emergent',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (54,'Wetland Undifferentiated',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (91,'Pipe, Unspecified Source',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (92,'Seep',null,7,'G','Spring');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (93,'Playa',null,40,'S','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (94,'River/Stream Intermittent',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (95,'River/Stream Perennial',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (96,'National Air Monitoring Station',null,60,'O','Atmosphere');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (97,'State/Local Air Monitoring Station',null,60,'O','Atmosphere');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (98,'Wetland Estuarine-Scrub-Shrub',null,20,'S','Wetland');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (99,'Other-Surface Water',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (100,'Other-Ground Water',null,80,'G','Aggregate groundwater use ');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (101,'Pond-Stormwater',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (102,'River/Stream Ephemeral',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (103,'BEACH Program Site-Channelized stream',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (104,'BEACH Program Site-Land runoff',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (105,'BEACH Program Site-Land',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (106,'BEACH Program Site-Storm sewer',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (107,'BEACH Program Site-Waste sewer',null,30,'S','Ocean');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (1011,'Pond-Anchialine',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (1204,'Leachate-Lysimeter',null,40,'S','Land');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (1231,'Floodwater non-Urban',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2344,'Pond-Wastewater',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2345,'Gas-Condensate',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2346,'Gas-Engine',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2347,'Gas-Extraction',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2348,'Gas-Flare',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2349,'Gas-Monitoring Probe',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2350,'Gas-Passive Vent',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2351,'Gas-Temporary',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2352,'Leachate-Extraction',null,50,'G','Well');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2353,'Leachate-Head Well',null,50,'G','Well');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2354,'Leachate-SamplePoint',null,50,'G','Well');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (3241,'Gas-Subslab',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (1921,'River/stream Effluent-Dominated',null,10,'S','Stream');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2451,'Atmosphere',null,60,'O','Atmosphere');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2452,'Constructed Diversion Dam',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2453,'Constructed Tunnel',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2501,'Constructed Water Transport Structure',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2502,'Oil and Gas Well',null,70,'O','Oil and Gas');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (3481,'Pond-Sediment',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (3482,'Pond-Stock',null,90,'S','Aggregate surface-water-use');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (3483,'Mine Pit',null,8,'G','Facility');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (2651,'Local Air Monitoring Station',null,60,'O','Atmosphere');
Insert into STORETW.DI_STATN_TYPES (PK_ISN,PRIMARY_TYPE,SECONDARY_TYPE,SORT_ORDER,SGO_INDICATOR,STATION_GROUP_TYPE) values (4354,'Wetland Palustrine Pond',null,91,null,'Wetland Palustrine Pond');
--------------------------------------------------------
--  DDL for Index ISTATN_TYPE03
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."ISTATN_TYPE03" ON "STORETW"."DI_STATN_TYPES" (UPPER("PRIMARY_TYPE")) 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 65536 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 ISTATN_TYPE02
--------------------------------------------------------

  CREATE INDEX "STORETW"."ISTATN_TYPE02" ON "STORETW"."DI_STATN_TYPES" ("SORT_ORDER") 
  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 PK_STATN_TYPES
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_STATN_TYPES" ON "STORETW"."DI_STATN_TYPES" ("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 ISTATN_TYPE01
--------------------------------------------------------

  CREATE INDEX "STORETW"."ISTATN_TYPE01" ON "STORETW"."DI_STATN_TYPES" ("PRIMARY_TYPE", "SECONDARY_TYPE") 
  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 DI_STATN_TYPES
--------------------------------------------------------

  ALTER TABLE "STORETW"."DI_STATN_TYPES" ADD CONSTRAINT "PK_STATN_TYPES" 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;
  ALTER TABLE "STORETW"."DI_STATN_TYPES" MODIFY ("PRIMARY_TYPE" NOT NULL ENABLE);
