$Id: db_xfer_mapping.txt,v 1.1 2006/11/29 20:19:56 braup Exp $ Mapping between full attribute names used in the GLIMS database and their shortened names used in ESRI shapefiles. All abbreviated names are case-insensitive. Full Name Abbreviated Name shapefile(s) Glacier_Static --------------------------------------------------------------------------- glacier_id ID segments,glaciers,ancillary,histograms glacier_name name glaciers wgms_id wgms_id glaciers local_glacier_id local_id glaciers parent_icemass_id parent_id glaciers glacier_loc_lon --- glaciers glacier_loc_lat --- glaciers Glacier_Dynamic --------------------------------------------------------------------------- analysis_id --- glacier_id ID segments,glaciers,ancillary,histograms data_source data_src session source_timestamp src_time session analysis_timestamp analy_time session institution_id RC_ID session analyst_given_name anlst_givn session analyst_surname anlst_surn session process_desc proc_desc session three_d_desc 3d_desc session primary_classification prim_class glaciers form form glaciers frontal_characteristics front_char glaciers longitudinal_characteristics long_char glaciers dominant_mass_source mass_src glaciers tongue_activity tongue_act glaciers width width_m glaciers length length_m glaciers area area_km2 glaciers abzone_area abarea_km2 glaciers speed speed_myr glaciers ela ela_m glaciers ela_desc ela_desc glaciers snowline_elev snowline glaciers record_status --- Glacier_Line --------------------------------------------------------------------------- analysis_id --- segment_id --- segment_order --- line_type category segments Segment --------------------------------------------------------------------------- segment_id --- segment_type type segments segment_label label segments segment_left_material left_mat segments segment_right_material right_mat segments orthocorrected ortho segments loc_unc_x loc_unc_x segments loc_unc_y loc_unc_y segments glob_unc_x glob_unc_x segments glob_unc_y glob_unc_y segments seg_left_feature left_feat segments seg_right_feature right_feat segments Segment_Point --------------------------------------------------------------------------- segment_point_id --- segment_id --- pnt_x_coord --- segments pnt_y_coord --- segments pnt_z_coord --- segments Tiepoint_Region --------------------------------------------------------------------------- tiepoint_region_id ID segments institution_id RC_ID session tiepoint_region_timestamp timestamp session comment ??? Tiepoint_Region_Outline --------------------------------------------------------------------------- tiepoint_region_id ID segments segment_id --- Area_Histogram --------------------------------------------------------------------------- area_histogram_id --- analysis_id --- bin_width binwidth_m histograms registration regist histograms Area_Histogram_Data --------------------------------------------------------------------------- area_histogram_id --- elevation elev_m histograms area area_km2 histograms Vector_Set --------------------------------------------------------------------------- vel_set_id --- analysis_id1 anal_id1 vec_sets analysis_id2 anal_id2 vec_sets num_vecs num_vecs vec_sets loc_unc_first_lon p1_loc_lon vec_sets loc_unc_first_lat p1_loc_lat vec_sets glob_unc_first_lon p1_glb_lon vec_sets glob_unc_first_lat p1_glb_lat vec_sets loc_unc_second_lon p2_loc_lon vec_sets loc_unc_second_lat p2_loc_lat vec_sets glob_unc_second_lo p2_glb_lon vec_sets glob_unc_second_la p2_glb_lat vec_sets Vector --------------------------------------------------------------------------- vel_set_id --- --- first_lon --- vec_points first_lat --- vec_points second_lon --- vec_points second_lat --- vec_points Image --------------------------------------------------------------------------- image_id image_id images instrument_id inst_id images orig_id orig_id images image_loc_url imglocurl images acq_timestamp acq_time images image_center_lon imgctrlon images image_center_lat imgctrlat images image_center_lon_unc imglon_unc images image_center_lat_unc imglat_unc images image_azim image_azim images cloud_pct cloud_pct images sun_azim sun_azim images sun_elev sun_elev images instrument_zenith inst_zen images instrument_azimuth inst_azim images projection projection images Instrument --------------------------------------------------------------------------- instrument_id --- instrument_long_name --- instrument_short_name --- instrument_spacecraft_name --- instrument_altitude --- instrument_inclination --- num_bands --- band_list --- eq_crossing_time --- Band --------------------------------------------------------------------------- band_id --- instrument_id --- scan_type --- ifov_x --- ifov_y --- sample_interval_x --- sample_interval_y --- passband_low --- passband_high --- passband_unit --- num_bits --- num_lines --- num_samples --- polarization --- Image_Band --------------------------------------------------------------------------- band_id --- image_id --- Glacier_Image_Info --------------------------------------------------------------------------- analysis_id --- image_id --- Reference_Document --------------------------------------------------------------------------- reference_doc_id --- tag_code ??? tag_value ??? Reference_Doc_Code --------------------------------------------------------------------------- tag_code --- tag_code_description --- Glacier_Reference --------------------------------------------------------------------------- glacier_id --- reference_doc_id --- Point_Measurement --------------------------------------------------------------------------- pnt_meas_id --- glacier_id ID point_meas pnt_timestamp timestamp point_meas pnt_lon longitude point_meas pnt_lat latitude point_meas pnt_elev elev_m point_meas pnt_label label point_meas pnt_value value point_meas pnt_lon_unc lon_unc point_meas pnt_lat_unc lat_unc point_meas pnt_elev_unc elev_unc point_meas pnt_value_unc value_unc point_meas pnt_unit unit point_meas comment comment point_meas Institution --------------------------------------------------------------------------- institution_id --- institution_name --- address --- city --- state --- country_code --- postal_code --- lon --- lat --- contact_name --- email --- url --- geog_area --- parent_rc --- Country --------------------------------------------------------------------------- country_code --- country_name --- Ancillary_Data --------------------------------------------------------------------------- glac_analysis_id ID ancillary location ancdat_loc ancillary data_type ancdat_typ ancillary size ancdat_sz ancillary comment comment ancillary