Revision 14643
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 7867 | 7867 |
|
| 7868 | 7868 |
|
| 7869 | 7869 |
-- |
| 7870 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 7870 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7871 | 7871 |
-- |
| 7872 | 7872 |
|
| 7873 | 7873 |
|
| 7874 | 7874 |
|
| 7875 | 7875 |
|
| 7876 | 7876 |
-- |
| 7877 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7877 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7878 | 7878 |
-- |
| 7879 | 7879 |
|
| 7880 | 7880 |
|
| 7881 | 7881 |
|
| 7882 | 7882 |
|
| 7883 | 7883 |
-- |
| 7884 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7884 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 7885 | 7885 |
-- |
| 7886 | 7886 |
|
| 7887 | 7887 |
|
| ... | ... | |
| 11624 | 11624 |
|
| 11625 | 11625 |
|
| 11626 | 11626 |
-- |
| 11627 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 11627 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 11628 | 11628 |
-- |
| 11629 | 11629 |
|
| 11630 | 11630 |
|
| ... | ... | |
| 12552 | 12552 |
|
| 12553 | 12553 |
|
| 12554 | 12554 |
-- |
| 12555 |
-- Name: view_full_occurrence_individual_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 12555 |
-- Name: view_full_occurrence_individual__new_pkey1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 12556 | 12556 |
-- |
| 12557 | 12557 |
|
| 12558 | 12558 |
ALTER TABLE view_full_occurrence_individual |
| 12559 |
ADD CONSTRAINT view_full_occurrence_individual_pkey PRIMARY KEY (taxonobservation_id);
|
|
| 12559 |
ADD CONSTRAINT view_full_occurrence_individual__new_pkey1 PRIMARY KEY (taxonobservation_id);
|
|
| 12560 | 12560 |
|
| 12561 | 12561 |
|
| 12562 | 12562 |
-- |
| ... | ... | |
| 13703 | 13703 |
|
| 13704 | 13704 |
|
| 13705 | 13705 |
-- |
| 13706 |
-- Name: view_full_occurrence_individual_datasource_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13706 |
-- Name: view_full_occurrence_individual___datasource_occurrence_id_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13707 | 13707 |
-- |
| 13708 | 13708 |
|
| 13709 |
CREATE INDEX view_full_occurrence_individual_datasource_idx ON view_full_occurrence_individual (datasource);
|
|
| 13709 |
CREATE INDEX view_full_occurrence_individual___datasource_occurrence_id_idx1 ON view_full_occurrence_individual (datasource, occurrence_id);
|
|
| 13710 | 13710 |
|
| 13711 | 13711 |
|
| 13712 | 13712 |
-- |
| 13713 |
-- Name: view_full_occurrence_individual_datasource_occurrence_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13713 |
-- Name: view_full_occurrence_individual__new_datasource_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13714 | 13714 |
-- |
| 13715 | 13715 |
|
| 13716 |
CREATE INDEX view_full_occurrence_individual_datasource_occurrence_id_idx ON view_full_occurrence_individual (datasource, occurrence_id);
|
|
| 13716 |
CREATE INDEX view_full_occurrence_individual__new_datasource_idx1 ON view_full_occurrence_individual (datasource);
|
|
| 13717 | 13717 |
|
| 13718 | 13718 |
|
| 13719 | 13719 |
-- |
| 13720 |
-- Name: view_full_occurrence_individual_date_collected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13720 |
-- Name: view_full_occurrence_individual__new_date_collected_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13721 | 13721 |
-- |
| 13722 | 13722 |
|
| 13723 |
CREATE INDEX view_full_occurrence_individual_date_collected_idx ON view_full_occurrence_individual (date_collected);
|
|
| 13723 |
CREATE INDEX view_full_occurrence_individual__new_date_collected_idx1 ON view_full_occurrence_individual (date_collected);
|
|
| 13724 | 13724 |
|
| 13725 | 13725 |
|
| 13726 | 13726 |
-- |
| 13727 |
-- Name: view_full_occurrence_individual_event_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13727 |
-- Name: view_full_occurrence_individual__new_event_date_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13728 | 13728 |
-- |
| 13729 | 13729 |
|
| 13730 |
CREATE INDEX view_full_occurrence_individual_event_date_idx ON view_full_occurrence_individual (event_date);
|
|
| 13730 |
CREATE INDEX view_full_occurrence_individual__new_event_date_idx1 ON view_full_occurrence_individual (event_date);
|
|
| 13731 | 13731 |
|
| 13732 | 13732 |
|
| 13733 | 13733 |
-- |
| 13734 |
-- Name: view_full_occurrence_individual_is_cultivated_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13734 |
-- Name: view_full_occurrence_individual__new_is_cultivated_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13735 | 13735 |
-- |
| 13736 | 13736 |
|
| 13737 |
CREATE INDEX view_full_occurrence_individual_is_cultivated_idx ON view_full_occurrence_individual (is_cultivated);
|
|
| 13737 |
CREATE INDEX view_full_occurrence_individual__new_is_cultivated_idx1 ON view_full_occurrence_individual (is_cultivated);
|
|
| 13738 | 13738 |
|
| 13739 | 13739 |
|
| 13740 | 13740 |
-- |
| 13741 |
-- Name: view_full_occurrence_individual_is_geovalid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13741 |
-- Name: view_full_occurrence_individual__new_is_geovalid_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13742 | 13742 |
-- |
| 13743 | 13743 |
|
| 13744 |
CREATE INDEX view_full_occurrence_individual_is_geovalid_idx ON view_full_occurrence_individual (is_geovalid);
|
|
| 13744 |
CREATE INDEX view_full_occurrence_individual__new_is_geovalid_idx1 ON view_full_occurrence_individual (is_geovalid);
|
|
| 13745 | 13745 |
|
| 13746 | 13746 |
|
| 13747 | 13747 |
-- |
| 13748 |
-- Name: view_full_occurrence_individual_is_new_world_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13748 |
-- Name: view_full_occurrence_individual__new_is_new_world_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13749 | 13749 |
-- |
| 13750 | 13750 |
|
| 13751 |
CREATE INDEX view_full_occurrence_individual_is_new_world_idx ON view_full_occurrence_individual (is_new_world);
|
|
| 13751 |
CREATE INDEX view_full_occurrence_individual__new_is_new_world_idx1 ON view_full_occurrence_individual (is_new_world);
|
|
| 13752 | 13752 |
|
| 13753 | 13753 |
|
| 13754 | 13754 |
-- |
| 13755 |
-- Name: view_full_occurrence_individual_latitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13755 |
-- Name: view_full_occurrence_individual__new_latitude_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13756 | 13756 |
-- |
| 13757 | 13757 |
|
| 13758 |
CREATE INDEX view_full_occurrence_individual_latitude_idx ON view_full_occurrence_individual (latitude);
|
|
| 13758 |
CREATE INDEX view_full_occurrence_individual__new_latitude_idx1 ON view_full_occurrence_individual (latitude);
|
|
| 13759 | 13759 |
|
| 13760 | 13760 |
|
| 13761 | 13761 |
-- |
| 13762 |
-- Name: view_full_occurrence_individual_longitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13762 |
-- Name: view_full_occurrence_individual__new_longitude_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13763 | 13763 |
-- |
| 13764 | 13764 |
|
| 13765 |
CREATE INDEX view_full_occurrence_individual_longitude_idx ON view_full_occurrence_individual (longitude);
|
|
| 13765 |
CREATE INDEX view_full_occurrence_individual__new_longitude_idx1 ON view_full_occurrence_individual (longitude);
|
|
| 13766 | 13766 |
|
| 13767 | 13767 |
|
| 13768 | 13768 |
-- |
| 13769 |
-- Name: view_full_occurrence_individual_plot_area_ha_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13769 |
-- Name: view_full_occurrence_individual__new_plot_area_ha_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13770 | 13770 |
-- |
| 13771 | 13771 |
|
| 13772 |
CREATE INDEX view_full_occurrence_individual_plot_area_ha_idx ON view_full_occurrence_individual (plot_area_ha);
|
|
| 13772 |
CREATE INDEX view_full_occurrence_individual__new_plot_area_ha_idx1 ON view_full_occurrence_individual (plot_area_ha);
|
|
| 13773 | 13773 |
|
| 13774 | 13774 |
|
| 13775 | 13775 |
-- |
| 13776 |
-- Name: view_full_occurrence_individual_scrubbed_species_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13776 |
-- Name: view_full_occurrence_individual__new_taxonomic_status_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13777 | 13777 |
-- |
| 13778 | 13778 |
|
| 13779 |
CREATE INDEX view_full_occurrence_individual_scrubbed_species_binomial_idx ON view_full_occurrence_individual (scrubbed_species_binomial);
|
|
| 13779 |
CREATE INDEX view_full_occurrence_individual__new_taxonomic_status_idx1 ON view_full_occurrence_individual (taxonomic_status);
|
|
| 13780 | 13780 |
|
| 13781 | 13781 |
|
| 13782 | 13782 |
-- |
| 13783 |
-- Name: view_full_occurrence_individual_taxonomic_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13783 |
-- Name: view_full_occurrence_individual__scrubbed_species_binomial_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13784 | 13784 |
-- |
| 13785 | 13785 |
|
| 13786 |
CREATE INDEX view_full_occurrence_individual_taxonomic_status_idx ON view_full_occurrence_individual (taxonomic_status);
|
|
| 13786 |
CREATE INDEX view_full_occurrence_individual__scrubbed_species_binomial_idx1 ON view_full_occurrence_individual (scrubbed_species_binomial);
|
|
| 13787 | 13787 |
|
| 13788 | 13788 |
|
| 13789 | 13789 |
-- |
| trunk/schemas/public_.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 |
-- |
| trunk/schemas/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()