DRG   Air Photos   DOI10   DOQQ
create table drg_24k_ca create table c9800 create table doi10_us create table doqq_cir_ca
(ocode varchar(50) NOT NULL, (frame_id varchar(50) NOT NULL, (FILENAME varchar(50) NOT NULL (FILENAME varchar(50) NOT NULL,
mapname varchar(255) NOT NULL, title varchar(255) NOT NULL, WEST_LONG real NOT NULL QUAD_NAME varchar(50),
state varchar(50), w_b_coord real NOT NULL, EAST_LONG real NOT NULL QUADRANT varchar(50),
refcode varchar(50), e_b_coord real NOT NULL, NORTH_LAT real NOT NULL WEST_LONG real NOT NULL,
w_b_coord real NOT NULL, n_b_coord real NOT NULL, SOUTH_LAT real NOT NULL EAST_LONG real NOT NULL,
e_b_coord real NOT NULL, s_b_coord real NOT NULL, PRODUCTION_DATE varchar(50), NORTH_LAT real NOT NULL,
n_b_coord real NOT NULL, vertices varchar(255), RASTER_ORDER varchar(50), SOUTH_LAT real NOT NULL,
s_b_coord real NOT NULL, originator varchar(255), BITS_PER_PIXEL integer, PRODUCTION_DATE varchar(100),
year integer, original_date integer, SAMPLES integer, RASTER_ORDER varchar(50),
begin date, begin date, LINES integer, BAND_ORG varchar(50),
end date, end date, HORIZ_DATUM varchar(50), BAND_CONTENT varchar(50),
mbytesize_tif real, local_call_number varchar(255), HORIZ_COORD_SYS varchar(50), BITS_PER_PIXEL integer,
bytesize_browse integer, mbytesize_tif real, HORIZ_UNITS varchar(10), SAMPLES integer,
bytesize_thumb integer, bytesize_browse integer, HORIZ_RES real, LINES_1 integer,
ucsb_local_call_num varchar(50) bytesize_thumb integer, IMAGE_SOURCE varchar(10), HORIZ_DATUM varchar(100),
assigned_terms varchar(255), format varchar(50), SOURCE_IMAGE_DATE varchar(50), HORIZ_COORD_SYSTEM varchar(100),
subject_related_text varchar(255), type varchar(50), AGENCY varchar(50), COORD_ZONE integer,
alltext varchar(255), PRIMARY KEY (frame_id)); DATA_FILE_SIZE integer, HORIZ_UNITS varchar(50),
FULLTEXT (assigned_terms, subject_related_text), title varchar(255) NOT NULL HORIZ_RES real,
PRIMARY KEY (ocode)); year integer, SEC_HORIZ_DATUM varchar(100),
begin date, XY_ORIGIN_X real,
end date, XY_ORIGIN_Y real,
alltext alltext_t, SEC_XY_ORIGIN_X real,
mbytesize_data real, SEC_XY_ORIGIN_Y real,
bytesize_browse integer, NATION varchar(50),
bytesize_thumb integer, STATE varchar(50),
scale varchar(50)); NW_QUAD_CORNER_XY_X real,
NW_QUAD_CORNER_XY_Y real,
NE_QUAD_CORNER_XY_X real,
NE_QUAD_CORNER_XY_Y real,
SE_QUAD_CORNER_XY_X real,
SE_QUAD_CORNER_XY_Y real,
SW_QUAD_CORNER_XY_X real,
SW_QUAD_CORNER_XY_Y real,
SEC_NW_QUAD_XY_X real,
SEC_NW_QUAD_XY_Y real,
SEC_NE_QUAD_XY_X real,
SEC_NE_QUAD_XY_Y real,
SEC_SE_QUAD_XY_X real,
SEC_SE_QUAD_XY_Y real,
SEC_SW_QUAD_XY_X real,
SEC_SW_QUAD_XY_Y real,
RMSE_XY real,
IMAGE_SOURCE varchar(50),
SOURCE_IMAGE_ID varchar(100),
SOURCE_IMAGE_DATE varchar(100),
SOURCE_DEM_DATE varchar(100),
AGENCY varchar(100),
PRODUCER varchar(100),
PROD_SYS varchar(100),
COMPRESSION varchar(50),
STAND_VERS varchar(50),
MDATA_DATE varchar(100),
DATA_FILE_SIZE integer,
BYTE_COUNT integer,
title varchar(255),
footprint varchar(255),
begin date,
end date,
local_call_number varchar(255),
assigned_terms varchar(255),
subject_related_text varchar(255),
FULLTEXT (title, assigned_terms, subject_related_text),
PRIMARY KEY (FILENAME));