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 4751 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5985 about 12 years Aaron Marcuse-Kubitza import_times: Use $'' quoting to expand tab, in...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6000 about 12 years Aaron Marcuse-Kubitza inputs/SALVIAS/verify/plots.ref.sql: Standardiz...
  lib 5993 about 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Setting pkeys of missin...
  mappings 5999 about 12 years Aaron Marcuse-Kubitza mappings/verify.plots.sql: Added "top-level" to...
  schemas 5996 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: Use ...
  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 9.87 KB 5679 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: schemas/rot...
README.TXT 12.5 KB 5966 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: After import, removed ...
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
6000 11/05/2012 08:17 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Standardized line wrapping to put ; on its own line in multi-line queries and at the end of the line in one-line queries

5999 11/05/2012 08:13 PM Aaron Marcuse-Kubitza

mappings/verify.plots.sql: Added "top-level" to # locations, # location events names because these queries do not include all locations

5998 11/05/2012 07:52 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: # locations: Fixed count to include all plotMetadata entries instead of just unique coordinates, because each plotMetadata entry now gets its own location

5997 11/05/2012 07:34 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: matched place: When any of the accepted* names is specified, set matched_place_id=0 (self-reference) to indicate that the matched place is an accepted (scrubbed) place

5996 11/05/2012 05:30 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Use the canonical (scrubbed) place instead of the datasource's place where available. Note that canon_place_id is always populated (with a self-reference if needed), to enable using a just a LEFT JOIN for this.

5995 11/05/2012 05:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Use datasource_* prefix instead of reference_* prefix that tables had gotten when datasource_id was renamed to reference_id

5994 11/05/2012 05:04 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref: Regenerated on vegbiendev using the PostgreSQL 9.1 pg_catalog.default collation

5993 11/05/2012 04:49 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Setting pkeys of missing rows: Fixed bug in column-based import where when input rows match multiple output rows in one of this iteration's input tables, the into table's pkey constraint is violated because full_in_table contains multiple entries for an input pkey

5992 11/05/2012 04:42 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: place: Added index on matched_place_id to facilitate looking up places by matched_place_id in place_set_canon_place_id()

5991 11/05/2012 04:26 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added geoscrub_input derived table with associated view. Build geoscrub_input as part of make_analytical_db().

View all revisions | View revisions

Also available in: Atom