Project

General

Profile

« Previous | Next » 

Revision 1314

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: placerank: Standardized names to DwC/GML

View differences:

schemas/vegbien.sql
38 38 
CREATE TYPE placerank AS ENUM (
39 39 
    'continent',
40 40 
    'country',
41 
    'stateProvince',
42 
    'county',
43 
    'municipality',
44 
    'site',
41 45 
    'territory',
42 46 
    'region',
43 
    'state',
44 
    'county',
45 
    'municipality',
46 
    'site'
47 
    'waterBody',
48 
    'island',
49 
    'islandGroup'
47 50 
);
48 51 

  		




  49
  52
  
    

  		




  ......




  51
  54
  
    
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: -


  		




  52
  55
  
    
--


  		




  53
  56
  
    

  		




  54
  
  
    
COMMENT ON TYPE placerank IS 'state = province


  		




  55
  
  
    
county = parish, canton


  		




  
  57
  
    
COMMENT ON TYPE placerank IS 'county = parish, canton


  		




  56
  58
  
    
municipality = city


  		




  57
  59
  
    
';


  		




  58
  60
  
    

  		












Also available in:  Unified diff