Glacier_Static

glacier_id

varchar(20)

P

X

unique Glacier ID number, generated from lon/lat of glacier

glacier_name

varchar(40)

Glacier name, if there is one.

wgms_id

varchar(14)

World Glacier Monitoring Service (WGMS) ID, if assigned

glacier_type

varchar(15)

Glacier type (flags for surging, temperate, ice stream, etc)

glacier_loc_x

numeric(8,6)

Offset (easting, m) bet. glacierID pt & ref pt

glacier_loc_y

numeric(9,6)

Offset (northing, m) bet. glacierID pt & ref pt

ref_pnt_id

varchar(20)

F

GlacierID reference point

analysis_id

int

P

X

ID for this analysis (snapshot)

glacier_id

varchar(20)

F

X

Glacier ID number, from Glacier_Static table

data_source

varchar(255)

X

Desc. of data source, e.g. ASTER image, GPS survey, etc. (TEXT)

analysis_timestamp

datetime

X

Time stamp for this analysis (date and time, easily sortable, such as UNIX seconds)

institution_id

int

F

X

ID of institution where the analysis was done, from Institution table

analyst_first_name

varchar(20)

X

First name of the person in charge of the analysis

analyst_last_name

varchar(20)

X

Last name of the person in charge of the analysis

process_desc

text

X

Description of the processing (including algorithms) used in the analysis

three_d_desc

text

Description of how 3-D information was derived

width

float

Representative width of glacier, meters

length

float

Representative length of glacier, meters

area

float

Representative total area of glacier, km2

abzone_area

float

Area of ablation zone of glacier, km2

speed

float

Representative speed (float, m/a)

analysis_id

int

P/F

X

from Glacier_Dynamic table

segment_id

int

P/F

X

from Segment table

segment_id

int

P

X

unique segment ID number

segment_type

varchar(30)

X

measured,arbitrary

segment_label

varchar(32)

cloud,terminus,divide

segment_left_material

char(3)

Materials on left side: glacier,nonglacier,ice,rock,snow,vegetation,water

segment_right_material

char(3)

Materials on right side: glacier,nonglacier,ice,rock,snow,vegetation,water

orthocorrected

char(1)

X

Flag to indicate whether location is terrain-corrected or not

coord_system

char(1)

X

enumerated data type, one of: latlon, noreast

ellipsoid

varchar(10)

O

ellipsoid name (e.g. WGS-84), or NULL if coord_system is not latlon

ref_pnt_id

varchar(20)

F

O

ID of reference point, for northing/easting coordinates, from Reference_Point table

segment_point_id

int

P

X

unique segment point ID number

segment_id

int

F

segment ID number, from Segment table

pnt_x_coord

float

X

x-coordinate of segment point

pnt_y_coord

float

X

y-coordinate of segment point

pnt_z_coord

float

z-coordinate (geoidal elevation) of segment point

analysis_id

int

P/F

X

Glacier to which this centerline relates (unique)

segment_id

int

P/F

X

Link to segment that makes up the centerline

tiepoint_region_id

int

P

X

ID of tiepoint region (primary key).

institution_id

int

F

tiepoint_region_timestamp

datetime

Time/Date the tiepoint polygon was created

comment

varchar(255)

Text field for additional comments

tiepoint_region_id

int

P/F

X

ID of tiepoint region (primary key).

segment_id

int

P/F

X

segment ID number, from Segment table

area_histogram_id

int

P

X

Primary Key

analysis_id

int

F

X

Glacier to which this relates (unique), foreign key, from Glacier_Dynamic

bin_width

numeric(5,1)

X

width (in m) of elevation bin

registration

char(1)

X

flag, indicates whether data are bin-centered (C), lower (L), or upper (U) boundary

area_histogram_id

int

F

X

foreign key, from Area_Histogram table

elevation

numeric(5,1)

X

representative elevation of bin, m above geoid

area

numeric(9,1)

X

area of glacier in this elevation bin (km2)

vel_set_id

int

P

X

ID of velocity information set

analysis_id1

int

F

X

ID for the first analysis, foreign key from Glacier_Dynamic

analysis_id2

int

F

X

ID for the second analysis, foreign key from Glacier_Dynamic

num_vecs

int

Number of displacement vectors (can be NULL)

first_x_uncertainty

float

Uncertainty in first_x, in degrees or m

first_y_uncertainty

float

Uncertainty in first_y, in degrees or m

delta_x_uncertainty

float

Uncertainty in delta_x, in degrees or m

delta_y_uncertainty

float

Uncertainty in delta_y, in degrees or m

coord_system

char(1)

X

enumerated data type, one of: latlon, noreast (m)

ellipsoid

varchar(10)

O

ellipsoid name (e.g. WGS-84), or NULL if coord_type is not latlon

ref_pnt_id

varchar(10)

O

ID of reference point, for northing/easting coordinates

vel_set_id

int

F

X

foreign key from Displacement_Info

first_x

float

X

x-location of feature in first image

first_y

float

X

y-location of feature in first image

delta_x

float

X

x-location of feature in second image

delta_y

float

X

y-location of feature in second image

image_id

int

P

X

ID of image

instrument_id

int

F

X

ID of source instrument, from Instrument table

ecs_granule_id

varchar(50)

ID of image within ECS

image_loc_url

varchar(120)

URL of source of image

acq_timestamp

datetime

X

Date/Time of image exposure

image_center_lon

float

Center geodetic longitude of image (WGS-84 ellipsoid)

image_center_lat

float

Center geodetic latitude of image (WGS-84 ellipsoid)

image_center_lon_unc

float

Uncertainty of image georeferencing - lon

image_center_lat_unc

float

Uncertainty of image georeferencing - lat

image_azim

numeric(7,4)

Orientation of image (degrees east of north)

cloud_pct

numeric(3,0)

Cloud severity (0 to 100%, 100% being totally cloudy)

sun_azim

numeric(7,4)

Sun azimuth (degrees east of north)

sun_elev

numeric(7,4)

Sun elevation (degrees from horizon)

instrument_zenith

numeric(7,4)

Zenith angle of instrument pointing (degrees, 0=nadir)

instrument_azimuth

numeric(7,4)

Azimuth of instrument pointing (degrees east of north)

projection

varchar(30)

Name of the projection used (e.g. polar stereographic)

instrument_id

int

P

X

ID of instrument

instrument_long_name

varchar(50)

X

Long name of instrument

instrument_short_name

varchar(10)

Short name for the instrument

instrument_spacecraft_name

varchar(50)

Name of spacecraft that instrument is on

instrument_altitude

numeric(8,3)

Average orbit altitude (km)

instrument_inclination

numeric(7,4)

Orbit inclination (degrees)

num_bands

int

Number of bands

band_list

varchar(255)

X

List of names of bands/modes

eq_crossing_time

varchar(10)

Time of equator crossing, for sun-synchronous satellites

band_id

int

P

X

Band/Mode name (or number)

instrument_id

int

F

X

ID of instrument, from Instrument table

scan_type

varchar(10)

Scan type (whisk, push, etc)

ifov_x

float

Instantaneous field of view, X (radians)

ifov_y

float

Instantaneous field of view, Y (radians)

sample_interval_x

numeric(6,2)

Nominal sample interval X (meters)

sample_interval_y

numeric(6,2)

Nominal sample interval Y (meters)

passband_low

numeric(7,3)

Low edge of passband (nanometers)

passband_high

numeric(7,3)

High edge of passband (nanometers)

passband_unit

varchar(5)

Unit used for the passband

num_bits

int

Number of bits in DN

num_lines

int

Number of lines per nominal scene

num_samples

int

Number of samples per line

polarization

varchar(5)

Polarization (for radar, e.g. HH, VH, etc.)

band_id

int

P/F

X

ID of band in this image, from Band table

image_id

int

P/F

X

ID of image cube, from Image table

analysis_id

int

P/F

X

foreign key from Glacier_Dynamic table

image_id

int

P/F

X

foreign key from Image table

reference_doc_id

int

P

X

Primary Key, ID for the reference document

tag_code

int

P/F

X

Unique identifier for a specific field in reference information

tag_value

varchar(255)

X

Value associated with the tag_code

tag_code

int

P

X

Unique identifier for a specific field in reference information

tag_code_description

varchar(255)

X

Description of the tag_code(e.g. author name, journal name)

glacier_id

varchar(20)

P/F

X

Glacier ID number, from Glacier_Static table

reference_doc_id

int

P/F

X

Reference Document ID number, from Reference_Doc table

pnt_meas_id

int

P

X

ID of point measurement

glacier_id

varchar(20)

F

X

Glacier that this measurement relates to, from Glacier_Static table

pnt_timestamp

datetime

X

Time stamp for this measurement (e.g. 2005-12-12T14:23:21Z)

pnt_x_coord

float

X

x-coordinate of measurement

pnt_y_coord

float

X

y-coordinate of measurement

pnt_z_coord

float

vertical coordinate (geoidal elevation) of measurement (m)

pnt_coord_system

char(1)

enumerated data type, one of: latlon, noreast (m)

pnt_ellipsoid

varchar(10)

O

ellipsoid name (e.g. WGS-84), or NULL if coord_type is not latlon

ref_pnt_id

varchar(10)

F

O

ID of reference point, for northing/easting coordinates, from Reference_Point table

pnt_label

varchar(20)

Label for the measured quantity, e.g. "debris thickness"

pnt_value

float

floating point number representing value of measurement

pnt_unit

varchar(10)

Unit for measurement (e.g. m, degrees C, etc.)

ref_pnt_id

varchar(20)

P

X

same ID method as glaciers and snowfields

ref_pnt_name

varchar(50)

Name of ground reference point, if there is one

ref_pnt_desc

varchar(255)

X

Text for how location determined (~50 characters)

ref_pnt_lat

numeric(8,6)

X

latitude of reference point (decimal degrees)

ref_pnt_lat_unc

numeric(8,6)

Uncertainty in latitude (decimal degrees)

ref_pnt_lon

numeric(9,6)

X

longitude of reference point (decimal degrees)

ref_pnt_lon_unc

numeric(9,6)

Uncertainty in longitude (decimal degrees)

ref_pnt_elev

numeric(7,3)

elevation of reference point (m)

ref_pnt_elev_unc

numeric(7,3)

Uncertainty in elevation (m)

ref_pnt_chip

image

Image chip (32 pixel x 32 pixel image cube)

ref_pnt_chip_src

int

F

ID of source image for chip, foreign key to the Image table

ref_pnt_chip_numbands

int

Number of bands in image chip

ref_pnt_chip_bands

varchar(30)

Bands in image chip # a fixed list of band numbers

ref_pnt_img_line

int

Line in source image of first line of chip

ref_pnt_img_samp

int

Sample in source image of first column of chip

ref_pnt_chip_line

float

Line location of reference point within chip (floating pt number)

ref_pnt_chip_samp

float

Sample location of reference point within chip (floating pt number)

reference_doc_id

int

F

Pointer to source of more detailed information, foreign key from the Reference_Doc table

institution_id

int

P

X

ID of institution

institution_name

varchar(120)

X

Name of institution

institution_address

varchar(80)

mailing address of institution

institution_city

varchar(50)

City where institution is located

institution_country

varchar(2)

Country where institution is located, ISO-3166 2-letter code

postal_code

varchar(20)

Postal code (like US ZIP code)

longitude

float

longitude of institution (for ease of plotting on maps)

latitude

float

latitude of institution

country_code

char(2)

X

ISO-3166 2-letter code

country_name

varchar(30)

X