Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/NY @ 13114

Name Size Revision Age Author Comment
  Ecatalog_all 13112 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/Ecatalog_all/map.csv: Scientific...
  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 about 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 about 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.2 KB 13112 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/Ecatalog_all/map.csv: Scientific...
validations.sql.run 94 Bytes 12922 over 10 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
  • svn:ignore: *

Latest revisions

# Date Author Comment
13112 04/10/2014 01:25 PM Aaron Marcuse-Kubitza

fix: inputs/NY/Ecatalog_all/map.csv: ScientificName: remapped to scientificName instead of taxonName as this does include the author
13111 04/10/2014 01:17 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: specimens*_of_unique_verb_subsp_taxa_with_author: use taxonName instead of concatenating the ranks, as that corresponds to what we use as the concatenated taxonomic name
13110 04/10/2014 12:59 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: specimens*_of_verbatim_subspecific_taxa_with_author: need `subspecies IS NOT NULL` filter
13109 04/10/2014 12:57 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_07_list_of_verbatim_subspecific_taxa_with_author: need to include subspecies (as _specimens_06_count_of_unique_verb_subsp_taxa_with_author does)
13107 04/10/2014 12:03 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: specimens*_of_species_binomials: removed incorrect `subspecies IS NOT NULL` filter (this should be on *_of_unique_verb_subsp_taxa_with_author instead)
13095 04/10/2014 03:45 AM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_16_list_distinct_specimen_descriptions: removed duplicated rows using DISTINCT
13089 04/10/2014 02:34 AM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_03_list_of_verbatim_families: use family as specified in query description, not as implemented
13087 04/10/2014 02:07 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql, inputs/NY/validations.sql, validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: dateCollected: cast this to text rather than date because some values for this field are not valid dates and will throw an error if cast to date
13086 04/09/2014 08:19 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: dateCollected: matched type to output query
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.

View revisions

Also available in: Atom