Project

General

Profile

« Previous | Next » 

Revision 6110

Added by Aaron Marcuse-Kubitza over 11 years ago

Added inputs/.geoscrub/geoscrub_cultivated/

View differences:

inputs/.geoscrub/geoscrub_cultivated/create.sql
1 
SELECT
2 
DISTINCT ON ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim")
3 
  "latitudeDecimalVerbatim"
4 
, "longitudeDecimalVerbatim"
5 
, "isCultivated"
6 
, "isCultivatedReason"
7 
FROM geoscrub_cleaned_unique
8 
;
9 

  		




  
  10
  
    
ALTER TABLE :table ADD PRIMARY KEY ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim");


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/header.csv
    
  





  
  1
  
    
latitudeDecimalVerbatim,longitudeDecimalVerbatim,isCultivated,isCultivatedReason


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/map.csv
    
  





  
  1
  
    
geoscrub,VegCore,Filter,Comments


  		




  
  2
  
    
latitudeDecimalVerbatim,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  3
  
    
longitudeDecimalVerbatim,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  4
  
    
isCultivated,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  5
  
    
isCultivatedReason,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/VegBIEN.csv
    
  





  
  1
  
    
geoscrub,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments


  		




  
  2
  
    
isCultivated,,"** No non-empty join mapping for OMIT ** This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  3
  
    
isCultivatedReason,,"** No non-empty join mapping for OMIT ** This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  4
  
    
latitudeDecimalVerbatim,,"** No non-empty join mapping for OMIT ** This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  5
  
    
longitudeDecimalVerbatim,,"** No non-empty join mapping for OMIT ** This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/test.xml.ref
    
  





  
  1
  
    
Put template:


  		




  
  2
  
    
<VegBIEN/>Inserted 1 new rows into database


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/new_terms.csv
    
  





  
  1
  
    
latitudeDecimalVerbatim,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  2
  
    
longitudeDecimalVerbatim,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  3
  
    
isCultivated,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		




  
  4
  
    
isCultivatedReason,OMIT,,"This table is used directly by the analytical DB, rather than being imported into VegBIEN"


  		












Also available in:  Unified diff