Project

General

Profile

Statistics
| Revision:
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 1246 almost 13 years Aaron Marcuse-Kubitza Specimens verification: Added # genera and # sp...
  lib 1239 almost 13 years Aaron Marcuse-Kubitza xpath.py: get(): Added support for lookup-only ...
  mappings 1249 almost 13 years Aaron Marcuse-Kubitza mappings/verify.*: Use nested SELECT instead of...
  schemas 1251 almost 13 years Aaron Marcuse-Kubitza vegbien.sql: specimenreplicate: Added fki index...
  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
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

1244 03/03/2012 01:42 PM Aaron Marcuse-Kubitza

inputs/NYBG: Added verify/specimens.ref.sql

1243 03/03/2012 01:41 PM Aaron Marcuse-Kubitza

Added mappings/verify.specimens.sql

1242 03/03/2012 01:41 PM Aaron Marcuse-Kubitza

Added inputs/NYBG-CSV/verify/

View all revisions | View revisions

Also available in: Atom