Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7037 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7293 almost 12 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: Added Max_score ...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7302 almost 12 years Aaron Marcuse-Kubitza Added inputs/newWorld/newWorldCountries/ with p...
  lib 7290 almost 12 years Aaron Marcuse-Kubitza csvs.py: ColInsertFilter: Support adding multip...
  mappings 7215 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: fieldNumber (auth...
  schemas 7301 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: isNe...
  to_do 7207 almost 12 years Aaron Marcuse-Kubitza Added to_do/timeline.2013.xls (from Brad, conve...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 11.8 KB 7268 almost 12 years Aaron Marcuse-Kubitza root Makefile: Datasources: import: Use new imp...
README.TXT 17.2 KB 7300 almost 12 years Aaron Marcuse-Kubitza README.TXT: Full database import: freeing disk ...
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
7302 01/18/2013 10:02 AM Aaron Marcuse-Kubitza

Added inputs/newWorld/newWorldCountries/ with postprocess.sql that sets isNewWorld to false wherever it's NULL. (The input table only marks New World countries as true, but doesn't mark non-New World countries as false.)

7301 01/18/2013 09:50 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: isNewWorld: Fixed bug where need to COALESCE "newWorldCountries"."isNewWorld" to false, because it is only set to a boolean for countries that are New World

7300 01/18/2013 09:19 AM Aaron Marcuse-Kubitza

README.TXT: Full database import: freeing disk space: Updated import schema size, which is smaller due to the removed CTFS staging tables, removed duplicate rows, and possibly fewer index holes

7299 01/18/2013 08:56 AM Aaron Marcuse-Kubitza

README.TXT: Full database import: After running `make schemas/$version/publish`, added `unset version` to make sure future version-dependent commands use the public schema

7298 01/18/2013 08:50 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxon_trait_view: Fixed bug where measurementUnit needed to be set to trait.units, not name

7297 01/18/2013 08:42 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: provider_count_view: Don't set default values for sourcetype/observationtype, because the appropriate values are now set for all top-level inputs and these defaults are not applicable for data owners not in geoscrub.herbaria

7296 01/18/2013 08:41 AM Aaron Marcuse-Kubitza

inputs/bien2_traits/Source/map.csv: Mapped observationType

7295 01/18/2013 08:27 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxondetermination: Removed taxondetermination_computer_min_fit CHECK constraint, whose functionality is now duplicated by unscrubbed_taxondetermination_view's Max_score filter condition. The score threshold value should only be maintained in one place, namely unscrubbed_taxondetermination_view.

7294 01/18/2013 08:23 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Fixed bug where need to filter out any names that will be rejected by taxondetermination's constraints, because otherwise, these names will stay in unscrubbed_taxondetermination_view and be repeatedly reimported

7293 01/18/2013 07:38 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: Added Max_score column for use in filtering out names that will be rejected by taxondetermination's constraints

View all revisions | View revisions

Also available in: Atom