# $Id: valids.txt,v 1.1 2006/11/29 20:19:56 braup Exp $ List of valid values for various database parameters, by table: Glacier_Static glacier_id Must be of the form: GnnnnnnEmmmmm[N|S], where [N|S] means "either N or S", nnnnnn has the range [000000,359999], and mmmmm has the range [00000,90000]. Glacier_Dynamic The field "glacier_type" will be replaced by the fields "primary_classification", "form", "frontal_characteristics", "longitudinal_characteristics", "dominant_mass_source", and "tongue_activity", each of which is defined below. (See ftp://ftp.ngdc.noaa.gov/Snow_Ice/Glaciers/Inventory/glacier_inventory.txt) primary_classification (can be null) 0 Uncertain or miscellaneous 1 Continental ice sheet 2 Ice-field 3 Ice cap 4 Outlet glacier 5 Valley glacier 6 Mountain glacier 7 Glacieret and snowfield 8 Ice shelf 9 Rock glacier form (can be null) 0 Uncertain or miscellaneous 1 Compound basins 2 Compound basin 3 Simple basin 4 Cirque 5 Niche 6 Crater 7 Ice apron 8 Group 9 Remnant frontal_characteristics (can be null) 0 normal or miscellaneous 1 Piedmont 2 Expanded 3 Lobed 4 Calving 5 Confluent longitudinal_characteristics (can be null) 0 Uncertain or miscellaneous 1 Even, regular 2 Hanging 3 Cascading 4 Ice-fall 5 Interrupted dominant_mass_source (can be null) 0 unknown 1 Snow 2 Avalanches 3 Superimposed ice tongue_activity (can be null) 0 uncertain 1 Marked retreat 2 Slight retreat 3 Stationary 4 Slight advance 5 Marked advance 6 Possible surge 7 Known surge 8 Oscillating 9 Downwasting Glacier_Line line_type [varchar(20)] glac_bound, centerline, snow_line, debris_bound, basin_bound, intrnl_rock (nunataks, etc.), intrnl_water Ancillary_Data id glacier_id (GnnnnnnEmmmmm[N|S]) OR analysis_id (integer) object_type [char(16)]: mugshot, dem, raster_sds location [char(200)]: file:/local/file/location/img.jpg, http://machine.name/path/file.suffix ftp://... Postal address, city, province, ... Segment segment_type [char(1)]: m (measured), a (arbitrary) segment_label [char(3)]: cld (cloud), shd (shadow), trm (terminus), div (divide), gdl (grounding line), lat (lateral margin), hed (boundary at head of glacier), eod (edge of image data), nul (NULL) segment_left_material segment_right_material [char(3)]: ice, snw (snow), rck (rock), veg (vegetation), wtr (water), nul (NULL) segment_left_feature segment_right_feature [char(3)]: glc (glacier), shf (floating ice shelf), mtn (mountain), lak (lake), sea (sea or ocean), is (ice sheet; slowly moving ice), vly (valley or cirque floor), nul (NULL) [Allow glacier ID to fill these fields?] orthocorrected [char(1)]: Y or N (yes or no) coord_system [char(1)]: [remove this field] Segment_Point [no enumerated datatypes] Center_Line [no enumerated datatypes] Tiepoint_Region [no enumerated datatypes] Tiepoint_Region_Outline [no enumerated datatypes] Area_Histogram registration [char(1)]: C (bin-centered), L (lower boundary), U (upper boundary) Area_Histogram_Data [no enumerated datatypes] Vector_Set coord_system, ellipsoid: See Table Segment above. Vector [no enumerated datatypes] Image [no enumerated datatypes] Instrument instrument_short_name > instrument_long_name: [see Sensors, below] ########################################################################### Sensors: [From http://gcmd.gsfc.nasa.gov/Resources/valids/sensors.html. This short list can be added to in the future as need arises.] SHORT_NAME > LONG_NAME ------------------------------------------------------------------------ ALI > Advanced Land Imager ASTER > Advanced Spaceborne Thermal Emission and Reflection Radiometer AVHRR > Advanced Very High Resolution Radiometer AVIRIS > Airborne Visible and Infrared Imaging Spectrometer AVNIR > Advanced Visible and Near-Infrared Radiometer ETM+ > Enhanced Thematic Mapper Plus MISR > Multi-Angle Imaging SpectroRadiometer MODIS > Moderate-Resolution Imaging Spectroradiometer MSS > Multispectral Scanner SAR > Synthetic Aperture Radar instrument_spacecraft_name: (subset of http://gcmd.gsfc.nasa.gov/Resources/valids/sources.html) Siri Jodha's start: ERS-1, ERS-2, JERS-1, RADARSAT, ALOS, Envisat, SPOT, LANDSAT, NOAA, IKONOS, TERRA Band passband_unit (not enumerated datatype, but should be any valid SI unit symbol. Note that "micron" should not be used, as this name is in the "unacceptable units" section in the NIST publication below. In a limited ASCII environment, "micrometer" should be symbolized "um". See NIST's "Guide to SI", Special Publication 811, available at http://www.nist.gov/metric/) polarization: HH, VV, HV, VH scan_type for optical: frame, pushbroom wiskbroom for passive microwave: conical scanning for active microwave: SAR, altimeter Reference_Document tag_code Already in database; similar to the Endnote ASCII format. Point_Measurement [no enumerated datatypes] Reference_Point [no enumerated datatypes] Institution institution_country (already in database: ISO-3166 2-letter code)