Revision 13063
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 5079 | 5079 |
|
| 5080 | 5080 |
|
| 5081 | 5081 |
-- |
| 5082 |
-- Name: VIEW _specimens_01_count_of_total_records_specimens_in_source_db; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 5083 |
-- |
|
| 5084 |
|
|
| 5085 |
|
|
| 5086 |
|
|
| 5087 |
|
|
| 5088 |
-- |
|
| 5089 |
-- Name: _specimens_02_count_of_unique_verbatim_families; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5090 |
-- |
|
| 5091 |
|
|
| 5092 |
|
|
| 5093 |
|
|
| 5094 |
|
|
| 5095 |
-- |
|
| 5096 |
-- Name: _specimens_03_list_of_verbatim_families; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5097 |
-- |
|
| 5098 |
|
|
| 5099 |
|
|
| 5100 |
|
|
| 5101 |
|
|
| 5102 |
-- |
|
| 5103 |
-- Name: _specimens_04_count_of_species_binomials; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5104 |
-- |
|
| 5105 |
|
|
| 5106 |
|
|
| 5107 |
|
|
| 5108 |
|
|
| 5109 |
-- |
|
| 5110 |
-- Name: _specimens_05_list_of_species_binomials; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5111 |
-- |
|
| 5112 |
|
|
| 5113 |
|
|
| 5114 |
|
|
| 5115 |
|
|
| 5116 |
-- |
|
| 5117 |
-- Name: _specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5118 |
-- |
|
| 5119 |
|
|
| 5120 |
|
|
| 5121 |
|
|
| 5122 |
|
|
| 5123 |
-- |
|
| 5124 |
-- Name: _specimens_07_list_of_verbatim_subspecific_taxa_with_author; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5125 |
-- |
|
| 5126 |
|
|
| 5127 |
|
|
| 5128 |
|
|
| 5129 |
|
|
| 5130 |
-- |
|
| 5131 |
-- Name: _specimens_08_count_of_unique_verbatim_author_taxa_with_genus; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5132 |
-- |
|
| 5133 |
|
|
| 5134 |
|
|
| 5135 |
|
|
| 5136 |
|
|
| 5137 |
-- |
|
| 5138 |
-- Name: _specimens_09_list_of_unique_verbatim_author_taxa_with_genus; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5139 |
-- |
|
| 5140 |
|
|
| 5141 |
|
|
| 5142 |
|
|
| 5143 |
|
|
| 5144 |
-- |
|
| 5145 |
-- Name: _specimens_10_count_number_of_records_by_institution; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5146 |
-- |
|
| 5147 |
|
|
| 5148 |
|
|
| 5149 |
|
|
| 5150 |
|
|
| 5151 |
-- |
|
| 5152 |
-- Name: _specimens_11_list_of_three_standard_political_divisions; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5153 |
-- |
|
| 5154 |
|
|
| 5155 |
|
|
| 5156 |
|
|
| 5157 |
|
|
| 5158 |
-- |
|
| 5159 |
-- Name: _specimens_12_distinct_collector_name_collect_num_date_w_count; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5160 |
-- |
|
| 5161 |
|
|
| 5162 |
|
|
| 5163 |
|
|
| 5164 |
|
|
| 5165 |
-- |
|
| 5166 |
-- Name: _specimens_13_count_of_all_verbatim_and_decimal_lat_long; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5167 |
-- |
|
| 5168 |
|
|
| 5169 |
|
|
| 5170 |
|
|
| 5171 |
|
|
| 5172 |
-- |
|
| 5173 |
-- Name: _specimens_14_count_of_all_invalid_verbatim_lat_long; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5174 |
-- |
|
| 5175 |
|
|
| 5176 |
|
|
| 5177 |
|
|
| 5178 |
|
|
| 5179 |
-- |
|
| 5180 |
-- Name: _specimens_15_list_distinct_locality_descriptions; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5181 |
-- |
|
| 5182 |
|
|
| 5183 |
|
|
| 5184 |
|
|
| 5185 |
|
|
| 5186 |
-- |
|
| 5187 |
-- Name: _specimens_16_list_distinct_specimen_descriptions; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5188 |
-- |
|
| 5189 |
|
|
| 5190 |
|
|
| 5191 |
|
|
| 5192 |
|
|
| 5193 |
-- |
|
| 5082 | 5194 |
-- Name: _traits_01_count_records; Type: VIEW; Schema: public_validations; Owner: - |
| 5083 | 5195 |
-- |
| 5084 | 5196 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validations: added specimens queries to pipeline