Project

General

Profile

« Previous | Next » 

Revision 6126

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Rename lookup_MethodCode.Description to lookup_MethodCode_Description to make it globally unique when joined with plotMetadata

View differences:

inputs/SALVIAS/salvias_plots.~.clean_up.sql
1 
-- Ensure globally unique column names when tables are joined
2 
ALTER TABLE "lookup_MethodCode" RENAME "Description" TO "lookup_MethodCode_Description";
inputs/SALVIAS/plotMetadata_/header.csv
1 
MethodCode,PlotID,orig_filename,AccessCode,project_id,PrimOwnerID,SiteCode,SiteName,new_world,MajorGeo,Country,PolDiv1,pol1_type,pol2,pol2_type,lat_string,long_string,LatDec,LongDec,lat_long_accuracy,Elev,elev_max_m,elev_min_m,Precip,ElevSource,Temp,PrecipSource,TempSource,bearing,slope_aspect,slope_gradient,clay_percent,silt_percent,sand_percent,pH,soil_N,soil_P,soil_C,soil_K,soil_Mg,soil_Ca,soil_Na,soil_acidity,soil_base,soil_cation_cap,soil_conductivity,organic_percent,soil_texture,RevisionComments,Locality_Description,topography_desc,vegetation_1,vegetation_2,Habitat,life_zone_code,life_zone,PlotMethod,plot_area_ha,recensused,date_start,date_finish,plot_administrator,plot_notes,tmp_del,Country_index,PrimOwnerID_index,plot_administrator_index,project_id_index,Description
1 
MethodCode,PlotID,orig_filename,AccessCode,project_id,PrimOwnerID,SiteCode,SiteName,new_world,MajorGeo,Country,PolDiv1,pol1_type,pol2,pol2_type,lat_string,long_string,LatDec,LongDec,lat_long_accuracy,Elev,elev_max_m,elev_min_m,Precip,ElevSource,Temp,PrecipSource,TempSource,bearing,slope_aspect,slope_gradient,clay_percent,silt_percent,sand_percent,pH,soil_N,soil_P,soil_C,soil_K,soil_Mg,soil_Ca,soil_Na,soil_acidity,soil_base,soil_cation_cap,soil_conductivity,organic_percent,soil_texture,RevisionComments,Locality_Description,topography_desc,vegetation_1,vegetation_2,Habitat,life_zone_code,life_zone,PlotMethod,plot_area_ha,recensused,date_start,date_finish,plot_administrator,plot_notes,tmp_del,Country_index,PrimOwnerID_index,plot_administrator_index,project_id_index,lookup_MethodCode_Description
inputs/SALVIAS/plotMetadata_/map.csv
67 67 
PrimOwnerID_index,*PrimOwnerID_index,,
68 68 
plot_administrator_index,*plot_administrator_index,,
69 69 
project_id_index,*project_id_index,,
70 
Description,*Description,,
70 
lookup_MethodCode_Description,*lookup_MethodCode_Description,,
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
61 61 
SiteCode,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
62 62 
AccessCode,,** No join mapping for *AccessCode **
63 63 
Country_index,,** No join mapping for *Country_index **
64 
Description,,** No join mapping for *Description **
65 64 
ElevSource,,** No join mapping for *ElevSource **
66 65 
MethodCode,,** No join mapping for *MethodCode **
67 66 
PrecipSource,,** No join mapping for *PrecipSource **
......
74 73 
lat_long_accuracy,,** No join mapping for *lat_long_accuracy **
75 74 
lat_string,,** No join mapping for *lat_string **
76 75 
long_string,,** No join mapping for *long_string **
76 
lookup_MethodCode_Description,,** No join mapping for *lookup_MethodCode_Description **
77 77 
new_world,,** No join mapping for *new_world **
78 78 
orig_filename,,** No join mapping for *orig_filename **
79 79 
plot_administrator,,** No join mapping for *plot_administrator **
inputs/SALVIAS/plotMetadata_/unmapped_terms.csv
24 24 
*PrimOwnerID_index
25 25 
*plot_administrator_index
26 26 
*project_id_index
27 
*Description
27 
*lookup_MethodCode_Description

Also available in: Unified diff