Project

General

Profile

Statistics
| Revision:

root @ 6102

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 4751 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6097 about 12 years Aaron Marcuse-Kubitza psql_vegbien: Added $no_search_path option to t...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6094 about 12 years Aaron Marcuse-Kubitza inputs/SALVIAS/plotMetadata/: LEFT JOINed with ...
  lib 6027 about 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Remove SELECT pg_cata...
  mappings 6083 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Added threatened
  schemas 6101 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: cult...
  to_do 4524 about 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 10.1 KB 6102 about 12 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where sc...
README.TXT 12.7 KB 6059 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Before starting import...
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 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6102 11/09/2012 04:41 PM Aaron Marcuse-Kubitza

root Makefile: Installation: Fixed bug where schemas/install needed to happen after inputs/install because some of the public schema's views now depend on inputs
6101 11/09/2012 04:07 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: cultivatedBasis: Concatenate ''::text to geoscrub.isCultivatedReason so it will be cast to a text field both on PostgreSQL 9.1.1 (local machine), which removes any explicit cast to text when creating the view, and 9.1.6 (vegbiendev), which requires an explicit cast to text
6100 11/09/2012 03:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: cultivatedBasis: Use geoscrub.isCultivatedReason instead when geoscrub.isCultivated is used as the source for cultivated
6099 11/09/2012 12:53 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Use geoscrub.isCultivated when taxonoccurrence.iscultivated is not provided (joining to geoscrub on the coordinates)
6098 11/08/2012 06:38 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: Run all schema installs and uninstalls using no_search_path=1, so that the schemas in the automatic search_path are not required for the command to run
6097 11/08/2012 06:37 PM Aaron Marcuse-Kubitza

psql_vegbien: Added $no_search_path option to turn off the automatic SET search_path directive
6096 11/08/2012 06:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonverbatim: Added growthform for growthform based on the taxon name rather than provided with the input data's taxonoccurrence
6095 11/08/2012 06:00 PM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Fixed lines
6094 11/08/2012 05:47 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/plotMetadata/: LEFT JOINed with lookup_MethodCode to create plotMetadata_
6093 11/08/2012 04:52 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: threatened_taxonlabel_view: Fixed bug where needed DISTINCT on resulting taxonlabel_id because some descendants apparently appear in multiple threatened taxonlabels' subtrees

View all revisions | View revisions

Also available in: Atom