Project

General

Profile

Statistics
| Revision:

root @ 6111

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 6104 about 12 years Aaron Marcuse-Kubitza Added import_name, which gets the name of an im...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6110 about 12 years Aaron Marcuse-Kubitza Added inputs/.geoscrub/geoscrub_cultivated/
  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 6111 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: Fixe...
  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 10.1 KB 6102 about 12 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where sc...
README.TXT 12.8 KB 6105 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Instead of using `make...
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
6111 11/09/2012 06:32 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Fixed bug where needed to join on new geoscrub_cultivated, not geoscrub, for all geoscrub-related information. geoscrub contains many duplicate records, causing one input row to match many rows in geoscrub, when there should only be one entry for each coordinate pair.
6110 11/09/2012 06:26 PM Aaron Marcuse-Kubitza

Added inputs/.geoscrub/geoscrub_cultivated/
6109 11/09/2012 06:04 PM Aaron Marcuse-Kubitza

inputs/.geoscrub/geoscrub_cleaned_unique/create.sql: Added index on latitudeDecimalVerbatim, longitudeDecimalVerbatim for use by analytical_stem_view
6108 11/09/2012 05:34 PM Aaron Marcuse-Kubitza

inputs/newWorld/geoscrub.schema.~.changes.sql: Change countryNameStd type to text to allow merge-joining with place.country in analytical_stem_view
6107 11/09/2012 05:28 PM Aaron Marcuse-Kubitza

inputs/newWorld/geoscrub.schema.~.changes.sql: ALTER TABLE ... ALTER COLUMN statement: Reformatted to allow adding additional ALTER COLUMN clauses
6106 11/09/2012 05:25 PM Aaron Marcuse-Kubitza

inputs/.geoscrub/geoscrub_cleaned_unique/create.sql: Change latitudeDecimalVerbatim, longitudeDecimalVerbatim types to double precision to allow merge-joining with coordinates.latitude_deg, longitude_deg in analytical_stem_view
6105 11/09/2012 05:12 PM Aaron Marcuse-Kubitza

README.TXT: Data import: Instead of using `make schemas/rotate` and then renaming the public schema to the correct name, just rename directly to the correct name using `make schemas/rename/...`. Use new import_name to determine the import name instead of manually finding the date in the first datasource's log file name.
6104 11/09/2012 05:06 PM Aaron Marcuse-Kubitza

Added import_name, which gets the name of an import based on its log file names
6103 11/09/2012 04:50 PM Aaron Marcuse-Kubitza

README.TXT: Data import: Moved checking that imports were successful before running make_analytical_db
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

View all revisions | View revisions

Also available in: Atom