Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/NY @ 13152

Name Size Revision Age Author Comment
  Ecatalog_all 13149 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/Ecatalog_all/map.csv, postproces...
  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 236 Bytes 13151 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 641 Bytes 13137 over 10 years Aaron Marcuse-Kubitza inputs/NY/validations.-.util.sql: added util.is...
validations.sql 11.5 KB 13152 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/NY/validations.sql: _specimens_0...
validations.sql.run 94 Bytes 12922 over 10 years Aaron Marcuse-Kubitza added inputs/NY/validations*.sql*
  • svn:ignore: *

Latest revisions

# Date Author Comment
13152 04/16/2014 10:49 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_07_list_of_verbatim_subspecific_taxa_with_author: updated filter condition to match output query
13151 04/16/2014 10:48 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: updated runtime (8 min, with added queries)
13150 04/16/2014 10:24 PM Aaron Marcuse-Kubitza

fix: inputs/NY/Ecatalog_all/map.csv, postprocess.sql: remapped substrate, vegetation to locationRemarks
13149 04/16/2014 06:41 PM Aaron Marcuse-Kubitza

fix: inputs/NY/Ecatalog_all/map.csv, postprocess.sql: remapped substrate, vegetation to locationRemarks
13147 04/16/2014 04:24 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql, schemas/vegbien.sql: _specimens_13*: also need to include coordinate pairs which have one of their coordinates NULL, by using OR instead of AND
13146 04/16/2014 04:15 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_13b_list_of_all_decimal_lat_long: matched column types to output query
13145 04/16/2014 04:14 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_13a_list_of_all_verbatim_lat_long: matched column types to output query
13144 04/16/2014 03:13 PM Aaron Marcuse-Kubitza

inputs/NY/validations.sql, schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: added breakdowns _specimens_13a_list_of_all_verbatim_lat_long, _specimens_13b_list_of_all_decimal_lat_long to help troubleshoot the diff
13143 04/16/2014 02:04 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql, schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: count lat/longs together instead of separately, because the DISTINCT is by coordinate pair, not individual coordinate value (which wouldn't make much sense)
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

View revisions

Also available in: Atom