Revision 14932
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 5345 | 5345 |
|
| 5346 | 5346 |
|
| 5347 | 5347 |
-- |
| 5348 |
-- Name: analytical_stem_CVS; Type: VIEW; Schema: public; Owner: - |
|
| 5349 |
-- |
|
| 5350 |
|
|
| 5351 |
|
|
| 5352 |
|
|
| 5353 |
|
|
| 5354 |
-- |
|
| 5348 | 5355 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
| 5349 | 5356 |
-- |
| 5350 | 5357 |
|
| ... | ... | |
| 15180 | 15187 |
|
| 15181 | 15188 |
|
| 15182 | 15189 |
-- |
| 15190 |
-- Name: analytical_stem_CVS; Type: ACL; Schema: public; Owner: - |
|
| 15191 |
-- |
|
| 15192 |
|
|
| 15193 |
|
|
| 15194 |
|
|
| 15195 |
|
|
| 15196 |
|
|
| 15197 |
|
|
| 15198 |
|
|
| 15199 |
-- |
|
| 15183 | 15200 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
| 15184 | 15201 |
-- |
| 15185 | 15202 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 8249 | 8249 |
|
| 8250 | 8250 |
|
| 8251 | 8251 |
-- |
| 8252 |
-- Name: analytical_stem_CVS; Type: VIEW; Schema: public; Owner: - |
|
| 8253 |
-- |
|
| 8254 |
|
|
| 8255 |
CREATE VIEW "analytical_stem_CVS" AS |
|
| 8256 |
SELECT analytical_stem.datasource, |
|
| 8257 |
analytical_stem.country, |
|
| 8258 |
analytical_stem.state_province, |
|
| 8259 |
analytical_stem.county, |
|
| 8260 |
analytical_stem.locality, |
|
| 8261 |
analytical_stem.latitude, |
|
| 8262 |
analytical_stem.longitude, |
|
| 8263 |
analytical_stem.coord_uncertainty_m, |
|
| 8264 |
analytical_stem.georef_sources, |
|
| 8265 |
analytical_stem.georef_protocol, |
|
| 8266 |
analytical_stem.is_geovalid, |
|
| 8267 |
analytical_stem.is_new_world, |
|
| 8268 |
analytical_stem.project_id, |
|
| 8269 |
analytical_stem.project_contributors, |
|
| 8270 |
analytical_stem.location_id, |
|
| 8271 |
analytical_stem.plot_name, |
|
| 8272 |
analytical_stem.subplot, |
|
| 8273 |
analytical_stem.is_location_cultivated, |
|
| 8274 |
analytical_stem.locationevent_id, |
|
| 8275 |
analytical_stem.event_date, |
|
| 8276 |
analytical_stem.elevation_m, |
|
| 8277 |
analytical_stem.slope_aspect_deg, |
|
| 8278 |
analytical_stem.slope_gradient_deg, |
|
| 8279 |
analytical_stem.plot_area_ha, |
|
| 8280 |
analytical_stem.sampling_protocol, |
|
| 8281 |
analytical_stem.temperature_c, |
|
| 8282 |
analytical_stem.precip_mm, |
|
| 8283 |
analytical_stem.stratum_name, |
|
| 8284 |
analytical_stem.community_concept_name, |
|
| 8285 |
analytical_stem.observation_contributors, |
|
| 8286 |
analytical_stem.custodial_institution_codes, |
|
| 8287 |
analytical_stem.collection_code, |
|
| 8288 |
analytical_stem.catalog_number, |
|
| 8289 |
analytical_stem.occurrence_id, |
|
| 8290 |
analytical_stem.recorded_by, |
|
| 8291 |
analytical_stem.record_number, |
|
| 8292 |
analytical_stem.date_collected, |
|
| 8293 |
analytical_stem.verbatim_family, |
|
| 8294 |
analytical_stem.verbatim_scientific_name, |
|
| 8295 |
analytical_stem.identified_by, |
|
| 8296 |
analytical_stem.date_identified, |
|
| 8297 |
analytical_stem.identification_remarks, |
|
| 8298 |
analytical_stem.family_matched, |
|
| 8299 |
analytical_stem.name_matched, |
|
| 8300 |
analytical_stem.name_matched_author, |
|
| 8301 |
analytical_stem.higher_plant_group, |
|
| 8302 |
analytical_stem.taxonomic_status, |
|
| 8303 |
analytical_stem.scrubbed_family, |
|
| 8304 |
analytical_stem.scrubbed_genus, |
|
| 8305 |
analytical_stem.scrubbed_specific_epithet, |
|
| 8306 |
analytical_stem.scrubbed_species_binomial, |
|
| 8307 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 8308 |
analytical_stem.scrubbed_author, |
|
| 8309 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 8310 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 8311 |
analytical_stem.growth_form, |
|
| 8312 |
analytical_stem.reproductive_condition, |
|
| 8313 |
analytical_stem.is_cultivated, |
|
| 8314 |
analytical_stem.is_cultivated_basis, |
|
| 8315 |
analytical_stem.occurrence_remarks, |
|
| 8316 |
analytical_stem.cover_percent, |
|
| 8317 |
analytical_stem.taxon_observation_id, |
|
| 8318 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8319 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8320 |
analytical_stem.individual_organism_observation_id, |
|
| 8321 |
analytical_stem.individual_id, |
|
| 8322 |
analytical_stem.individual_count, |
|
| 8323 |
analytical_stem.plantobservation_id, |
|
| 8324 |
analytical_stem.taxonobservation_id |
|
| 8325 |
FROM analytical_stem |
|
| 8326 |
WHERE (analytical_stem.datasource = 'CVS'::text); |
|
| 8327 |
|
|
| 8328 |
|
|
| 8329 |
-- |
|
| 8252 | 8330 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
| 8253 | 8331 |
-- |
| 8254 | 8332 |
|
| ... | ... | |
| 20016 | 20094 |
|
| 20017 | 20095 |
|
| 20018 | 20096 |
-- |
| 20097 |
-- Name: analytical_stem_CVS; Type: ACL; Schema: public; Owner: - |
|
| 20098 |
-- |
|
| 20099 |
|
|
| 20100 |
REVOKE ALL ON TABLE "analytical_stem_CVS" FROM PUBLIC; |
|
| 20101 |
REVOKE ALL ON TABLE "analytical_stem_CVS" FROM bien; |
|
| 20102 |
GRANT ALL ON TABLE "analytical_stem_CVS" TO bien; |
|
| 20103 |
GRANT SELECT ON TABLE "analytical_stem_CVS" TO bien_read; |
|
| 20104 |
|
|
| 20105 |
|
|
| 20106 |
-- |
|
| 20019 | 20107 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
| 20020 | 20108 |
-- |
| 20021 | 20109 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 8249 | 8249 |
|
| 8250 | 8250 |
|
| 8251 | 8251 |
-- |
| 8252 |
-- Name: analytical_stem_CVS; Type: VIEW; Schema: public; Owner: - |
|
| 8253 |
-- |
|
| 8254 |
|
|
| 8255 |
CREATE VIEW "analytical_stem_CVS" AS |
|
| 8256 |
SELECT analytical_stem.datasource, |
|
| 8257 |
analytical_stem.country, |
|
| 8258 |
analytical_stem.state_province, |
|
| 8259 |
analytical_stem.county, |
|
| 8260 |
analytical_stem.locality, |
|
| 8261 |
analytical_stem.latitude, |
|
| 8262 |
analytical_stem.longitude, |
|
| 8263 |
analytical_stem.coord_uncertainty_m, |
|
| 8264 |
analytical_stem.georef_sources, |
|
| 8265 |
analytical_stem.georef_protocol, |
|
| 8266 |
analytical_stem.is_geovalid, |
|
| 8267 |
analytical_stem.is_new_world, |
|
| 8268 |
analytical_stem.project_id, |
|
| 8269 |
analytical_stem.project_contributors, |
|
| 8270 |
analytical_stem.location_id, |
|
| 8271 |
analytical_stem.plot_name, |
|
| 8272 |
analytical_stem.subplot, |
|
| 8273 |
analytical_stem.is_location_cultivated, |
|
| 8274 |
analytical_stem.locationevent_id, |
|
| 8275 |
analytical_stem.event_date, |
|
| 8276 |
analytical_stem.elevation_m, |
|
| 8277 |
analytical_stem.slope_aspect_deg, |
|
| 8278 |
analytical_stem.slope_gradient_deg, |
|
| 8279 |
analytical_stem.plot_area_ha, |
|
| 8280 |
analytical_stem.sampling_protocol, |
|
| 8281 |
analytical_stem.temperature_c, |
|
| 8282 |
analytical_stem.precip_mm, |
|
| 8283 |
analytical_stem.stratum_name, |
|
| 8284 |
analytical_stem.community_concept_name, |
|
| 8285 |
analytical_stem.observation_contributors, |
|
| 8286 |
analytical_stem.custodial_institution_codes, |
|
| 8287 |
analytical_stem.collection_code, |
|
| 8288 |
analytical_stem.catalog_number, |
|
| 8289 |
analytical_stem.occurrence_id, |
|
| 8290 |
analytical_stem.recorded_by, |
|
| 8291 |
analytical_stem.record_number, |
|
| 8292 |
analytical_stem.date_collected, |
|
| 8293 |
analytical_stem.verbatim_family, |
|
| 8294 |
analytical_stem.verbatim_scientific_name, |
|
| 8295 |
analytical_stem.identified_by, |
|
| 8296 |
analytical_stem.date_identified, |
|
| 8297 |
analytical_stem.identification_remarks, |
|
| 8298 |
analytical_stem.family_matched, |
|
| 8299 |
analytical_stem.name_matched, |
|
| 8300 |
analytical_stem.name_matched_author, |
|
| 8301 |
analytical_stem.higher_plant_group, |
|
| 8302 |
analytical_stem.taxonomic_status, |
|
| 8303 |
analytical_stem.scrubbed_family, |
|
| 8304 |
analytical_stem.scrubbed_genus, |
|
| 8305 |
analytical_stem.scrubbed_specific_epithet, |
|
| 8306 |
analytical_stem.scrubbed_species_binomial, |
|
| 8307 |
analytical_stem.scrubbed_taxon_name_no_author, |
|
| 8308 |
analytical_stem.scrubbed_author, |
|
| 8309 |
analytical_stem.scrubbed_taxon_name_with_author, |
|
| 8310 |
analytical_stem.scrubbed_species_binomial_with_morphospecies, |
|
| 8311 |
analytical_stem.growth_form, |
|
| 8312 |
analytical_stem.reproductive_condition, |
|
| 8313 |
analytical_stem.is_cultivated, |
|
| 8314 |
analytical_stem.is_cultivated_basis, |
|
| 8315 |
analytical_stem.occurrence_remarks, |
|
| 8316 |
analytical_stem.cover_percent, |
|
| 8317 |
analytical_stem.taxon_observation_id, |
|
| 8318 |
analytical_stem.taxon_name_usage_concept_author_code, |
|
| 8319 |
analytical_stem.aggregate_organism_observation_id, |
|
| 8320 |
analytical_stem.individual_organism_observation_id, |
|
| 8321 |
analytical_stem.individual_id, |
|
| 8322 |
analytical_stem.individual_count, |
|
| 8323 |
analytical_stem.plantobservation_id, |
|
| 8324 |
analytical_stem.taxonobservation_id |
|
| 8325 |
FROM analytical_stem |
|
| 8326 |
WHERE (analytical_stem.datasource = 'CVS'::text); |
|
| 8327 |
|
|
| 8328 |
|
|
| 8329 |
-- |
|
| 8252 | 8330 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
| 8253 | 8331 |
-- |
| 8254 | 8332 |
|
| ... | ... | |
| 20016 | 20094 |
|
| 20017 | 20095 |
|
| 20018 | 20096 |
-- |
| 20097 |
-- Name: analytical_stem_CVS; Type: ACL; Schema: public; Owner: - |
|
| 20098 |
-- |
|
| 20099 |
|
|
| 20100 |
REVOKE ALL ON TABLE "analytical_stem_CVS" FROM PUBLIC; |
|
| 20101 |
REVOKE ALL ON TABLE "analytical_stem_CVS" FROM bien; |
|
| 20102 |
GRANT ALL ON TABLE "analytical_stem_CVS" TO bien; |
|
| 20103 |
GRANT SELECT ON TABLE "analytical_stem_CVS" TO bien_read; |
|
| 20104 |
|
|
| 20105 |
|
|
| 20106 |
-- |
|
| 20019 | 20107 |
-- Name: analytical_stem_GBIF; Type: ACL; Schema: public; Owner: - |
| 20020 | 20108 |
-- |
| 20021 | 20109 |
|
Also available in: Unified diff
schemas/public_.sql: added analytical_stem_CVS view