all = public_.sql vegbien.sql vegbien.my.sql util.sql py_util.sql

# Must come before `%/install: public_.sql` to override it

%/install: public_.sql _always

%/uninstall: public_.sql _always

public_.sql:

vegbien.sql: public_.sql

	(cat public_.sql; schema=1 ../bin/pg_dump_vegbien all --schema='geoscrub' \

--schema='"TNRS"' --exclude-table='*."~"*' --exclude-table='*."Source"') >$@

# `all`: prevents auto-adding a --schema entry

--

-- PostgreSQL database dump

--

--

-- Name: TNRS; Type: SCHEMA; Schema: -; Owner: -

--

CREATE SCHEMA `TNRS`;

--

-- Name: SCHEMA `TNRS`; Type: COMMENT; Schema: -; Owner: -

--

--

-- Name: geoscrub; Type: SCHEMA; Schema: -; Owner: -

--

CREATE SCHEMA geoscrub;

--

-- Name: batch__fill(); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: family_is_homonym(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: genus_is_homonym(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: map_taxonomic_status(varchar(255), varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: FUNCTION tnrs_populate_fields(); Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: map_coord_validity(int(11)); Type: FUNCTION; Schema: geoscrub; Owner: -

--

--

-- Name: map_geovalidity(int(11)); Type: FUNCTION; Schema: geoscrub; Owner: -

--

--

-- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: 

--

CREATE TABLE tnrs (

    batch varchar(255)  NOT NULL,

    `Name_number` int(11) NOT NULL,

    `Name_submitted` varchar(255) NOT NULL,

    `Overall_score` double precision,

    `Name_matched` varchar(255),

    `Name_matched_rank` varchar(255),

    `Name_score` double precision,

    `Name_matched_author` varchar(255),

    `Name_matched_url` varchar(255),

    `Author_matched` varchar(255),

    `Author_score` double precision,

    `Family_matched` varchar(255),

    `Family_score` double precision,

    `Name_matched_accepted_family` varchar(255),

    `Genus_matched` varchar(255),

    `Genus_score` double precision,

    `Specific_epithet_matched` varchar(255),

    `Specific_epithet_score` double precision,

    `Infraspecific_rank` varchar(255),

    `Infraspecific_epithet_matched` varchar(255),

    `Infraspecific_epithet_score` double precision,

    `Infraspecific_rank_2` varchar(255),

    `Infraspecific_epithet_2_matched` varchar(255),

    `Infraspecific_epithet_2_score` double precision,

    `Annotations` varchar(255),

    `Unmatched_terms` varchar(255),

    `Taxonomic_status` varchar(255),

    `Accepted_name` varchar(255),

    `Accepted_name_author` varchar(255),

    `Accepted_name_rank` varchar(255),

    `Accepted_name_url` varchar(255),

    `Accepted_name_species` varchar(255),

    `Accepted_name_family` varchar(255),

    `Selected` varchar(255),

    `Source` varchar(255),

    `Warnings` varchar(255),

    `Accepted_name_lsid` varchar(255),

    is_valid_match int(1) NOT NULL,

    scrubbed_unique_taxon_name varchar(255)

);

--

-- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -

--

--

-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -

--

--

-- Name: VIEW `ValidMatchedTaxon`; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: batch; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: 

--

CREATE TABLE batch (

    id varchar(255) NOT NULL,

    id_by_time varchar(255),

    time_submitted timestamp NULL ,

    client_version varchar(255)

);

--

-- Name: batch_download_settings; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: 

--

CREATE TABLE batch_download_settings (

    id varchar(255) NOT NULL,

    `E-mail` varchar(255),

    `Id` varchar(255),

    `Job type` varchar(255),

    `Contains Id` int(1),

    `Start time` varchar(255),

    `Finish time` varchar(255),

    `TNRS version` varchar(255),

    `Sources selected` varchar(255),

    `Match threshold` double precision,

    `Classification` varchar(255),

    `Allow partial matches?` int(1),

    `Sort by source` int(1),

    `Constrain by higher taxonomy` int(1)

);

--

-- Name: TABLE batch_download_settings; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: client_version; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: 

--

CREATE TABLE client_version (

    id varchar(255) NOT NULL,

    global_rev int(11) NOT NULL,

    `/lib/tnrs.py rev` int(11),

    `/bin/tnrs_db rev` int(11)

);

--

-- Name: TABLE client_version; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: COLUMN client_version.global_rev; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: COLUMN client_version.`/lib/tnrs.py rev`; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: COLUMN client_version.`/bin/tnrs_db rev`; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: taxon_scrub.scrubbed_unique_taxon_name.*; Type: VIEW; Schema: TNRS; Owner: -

--

--

-- Name: VIEW `taxon_scrub.scrubbed_unique_taxon_name.*`; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: taxon_scrub; Type: VIEW; Schema: TNRS; Owner: -

--

--

-- Name: VIEW taxon_scrub; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: 

--

CREATE TABLE county_centroids (

    `*row_num` int(11) NOT NULL,

    `stateProvince` varchar(255),

    county varchar(255),

    `decimalLatitude` double precision,

    `decimalLongitude` double precision,

    `*error_km` double precision

);

--

-- Name: geoscrub_output; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: 

--

CREATE TABLE geoscrub_output (

    `*row_num` int(11) NOT NULL,

    `decimalLatitude` double precision NOT NULL,

    `decimalLongitude` double precision NOT NULL,

    country varchar(255),

    `stateProvince` varchar(255),

    county varchar(255),

    `acceptedCountry` varchar(255),

    `acceptedStateProvince` varchar(255),

    `acceptedCounty` varchar(255),

    `latLongDomainValid_verbatim` int(11),

    `latLongInCountry_verbatim` int(11),

    `latLongInStateProvince_verbatim` int(11),

    `latLongInCounty_verbatim` int(11),

    `latLongDomainValid` int(1),

    `latLongInCountry` int(1),

    `latLongInStateProvince` int(1),

    `latLongInCounty` int(1),

    geovalid int(1)

);

--

-- Name: batch_download_settings_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE batch_download_settings

    ADD CONSTRAINT batch_download_settings_pkey PRIMARY KEY (id);

--

-- Name: batch_id_by_time_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE batch

    ADD CONSTRAINT batch_id_by_time_key UNIQUE (id_by_time);

--

-- Name: batch_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE batch

    ADD CONSTRAINT batch_pkey PRIMARY KEY (id);

--

-- Name: client_version_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE client_version

    ADD CONSTRAINT client_version_pkey PRIMARY KEY (id);

--

-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE tnrs

    ADD CONSTRAINT `tnrs_Name_submitted_key` UNIQUE (`Name_submitted`);

--

-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 

--

ALTER TABLE tnrs

    ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, `Name_number`);

--

-- Name: county_centroids_pkey; Type: CONSTRAINT; Schema: geoscrub; Owner: -; Tablespace: 

--

ALTER TABLE county_centroids

    ADD CONSTRAINT county_centroids_pkey PRIMARY KEY (`*row_num`);

--

-- Name: geoscrub_output_pkey; Type: CONSTRAINT; Schema: geoscrub; Owner: -; Tablespace: 

--

ALTER TABLE geoscrub_output

    ADD CONSTRAINT geoscrub_output_pkey PRIMARY KEY (`*row_num`);

--

-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 

--

CREATE INDEX batch_client_version_idx ON batch  (client_version);

--

-- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 

--

--

-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: 

--

--

-- Name: batch__fill; Type: TRIGGER; Schema: TNRS; Owner: -

--

--

-- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: -

--

--

-- Name: batch_client_version_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -

--

ALTER TABLE batch

    ADD CONSTRAINT batch_client_version_fkey FOREIGN KEY (client_version) REFERENCES client_version(id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: batch_download_settings_id_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -

--

ALTER TABLE batch_download_settings

    ADD CONSTRAINT batch_download_settings_id_fkey FOREIGN KEY (id) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: tnrs_batch_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -

--

ALTER TABLE tnrs

    ADD CONSTRAINT tnrs_batch_fkey FOREIGN KEY (batch) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: TNRS; Type: ACL; Schema: -; Owner: -

--

--

-- Name: tnrs; Type: ACL; Schema: TNRS; Owner: -

--

--

-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -

--

--

-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -

--

--

-- Name: taxon_scrub.scrubbed_unique_taxon_name.*; Type: ACL; Schema: TNRS; Owner: -

--

--

-- Name: taxon_scrub; Type: ACL; Schema: TNRS; Owner: -

--

--

-- PostgreSQL database dump complete

--

--

-- PostgreSQL database dump

--

SET statement_timeout = 0;

SET lock_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

SET check_function_bodies = false;

SET client_min_messages = warning;

--

-- Name: public_validations; Type: SCHEMA; Schema: -; Owner: -

--

CREATE SCHEMA public_validations;

--

-- Name: SCHEMA public_validations; Type: COMMENT; Schema: -; Owner: -

--

COMMENT ON SCHEMA public_validations IS '

aggregating validations queries

to run the validations on all datasources:

SELECT public_validations.remake_diff_tables();

to run the validations on a particular datasource:

SELECT public_validations.remake_diff_tables(''datasource'');

to run a particular validations query for a datasource:

SELECT public_validations.remake_diff_table(''"datasource"._view_name'');

to reset the queries to what''s in schemas/vegbien.sql:

SELECT public_validations.rm_output_queries();

run the portion of schemas/vegbien.sql from

SET search_path = public_validations, pg_catalog;

to the last _* view

**IMPORTANT**: run every `CREATE TYPE` with a comment containing "custom"

to remove a validations query so its columns can be changed:

SELECT public_validations.rm_output_queries(''public_validations._view_name'');

	-- not rm_query_view() because that also removes input queries

to change the key and value columns for a validations query:

DROP   TYPE public_validations."keys_~type._view_name"    CASCADE;

CREATE TYPE public_validations."keys_~type._view_name"    AS (key_cols);

DROP   TYPE public_validations."values__~type._view_name" CASCADE;

CREATE TYPE public_validations."values__~type._view_name" AS (value_cols);

SELECT public_validations.remake_diff_table(''"datasource"._view_name'');

to reset the key and value columns for all validations queries:

SELECT public_validations.rm_output_queries();

reset the queries to what''s in schemas/vegbien.sql, as described above

SELECT public_validations.remake_diff_tables();

';

SET search_path = public, pg_catalog;

--

-- Name: accesslevel; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE accesslevel AS ENUM (

    'private',

    'metadata only',

    'data by request',

    'public'

);

--

-- Name: coordinatesource; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE coordinatesource AS ENUM (

    'source data',

    'GPS',

    'georeferencing'

);

--

-- Name: TYPE coordinatesource; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE coordinatesource IS '

From <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore_data_dictionary#coordinateSource>

';

--

-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE establishmentmeans_dwc AS ENUM (

    'cultivated',

    'wild',

    'native',

    'exotic',

    'invasive',

    'escaped from captivity'

);

--

-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE establishmentmeans_dwc IS '

See <http://rs.tdwg.org/dwc/terms/#establishmentMeans>

';

--

-- Name: growthform; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE growthform AS ENUM (

    'tree',

    'shrub',

    'liana',

    'vine',

    'herb',

    'hemiepiphyte',

    'epiphyte',

    'grass',

    'forb',

    'moss',

    'lichen',

    'fungus',

    'floating aquatic',

    'submerged aquatic'

);

--

-- Name: higher_plant_group; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE higher_plant_group AS ENUM (

    'all',

    'bryophytes',

    'ferns and allies',

    'flowering plants',

    'gymnosperms (conifers)',

    'gymnosperms (non-conifer)'

);

--

-- Name: observationtype; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE observationtype AS ENUM (

    'plot',

    'specimen'

);

--

-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE occurrencestatus_dwc AS ENUM (

    'present',

    'absent',

    'common',

    'irregular',

    'rare',

    'doubtful'

);

--

-- Name: placerank; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE placerank AS ENUM (

    'continent',

    'waterBody',

    'islandGroup',

    'island',

    'country',

    'territory',

    'region',

    'stateProvince',

    'county',

    'municipality',

    'village',

    'site'

);

--

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

--

COMMENT ON TYPE placerank IS '

county = parish, canton

municipality = city

From <http://rs.tdwg.org/dwc/terms/#dcindex#dcterms:Location>, <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1415&entity=dba_fielddescription&params=1415>

';

--

-- Name: rankedplacename; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE rankedplacename AS (

	rank placerank,

	verbatimrank text,

	placename text

);

--

-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE taxonrank AS ENUM (

    'unknown',

    'suprageneric',

    'domain',

    'superkingdom',

    'kingdom',

    'subkingdom',

    'infrakingdom',

    'superphylum',

    'phylum',

    'subphylum',

    'infraphylum',

    'superclass',

    'class',

    'subclass',

    'infraclass',

    'superorder',

    'order',

    'suborder',

    'infraorder',

    'family group',

    'superfamily',

    'family',

    'subfamily',

    'infrafamily',

    'family subdivision',

    'supertribe',

    'tribe',

    'subtribe',

    'infratribe',

    'genus group',

    'genus',

    'subgenus',

    'infragenus',

    'genus subdivision',

    'section',

    'subsection',

    'series',

    'subseries',

    'infrageneric',

    'species aggregate',

    'species group',

    'species',

    'subspecies',

    'subspecific aggregate',

    'below subspecies',

    'infraspecies',

    'biovariety',

    'pathovariety',

    'variety',

    'subvariety',

    'subsubvariety',

    'forma',

    'subforma',

    'subsubforma',

    'special forma',

    'infraspecific',

    'candidate',

    'cultivated plants',

    'cultivar',

    'convar',

    'grex',

    'cultivar group',

    'graft-chimaera',

    'denomination class'

);

--

-- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE taxonrank IS '

From <http://www.tdwg.org/standards/117/download/>

';

--

-- Name: rankedtaxonname; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE rankedtaxonname AS (

	rank taxonrank,

	verbatimrank text,

	taxonname text

);

--

-- Name: relationship; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE relationship AS ENUM (

    'is congruent to',

    'is not congruent to',

    'is included in',

    'is not included in',

    'overlaps',

    'does not overlap',

    'is child taxon of',

    'is anamorph of',

    'is teleomorph of',

    'is hybrid child of',

    'is ambiregnal of',

    'is vernacular for'

);

--

-- Name: role; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE role AS ENUM (

    'unknown',

    'advisor',

    'author',

    'co-principal investigator',

    'collector',

    'computer',

    'contact',

    'contributor',

    'custodian/steward',

    'editor',

    'identifier',

    'originator',

    'performer',

    'principal investigator',

    'recipient',

    'reviewer',

    'technician'

);

--

-- Name: TYPE role; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE role IS '

From <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1331&entity=dba_fielddescription&params=1331>, <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=projectcontributor&entity=dba_tabledescription&where=where_tablename#ROLE_ID>, and misc terms.

';

--

-- Name: schema_anchor; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE schema_anchor AS (

);

--

-- Name: TYPE schema_anchor; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE schema_anchor IS 'used with schema_anchor params';

--

-- Name: sourcetype; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE sourcetype AS ENUM (

    'herbarium',

    'primary database',

    'aggregator',

    'book',

    'article',

    'chapter',

    'conference proceedings',

    'dissertation',

    'edited book',

    'generic',

    'journal',

    'manuscript',

    'personal communication',

    'presentation',

    'report',

    'thesis',

    'website'

);

--

-- Name: TYPE sourcetype; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE sourcetype IS '

From <https://projects.nceas.ucsb.edu/nceas/attachments/download/428/bien_web_datasource_schema.sql>, <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1300&entity=dba_fielddescription&params=1300>, <http://vegbiendev.nceas.ucsb.edu/phppgadmin/display.php?server=localhost%3A5432%3Aallow&database=vegbien&schema=VegBank&table=source&subject=table#sourcetype>

';

--

-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE taxonclass AS ENUM (

    'tree',

    'shrub',

    'liana',

    'vine',

    'herb',

    'hemiepiphyte',

    'epiphyte',

    'grass',

    'forb',

    'moss',

    'lichen',

    'fungus',

    'floating aquatic',

    'submerged aquatic',

    'cultivated',

    'wild',

    'native',

    'exotic',

    'invasive',

    'escaped from captivity',

    'dominant',

    'vascular',

    'woody'

);

--

-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE taxonclass IS '

= growthform + establishmentmeans_dwc + some others

';

--

-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE taxonomic_status AS ENUM (

    'No opinion',

    'Accepted',

    'Synonym',

    'Illegitimate',

    'Invalid'

);

--

-- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TYPE taxonomic_status IS '

See <http://tnrs.iplantcollaborative.org/instructions.html#Status>

';

SET search_path = public_validations, pg_catalog;

--

-- Name: keys_~type._plots_01_count_of_projects; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_01_count_of_projects" AS (

);

--

-- Name: keys_~type._plots_02_list_of_project_names; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_02_list_of_project_names" AS (

	project_name text

);

--

-- Name: keys_~type._plots_03_count_of_all_plots_in_this_source; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_03_count_of_all_plots_in_this_source" AS (

);

--

-- Name: keys_~type._plots_04_count_of_plots_in_each_project_in_this_sou; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_04_count_of_plots_in_each_project_in_this_sou" AS (

	project_name text

);

--

-- Name: keys_~type._plots_05_list_of_plot_codes_by_project; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_05_list_of_plot_codes_by_project" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_06_list_of_plots_with_stem_measurements; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_06_list_of_plots_with_stem_measurements" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_06a_list_of_stems; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_06a_list_of_stems" AS (

	project_name text,

	plot_code text,

	stem_id text

);

--

-- Name: keys_~type._plots_07_list_of_plots_which_use_counts_of_indiv_pe; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_07_list_of_plots_which_use_counts_of_indiv_pe" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_08_list_of_plots_which_use_percent_cover; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_08_list_of_plots_which_use_percent_cover" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_09_list_of_plots_which_use_line_intercept; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_09_list_of_plots_which_use_line_intercept" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_10_count_of_individuals_per_plot_in_each_proj; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_10_count_of_individuals_per_plot_in_each_proj" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_10a_aggregate_observation_individual_counts; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_10a_aggregate_observation_individual_counts" AS (

	project_name text,

	plot_code text,

	individual_id text

);

--

-- Name: keys_~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_11_count_of_stems_per_plot_in_each_project" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_pr; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_pr" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plo; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plo" AS (

	project_name text,

	plot_code text,

	taxon text

);

--

-- Name: keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot" AS (

	project_name text,

	plot_code text,

	taxon text

);

--

-- Name: keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_" AS (

	project_name text,

	plot_code text,

	taxon text,

	totalpercentcover double precision

);

--

-- Name: keys_~type._plots_16_intercepts_for_each_verb_taxon_in_each_plo; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_16_intercepts_for_each_verb_taxon_in_each_plo" AS (

	project_name text,

	plot_code text,

	taxon text

);

--

-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec" AS (

	project_name text,

	plot_code text

);

--

-- Name: keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e" AS (

	project_name text,

	plot_code text,

	subplot_code text

);

--

-- Name: keys_~type._plots_19_count_of_censuses_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_19_count_of_censuses_per_plot_in_each_project" AS (

	project_name text,

	plot_code text

);

--

-- Name: TYPE "keys_~type._plots_19_count_of_censuses_per_plot_in_each_project"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._plots_19_count_of_censuses_per_plot_in_each_project" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_01_count_of_total_records_specimens_in_so; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_01_count_of_total_records_specimens_in_so" AS (

);

--

-- Name: TYPE "keys_~type._specimens_01_count_of_total_records_specimens_in_so"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_01_count_of_total_records_specimens_in_so" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_02_count_of_unique_verbatim_families; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families" AS (

);

--

-- Name: TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_03_list_of_verbatim_families; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_03_list_of_verbatim_families" AS (

	family text

);

--

-- Name: TYPE "keys_~type._specimens_03_list_of_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_03_list_of_verbatim_families" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_04_count_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_04_count_of_species_binomials" AS (

);

--

-- Name: TYPE "keys_~type._specimens_04_count_of_species_binomials"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_04_count_of_species_binomials" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_05_list_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_05_list_of_species_binomials" AS (

	species_binomial text

);

--

-- Name: TYPE "keys_~type._specimens_05_list_of_species_binomials"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_05_list_of_species_binomials" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a" AS (

);

--

-- Name: TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w" AS (

);

--

-- Name: TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_10_count_number_of_records_by_institution; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_10_count_number_of_records_by_institution" AS (

	specimen_duplicate_institutions text

);

--

-- Name: TYPE "keys_~type._specimens_10_count_number_of_records_by_institution"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_10_count_number_of_records_by_institution" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_11_list_of_three_standard_political_divis; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" AS (

	country text,

	"stateProvince" text,

	county text

);

--

-- Name: TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" IS '

autogenerated

';

--

-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da" AS (

	"collectorName" text,

	"collectionNumber" text,

	"dateCollected" text

);

--

-- Name: TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da" IS '