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 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 6108 about 12 years Aaron Marcuse-Kubitza inputs/newWorld/geoscrub.schema.~.changes.sql: ...
  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 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
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

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)

View all revisions | View revisions

Also available in: Atom