Project

General

Profile

Statistics
| Revision:

root @ 7303

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 7303 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
7303 01/18/2013 10:08 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: isNewWorld: Removed no longer needed COALESCE to false, because newWorldCountries now uses false where applicable instead of NULL. This also ensures that isNewWorld will be NULL if there is no country name to test, which was not the case in the previous workaround.
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

View all revisions | View revisions

Also available in: Atom