Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/NY @ 13138

Name Size Revision Age Author Comment
  Ecatalog_all 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  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 238 Bytes 13126 over 10 years Aaron Marcuse-Kubitza inputs/NY/run: `make inputs/NY/validate`: docum...
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 641 Bytes 13137 over 10 years Aaron Marcuse-Kubitza inputs/NY/validations.-.util.sql: added util.is...
validations.sql 11.1 KB 13138 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/validations.sql: _specimens_13_c...
validations.sql.run 94 Bytes 12922 over 10 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
  • svn:ignore: *

Latest revisions

# Date Author Comment
13138 04/15/2014 06:52 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: use new is_castable(), which is much more accurate than Brad's custom regexp for determining if something is numeric
13137 04/15/2014 06:29 PM Aaron Marcuse-Kubitza

inputs/NY/validations.-.util.sql: added util.is_castable() wrapper
13130 04/14/2014 04:51 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to include both lat and long in the value to DISTINCT on
13129 04/14/2014 04:48 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to DISTINCT the values that are being counted, because they are merged by the coordinates_unique unique constraint in the import
13126 04/14/2014 03:58 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: documented slow queries: _specimens_12_distinct_collector_name_collect_num_date_w_count
13124 04/14/2014 03:22 PM Aaron Marcuse-Kubitza

inputs/NY/run, inputs/SALVIAS/run_: `make inputs/.../validate`: updated runtime (+2 min)
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

View revisions

Also available in: Atom