Project

General

Profile

Statistics
| Revision:

root @ 1254

Name Size Revision Age Author Comment
  _archive 258 about 13 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 1229 almost 13 years Aaron Marcuse-Kubitza repl: Removed automatic case-insensitivity beca...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 1254 almost 13 years Aaron Marcuse-Kubitza specimens verification: Added # binomials test
  lib 1239 almost 13 years Aaron Marcuse-Kubitza xpath.py: get(): Added support for lookup-only ...
  mappings 1254 almost 13 years Aaron Marcuse-Kubitza specimens verification: Added # binomials test
  schemas 1253 almost 13 years Aaron Marcuse-Kubitza vegbien.sql: specimenreplicate: Removed specime...
  to_do 811 almost 13 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 6.08 KB 1241 almost 13 years Aaron Marcuse-Kubitza Makefile: Print done message after verify
README.TXT 1.62 KB 879 almost 13 years Aaron Marcuse-Kubitza Switched to using inputs/test as main test target
map 900 Bytes 1093 almost 13 years Aaron Marcuse-Kubitza env_password: Fixed bug where exit command woul...

Latest revisions

# Date Author Comment
1254 03/03/2012 05:44 PM Aaron Marcuse-Kubitza

specimens verification: Added # binomials test
1253 03/03/2012 05:35 PM Aaron Marcuse-Kubitza

vegbien.sql: specimenreplicate: Removed specimenreplicate_unique_collectionnumber index because the collectionnumber (NYBG FieldNumber) is not always unique within a collector, even though it should be. Changed specimenreplicate_unique_catalognumber to only operate on rows with no sourceaccessioncode (of which there are 8 in NYBG).
1252 03/03/2012 05:09 PM Aaron Marcuse-Kubitza

mappings/verify.specimens.sql: # species test: Fixed to join separately on taxondeterminations for genus and species. # genera test: Removed no longer needed join on party.
1251 03/03/2012 05:04 PM Aaron Marcuse-Kubitza

vegbien.sql: specimenreplicate: Added fki index on taxonoccurrence_id
1250 03/03/2012 04:25 PM Aaron Marcuse-Kubitza

vegbien.sql: plantname: Added index on rank to speed up specimens verifications, where the query planner insists on joining from plantname to specimenreplicate instead of the other way around (which takes much longer without the index)
1249 03/03/2012 03:33 PM Aaron Marcuse-Kubitza

mappings/verify.*: Use nested SELECT instead of JOIN on party to get datasource_id, so that party will not be joined on after other joins have already occurred (which slows things down)
1248 03/03/2012 03:26 PM Aaron Marcuse-Kubitza

vegbien.sql: party: Changed party_unique_name to ignore NULL values and the organizationname (a first(+middle)+last name is considered unique)
1247 03/03/2012 03:15 PM Aaron Marcuse-Kubitza

vegbien.sql: party: Added party_unique_organizationname constraint
1246 03/03/2012 02:11 PM Aaron Marcuse-Kubitza

Specimens verification: Added # genera and # species
1245 03/03/2012 01:50 PM Aaron Marcuse-Kubitza

input.Makefile: verify: Create target dir if it doesn't exist

View all revisions | View revisions

Also available in: Atom