| 2654 |
|
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));
|
schemas/vegbien.sql: Removed no longer used plot_change_over_time view. Use one of the queries at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Plot_change_over_time_analysis> instead.