DM Production Data Base and GLIS Schemas
DM AVHRR Production Data Base Schema
DATE: 12/17/92
RECORD/FIELD REF TYPE LEN LONG NAME
avhrrarc 60000 avhrr_archive *ahkey COMB archive_key ahsrcln avsrcln NUMERIC 6
source_link ahstorlo STRING 6 storage_location ahfileno NUMERIC 2 file_seq_nbr ahformat
NUMERIC 2 format ahstatus STRING 1 archive_status ahbandav STRING 5 band_avail ahdtent
DATE date_entered ahdtupd DATE date_updated ahdissit NUMERIC 3 distrib_site ahrcvsta
STRING 3 receive_station avhrrsrc 60000 avhrr_source *avsrcln NUMERIC 6 source_link
avordid COMB ordering_id avrcvmth STRING 2 receiving_method avsatno STRING 2 satellite_nbr
avacqdt DATE acquisition_date avastttm NUMERIC 6 acq_start_time avastptm NUMERIC 6
acq_stop_time avdtent DATE date_entered avdtupd DATE date_updated avdnind STRING 1
day_night_ind avdirf STRING 1 direction_f aveclong NUMERIC 6 equat_cross_long avmgmtcd
STRING 2 management_code avorbno NUMERIC 5 orbit_nbr avpassdu NUMERIC 3 pass_duration
avrecsta STRING 1 record_status avscanlc NUMERIC 5 scan_line_count avtmord NUMERIC 4
times_ordered avtmstmp NUMERIC 6 browse_time_stmp geoloc *gokey COMB geo_loc_key gosrcln
avsrcln NUMERIC 6 source_link goposind STRING 2 position_ind godtent DATE date_entered
godtupd DATE date_updated golat NUMERIC 5 latitude golong NUMERIC 6 longitude refaid 60000
reference_aid *rakey COMB ref_aid_key rasrcln avsrcln NUMERIC 6 source_link rarefaid
STRING 9 reference_aid_id radtent DATE date_entered radtupd DATE date_updated GLIS AVHRR
Data Base Schema and Indices: Column name Type Nulls source_link integer no data_type_name
char(3) no receiving_method char(2) no satellite_number smallint no acquisition_date date
no acq_start_time integer no entity_id char(16) no date_entered date no day_night_ind
char(1) no direction_flag char(1) no equatorial_cross integer no equat_cross_degrs
smallint no maximum_latitude smallint no minimum_latitude smallint no orbit_number integer
no pass_duration smallint no browse_avail_flag char(1) no browse_drive char(4) no
archive_format smallint no archive_status char(1) no band_availability char(5) no
distribution_site char(1) no receiving_station char(3) no reference_aid_id char(9) no
nw_latitude integer no ne_latitude integer no ne_longitude integer no se_latitude integer
no se_longitude integer no sw_latitude integer no sw_longitude integer no cn_latitude
integer no cn_longitude integer no browse_time_stamp char(6) no
Back to 1-KM Homepage
