Revision 5757
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1999 | 1999 |
|
| 2000 | 2000 |
|
| 2001 | 2001 |
-- |
| 2002 |
-- Name: plot_change_over_time; Type: VIEW; Schema: public; Owner: - |
|
| 2003 |
-- |
|
| 2004 |
|
|
| 2005 |
CREATE VIEW plot_change_over_time AS |
|
| 2006 |
SELECT analytical_db_view.`dataSourceName`, analytical_db_view.family, analytical_db_view.genus, analytical_db_view.species, analytical_db_view.taxon, analytical_db_view.`taxonAuthor`, analytical_db_view.`taxonMorphospecies`, analytical_db_view.country, analytical_db_view.`stateProvince`, analytical_db_view.`countyParish`, analytical_db_view.collector, analytical_db_view.`collectionNumber`, analytical_db_view.`identifiedBy`, analytical_db_view.`observationDate`, analytical_db_view.`plotCode`, analytical_db_view.`plotAreaHa`, analytical_db_view.`plotMethod`, analytical_db_view.latitude, analytical_db_view.longitude, analytical_db_view.elevation_m, analytical_db_view.`isCultivated`, analytical_db_view.`isCultivatedReason`, analytical_db_view.`pctCover`, analytical_db_view.growthform, analytical_db_view.xposition_m, analytical_db_view.yposition_m FROM analytical_db_view WHERE ((analytical_db_view.`dataSourceName` = CAST('CTFS' AS text)) AND (analytical_db_view.xposition_m IS NOT NULL));
|
|
| 2007 |
|
|
| 2008 |
|
|
| 2009 |
-- |
|
| 2002 | 2010 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2003 | 2011 |
-- |
| 2004 | 2012 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2644 | 2644 |
|
| 2645 | 2645 |
|
| 2646 | 2646 |
-- |
| 2647 |
-- Name: plot_change_over_time; Type: VIEW; Schema: public; Owner: - |
|
| 2648 |
-- |
|
| 2649 |
|
|
| 2650 |
CREATE VIEW plot_change_over_time AS |
|
| 2651 |
SELECT analytical_db_view."dataSourceName", analytical_db_view.family, analytical_db_view.genus, analytical_db_view.species, analytical_db_view.taxon, analytical_db_view."taxonAuthor", analytical_db_view."taxonMorphospecies", analytical_db_view.country, analytical_db_view."stateProvince", analytical_db_view."countyParish", analytical_db_view.collector, analytical_db_view."collectionNumber", analytical_db_view."identifiedBy", analytical_db_view."observationDate", analytical_db_view."plotCode", analytical_db_view."plotAreaHa", analytical_db_view."plotMethod", analytical_db_view.latitude, analytical_db_view.longitude, analytical_db_view.elevation_m, analytical_db_view."isCultivated", analytical_db_view."isCultivatedReason", analytical_db_view."pctCover", analytical_db_view.growthform, analytical_db_view.xposition_m, analytical_db_view.yposition_m FROM analytical_db_view WHERE ((analytical_db_view."dataSourceName" = 'CTFS'::text) AND (analytical_db_view.xposition_m IS NOT NULL)); |
|
| 2652 |
|
|
| 2653 |
|
|
| 2654 |
-- |
|
| 2647 | 2655 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2648 | 2656 |
-- |
| 2649 | 2657 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added initial plot_change_over_time view