Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/NY @ 13123

Name Size Revision Age Author Comment
  Ecatalog_all 13115 almost 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  Source 11396 over 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 almost 12 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
  verify 12039 about 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 almost 11 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 almost 11 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
validations.sql 10.8 KB 13123 almost 11 years Aaron Marcuse-Kubitza fix: inputs/NY/validations.sql: _specimens_*_of...
validations.sql.run 94 Bytes 12922 almost 11 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
  • svn:ignore: *

Latest revisions

# Date Author Comment
13123 04/10/2014 04:06 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: specimens*_of_unique_verbatim_author_taxa_with_genus: use scientificName rather than the concatenated ranks, because that is what is imported to taxonlabel.taxonomicname
13115 04/10/2014 02:24 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: mapped subspecies to new taxonverbatim.subspecies for easier access by validations queries
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

View revisions

Also available in: Atom