Revision 13832
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3282 | 3282 |
|
| 3283 | 3283 |
|
| 3284 | 3284 |
-- |
| 3285 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: - |
|
| 3286 |
-- |
|
| 3287 |
|
|
| 3288 |
|
|
| 3289 |
|
|
| 3290 |
|
|
| 3291 |
-- |
|
| 3285 | 3292 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3286 | 3293 |
-- |
| 3287 | 3294 |
|
| ... | ... | |
| 12896 | 12903 |
|
| 12897 | 12904 |
|
| 12898 | 12905 |
-- |
| 12906 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: ACL; Schema: public; Owner: - |
|
| 12907 |
-- |
|
| 12908 |
|
|
| 12909 |
|
|
| 12910 |
|
|
| 12911 |
|
|
| 12912 |
|
|
| 12913 |
|
|
| 12914 |
|
|
| 12915 |
-- |
|
| 12899 | 12916 |
-- Name: address; Type: ACL; Schema: public; Owner: - |
| 12900 | 12917 |
-- |
| 12901 | 12918 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 5518 | 5518 |
|
| 5519 | 5519 |
|
| 5520 | 5520 |
-- |
| 5521 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: - |
|
| 5522 |
-- |
|
| 5523 |
|
|
| 5524 |
CREATE VIEW "2014-6-4.Iara_Lacher.reserve_prioritization" AS |
|
| 5525 |
SELECT analytical_stem.country, |
|
| 5526 |
analytical_stem."decimalLatitude", |
|
| 5527 |
analytical_stem."decimalLongitude", |
|
| 5528 |
analytical_stem."dateCollected", |
|
| 5529 |
COALESCE(analytical_stem."specimenHolderInstitutions", analytical_stem.datasource) AS orig_datasource, |
|
| 5530 |
analytical_stem.scrubbed_family AS accepted_family, |
|
| 5531 |
analytical_stem.scrubbed_genus AS accepted_genus, |
|
| 5532 |
analytical_stem.scrubbed_species_binomial AS accepted_species_binomial, |
|
| 5533 |
analytical_stem.scrubbed_taxon_name_with_author AS accepted_taxon_name_with_author, |
|
| 5534 |
analytical_stem."growthForm" AS lifeform |
|
| 5535 |
FROM analytical_stem |
|
| 5536 |
WHERE ((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem.taxonomic_status = 'accepted'::text), false)); |
|
| 5537 |
|
|
| 5538 |
|
|
| 5539 |
-- |
|
| 5521 | 5540 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 5522 | 5541 |
-- |
| 5523 | 5542 |
|
| ... | ... | |
| 16588 | 16607 |
|
| 16589 | 16608 |
|
| 16590 | 16609 |
-- |
| 16610 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: ACL; Schema: public; Owner: - |
|
| 16611 |
-- |
|
| 16612 |
|
|
| 16613 |
REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM PUBLIC; |
|
| 16614 |
REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM bien; |
|
| 16615 |
GRANT ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien; |
|
| 16616 |
GRANT SELECT ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien_read; |
|
| 16617 |
|
|
| 16618 |
|
|
| 16619 |
-- |
|
| 16591 | 16620 |
-- Name: address; Type: ACL; Schema: public; Owner: - |
| 16592 | 16621 |
-- |
| 16593 | 16622 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 5518 | 5518 |
|
| 5519 | 5519 |
|
| 5520 | 5520 |
-- |
| 5521 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: - |
|
| 5522 |
-- |
|
| 5523 |
|
|
| 5524 |
CREATE VIEW "2014-6-4.Iara_Lacher.reserve_prioritization" AS |
|
| 5525 |
SELECT analytical_stem.country, |
|
| 5526 |
analytical_stem."decimalLatitude", |
|
| 5527 |
analytical_stem."decimalLongitude", |
|
| 5528 |
analytical_stem."dateCollected", |
|
| 5529 |
COALESCE(analytical_stem."specimenHolderInstitutions", analytical_stem.datasource) AS orig_datasource, |
|
| 5530 |
analytical_stem.scrubbed_family AS accepted_family, |
|
| 5531 |
analytical_stem.scrubbed_genus AS accepted_genus, |
|
| 5532 |
analytical_stem.scrubbed_species_binomial AS accepted_species_binomial, |
|
| 5533 |
analytical_stem.scrubbed_taxon_name_with_author AS accepted_taxon_name_with_author, |
|
| 5534 |
analytical_stem."growthForm" AS lifeform |
|
| 5535 |
FROM analytical_stem |
|
| 5536 |
WHERE ((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem.taxonomic_status = 'accepted'::text), false)); |
|
| 5537 |
|
|
| 5538 |
|
|
| 5539 |
-- |
|
| 5521 | 5540 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 5522 | 5541 |
-- |
| 5523 | 5542 |
|
| ... | ... | |
| 16588 | 16607 |
|
| 16589 | 16608 |
|
| 16590 | 16609 |
-- |
| 16610 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: ACL; Schema: public; Owner: - |
|
| 16611 |
-- |
|
| 16612 |
|
|
| 16613 |
REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM PUBLIC; |
|
| 16614 |
REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM bien; |
|
| 16615 |
GRANT ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien; |
|
| 16616 |
GRANT SELECT ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien_read; |
|
| 16617 |
|
|
| 16618 |
|
|
| 16619 |
-- |
|
| 16591 | 16620 |
-- Name: address; Type: ACL; Schema: public; Owner: - |
| 16592 | 16621 |
-- |
| 16593 | 16622 |
|
Also available in: Unified diff
schemas/public_.sql: added 2014-6-4.Iara_Lacher.reserve_prioritization