Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/NY @ 13082

Name Size Revision Age Author Comment
  Ecatalog_all 12960 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/NY/Ecatalog_all/map.csv: can't u...
  Source 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  _archive 7550 almost 12 years Aaron Marcuse-Kubitza Added inputs/NY/_archive/
  _src 7571 almost 12 years Aaron Marcuse-Kubitza inputs/: Added .md5 files for all .zip, .gz
  logs 8801 over 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
  verify 12039 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: verify/%.out: use a *.sq...
Makefile 27 Bytes 10177 over 11 years Aaron Marcuse-Kubitza inputs/*/: added top-level Makefile which inclu...
NYSpecimenDataAmericas.csv.tar.gz.md5 33 Bytes 7571 almost 12 years Aaron Marcuse-Kubitza inputs/: Added .md5 files for all .zip, .gz
NYSpecimenDataAmericas.csv.tar.gz.url 83 Bytes 7590 almost 12 years Aaron Marcuse-Kubitza Added inputs/NY/NYSpecimenDataAmericas.csv.tar....
NY_DATA_20130212.~.utils.sql 128 Bytes 7624 almost 12 years Aaron Marcuse-Kubitza inputs/NY/NY_DATA_20130212.~.utils.sql: pkey: M...
import_order.txt 20 Bytes 7549 almost 12 years Aaron Marcuse-Kubitza inputs/NY/: Removed tables from previous extract
new_terms.csv 422 Bytes 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...
run 159 Bytes 13070 over 10 years Aaron Marcuse-Kubitza inputs/NY/run: `make inputs/NY/validate`: updat...
table.run 81 Bytes 10179 over 11 years Aaron Marcuse-Kubitza inputs/*/: added table.run for use by the table...
unmapped_terms.csv 302 Bytes 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...
validations.-.util.sql 316 Bytes 12922 over 10 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
validations.sql 11.4 KB 13042 over 10 years Aaron Marcuse-Kubitza validation/aggregating/specimens/qualitative_va...
validations.sql.run 94 Bytes 12922 over 10 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
  • svn:ignore: *

Latest revisions

# Date Author Comment
13070 04/08/2014 01:40 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: updated runtime (6.5 min). this increases as more queries are able to run successfully.
13065 04/07/2014 06:19 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: updated runtime (5 min)
13056 04/07/2014 09:47 AM Aaron Marcuse-Kubitza

inputs/NY/run: documented `make inputs/NY/validate` runtime (2 min, currently for the input queries)
13042 04/02/2014 05:21 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_species_binomials: renamed columns to species_binomial to reflect reverted query name
13041 04/02/2014 05:16 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_verbatim_species_excluding_author: renamed to *_species_binomials for clarity
13040 04/02/2014 05:14 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: _specimens_04_count_of_unique_verbatim_species_with_author, _specimens_05_list_of_unique_verbatim_species_with_author: switched back to original names because #6,7 now do the same thing as #4,5, so we should include the differing result set of #4,5 for datasources that provide it
13038 04/02/2014 04:38 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: use taxon_name*_with_author everywhere instead of custom column names, for consistency
13037 04/02/2014 04:09 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_verbatim_subspecific_taxa_without_author, etc.: renamed to *_with_author because these now use the concatenated name, rather than the without-author name that only some specimens datasources provide
13035 04/02/2014 03:54 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_verbatim_species_without_author, etc.: renamed to *_with_author because these now use the concatenated name, rather than the without-author name that only some specimens datasources provide
12960 03/28/2014 02:03 AM Aaron Marcuse-Kubitza

bugfix: inputs/NY/Ecatalog_all/map.csv: can't use CatalogNumber as pkey because it's not unique and not always populated. this fixes the NY NULL accessionNumbers bug (wiki.vegpath.org/Aggregating_validations_status#bugs).

View revisions

Also available in: Atom