Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  Source 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  _archive 7837 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/: Moved no longer needed public.un...
  logs 8801 over 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
  tnrs 9972 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: added Is_homonym...
  verify 12018 over 10 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
.htaccess 387 Bytes 8511 over 11 years Aaron Marcuse-Kubitza web/**/.htaccess: appended query strings for ex...
Makefile 27 Bytes 10178 over 11 years Aaron Marcuse-Kubitza inputs/*/: added top-level Makefile which inclu...
data.sql 12.8 KB 11708 almost 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql, data.sql: updated for ...
data.sql.run 294 Bytes 10789 about 11 years Aaron Marcuse-Kubitza inputs/.TNRS/data.sql.run: added refresh() targ...
grants.sql 85 Bytes 10108 over 11 years Aaron Marcuse-Kubitza added inputs/.TNRS/grants.sql, with statements ...
import_order.txt 7 Bytes 7838 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/import_order.txt: Removed public.u...
run 87 Bytes 10294 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/: switched to new-style import. be...
schema.sql 19.5 KB 11965 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: scrubbed_famil...
schema.sql.run 89 Bytes 10779 about 11 years Aaron Marcuse-Kubitza added lib/runscripts/schema.pg.sql.run and use ...
table.run 81 Bytes 10179 over 11 years Aaron Marcuse-Kubitza inputs/*/: added table.run for use by the table...
  • svn:ignore: *

Latest revisions

# Date Author Comment
12018 02/02/2014 12:49 AM Aaron Marcuse-Kubitza

inputs/input.Makefile: add!: verify/: also svn:ignore *.tsv, *.txt

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11965 01/16/2014 01:22 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so we are now using Family_matched as a workaround to populate this. the workaround is for accepted names only, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse.

11964 01/16/2014 01:19 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: reexported from live DB, which changes the element order

11912 12/16/2013 01:43 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: granted bien_read SELECT access to derived views as well as the core tnrs table

11715 11/21/2013 11:08 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: updated runtime (30 min) and rowcount (+2 million)

11711 11/21/2013 09:04 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): is_valid_match: set this to false if Taxonomic_status is Invalid

11709 11/21/2013 08:49 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added map_taxonomic_status()

11708 11/21/2013 08:48 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql, data.sql: updated for PostgreSQL 9.3

11647 11/13/2013 02:48 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs_populate_fields(): regenerate the derived cols: updated runtime (40 min)

View revisions

Also available in: Atom