Project

General

Profile

Statistics
| Revision:

root @ 1256

Name Size Revision Age Author Comment
  _archive 258 almost 13 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 1229 over 12 years Aaron Marcuse-Kubitza repl: Removed automatic case-insensitivity beca...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 1256 over 12 years Aaron Marcuse-Kubitza Added inputs/UArizona/maps
  lib 1239 over 12 years Aaron Marcuse-Kubitza xpath.py: get(): Added support for lookup-only ...
  mappings 1254 over 12 years Aaron Marcuse-Kubitza specimens verification: Added # binomials test
  schemas 1253 over 12 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.1 KB 1255 over 12 years Aaron Marcuse-Kubitza Makefile: python-Linux: Added python-profiler
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
1256 03/05/2012 10:56 AM Aaron Marcuse-Kubitza

Added inputs/UArizona/maps
1255 03/03/2012 05:56 PM Aaron Marcuse-Kubitza

Makefile: python-Linux: Added python-profiler
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

View all revisions | View revisions

Also available in: Atom