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

  CREATE TABLE "STORETW"."LU_MAD_HMETHOD" 
   (	"PK_ISN" NUMBER(12,0), 
	"ID_CODE" VARCHAR2(12 CHAR), 
	"GEOPOSITIONING_METHOD" VARCHAR2(254 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" 
   CACHE ;

   COMMENT ON COLUMN "STORETW"."LU_MAD_HMETHOD"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_MAD_HMETHOD.';
   COMMENT ON COLUMN "STORETW"."LU_MAD_HMETHOD"."ID_CODE" IS 'A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced.';
   COMMENT ON COLUMN "STORETW"."LU_MAD_HMETHOD"."GEOPOSITIONING_METHOD" IS 'Geopositionig Method';
   COMMENT ON TABLE "STORETW"."LU_MAD_HMETHOD"  IS 'Horizontal Method lookup table';
REM INSERTING into STORETW.LU_MAD_HMETHOD
SET DEFINE OFF;
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (1,'001','Address Matching-House Number');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (2,'002','Address Matching-Block Face');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (3,'003','Address Matching-Street Centerline');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (4,'004','Address Matching-Nearest Intersection');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (5,'005','Address Matching-Primary Name');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (6,'006','Address Matching-Digitized');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (7,'007','Address Matching-Other');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (8,'008','Census Block-1990-Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (9,'009','Census Block/Group-1990-Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (10,'010','Census Block/Tract-1990-Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (11,'011','Census-Other');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (12,'012','GPS Carrier Phase Static Relative Position');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (13,'013','GPS Carrier Phase Kinematic Relative Position');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (14,'014','GPS Code (Pseudo Range) Differential');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (15,'015','GPS Code (Pseudo Range) Precise Position');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (16,'016','GPS Code (Pseudo Range) Standard Position (SA Off)');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (17,'017','GPS Code (Pseudo Range) Standard Position (SA On)');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (18,'018','Interpolation-Map');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (19,'019','Interpolation-Photo');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (20,'020','Interpolation-Satellite');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (21,'021','Interpolation-Other');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (22,'022','Loran C');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (23,'023','Public Land Survey-Quarter Section');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (24,'024','Public Land Survey-Section');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (25,'025','Classical Surveying Techniques');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (26,'026','Zip Code-Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (27,'027','Unknown');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (28,'028','GPS-Unspecified');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (29,'029','GPS, With Canadian Active Control System');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (30,'030','Interpolation-Digital Map Srce (Tiger)');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (31,'031','Interpolation-Spot');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (32,'032','Interpolation-MSS');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (33,'033','Interpolation-TM');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (34,'034','Public Land Survey-Eighth Section');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (35,'035','Public Land Survey-Sixteenth Section');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (36,'036','Public Land Survey-Footing');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (37,'037','Zip+4 Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (38,'038','Zip+2 Centroid');
Insert into STORETW.LU_MAD_HMETHOD (PK_ISN,ID_CODE,GEOPOSITIONING_METHOD) values (39,'039','Interpolation - Digital Map Source');
--------------------------------------------------------
--  DDL for Index MAD_HMETHOD01
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."MAD_HMETHOD01" ON "STORETW"."LU_MAD_HMETHOD" (UPPER("GEOPOSITIONING_METHOD")) 
  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 MAD_HMETHOD02
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."MAD_HMETHOD02" ON "STORETW"."LU_MAD_HMETHOD" ("ID_CODE") 
  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 PK_MAD_HMETHOD
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_MAD_HMETHOD" ON "STORETW"."LU_MAD_HMETHOD" ("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 "STORETDATA_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table LU_MAD_HMETHOD
--------------------------------------------------------

  ALTER TABLE "STORETW"."LU_MAD_HMETHOD" ADD CONSTRAINT "PK_MAD_HMETHOD" 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 "STORETDATA_STORMODP"  ENABLE;
  ALTER TABLE "STORETW"."LU_MAD_HMETHOD" MODIFY ("ID_CODE" NOT NULL ENABLE);
