Revision 14487
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 5310 | 5310 |
|
| 5311 | 5311 |
|
| 5312 | 5312 |
-- |
| 5313 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 5314 |
-- |
|
| 5315 |
|
|
| 5316 |
|
|
| 5317 |
|
|
| 5318 |
|
|
| 5319 |
-- |
|
| 5320 |
-- Name: analytical_stem_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 5321 |
-- |
|
| 5322 |
|
|
| 5323 |
|
|
| 5324 |
|
|
| 5325 |
|
|
| 5326 |
-- |
|
| 5313 | 5327 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 5314 | 5328 |
-- |
| 5315 | 5329 |
|
| ... | ... | |
| 8329 | 8343 |
|
| 8330 | 8344 |
|
| 8331 | 8345 |
-- |
| 8346 |
-- Name: view_full_occurrence_individual_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 8347 |
-- |
|
| 8348 |
|
|
| 8349 |
|
|
| 8350 |
|
|
| 8351 |
|
|
| 8352 |
-- |
|
| 8353 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 8354 |
-- |
|
| 8355 |
|
|
| 8356 |
|
|
| 8357 |
|
|
| 8358 |
|
|
| 8359 |
-- |
|
| 8332 | 8360 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 8333 | 8361 |
-- |
| 8334 | 8362 |
|
| ... | ... | |
| 15016 | 15044 |
|
| 15017 | 15045 |
|
| 15018 | 15046 |
-- |
| 15047 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 15048 |
-- |
|
| 15049 |
|
|
| 15050 |
|
|
| 15051 |
|
|
| 15052 |
|
|
| 15053 |
|
|
| 15054 |
|
|
| 15055 |
|
|
| 15056 |
-- |
|
| 15057 |
-- Name: analytical_stem_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 15058 |
-- |
|
| 15059 |
|
|
| 15060 |
|
|
| 15061 |
|
|
| 15062 |
|
|
| 15063 |
|
|
| 15064 |
|
|
| 15065 |
|
|
| 15066 |
-- |
|
| 15019 | 15067 |
-- Name: classcontributor; Type: ACL; Schema: public; Owner: - |
| 15020 | 15068 |
-- |
| 15021 | 15069 |
|
| ... | ... | |
| 15772 | 15820 |
|
| 15773 | 15821 |
|
| 15774 | 15822 |
-- |
| 15823 |
-- Name: view_full_occurrence_individual_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 15824 |
-- |
|
| 15825 |
|
|
| 15826 |
|
|
| 15827 |
|
|
| 15828 |
|
|
| 15829 |
|
|
| 15830 |
|
|
| 15831 |
|
|
| 15832 |
-- |
|
| 15833 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 15834 |
-- |
|
| 15835 |
|
|
| 15836 |
|
|
| 15837 |
|
|
| 15838 |
|
|
| 15839 |
|
|
| 15840 |
|
|
| 15841 |
|
|
| 15842 |
-- |
|
| 15775 | 15843 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 15776 | 15844 |
-- |
| 15777 | 15845 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 7933 | 7933 |
|
| 7934 | 7934 |
|
| 7935 | 7935 |
-- |
| 7936 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 7937 |
-- |
|
| 7938 |
|
|
| 7939 |
CREATE VIEW "analytical_stem_GBIF" AS |
|
| 7940 |
SELECT analytical_stem.datasource, |
|
| 7941 |
analytical_stem.country, |
|
| 7942 |
analytical_stem.state_province, |
|
| 7943 |
analytical_stem.county, |
|
| 7944 |
analytical_stem.locality, |
|
| 7945 |
analytical_stem.latitude, |
|
| 7946 |
analytical_stem.longitude, |
|
| 7947 |
analytical_stem.coord_uncertainty_m, |
|
| 7948 |
analytical_stem.georef_sources, |
|
| 7949 |
analytical_stem.georef_protocol, |
|
| 7950 |
analytical_stem.is_geovalid, |
|
| 7951 |
analytical_stem.is_new_world, |
|
| 7952 |
analytical_stem.project_id, |
|
| 7953 |
analytical_stem.project_contributors, |
|
| 7954 |
analytical_stem.location_id, |
|
| 7955 |
analytical_stem.plot_name, |
|
| 7956 |
analytical_stem.subplot, |
|
| 7957 |
analytical_stem.is_location_cultivated, |
|
| 7958 |
analytical_stem.locationevent_id, |
|
| 7959 |
analytical_stem.event_date, |
|
| 7960 |
analytical_stem.elevation_m, |
|
| 7961 |
analytical_stem.slope_aspect_deg, |
|
| 7962 |
analytical_stem.slope_gradient_deg, |
|
| 7963 |
analytical_stem.plot_area_ha, |
|
| 7964 |
analytical_stem.sampling_protocol, |
|
| 7965 |
analytical_stem.temperature_c, |
|
| 7966 |
analytical_stem.precip_mm, |
|
| 7967 |
analytical_stem.stratum_name, |
|
| 7968 |
analytical_stem.community_concept_name, |
|
| 7969 |
analytical_stem.observation_contributors, |
|
| 7970 |
analytical_stem.custodial_institution_codes, |
|
| 7971 |
analytical_stem.collection_code, |
|
| 7972 |
analytical_stem.catalog_number, |
|
| 7973 |
analytical_stem.occurrence_id, |
|
| 7974 |
analytical_stem.recorded_by, |
|
| 7975 |
analytical_stem.record_number, |
|
| 7976 |
analytical_stem.date_collected, |
|
| 7977 |
analytical_stem.verbatim_family, |
|
| 7978 |
analytical_stem.verbatim_scientific_name, |
|
| 7979 |
analytical_stem.identified_by, |
|
| 7980 |
analytical_stem.date_identified, |
|
| 7981 |
analytical_stem.identification_remarks, |
|
| 7982 |
analytical_stem.family_matched, |
|
| 7983 |
analytical_stem.name_matched, |
|
| 7984 |
analytical_stem.name_matched_author, |
|
| 7985 |
analytical_stem.higher_plant_group, |
|
| 7986 |
analytical_stem.taxonomic_status, |
|
| 7987 |
analytical_stem.scrubbed_family, |
|
| 7988 |
analytical_stem.scrubbed_genus, |
|
| 7989 |
analytical_stem.scrubbed_specific_epithet, |
|
| 7990 |
analytical_stem.scrubbed_species_binomial, |
|
| 7991 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 7992 |
analytical_stem.scrubbed_author, |
|
| 7993 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 7994 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 7995 |
analytical_stem.growth_form, |
|
| 7996 |
analytical_stem.reproductive_condition, |
|
| 7997 |
analytical_stem.is_cultivated, |
|
| 7998 |
analytical_stem.is_cultivated_basis, |
|
| 7999 |
analytical_stem.occurrence_remarks, |
|
| 8000 |
analytical_stem.cover_percent, |
|
| 8001 |
analytical_stem.taxon_observation_id, |
|
| 8002 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8003 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8004 |
analytical_stem.individual_organism_observation_id, |
|
| 8005 |
analytical_stem.individual_id, |
|
| 8006 |
analytical_stem.individual_count, |
|
| 8007 |
analytical_stem.plantobservation_id, |
|
| 8008 |
analytical_stem.taxonobservation_id, |
|
| 8009 |
analytical_stem.stem_dbh_cm, |
|
| 8010 |
analytical_stem.stem_height_m, |
|
| 8011 |
analytical_stem.tag, |
|
| 8012 |
analytical_stem.relative_x_m, |
|
| 8013 |
analytical_stem.relative_y_m, |
|
| 8014 |
analytical_stem.stem_code |
|
| 8015 |
FROM analytical_stem |
|
| 8016 |
WHERE (analytical_stem.datasource = 'GBIF'::text); |
|
| 8017 |
|
|
| 8018 |
|
|
| 8019 |
-- |
|
| 8020 |
-- Name: analytical_stem_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 8021 |
-- |
|
| 8022 |
|
|
| 8023 |
CREATE VIEW "analytical_stem_non_GBIF" AS |
|
| 8024 |
SELECT analytical_stem.datasource, |
|
| 8025 |
analytical_stem.country, |
|
| 8026 |
analytical_stem.state_province, |
|
| 8027 |
analytical_stem.county, |
|
| 8028 |
analytical_stem.locality, |
|
| 8029 |
analytical_stem.latitude, |
|
| 8030 |
analytical_stem.longitude, |
|
| 8031 |
analytical_stem.coord_uncertainty_m, |
|
| 8032 |
analytical_stem.georef_sources, |
|
| 8033 |
analytical_stem.georef_protocol, |
|
| 8034 |
analytical_stem.is_geovalid, |
|
| 8035 |
analytical_stem.is_new_world, |
|
| 8036 |
analytical_stem.project_id, |
|
| 8037 |
analytical_stem.project_contributors, |
|
| 8038 |
analytical_stem.location_id, |
|
| 8039 |
analytical_stem.plot_name, |
|
| 8040 |
analytical_stem.subplot, |
|
| 8041 |
analytical_stem.is_location_cultivated, |
|
| 8042 |
analytical_stem.locationevent_id, |
|
| 8043 |
analytical_stem.event_date, |
|
| 8044 |
analytical_stem.elevation_m, |
|
| 8045 |
analytical_stem.slope_aspect_deg, |
|
| 8046 |
analytical_stem.slope_gradient_deg, |
|
| 8047 |
analytical_stem.plot_area_ha, |
|
| 8048 |
analytical_stem.sampling_protocol, |
|
| 8049 |
analytical_stem.temperature_c, |
|
| 8050 |
analytical_stem.precip_mm, |
|
| 8051 |
analytical_stem.stratum_name, |
|
| 8052 |
analytical_stem.community_concept_name, |
|
| 8053 |
analytical_stem.observation_contributors, |
|
| 8054 |
analytical_stem.custodial_institution_codes, |
|
| 8055 |
analytical_stem.collection_code, |
|
| 8056 |
analytical_stem.catalog_number, |
|
| 8057 |
analytical_stem.occurrence_id, |
|
| 8058 |
analytical_stem.recorded_by, |
|
| 8059 |
analytical_stem.record_number, |
|
| 8060 |
analytical_stem.date_collected, |
|
| 8061 |
analytical_stem.verbatim_family, |
|
| 8062 |
analytical_stem.verbatim_scientific_name, |
|
| 8063 |
analytical_stem.identified_by, |
|
| 8064 |
analytical_stem.date_identified, |
|
| 8065 |
analytical_stem.identification_remarks, |
|
| 8066 |
analytical_stem.family_matched, |
|
| 8067 |
analytical_stem.name_matched, |
|
| 8068 |
analytical_stem.name_matched_author, |
|
| 8069 |
analytical_stem.higher_plant_group, |
|
| 8070 |
analytical_stem.taxonomic_status, |
|
| 8071 |
analytical_stem.scrubbed_family, |
|
| 8072 |
analytical_stem.scrubbed_genus, |
|
| 8073 |
analytical_stem.scrubbed_specific_epithet, |
|
| 8074 |
analytical_stem.scrubbed_species_binomial, |
|
| 8075 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 8076 |
analytical_stem.scrubbed_author, |
|
| 8077 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 8078 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 8079 |
analytical_stem.growth_form, |
|
| 8080 |
analytical_stem.reproductive_condition, |
|
| 8081 |
analytical_stem.is_cultivated, |
|
| 8082 |
analytical_stem.is_cultivated_basis, |
|
| 8083 |
analytical_stem.occurrence_remarks, |
|
| 8084 |
analytical_stem.cover_percent, |
|
| 8085 |
analytical_stem.taxon_observation_id, |
|
| 8086 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8087 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8088 |
analytical_stem.individual_organism_observation_id, |
|
| 8089 |
analytical_stem.individual_id, |
|
| 8090 |
analytical_stem.individual_count, |
|
| 8091 |
analytical_stem.plantobservation_id, |
|
| 8092 |
analytical_stem.taxonobservation_id, |
|
| 8093 |
analytical_stem.stem_dbh_cm, |
|
| 8094 |
analytical_stem.stem_height_m, |
|
| 8095 |
analytical_stem.tag, |
|
| 8096 |
analytical_stem.relative_x_m, |
|
| 8097 |
analytical_stem.relative_y_m, |
|
| 8098 |
analytical_stem.stem_code |
|
| 8099 |
FROM analytical_stem |
|
| 8100 |
WHERE (analytical_stem.datasource <> 'GBIF'::text); |
|
| 8101 |
|
|
| 8102 |
|
|
| 8103 |
-- |
|
| 7936 | 8104 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 7937 | 8105 |
-- |
| 7938 | 8106 |
|
| ... | ... | |
| 12000 | 12168 |
|
| 12001 | 12169 |
|
| 12002 | 12170 |
-- |
| 12171 |
-- Name: view_full_occurrence_individual_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 12172 |
-- |
|
| 12173 |
|
|
| 12174 |
CREATE VIEW "view_full_occurrence_individual_GBIF" AS |
|
| 12175 |
SELECT view_full_occurrence_individual.datasource, |
|
| 12176 |
view_full_occurrence_individual.country, |
|
| 12177 |
view_full_occurrence_individual.state_province, |
|
| 12178 |
view_full_occurrence_individual.county, |
|
| 12179 |
view_full_occurrence_individual.locality, |
|
| 12180 |
view_full_occurrence_individual.latitude, |
|
| 12181 |
view_full_occurrence_individual.longitude, |
|
| 12182 |
view_full_occurrence_individual.coord_uncertainty_m, |
|
| 12183 |
view_full_occurrence_individual.georef_sources, |
|
| 12184 |
view_full_occurrence_individual.georef_protocol, |
|
| 12185 |
view_full_occurrence_individual.is_geovalid, |
|
| 12186 |
view_full_occurrence_individual.is_new_world, |
|
| 12187 |
view_full_occurrence_individual.project_id, |
|
| 12188 |
view_full_occurrence_individual.project_contributors, |
|
| 12189 |
view_full_occurrence_individual.location_id, |
|
| 12190 |
view_full_occurrence_individual.plot_name, |
|
| 12191 |
view_full_occurrence_individual.subplot, |
|
| 12192 |
view_full_occurrence_individual.is_location_cultivated, |
|
| 12193 |
view_full_occurrence_individual.locationevent_id, |
|
| 12194 |
view_full_occurrence_individual.event_date, |
|
| 12195 |
view_full_occurrence_individual.elevation_m, |
|
| 12196 |
view_full_occurrence_individual.slope_aspect_deg, |
|
| 12197 |
view_full_occurrence_individual.slope_gradient_deg, |
|
| 12198 |
view_full_occurrence_individual.plot_area_ha, |
|
| 12199 |
view_full_occurrence_individual.sampling_protocol, |
|
| 12200 |
view_full_occurrence_individual.temperature_c, |
|
| 12201 |
view_full_occurrence_individual.precip_mm, |
|
| 12202 |
view_full_occurrence_individual.stratum_name, |
|
| 12203 |
view_full_occurrence_individual.community_concept_name, |
|
| 12204 |
view_full_occurrence_individual.observation_contributors, |
|
| 12205 |
view_full_occurrence_individual.custodial_institution_codes, |
|
| 12206 |
view_full_occurrence_individual.collection_code, |
|
| 12207 |
view_full_occurrence_individual.catalog_number, |
|
| 12208 |
view_full_occurrence_individual.occurrence_id, |
|
| 12209 |
view_full_occurrence_individual.recorded_by, |
|
| 12210 |
view_full_occurrence_individual.record_number, |
|
| 12211 |
view_full_occurrence_individual.date_collected, |
|
| 12212 |
view_full_occurrence_individual.verbatim_family, |
|
| 12213 |
view_full_occurrence_individual.verbatim_scientific_name, |
|
| 12214 |
view_full_occurrence_individual.identified_by, |
|
| 12215 |
view_full_occurrence_individual.date_identified, |
|
| 12216 |
view_full_occurrence_individual.identification_remarks, |
|
| 12217 |
view_full_occurrence_individual.family_matched, |
|
| 12218 |
view_full_occurrence_individual.name_matched, |
|
| 12219 |
view_full_occurrence_individual.name_matched_author, |
|
| 12220 |
view_full_occurrence_individual.higher_plant_group, |
|
| 12221 |
view_full_occurrence_individual.taxonomic_status, |
|
| 12222 |
view_full_occurrence_individual.scrubbed_family, |
|
| 12223 |
view_full_occurrence_individual.scrubbed_genus, |
|
| 12224 |
view_full_occurrence_individual.scrubbed_specific_epithet, |
|
| 12225 |
view_full_occurrence_individual.scrubbed_species_binomial, |
|
| 12226 |
view_full_occurrence_individual.scrubbed_taxon_name_no_author, |
|
| 12227 |
view_full_occurrence_individual.scrubbed_author, |
|
| 12228 |
view_full_occurrence_individual.scrubbed_taxon_name_with_author, |
|
| 12229 |
view_full_occurrence_individual.scrubbed_species_binomial_with_morphospecies, |
|
| 12230 |
view_full_occurrence_individual.growth_form, |
|
| 12231 |
view_full_occurrence_individual.reproductive_condition, |
|
| 12232 |
view_full_occurrence_individual.is_cultivated, |
|
| 12233 |
view_full_occurrence_individual.is_cultivated_basis, |
|
| 12234 |
view_full_occurrence_individual.occurrence_remarks, |
|
| 12235 |
view_full_occurrence_individual.cover_percent, |
|
| 12236 |
view_full_occurrence_individual.taxon_observation_id, |
|
| 12237 |
view_full_occurrence_individual.taxon_name_usage_concept_author_code, |
|
| 12238 |
view_full_occurrence_individual.aggregate_organism_observation_id, |
|
| 12239 |
view_full_occurrence_individual.individual_organism_observation_id, |
|
| 12240 |
view_full_occurrence_individual.individual_id, |
|
| 12241 |
view_full_occurrence_individual.individual_count, |
|
| 12242 |
view_full_occurrence_individual.plantobservation_id, |
|
| 12243 |
view_full_occurrence_individual.taxonobservation_id |
|
| 12244 |
FROM view_full_occurrence_individual |
|
| 12245 |
WHERE (view_full_occurrence_individual.datasource = 'GBIF'::text); |
|
| 12246 |
|
|
| 12247 |
|
|
| 12248 |
-- |
|
| 12249 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 12250 |
-- |
|
| 12251 |
|
|
| 12252 |
CREATE VIEW "view_full_occurrence_individual_non_GBIF" AS |
|
| 12253 |
SELECT view_full_occurrence_individual.datasource, |
|
| 12254 |
view_full_occurrence_individual.country, |
|
| 12255 |
view_full_occurrence_individual.state_province, |
|
| 12256 |
view_full_occurrence_individual.county, |
|
| 12257 |
view_full_occurrence_individual.locality, |
|
| 12258 |
view_full_occurrence_individual.latitude, |
|
| 12259 |
view_full_occurrence_individual.longitude, |
|
| 12260 |
view_full_occurrence_individual.coord_uncertainty_m, |
|
| 12261 |
view_full_occurrence_individual.georef_sources, |
|
| 12262 |
view_full_occurrence_individual.georef_protocol, |
|
| 12263 |
view_full_occurrence_individual.is_geovalid, |
|
| 12264 |
view_full_occurrence_individual.is_new_world, |
|
| 12265 |
view_full_occurrence_individual.project_id, |
|
| 12266 |
view_full_occurrence_individual.project_contributors, |
|
| 12267 |
view_full_occurrence_individual.location_id, |
|
| 12268 |
view_full_occurrence_individual.plot_name, |
|
| 12269 |
view_full_occurrence_individual.subplot, |
|
| 12270 |
view_full_occurrence_individual.is_location_cultivated, |
|
| 12271 |
view_full_occurrence_individual.locationevent_id, |
|
| 12272 |
view_full_occurrence_individual.event_date, |
|
| 12273 |
view_full_occurrence_individual.elevation_m, |
|
| 12274 |
view_full_occurrence_individual.slope_aspect_deg, |
|
| 12275 |
view_full_occurrence_individual.slope_gradient_deg, |
|
| 12276 |
view_full_occurrence_individual.plot_area_ha, |
|
| 12277 |
view_full_occurrence_individual.sampling_protocol, |
|
| 12278 |
view_full_occurrence_individual.temperature_c, |
|
| 12279 |
view_full_occurrence_individual.precip_mm, |
|
| 12280 |
view_full_occurrence_individual.stratum_name, |
|
| 12281 |
view_full_occurrence_individual.community_concept_name, |
|
| 12282 |
view_full_occurrence_individual.observation_contributors, |
|
| 12283 |
view_full_occurrence_individual.custodial_institution_codes, |
|
| 12284 |
view_full_occurrence_individual.collection_code, |
|
| 12285 |
view_full_occurrence_individual.catalog_number, |
|
| 12286 |
view_full_occurrence_individual.occurrence_id, |
|
| 12287 |
view_full_occurrence_individual.recorded_by, |
|
| 12288 |
view_full_occurrence_individual.record_number, |
|
| 12289 |
view_full_occurrence_individual.date_collected, |
|
| 12290 |
view_full_occurrence_individual.verbatim_family, |
|
| 12291 |
view_full_occurrence_individual.verbatim_scientific_name, |
|
| 12292 |
view_full_occurrence_individual.identified_by, |
|
| 12293 |
view_full_occurrence_individual.date_identified, |
|
| 12294 |
view_full_occurrence_individual.identification_remarks, |
|
| 12295 |
view_full_occurrence_individual.family_matched, |
|
| 12296 |
view_full_occurrence_individual.name_matched, |
|
| 12297 |
view_full_occurrence_individual.name_matched_author, |
|
| 12298 |
view_full_occurrence_individual.higher_plant_group, |
|
| 12299 |
view_full_occurrence_individual.taxonomic_status, |
|
| 12300 |
view_full_occurrence_individual.scrubbed_family, |
|
| 12301 |
view_full_occurrence_individual.scrubbed_genus, |
|
| 12302 |
view_full_occurrence_individual.scrubbed_specific_epithet, |
|
| 12303 |
view_full_occurrence_individual.scrubbed_species_binomial, |
|
| 12304 |
view_full_occurrence_individual.scrubbed_taxon_name_no_author, |
|
| 12305 |
view_full_occurrence_individual.scrubbed_author, |
|
| 12306 |
view_full_occurrence_individual.scrubbed_taxon_name_with_author, |
|
| 12307 |
view_full_occurrence_individual.scrubbed_species_binomial_with_morphospecies, |
|
| 12308 |
view_full_occurrence_individual.growth_form, |
|
| 12309 |
view_full_occurrence_individual.reproductive_condition, |
|
| 12310 |
view_full_occurrence_individual.is_cultivated, |
|
| 12311 |
view_full_occurrence_individual.is_cultivated_basis, |
|
| 12312 |
view_full_occurrence_individual.occurrence_remarks, |
|
| 12313 |
view_full_occurrence_individual.cover_percent, |
|
| 12314 |
view_full_occurrence_individual.taxon_observation_id, |
|
| 12315 |
view_full_occurrence_individual.taxon_name_usage_concept_author_code, |
|
| 12316 |
view_full_occurrence_individual.aggregate_organism_observation_id, |
|
| 12317 |
view_full_occurrence_individual.individual_organism_observation_id, |
|
| 12318 |
view_full_occurrence_individual.individual_id, |
|
| 12319 |
view_full_occurrence_individual.individual_count, |
|
| 12320 |
view_full_occurrence_individual.plantobservation_id, |
|
| 12321 |
view_full_occurrence_individual.taxonobservation_id |
|
| 12322 |
FROM view_full_occurrence_individual |
|
| 12323 |
WHERE (view_full_occurrence_individual.datasource <> 'GBIF'::text); |
|
| 12324 |
|
|
| 12325 |
|
|
| 12326 |
-- |
|
| 12003 | 12327 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 12004 | 12328 |
-- |
| 12005 | 12329 |
|
| ... | ... | |
| 19184 | 19508 |
|
| 19185 | 19509 |
|
| 19186 | 19510 |
-- |
| 19511 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 19512 |
-- |
|
| 19513 |
|
|
| 19514 |
REVOKE ALL ON TABLE "analytical_stem_GBIF" FROM PUBLIC; |
|
| 19515 |
REVOKE ALL ON TABLE "analytical_stem_GBIF" FROM bien; |
|
| 19516 |
GRANT ALL ON TABLE "analytical_stem_GBIF" TO bien; |
|
| 19517 |
GRANT SELECT ON TABLE "analytical_stem_GBIF" TO bien_read; |
|
| 19518 |
|
|
| 19519 |
|
|
| 19520 |
-- |
|
| 19521 |
-- Name: analytical_stem_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 19522 |
-- |
|
| 19523 |
|
|
| 19524 |
REVOKE ALL ON TABLE "analytical_stem_non_GBIF" FROM PUBLIC; |
|
| 19525 |
REVOKE ALL ON TABLE "analytical_stem_non_GBIF" FROM bien; |
|
| 19526 |
GRANT ALL ON TABLE "analytical_stem_non_GBIF" TO bien; |
|
| 19527 |
GRANT SELECT ON TABLE "analytical_stem_non_GBIF" TO bien_read; |
|
| 19528 |
|
|
| 19529 |
|
|
| 19530 |
-- |
|
| 19187 | 19531 |
-- Name: classcontributor; Type: ACL; Schema: public; Owner: - |
| 19188 | 19532 |
-- |
| 19189 | 19533 |
|
| ... | ... | |
| 19940 | 20284 |
|
| 19941 | 20285 |
|
| 19942 | 20286 |
-- |
| 20287 |
-- Name: view_full_occurrence_individual_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 20288 |
-- |
|
| 20289 |
|
|
| 20290 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_GBIF" FROM PUBLIC; |
|
| 20291 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_GBIF" FROM bien; |
|
| 20292 |
GRANT ALL ON TABLE "view_full_occurrence_individual_GBIF" TO bien; |
|
| 20293 |
GRANT SELECT ON TABLE "view_full_occurrence_individual_GBIF" TO bien_read; |
|
| 20294 |
|
|
| 20295 |
|
|
| 20296 |
-- |
|
| 20297 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 20298 |
-- |
|
| 20299 |
|
|
| 20300 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_non_GBIF" FROM PUBLIC; |
|
| 20301 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_non_GBIF" FROM bien; |
|
| 20302 |
GRANT ALL ON TABLE "view_full_occurrence_individual_non_GBIF" TO bien; |
|
| 20303 |
GRANT SELECT ON TABLE "view_full_occurrence_individual_non_GBIF" TO bien_read; |
|
| 20304 |
|
|
| 20305 |
|
|
| 20306 |
-- |
|
| 19943 | 20307 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 19944 | 20308 |
-- |
| 19945 | 20309 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 7933 | 7933 |
|
| 7934 | 7934 |
|
| 7935 | 7935 |
-- |
| 7936 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 7937 |
-- |
|
| 7938 |
|
|
| 7939 |
CREATE VIEW "analytical_stem_GBIF" AS |
|
| 7940 |
SELECT analytical_stem.datasource, |
|
| 7941 |
analytical_stem.country, |
|
| 7942 |
analytical_stem.state_province, |
|
| 7943 |
analytical_stem.county, |
|
| 7944 |
analytical_stem.locality, |
|
| 7945 |
analytical_stem.latitude, |
|
| 7946 |
analytical_stem.longitude, |
|
| 7947 |
analytical_stem.coord_uncertainty_m, |
|
| 7948 |
analytical_stem.georef_sources, |
|
| 7949 |
analytical_stem.georef_protocol, |
|
| 7950 |
analytical_stem.is_geovalid, |
|
| 7951 |
analytical_stem.is_new_world, |
|
| 7952 |
analytical_stem.project_id, |
|
| 7953 |
analytical_stem.project_contributors, |
|
| 7954 |
analytical_stem.location_id, |
|
| 7955 |
analytical_stem.plot_name, |
|
| 7956 |
analytical_stem.subplot, |
|
| 7957 |
analytical_stem.is_location_cultivated, |
|
| 7958 |
analytical_stem.locationevent_id, |
|
| 7959 |
analytical_stem.event_date, |
|
| 7960 |
analytical_stem.elevation_m, |
|
| 7961 |
analytical_stem.slope_aspect_deg, |
|
| 7962 |
analytical_stem.slope_gradient_deg, |
|
| 7963 |
analytical_stem.plot_area_ha, |
|
| 7964 |
analytical_stem.sampling_protocol, |
|
| 7965 |
analytical_stem.temperature_c, |
|
| 7966 |
analytical_stem.precip_mm, |
|
| 7967 |
analytical_stem.stratum_name, |
|
| 7968 |
analytical_stem.community_concept_name, |
|
| 7969 |
analytical_stem.observation_contributors, |
|
| 7970 |
analytical_stem.custodial_institution_codes, |
|
| 7971 |
analytical_stem.collection_code, |
|
| 7972 |
analytical_stem.catalog_number, |
|
| 7973 |
analytical_stem.occurrence_id, |
|
| 7974 |
analytical_stem.recorded_by, |
|
| 7975 |
analytical_stem.record_number, |
|
| 7976 |
analytical_stem.date_collected, |
|
| 7977 |
analytical_stem.verbatim_family, |
|
| 7978 |
analytical_stem.verbatim_scientific_name, |
|
| 7979 |
analytical_stem.identified_by, |
|
| 7980 |
analytical_stem.date_identified, |
|
| 7981 |
analytical_stem.identification_remarks, |
|
| 7982 |
analytical_stem.family_matched, |
|
| 7983 |
analytical_stem.name_matched, |
|
| 7984 |
analytical_stem.name_matched_author, |
|
| 7985 |
analytical_stem.higher_plant_group, |
|
| 7986 |
analytical_stem.taxonomic_status, |
|
| 7987 |
analytical_stem.scrubbed_family, |
|
| 7988 |
analytical_stem.scrubbed_genus, |
|
| 7989 |
analytical_stem.scrubbed_specific_epithet, |
|
| 7990 |
analytical_stem.scrubbed_species_binomial, |
|
| 7991 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 7992 |
analytical_stem.scrubbed_author, |
|
| 7993 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 7994 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 7995 |
analytical_stem.growth_form, |
|
| 7996 |
analytical_stem.reproductive_condition, |
|
| 7997 |
analytical_stem.is_cultivated, |
|
| 7998 |
analytical_stem.is_cultivated_basis, |
|
| 7999 |
analytical_stem.occurrence_remarks, |
|
| 8000 |
analytical_stem.cover_percent, |
|
| 8001 |
analytical_stem.taxon_observation_id, |
|
| 8002 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8003 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8004 |
analytical_stem.individual_organism_observation_id, |
|
| 8005 |
analytical_stem.individual_id, |
|
| 8006 |
analytical_stem.individual_count, |
|
| 8007 |
analytical_stem.plantobservation_id, |
|
| 8008 |
analytical_stem.taxonobservation_id, |
|
| 8009 |
analytical_stem.stem_dbh_cm, |
|
| 8010 |
analytical_stem.stem_height_m, |
|
| 8011 |
analytical_stem.tag, |
|
| 8012 |
analytical_stem.relative_x_m, |
|
| 8013 |
analytical_stem.relative_y_m, |
|
| 8014 |
analytical_stem.stem_code |
|
| 8015 |
FROM analytical_stem |
|
| 8016 |
WHERE (analytical_stem.datasource = 'GBIF'::text); |
|
| 8017 |
|
|
| 8018 |
|
|
| 8019 |
-- |
|
| 8020 |
-- Name: analytical_stem_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 8021 |
-- |
|
| 8022 |
|
|
| 8023 |
CREATE VIEW "analytical_stem_non_GBIF" AS |
|
| 8024 |
SELECT analytical_stem.datasource, |
|
| 8025 |
analytical_stem.country, |
|
| 8026 |
analytical_stem.state_province, |
|
| 8027 |
analytical_stem.county, |
|
| 8028 |
analytical_stem.locality, |
|
| 8029 |
analytical_stem.latitude, |
|
| 8030 |
analytical_stem.longitude, |
|
| 8031 |
analytical_stem.coord_uncertainty_m, |
|
| 8032 |
analytical_stem.georef_sources, |
|
| 8033 |
analytical_stem.georef_protocol, |
|
| 8034 |
analytical_stem.is_geovalid, |
|
| 8035 |
analytical_stem.is_new_world, |
|
| 8036 |
analytical_stem.project_id, |
|
| 8037 |
analytical_stem.project_contributors, |
|
| 8038 |
analytical_stem.location_id, |
|
| 8039 |
analytical_stem.plot_name, |
|
| 8040 |
analytical_stem.subplot, |
|
| 8041 |
analytical_stem.is_location_cultivated, |
|
| 8042 |
analytical_stem.locationevent_id, |
|
| 8043 |
analytical_stem.event_date, |
|
| 8044 |
analytical_stem.elevation_m, |
|
| 8045 |
analytical_stem.slope_aspect_deg, |
|
| 8046 |
analytical_stem.slope_gradient_deg, |
|
| 8047 |
analytical_stem.plot_area_ha, |
|
| 8048 |
analytical_stem.sampling_protocol, |
|
| 8049 |
analytical_stem.temperature_c, |
|
| 8050 |
analytical_stem.precip_mm, |
|
| 8051 |
analytical_stem.stratum_name, |
|
| 8052 |
analytical_stem.community_concept_name, |
|
| 8053 |
analytical_stem.observation_contributors, |
|
| 8054 |
analytical_stem.custodial_institution_codes, |
|
| 8055 |
analytical_stem.collection_code, |
|
| 8056 |
analytical_stem.catalog_number, |
|
| 8057 |
analytical_stem.occurrence_id, |
|
| 8058 |
analytical_stem.recorded_by, |
|
| 8059 |
analytical_stem.record_number, |
|
| 8060 |
analytical_stem.date_collected, |
|
| 8061 |
analytical_stem.verbatim_family, |
|
| 8062 |
analytical_stem.verbatim_scientific_name, |
|
| 8063 |
analytical_stem.identified_by, |
|
| 8064 |
analytical_stem.date_identified, |
|
| 8065 |
analytical_stem.identification_remarks, |
|
| 8066 |
analytical_stem.family_matched, |
|
| 8067 |
analytical_stem.name_matched, |
|
| 8068 |
analytical_stem.name_matched_author, |
|
| 8069 |
analytical_stem.higher_plant_group, |
|
| 8070 |
analytical_stem.taxonomic_status, |
|
| 8071 |
analytical_stem.scrubbed_family, |
|
| 8072 |
analytical_stem.scrubbed_genus, |
|
| 8073 |
analytical_stem.scrubbed_specific_epithet, |
|
| 8074 |
analytical_stem.scrubbed_species_binomial, |
|
| 8075 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 8076 |
analytical_stem.scrubbed_author, |
|
| 8077 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 8078 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 8079 |
analytical_stem.growth_form, |
|
| 8080 |
analytical_stem.reproductive_condition, |
|
| 8081 |
analytical_stem.is_cultivated, |
|
| 8082 |
analytical_stem.is_cultivated_basis, |
|
| 8083 |
analytical_stem.occurrence_remarks, |
|
| 8084 |
analytical_stem.cover_percent, |
|
| 8085 |
analytical_stem.taxon_observation_id, |
|
| 8086 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8087 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8088 |
analytical_stem.individual_organism_observation_id, |
|
| 8089 |
analytical_stem.individual_id, |
|
| 8090 |
analytical_stem.individual_count, |
|
| 8091 |
analytical_stem.plantobservation_id, |
|
| 8092 |
analytical_stem.taxonobservation_id, |
|
| 8093 |
analytical_stem.stem_dbh_cm, |
|
| 8094 |
analytical_stem.stem_height_m, |
|
| 8095 |
analytical_stem.tag, |
|
| 8096 |
analytical_stem.relative_x_m, |
|
| 8097 |
analytical_stem.relative_y_m, |
|
| 8098 |
analytical_stem.stem_code |
|
| 8099 |
FROM analytical_stem |
|
| 8100 |
WHERE (analytical_stem.datasource <> 'GBIF'::text); |
|
| 8101 |
|
|
| 8102 |
|
|
| 8103 |
-- |
|
| 7936 | 8104 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 7937 | 8105 |
-- |
| 7938 | 8106 |
|
| ... | ... | |
| 12000 | 12168 |
|
| 12001 | 12169 |
|
| 12002 | 12170 |
-- |
| 12171 |
-- Name: view_full_occurrence_individual_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 12172 |
-- |
|
| 12173 |
|
|
| 12174 |
CREATE VIEW "view_full_occurrence_individual_GBIF" AS |
|
| 12175 |
SELECT view_full_occurrence_individual.datasource, |
|
| 12176 |
view_full_occurrence_individual.country, |
|
| 12177 |
view_full_occurrence_individual.state_province, |
|
| 12178 |
view_full_occurrence_individual.county, |
|
| 12179 |
view_full_occurrence_individual.locality, |
|
| 12180 |
view_full_occurrence_individual.latitude, |
|
| 12181 |
view_full_occurrence_individual.longitude, |
|
| 12182 |
view_full_occurrence_individual.coord_uncertainty_m, |
|
| 12183 |
view_full_occurrence_individual.georef_sources, |
|
| 12184 |
view_full_occurrence_individual.georef_protocol, |
|
| 12185 |
view_full_occurrence_individual.is_geovalid, |
|
| 12186 |
view_full_occurrence_individual.is_new_world, |
|
| 12187 |
view_full_occurrence_individual.project_id, |
|
| 12188 |
view_full_occurrence_individual.project_contributors, |
|
| 12189 |
view_full_occurrence_individual.location_id, |
|
| 12190 |
view_full_occurrence_individual.plot_name, |
|
| 12191 |
view_full_occurrence_individual.subplot, |
|
| 12192 |
view_full_occurrence_individual.is_location_cultivated, |
|
| 12193 |
view_full_occurrence_individual.locationevent_id, |
|
| 12194 |
view_full_occurrence_individual.event_date, |
|
| 12195 |
view_full_occurrence_individual.elevation_m, |
|
| 12196 |
view_full_occurrence_individual.slope_aspect_deg, |
|
| 12197 |
view_full_occurrence_individual.slope_gradient_deg, |
|
| 12198 |
view_full_occurrence_individual.plot_area_ha, |
|
| 12199 |
view_full_occurrence_individual.sampling_protocol, |
|
| 12200 |
view_full_occurrence_individual.temperature_c, |
|
| 12201 |
view_full_occurrence_individual.precip_mm, |
|
| 12202 |
view_full_occurrence_individual.stratum_name, |
|
| 12203 |
view_full_occurrence_individual.community_concept_name, |
|
| 12204 |
view_full_occurrence_individual.observation_contributors, |
|
| 12205 |
view_full_occurrence_individual.custodial_institution_codes, |
|
| 12206 |
view_full_occurrence_individual.collection_code, |
|
| 12207 |
view_full_occurrence_individual.catalog_number, |
|
| 12208 |
view_full_occurrence_individual.occurrence_id, |
|
| 12209 |
view_full_occurrence_individual.recorded_by, |
|
| 12210 |
view_full_occurrence_individual.record_number, |
|
| 12211 |
view_full_occurrence_individual.date_collected, |
|
| 12212 |
view_full_occurrence_individual.verbatim_family, |
|
| 12213 |
view_full_occurrence_individual.verbatim_scientific_name, |
|
| 12214 |
view_full_occurrence_individual.identified_by, |
|
| 12215 |
view_full_occurrence_individual.date_identified, |
|
| 12216 |
view_full_occurrence_individual.identification_remarks, |
|
| 12217 |
view_full_occurrence_individual.family_matched, |
|
| 12218 |
view_full_occurrence_individual.name_matched, |
|
| 12219 |
view_full_occurrence_individual.name_matched_author, |
|
| 12220 |
view_full_occurrence_individual.higher_plant_group, |
|
| 12221 |
view_full_occurrence_individual.taxonomic_status, |
|
| 12222 |
view_full_occurrence_individual.scrubbed_family, |
|
| 12223 |
view_full_occurrence_individual.scrubbed_genus, |
|
| 12224 |
view_full_occurrence_individual.scrubbed_specific_epithet, |
|
| 12225 |
view_full_occurrence_individual.scrubbed_species_binomial, |
|
| 12226 |
view_full_occurrence_individual.scrubbed_taxon_name_no_author, |
|
| 12227 |
view_full_occurrence_individual.scrubbed_author, |
|
| 12228 |
view_full_occurrence_individual.scrubbed_taxon_name_with_author, |
|
| 12229 |
view_full_occurrence_individual.scrubbed_species_binomial_with_morphospecies, |
|
| 12230 |
view_full_occurrence_individual.growth_form, |
|
| 12231 |
view_full_occurrence_individual.reproductive_condition, |
|
| 12232 |
view_full_occurrence_individual.is_cultivated, |
|
| 12233 |
view_full_occurrence_individual.is_cultivated_basis, |
|
| 12234 |
view_full_occurrence_individual.occurrence_remarks, |
|
| 12235 |
view_full_occurrence_individual.cover_percent, |
|
| 12236 |
view_full_occurrence_individual.taxon_observation_id, |
|
| 12237 |
view_full_occurrence_individual.taxon_name_usage_concept_author_code, |
|
| 12238 |
view_full_occurrence_individual.aggregate_organism_observation_id, |
|
| 12239 |
view_full_occurrence_individual.individual_organism_observation_id, |
|
| 12240 |
view_full_occurrence_individual.individual_id, |
|
| 12241 |
view_full_occurrence_individual.individual_count, |
|
| 12242 |
view_full_occurrence_individual.plantobservation_id, |
|
| 12243 |
view_full_occurrence_individual.taxonobservation_id |
|
| 12244 |
FROM view_full_occurrence_individual |
|
| 12245 |
WHERE (view_full_occurrence_individual.datasource = 'GBIF'::text); |
|
| 12246 |
|
|
| 12247 |
|
|
| 12248 |
-- |
|
| 12249 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: - |
|
| 12250 |
-- |
|
| 12251 |
|
|
| 12252 |
CREATE VIEW "view_full_occurrence_individual_non_GBIF" AS |
|
| 12253 |
SELECT view_full_occurrence_individual.datasource, |
|
| 12254 |
view_full_occurrence_individual.country, |
|
| 12255 |
view_full_occurrence_individual.state_province, |
|
| 12256 |
view_full_occurrence_individual.county, |
|
| 12257 |
view_full_occurrence_individual.locality, |
|
| 12258 |
view_full_occurrence_individual.latitude, |
|
| 12259 |
view_full_occurrence_individual.longitude, |
|
| 12260 |
view_full_occurrence_individual.coord_uncertainty_m, |
|
| 12261 |
view_full_occurrence_individual.georef_sources, |
|
| 12262 |
view_full_occurrence_individual.georef_protocol, |
|
| 12263 |
view_full_occurrence_individual.is_geovalid, |
|
| 12264 |
view_full_occurrence_individual.is_new_world, |
|
| 12265 |
view_full_occurrence_individual.project_id, |
|
| 12266 |
view_full_occurrence_individual.project_contributors, |
|
| 12267 |
view_full_occurrence_individual.location_id, |
|
| 12268 |
view_full_occurrence_individual.plot_name, |
|
| 12269 |
view_full_occurrence_individual.subplot, |
|
| 12270 |
view_full_occurrence_individual.is_location_cultivated, |
|
| 12271 |
view_full_occurrence_individual.locationevent_id, |
|
| 12272 |
view_full_occurrence_individual.event_date, |
|
| 12273 |
view_full_occurrence_individual.elevation_m, |
|
| 12274 |
view_full_occurrence_individual.slope_aspect_deg, |
|
| 12275 |
view_full_occurrence_individual.slope_gradient_deg, |
|
| 12276 |
view_full_occurrence_individual.plot_area_ha, |
|
| 12277 |
view_full_occurrence_individual.sampling_protocol, |
|
| 12278 |
view_full_occurrence_individual.temperature_c, |
|
| 12279 |
view_full_occurrence_individual.precip_mm, |
|
| 12280 |
view_full_occurrence_individual.stratum_name, |
|
| 12281 |
view_full_occurrence_individual.community_concept_name, |
|
| 12282 |
view_full_occurrence_individual.observation_contributors, |
|
| 12283 |
view_full_occurrence_individual.custodial_institution_codes, |
|
| 12284 |
view_full_occurrence_individual.collection_code, |
|
| 12285 |
view_full_occurrence_individual.catalog_number, |
|
| 12286 |
view_full_occurrence_individual.occurrence_id, |
|
| 12287 |
view_full_occurrence_individual.recorded_by, |
|
| 12288 |
view_full_occurrence_individual.record_number, |
|
| 12289 |
view_full_occurrence_individual.date_collected, |
|
| 12290 |
view_full_occurrence_individual.verbatim_family, |
|
| 12291 |
view_full_occurrence_individual.verbatim_scientific_name, |
|
| 12292 |
view_full_occurrence_individual.identified_by, |
|
| 12293 |
view_full_occurrence_individual.date_identified, |
|
| 12294 |
view_full_occurrence_individual.identification_remarks, |
|
| 12295 |
view_full_occurrence_individual.family_matched, |
|
| 12296 |
view_full_occurrence_individual.name_matched, |
|
| 12297 |
view_full_occurrence_individual.name_matched_author, |
|
| 12298 |
view_full_occurrence_individual.higher_plant_group, |
|
| 12299 |
view_full_occurrence_individual.taxonomic_status, |
|
| 12300 |
view_full_occurrence_individual.scrubbed_family, |
|
| 12301 |
view_full_occurrence_individual.scrubbed_genus, |
|
| 12302 |
view_full_occurrence_individual.scrubbed_specific_epithet, |
|
| 12303 |
view_full_occurrence_individual.scrubbed_species_binomial, |
|
| 12304 |
view_full_occurrence_individual.scrubbed_taxon_name_no_author, |
|
| 12305 |
view_full_occurrence_individual.scrubbed_author, |
|
| 12306 |
view_full_occurrence_individual.scrubbed_taxon_name_with_author, |
|
| 12307 |
view_full_occurrence_individual.scrubbed_species_binomial_with_morphospecies, |
|
| 12308 |
view_full_occurrence_individual.growth_form, |
|
| 12309 |
view_full_occurrence_individual.reproductive_condition, |
|
| 12310 |
view_full_occurrence_individual.is_cultivated, |
|
| 12311 |
view_full_occurrence_individual.is_cultivated_basis, |
|
| 12312 |
view_full_occurrence_individual.occurrence_remarks, |
|
| 12313 |
view_full_occurrence_individual.cover_percent, |
|
| 12314 |
view_full_occurrence_individual.taxon_observation_id, |
|
| 12315 |
view_full_occurrence_individual.taxon_name_usage_concept_author_code, |
|
| 12316 |
view_full_occurrence_individual.aggregate_organism_observation_id, |
|
| 12317 |
view_full_occurrence_individual.individual_organism_observation_id, |
|
| 12318 |
view_full_occurrence_individual.individual_id, |
|
| 12319 |
view_full_occurrence_individual.individual_count, |
|
| 12320 |
view_full_occurrence_individual.plantobservation_id, |
|
| 12321 |
view_full_occurrence_individual.taxonobservation_id |
|
| 12322 |
FROM view_full_occurrence_individual |
|
| 12323 |
WHERE (view_full_occurrence_individual.datasource <> 'GBIF'::text); |
|
| 12324 |
|
|
| 12325 |
|
|
| 12326 |
-- |
|
| 12003 | 12327 |
-- Name: view_full_occurrence_individual_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 12004 | 12328 |
-- |
| 12005 | 12329 |
|
| ... | ... | |
| 19184 | 19508 |
|
| 19185 | 19509 |
|
| 19186 | 19510 |
-- |
| 19511 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 19512 |
-- |
|
| 19513 |
|
|
| 19514 |
REVOKE ALL ON TABLE "analytical_stem_GBIF" FROM PUBLIC; |
|
| 19515 |
REVOKE ALL ON TABLE "analytical_stem_GBIF" FROM bien; |
|
| 19516 |
GRANT ALL ON TABLE "analytical_stem_GBIF" TO bien; |
|
| 19517 |
GRANT SELECT ON TABLE "analytical_stem_GBIF" TO bien_read; |
|
| 19518 |
|
|
| 19519 |
|
|
| 19520 |
-- |
|
| 19521 |
-- Name: analytical_stem_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 19522 |
-- |
|
| 19523 |
|
|
| 19524 |
REVOKE ALL ON TABLE "analytical_stem_non_GBIF" FROM PUBLIC; |
|
| 19525 |
REVOKE ALL ON TABLE "analytical_stem_non_GBIF" FROM bien; |
|
| 19526 |
GRANT ALL ON TABLE "analytical_stem_non_GBIF" TO bien; |
|
| 19527 |
GRANT SELECT ON TABLE "analytical_stem_non_GBIF" TO bien_read; |
|
| 19528 |
|
|
| 19529 |
|
|
| 19530 |
-- |
|
| 19187 | 19531 |
-- Name: classcontributor; Type: ACL; Schema: public; Owner: - |
| 19188 | 19532 |
-- |
| 19189 | 19533 |
|
| ... | ... | |
| 19940 | 20284 |
|
| 19941 | 20285 |
|
| 19942 | 20286 |
-- |
| 20287 |
-- Name: view_full_occurrence_individual_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 20288 |
-- |
|
| 20289 |
|
|
| 20290 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_GBIF" FROM PUBLIC; |
|
| 20291 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_GBIF" FROM bien; |
|
| 20292 |
GRANT ALL ON TABLE "view_full_occurrence_individual_GBIF" TO bien; |
|
| 20293 |
GRANT SELECT ON TABLE "view_full_occurrence_individual_GBIF" TO bien_read; |
|
| 20294 |
|
|
| 20295 |
|
|
| 20296 |
-- |
|
| 20297 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: ACL; Schema: public; Owner: - |
|
| 20298 |
-- |
|
| 20299 |
|
|
| 20300 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_non_GBIF" FROM PUBLIC; |
|
| 20301 |
REVOKE ALL ON TABLE "view_full_occurrence_individual_non_GBIF" FROM bien; |
|
| 20302 |
GRANT ALL ON TABLE "view_full_occurrence_individual_non_GBIF" TO bien; |
|
| 20303 |
GRANT SELECT ON TABLE "view_full_occurrence_individual_non_GBIF" TO bien_read; |
|
| 20304 |
|
|
| 20305 |
|
|
| 20306 |
-- |
|
| 19943 | 20307 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 19944 | 20308 |
-- |
| 19945 | 20309 |
|
Also available in: Unified diff
schemas/public_.sql: added view_full_occurrence_individual_*GBIF, analytical_stem_*GBIF requested by Mark. note that this change has already been made on vegbiendev.