Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6458 about 12 years Aaron Marcuse-Kubitza vegbien_dest: $schemas: Removed analytical_db b...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6455 about 12 years Aaron Marcuse-Kubitza inputs/import.stats.xls: Added separate tab wit...
  lib 6444 about 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Support None in_table b...
  mappings 6432 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Mapped locality d...
  schemas 6453 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: scie...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 12.1 KB 6447 about 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: $(postgresReload-Lin...
README.TXT 14.6 KB 6373 about 12 years Aaron Marcuse-Kubitza README.TXT: Datasource setup: Add input data fo...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6458 11/25/2012 08:21 PM Aaron Marcuse-Kubitza

vegbien_dest: $schemas: Removed analytical_db because views that will be added to it were shadowing public schema tables with the same names during population of those tables in make_analytical_db

6457 11/25/2012 07:47 PM Aaron Marcuse-Kubitza

vegbien_dest: Export $public, to make sure it's available to any invoked scripts as an env var

6456 11/25/2012 07:45 PM Aaron Marcuse-Kubitza

vegbien_dest: $schemas: Added analytical_db

6455 11/25/2012 07:38 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Added separate tab with stats for 2012-6~9. The Excel format apparently only supports 255 columns, so previous imports had been silently truncated off. Note that once the 2012-10 imports reach column 255, a new tab will need to be created with the 2012-10+ imports.

6454 11/25/2012 07:20 PM Aaron Marcuse-Kubitza

bin/map: in_is_db: by_col: Clearing errors table: Skip this if the table has been set to None because it didn't exist (and thus was a metadata-only map spreadsheet)

6453 11/25/2012 06:54 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scientificNameWithMorphospecies: Fixed bug where need to use the specific_epithet from the accepted_taxonverbatim rather than the parsed_taxonverbatim

6452 11/25/2012 06:45 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scientificNameWithMorphospecies: Include the family any time the genus is not specified, instead of just when accepted_taxonlabel.rank = 'family'. These should have the same effect since TNRS includes the rank, but using COALESCE is clearer.

6451 11/25/2012 06:41 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scientificNameWithMorphospecies: Changed to also include morphospecies when just the family is specified

6450 11/25/2012 06:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Fixed bug where location.authorlocationcode needed to be used as the plotName when location.sourceaccessioncode was not provided, to ensure that plotName would be NOT NULL

6449 11/25/2012 06:20 PM Aaron Marcuse-Kubitza

inputs/FIA/import_order.txt: Fixed bug where FIA_COND_unique needed to be explicitly included in import_order.txt now that we're using import_order.txt to import the Source metadata table before the data tables

View all revisions | View revisions

Also available in: Atom