Revision 14643
Added by Aaron Marcuse-Kubitza about 10 years ago
| vegbien.sql | ||
|---|---|---|
| 11412 | 11412 |
view_full_occurrence_individual.individual_organism_observation_id, |
| 11413 | 11413 |
view_full_occurrence_individual.individual_id, |
| 11414 | 11414 |
view_full_occurrence_individual.individual_count, |
| 11415 |
view_full_occurrence_individual.plantobservation_id |
|
| 11415 |
view_full_occurrence_individual.plantobservation_id, |
|
| 11416 |
view_full_occurrence_individual.taxonobservation_id |
|
| 11416 | 11417 |
FROM view_full_occurrence_individual |
| 11417 | 11418 |
WHERE (view_full_occurrence_individual.datasource = 'CVS'::text); |
| 11418 | 11419 |
|
| ... | ... | |
| 11498 | 11499 |
view_full_occurrence_individual.individual_organism_observation_id, |
| 11499 | 11500 |
view_full_occurrence_individual.individual_id, |
| 11500 | 11501 |
view_full_occurrence_individual.individual_count, |
| 11501 |
view_full_occurrence_individual.plantobservation_id |
|
| 11502 |
view_full_occurrence_individual.plantobservation_id, |
|
| 11503 |
view_full_occurrence_individual.taxonobservation_id |
|
| 11502 | 11504 |
FROM view_full_occurrence_individual |
| 11503 | 11505 |
WHERE (view_full_occurrence_individual.datasource = 'NCU'::text); |
| 11504 | 11506 |
|
| ... | ... | |
| 11584 | 11586 |
view_full_occurrence_individual.individual_organism_observation_id, |
| 11585 | 11587 |
view_full_occurrence_individual.individual_id, |
| 11586 | 11588 |
view_full_occurrence_individual.individual_count, |
| 11587 |
view_full_occurrence_individual.plantobservation_id |
|
| 11589 |
view_full_occurrence_individual.plantobservation_id, |
|
| 11590 |
view_full_occurrence_individual.taxonobservation_id |
|
| 11588 | 11591 |
FROM view_full_occurrence_individual |
| 11589 | 11592 |
WHERE (view_full_occurrence_individual.datasource = 'VegBank'::text); |
| 11590 | 11593 |
|
| ... | ... | |
| 11677 | 11680 |
|
| 11678 | 11681 |
|
| 11679 | 11682 |
-- |
| 11683 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE; Schema: public; Owner: - |
|
| 11684 |
-- |
|
| 11685 |
|
|
| 11686 |
CREATE SEQUENCE view_full_occurrence_individual__new_taxonobservation_id_seq1 |
|
| 11687 |
START WITH 1 |
|
| 11688 |
INCREMENT BY 1 |
|
| 11689 |
NO MINVALUE |
|
| 11690 |
NO MAXVALUE |
|
| 11691 |
CACHE 1; |
|
| 11692 |
|
|
| 11693 |
|
|
| 11694 |
-- |
|
| 11695 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 11696 |
-- |
|
| 11697 |
|
|
| 11698 |
ALTER SEQUENCE view_full_occurrence_individual__new_taxonobservation_id_seq1 OWNED BY view_full_occurrence_individual.taxonobservation_id; |
|
| 11699 |
|
|
| 11700 |
|
|
| 11701 |
-- |
|
| 11680 | 11702 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: - |
| 11681 | 11703 |
-- |
| 11682 | 11704 |
|
| ... | ... | |
| 11755 | 11777 |
|
| 11756 | 11778 |
|
| 11757 | 11779 |
-- |
| 11758 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 11759 |
-- |
|
| 11760 |
|
|
| 11761 |
CREATE SEQUENCE view_full_occurrence_individual_taxonobservation_id_seq |
|
| 11762 |
START WITH 1 |
|
| 11763 |
INCREMENT BY 1 |
|
| 11764 |
NO MINVALUE |
|
| 11765 |
NO MAXVALUE |
|
| 11766 |
CACHE 1; |
|
| 11767 |
|
|
| 11768 |
|
|
| 11769 |
-- |
|
| 11770 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 11771 |
-- |
|
| 11772 |
|
|
| 11773 |
ALTER SEQUENCE view_full_occurrence_individual_taxonobservation_id_seq OWNED BY view_full_occurrence_individual.taxonobservation_id; |
|
| 11774 |
|
|
| 11775 |
|
|
| 11776 |
-- |
|
| 11777 | 11780 |
-- Name: view_full_occurrence_individual_view; Type: VIEW; Schema: public; Owner: - |
| 11778 | 11781 |
-- |
| 11779 | 11782 |
|
| ... | ... | |
| 13677 | 13680 |
-- Name: taxonobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 13678 | 13681 |
-- |
| 13679 | 13682 |
|
| 13680 |
ALTER TABLE ONLY view_full_occurrence_individual ALTER COLUMN taxonobservation_id SET DEFAULT nextval('view_full_occurrence_individual_taxonobservation_id_seq'::regclass);
|
|
| 13683 |
ALTER TABLE ONLY view_full_occurrence_individual ALTER COLUMN taxonobservation_id SET DEFAULT nextval('view_full_occurrence_individual__new_taxonobservation_id_seq1'::regclass);
|
|
| 13681 | 13684 |
|
| 13682 | 13685 |
|
| 13683 | 13686 |
-- |
| ... | ... | |
| 16058 | 16061 |
|
| 16059 | 16062 |
|
| 16060 | 16063 |
-- |
| 16061 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 16064 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 16062 | 16065 |
-- |
| 16063 | 16066 |
|
| 16064 | 16067 |
|
| ... | ... | |
| 16986 | 16989 |
|
| 16987 | 16990 |
|
| 16988 | 16991 |
-- |
| 16989 |
-- Name: view_full_occurrence_individual_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 16992 |
-- Name: view_full_occurrence_individual__new_pkey1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 16990 | 16993 |
-- |
| 16991 | 16994 |
|
| 16992 | 16995 |
ALTER TABLE ONLY view_full_occurrence_individual |
| 16993 |
ADD CONSTRAINT view_full_occurrence_individual_pkey PRIMARY KEY (taxonobservation_id);
|
|
| 16996 |
ADD CONSTRAINT view_full_occurrence_individual__new_pkey1 PRIMARY KEY (taxonobservation_id);
|
|
| 16994 | 16997 |
|
| 16995 | 16998 |
|
| 16996 | 16999 |
-- |
| ... | ... | |
| 18137 | 18140 |
|
| 18138 | 18141 |
|
| 18139 | 18142 |
-- |
| 18140 |
-- Name: view_full_occurrence_individual_datasource_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18143 |
-- Name: view_full_occurrence_individual___datasource_occurrence_id_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18141 | 18144 |
-- |
| 18142 | 18145 |
|
| 18143 |
CREATE INDEX view_full_occurrence_individual_datasource_idx ON view_full_occurrence_individual USING btree (datasource);
|
|
| 18146 |
CREATE INDEX view_full_occurrence_individual___datasource_occurrence_id_idx1 ON view_full_occurrence_individual USING btree (datasource, occurrence_id);
|
|
| 18144 | 18147 |
|
| 18145 | 18148 |
|
| 18146 | 18149 |
-- |
| 18147 |
-- Name: view_full_occurrence_individual_datasource_occurrence_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18150 |
-- Name: view_full_occurrence_individual__new_datasource_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18148 | 18151 |
-- |
| 18149 | 18152 |
|
| 18150 |
CREATE INDEX view_full_occurrence_individual_datasource_occurrence_id_idx ON view_full_occurrence_individual USING btree (datasource, occurrence_id);
|
|
| 18153 |
CREATE INDEX view_full_occurrence_individual__new_datasource_idx1 ON view_full_occurrence_individual USING btree (datasource);
|
|
| 18151 | 18154 |
|
| 18152 | 18155 |
|
| 18153 | 18156 |
-- |
| 18154 |
-- Name: view_full_occurrence_individual_date_collected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18157 |
-- Name: view_full_occurrence_individual__new_date_collected_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18155 | 18158 |
-- |
| 18156 | 18159 |
|
| 18157 |
CREATE INDEX view_full_occurrence_individual_date_collected_idx ON view_full_occurrence_individual USING btree (date_collected);
|
|
| 18160 |
CREATE INDEX view_full_occurrence_individual__new_date_collected_idx1 ON view_full_occurrence_individual USING btree (date_collected);
|
|
| 18158 | 18161 |
|
| 18159 | 18162 |
|
| 18160 | 18163 |
-- |
| 18161 |
-- Name: view_full_occurrence_individual_event_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18164 |
-- Name: view_full_occurrence_individual__new_event_date_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18162 | 18165 |
-- |
| 18163 | 18166 |
|
| 18164 |
CREATE INDEX view_full_occurrence_individual_event_date_idx ON view_full_occurrence_individual USING btree (event_date);
|
|
| 18167 |
CREATE INDEX view_full_occurrence_individual__new_event_date_idx1 ON view_full_occurrence_individual USING btree (event_date);
|
|
| 18165 | 18168 |
|
| 18166 | 18169 |
|
| 18167 | 18170 |
-- |
| 18168 |
-- Name: view_full_occurrence_individual_is_cultivated_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18171 |
-- Name: view_full_occurrence_individual__new_is_cultivated_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18169 | 18172 |
-- |
| 18170 | 18173 |
|
| 18171 |
CREATE INDEX view_full_occurrence_individual_is_cultivated_idx ON view_full_occurrence_individual USING btree (is_cultivated);
|
|
| 18174 |
CREATE INDEX view_full_occurrence_individual__new_is_cultivated_idx1 ON view_full_occurrence_individual USING btree (is_cultivated);
|
|
| 18172 | 18175 |
|
| 18173 | 18176 |
|
| 18174 | 18177 |
-- |
| 18175 |
-- Name: view_full_occurrence_individual_is_geovalid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18178 |
-- Name: view_full_occurrence_individual__new_is_geovalid_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18176 | 18179 |
-- |
| 18177 | 18180 |
|
| 18178 |
CREATE INDEX view_full_occurrence_individual_is_geovalid_idx ON view_full_occurrence_individual USING btree (is_geovalid);
|
|
| 18181 |
CREATE INDEX view_full_occurrence_individual__new_is_geovalid_idx1 ON view_full_occurrence_individual USING btree (is_geovalid);
|
|
| 18179 | 18182 |
|
| 18180 | 18183 |
|
| 18181 | 18184 |
-- |
| 18182 |
-- Name: view_full_occurrence_individual_is_new_world_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18185 |
-- Name: view_full_occurrence_individual__new_is_new_world_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18183 | 18186 |
-- |
| 18184 | 18187 |
|
| 18185 |
CREATE INDEX view_full_occurrence_individual_is_new_world_idx ON view_full_occurrence_individual USING btree (is_new_world);
|
|
| 18188 |
CREATE INDEX view_full_occurrence_individual__new_is_new_world_idx1 ON view_full_occurrence_individual USING btree (is_new_world);
|
|
| 18186 | 18189 |
|
| 18187 | 18190 |
|
| 18188 | 18191 |
-- |
| 18189 |
-- Name: view_full_occurrence_individual_latitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18192 |
-- Name: view_full_occurrence_individual__new_latitude_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18190 | 18193 |
-- |
| 18191 | 18194 |
|
| 18192 |
CREATE INDEX view_full_occurrence_individual_latitude_idx ON view_full_occurrence_individual USING btree (latitude);
|
|
| 18195 |
CREATE INDEX view_full_occurrence_individual__new_latitude_idx1 ON view_full_occurrence_individual USING btree (latitude);
|
|
| 18193 | 18196 |
|
| 18194 | 18197 |
|
| 18195 | 18198 |
-- |
| 18196 |
-- Name: view_full_occurrence_individual_longitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18199 |
-- Name: view_full_occurrence_individual__new_longitude_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18197 | 18200 |
-- |
| 18198 | 18201 |
|
| 18199 |
CREATE INDEX view_full_occurrence_individual_longitude_idx ON view_full_occurrence_individual USING btree (longitude);
|
|
| 18202 |
CREATE INDEX view_full_occurrence_individual__new_longitude_idx1 ON view_full_occurrence_individual USING btree (longitude);
|
|
| 18200 | 18203 |
|
| 18201 | 18204 |
|
| 18202 | 18205 |
-- |
| 18203 |
-- Name: view_full_occurrence_individual_plot_area_ha_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18206 |
-- Name: view_full_occurrence_individual__new_plot_area_ha_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18204 | 18207 |
-- |
| 18205 | 18208 |
|
| 18206 |
CREATE INDEX view_full_occurrence_individual_plot_area_ha_idx ON view_full_occurrence_individual USING btree (plot_area_ha);
|
|
| 18209 |
CREATE INDEX view_full_occurrence_individual__new_plot_area_ha_idx1 ON view_full_occurrence_individual USING btree (plot_area_ha);
|
|
| 18207 | 18210 |
|
| 18208 | 18211 |
|
| 18209 | 18212 |
-- |
| 18210 |
-- Name: view_full_occurrence_individual_scrubbed_species_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18213 |
-- Name: view_full_occurrence_individual__new_taxonomic_status_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18211 | 18214 |
-- |
| 18212 | 18215 |
|
| 18213 |
CREATE INDEX view_full_occurrence_individual_scrubbed_species_binomial_idx ON view_full_occurrence_individual USING btree (scrubbed_species_binomial);
|
|
| 18216 |
CREATE INDEX view_full_occurrence_individual__new_taxonomic_status_idx1 ON view_full_occurrence_individual USING btree (taxonomic_status);
|
|
| 18214 | 18217 |
|
| 18215 | 18218 |
|
| 18216 | 18219 |
-- |
| 18217 |
-- Name: view_full_occurrence_individual_taxonomic_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18220 |
-- Name: view_full_occurrence_individual__scrubbed_species_binomial_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 18218 | 18221 |
-- |
| 18219 | 18222 |
|
| 18220 |
CREATE INDEX view_full_occurrence_individual_taxonomic_status_idx ON view_full_occurrence_individual USING btree (taxonomic_status);
|
|
| 18223 |
CREATE INDEX view_full_occurrence_individual__scrubbed_species_binomial_idx1 ON view_full_occurrence_individual USING btree (scrubbed_species_binomial);
|
|
| 18221 | 18224 |
|
| 18222 | 18225 |
|
| 18223 | 18226 |
-- |
Also available in: Unified diff
schemas/public_.sql: view_full_occurrence_individual: re-ran view_full_occurrence_individual_view_modify(), which uses the new non-blocking rematerialize_view()