Project

General

Profile

« Previous | Next » 

Revision 6082

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/vegbank.~.clean_up.sql: Remove private columns (plot.reallatitude, reallongitude) that should not be publicly visible

View differences:

inputs/VegBank/vegbank.~.clean_up.sql
64 64 
DROP VIEW IF EXISTS view_taxonobs_distinctid_curr_counts CASCADE;
65 65 
DROP VIEW IF EXISTS view_taxonobs_distinctid_curr_counts_plants CASCADE;
66 66 

  		




  
  67
  
    
-- Remove private columns that should not be publicly visible


  		




  
  68
  
    
ALTER TABLE plot DROP COLUMN reallatitude;


  		




  
  69
  
    
ALTER TABLE plot DROP COLUMN reallongitude;


  		




  
  70
  
    

  		




  67
  71
  
    
-- Prevent "column name specified more than once" errors when tables are joined


  		




  68
  72
  
    
ALTER TABLE taxonobservation RENAME reference_id  TO taxonobservation_reference_id;


  		




  69
  73
  
    
ALTER TABLE taxonobservation RENAME accessioncode  TO taxonobservation_accessioncode;


  		












  

    
      inputs/VegBank/plot_/header.csv
    
  





  1
  
  
    
plot_id,authorplotcode,reference_id,parent_id,reallatitude,reallongitude,locationaccuracy,confidentialitystatus,confidentialityreason,latitude,longitude,authore,authorn,authorzone,authordatum,authorlocation,locationnarrative,azimuth,dsgpoly,shape,area,standsize,placementmethod,permanence,layoutnarrative,elevation,elevationaccuracy,elevationrange,slopeaspect,minslopeaspect,maxslopeaspect,slopegradient,minslopegradient,maxslopegradient,topoposition,landform,surficialdeposits,rocktype,stateprovince,country,submitter_surname,submitter_givenname,submitter_email,notespublic,notesmgt,revisions,dateentered,emb_plot,plotrationalenarrative,accessioncode,continent,area|country|territory,region|state|province,county,quadrangle,Geographic Name


  		




  
  1
  
    
plot_id,authorplotcode,reference_id,parent_id,locationaccuracy,confidentialitystatus,confidentialityreason,latitude,longitude,authore,authorn,authorzone,authordatum,authorlocation,locationnarrative,azimuth,dsgpoly,shape,area,standsize,placementmethod,permanence,layoutnarrative,elevation,elevationaccuracy,elevationrange,slopeaspect,minslopeaspect,maxslopeaspect,slopegradient,minslopegradient,maxslopegradient,topoposition,landform,surficialdeposits,rocktype,stateprovince,country,submitter_surname,submitter_givenname,submitter_email,notespublic,notesmgt,revisions,dateentered,emb_plot,plotrationalenarrative,accessioncode,continent,area|country|territory,region|state|province,county,quadrangle,Geographic Name


  		












  

    
      inputs/VegBank/plot_/map.csv
    
  





  3
  3
  
    
authorplotcode,plotName,,


  		




  4
  4
  
    
reference_id,*reference_id,,


  		




  5
  5
  
    
parent_id,parentLocationID,,


  		




  6
  
  
    
reallatitude,PRIVATE,,


  		




  7
  
  
    
reallongitude,PRIVATE,,


  		




  8
  6
  
    
locationaccuracy,coordinateUncertaintyInMeters,,


  		




  9
  7
  
    
confidentialitystatus,*confidentialitystatus,,


  		




  10
  8
  
    
confidentialityreason,*confidentialityreason,,


  		












  

    
      inputs/VegBank/plot_/VegBIEN.csv
    
  





  60
  60
  
    
placementmethod,,** No join mapping for *placementmethod ** 


  		




  61
  61
  
    
plotrationalenarrative,,** No join mapping for *plotrationalenarrative ** 


  		




  62
  62
  
    
quadrangle,,** No join mapping for *quadrangle ** 


  		




  63
  
  
    
reallatitude,,** No non-empty join mapping for PRIVATE ** 


  		




  64
  
  
    
reallongitude,,** No non-empty join mapping for PRIVATE ** 


  		




  65
  63
  
    
reference_id,,** No join mapping for *reference_id ** 


  		




  66
  64
  
    
revisions,,** No join mapping for *revisions ** 


  		




  67
  65
  
    
rocktype,,** No join mapping for *rocktype ** 


  		












Also available in:  Unified diff