Project

General

Profile

« Previous | Next » 

Revision 6440

Added by Aaron Marcuse-Kubitza about 12 years ago

Removed no longer used geoscrub_cultivated. Use analytical_stem_view.cultivated instead.

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 
WHERE
9 
"latitudeDecimalVerbatim" IS NOT NULL
10 
AND "longitudeDecimalVerbatim" IS NOT NULL
11 
;
12 

  		




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


  		












  

    
      inputs/.geoscrub/geoscrub_cultivated/header.csv
    
  





  1
  
  
    
latitudeDecimalVerbatim,longitudeDecimalVerbatim,isCultivated,isCultivatedReason


  		












Also available in:  Unified diff