Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  .NCBI 12029 almost 11 years Aaron Marcuse-Kubitza inputs/.geoscrub/county_centroids/test.xml.ref,...
  .TNRS 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  .archive 11717 about 11 years Aaron Marcuse-Kubitza inputs/: removed SALVIAS-CSV, because this is a...
  .geoscrub 12029 almost 11 years Aaron Marcuse-Kubitza inputs/.geoscrub/county_centroids/test.xml.ref,...
  .herbaria 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  ACAD 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  ARIZ 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  BRIT 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  CTFS 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  CVS 12038 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/project/: added _no_import sinc...
  FIA 12028 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/taxon_observation.**/header.csv: upd...
  GBIF 12516 almost 11 years Aaron Marcuse-Kubitza bugfix: *.sql: public.source_by_shortname(): ne...
  HIBG 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  HVAA 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  IRMNG 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  IUCN 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  JBM 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  MO 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  MT 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  Madidi 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  NCU 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  NVS 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  NY 12039 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: verify/%.out: use a *.sq...
  QFA 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  REMIB 12516 almost 11 years Aaron Marcuse-Kubitza bugfix: *.sql: public.source_by_shortname(): ne...
  SALVIAS 12526 almost 11 years Aaron Marcuse-Kubitza inputs/SALVIAS/validations.sql: use plot_code i...
  SpeciesLink 12516 almost 11 years Aaron Marcuse-Kubitza bugfix: *.sql: public.source_by_shortname(): ne...
  TEAM 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  TEX 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  TRT 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  TRTE 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  TurboVeg 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  U 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  UBC 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  UNCC 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  VASCAN 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  VegBIEN 12112 almost 11 years Aaron Marcuse-Kubitza fix: inputs/VegBIEN/Redmine/wiki/.htaccess: red...
  VegBank 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  WIN 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  XAL 12030 almost 11 years Aaron Marcuse-Kubitza added inputs/XAL/Specimen/_no_import, since thi...
  analytical_db 11567 about 11 years Aaron Marcuse-Kubitza added inputs/analytical_db/_archive/
  bien2_traits 12367 almost 11 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: _traits_08_taxonname_...
  bien_web 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  newWorld 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  test_taxonomic_names 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
.htaccess 334 Bytes 8513 over 11 years Aaron Marcuse-Kubitza added .htaccess files for inputs/, schemas/ bec...
.rsync_filter.download 18 Bytes 10043 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: test*.xml: turn on syncin...
.rsync_filter.starscream.download 24 Bytes 10039 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: install.log.sql: only exc...
.rsync_filter.starscream.upload 24 Bytes 10039 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: install.log.sql: only exc...
.rsync_filter.vegbiendev.upload 18 Bytes 10067 over 11 years Aaron Marcuse-Kubitza inputs/: don't upload test*.xml to jupiter on v...
BIEN2.datasources.xlsx 14.8 KB 3607 over 12 years Aaron Marcuse-Kubitza Added inputs/BIEN2.datasources.xlsx (formerly b...
Makefile 540 Bytes 10026 over 11 years Aaron Marcuse-Kubitza inputs/Makefile: download-logs: use bin/sync_up...
datasource_release_status.xlsx 33 Bytes 11942 almost 11 years Aaron Marcuse-Kubitza inputs/datasource_release_status.xlsx: renamed ...
import.stats.xls 1.2 MB 12158 almost 11 years Aaron Marcuse-Kubitza inputs/import.stats.xls: updated import times
input.Makefile 19 KB 12220 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: $(svnFilesGlob): added v...
publishable datasources.xlsx 6.06 KB 12005 almost 11 years Aaron Marcuse-Kubitza inputs/publishable datasources.xlsx: updated
publishable datasources.xlsx.url 88 Bytes 11942 almost 11 years Aaron Marcuse-Kubitza inputs/datasource_release_status.xlsx: renamed ...
table.run 81 Bytes 10179 over 11 years Aaron Marcuse-Kubitza inputs/*/: added table.run for use by the table...
  • svn:ignore: .~*

Latest revisions

# Date Author Comment
12526 02/27/2014 06:58 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/validations.sql: use plot_code instead of plotcode for easier readability

12516 02/27/2014 01:27 PM Aaron Marcuse-Kubitza

bugfix: *.sql: public.source_by_shortname(): need to wrap it in a nested SELECT because Postgres incorrectly does not constant-fold (inline) it, leading to a slowdown when it is therefore run many times. this is done using the steps at wiki.vegpath.org/Postgres_queries#wrap-function-call-in-nested-SELECT .

12508 02/26/2014 11:58 PM Aaron Marcuse-Kubitza

fix: inputs/SALVIAS/validations.sql: plotMetadata.SiteCode: need to match types with the output query column

12417 02/24/2014 10:51 PM Aaron Marcuse-Kubitza

fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query

12407 02/24/2014 08:58 AM Aaron Marcuse-Kubitza

inputs/SALVIAS/validations.sql: added Brad's comments from validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql

12406 02/24/2014 08:53 AM Aaron Marcuse-Kubitza

added inputs/SALVIAS/validations*.sql

12367 02/23/2014 12:13 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: _traits_08_taxonname_trait_and_value_for_first_5000_records: renamed to _traits_08_taxonname_trait_and_value because this actually includes all the records, not just the first 5000. this uses the new public_validations.rename_query_view() to rename all associated tables and views, including handling truncated names.

12286 02/17/2014 01:58 PM Aaron Marcuse-Kubitza

bugfix: inputs/bien2_traits/validations.sql: _traits_01_count_records: changed column names to match public_validations._traits_01_count_records

12246 02/16/2014 04:22 PM Aaron Marcuse-Kubitza

bugfix: inputs/bien2_traits/validations.sql: use a wrapper function for util.ifnull() so that the views don't get dropped when the util schema is reinstalled

12224 02/14/2014 03:09 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql, schemas/vegbien.sql, lib/runscripts/validations.pg.sql.run, inputs/bien2_traits/validations.sql: added _ to beginning of each view name so the validation views would sort at the top in the datasource's tables list. this will also make the validation result sets easily distinguishable from the data tables.

View revisions

Also available in: Atom