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 13401 over 10 years Aaron Marcuse-Kubitza inputs/input.Makefile: add: verify/: also svn:i...
.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 about 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql, data.sql: updated for ...
data.sql.run 327 Bytes 13372 over 10 years Aaron Marcuse-Kubitza fix: lib/runscripts/file.pg.sql.run: removed in...
grants.sql 1.55 KB 13437 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/grants.sql: added GRANT st...
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 22.8 KB 13508 over 10 years Aaron Marcuse-Kubitza fix: inputs/.TNRS/schema.sql: MatchedTaxon.taxo...
schema.sql.run 134 Bytes 13372 over 10 years Aaron Marcuse-Kubitza fix: lib/runscripts/file.pg.sql.run: removed in...
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
13508 05/21/2014 04:25 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon.taxonomicStatus: filter using map_taxonomic_status() so that the corrected value is available in the normalized DB, not just analytical_stem

13507 05/21/2014 04:05 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: to modify: use new MatchedTaxon_modify(), which eliminates the work of putting together the dependent views

13506 05/21/2014 03:53 PM Aaron Marcuse-Kubitza

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

13503 05/21/2014 04:13 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: map_taxonomic_status(): need to use accepted name instead of scrubbed name (which also includes no-opinion names), as described at http://wiki.vegpath.org/2013-11-14_conference_call#taxonomic-fields. this used to be the accepted name, but got switched when the concatenated name was also used to store the matched name for no-opinion names.

13501 05/21/2014 01:27 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: documented how to modify it (using util.force_recreate())

13498 05/20/2014 05:46 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon, etc.: added accepted_morphospecies_binomial derived field

13444 05/13/2014 04:50 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon.Accepted_name_species: mapped to accepted_species_binomial

13443 05/13/2014 04:09 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: COMMENTs: always include newline before and after

13441 05/13/2014 03:46 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_scrub, etc.: undid rename of accepted name columns to scrubbed_* (r13435), because these are actually not the same (scrubbed_* is the combination of accepted and no-opinion names). the accepted name columns will now be named accepted_*, following the standard naming scheme.

13439 05/13/2014 03:13 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_scrub, etc.: scrubbed_*: use columns from MatchedTaxon whenever possible, to as much as possible avoid the need to join to taxon_scrub.scrubbed_unique_taxon_name.*

View revisions

Also available in: Atom