/trunk/inputs/NY - Repository - BIEN 3 - NCEAS Projects

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	13087	over 10 years	Aaron Marcuse-Kubitza	bugfix: schemas/vegbien.sql, inputs/NY/validati...
validations.sql.run	94 Bytes	12922	over 10 years	Aaron Marcuse-Kubitza	added inputs/NY/validations.sql

#	Date	Author	Comment
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.
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

Project

General

Profile

Latest revisions

Project

General

Profile

root/trunk/inputs/NY @ 13087

Latest revisions