Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 10896 about 11 years Aaron Marcuse-Kubitza added BIEN2/traits_observation_counts.xls
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  backups 11697 about 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 11456 about 11 years Aaron Marcuse-Kubitza bugfix: bin/with_all: @inputs default value: us...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 11591 about 11 years Aaron Marcuse-Kubitza derived/biengeo/load-geoscrub-input.sh: allow t...
  exports 11599 about 11 years Aaron Marcuse-Kubitza exports/2013-7-10.Naia.range_limiting_factors.c...
  inputs 11688 about 11 years Aaron Marcuse-Kubitza inputs/CVS/run: `make .../reinstall`: documente...
  lib 11665 about 11 years Aaron Marcuse-Kubitza bugfix: lib/Firefox_bookmarks.reformat.csv: rem...
  mappings 11513 about 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped taxon_dete...
  planning 11693 about 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: hid previo...
  schemas 11696 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sync_analytical_stem_to_vi...
  web 11699 about 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 13.2 KB 11675 about 11 years Aaron Marcuse-Kubitza fix: /Makefile: $(macPostgresLibs): added libpq...
README.TXT 25.1 KB 11686 about 11 years Aaron Marcuse-Kubitza bugfix: /README.TXT: to backup files not in Tim...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
run 511 Bytes 11590 about 11 years Aaron Marcuse-Kubitza /run: use new exports/geoscrub_input.csv.run
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
11699 11/19/2013 09:21 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: open-sourcing: added potential licenses we could use (public domain/CC0, BSD, GNU Verbatim Copying License, not CC-BY because incompatible w/ GPL).

11698 11/19/2013 08:31 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: added links related to open-sourcing it, including the "Request to Open Source Software" form, the funding sources that need to be included in it, and part of the delegation of authority chain (from the UC Regents) that authorizes the open-sourcing.

11697 11/18/2013 11:38 PM Aaron Marcuse-Kubitza

backups/TNRS.backup.md5: updated

11696 11/18/2013 05:40 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sync_analytical_stem_to_view(): use new util.force_recreate() instead of manually dropping and re-creating every view that uses this. this avoids the need to add several lines to this function every time we add a new scientific view (of which we expect to have many), because force_recreate()'s error parsing handles this automatically. this makes it possible for a non-expert user to add scientific views without compromising the ability to add columns to analytical_stem_view, because they don't need to understand Postgres's dependency error messages when updating analytical_stem with this function.

11695 11/18/2013 05:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: added force_recreate(), for use by sync_analytical_stem_to_view(). this uses the new `GET STACKED DIAGNOSTICS` in PostgreSQL 9.3 to access the DETAIL section of the dependent_objects_still_exist error.

11694 11/18/2013 12:10 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. upgrading to PostgreSQL 9.3: added Linux pg_upgrade steps and install instructions. added Mac PostGIS, psycopg2 install steps. added note that after installing, you need to restore config values that the upgrade reset: in pgAdmin > Preferences > Query tool > Query editor, set Max characters per column back to -1 (to avoid cells being truncated). (this is not a bug in PostgreSQL, only in pgAdmin, and does not signal a need to downgrade.)

11693 11/18/2013 06:52 AM Aaron Marcuse-Kubitza

planning/timeline/timeline.2013.xls: hid previous weeks

11692 11/18/2013 06:51 AM Aaron Marcuse-Kubitza

planning/timeline/timeline.2013.xls: rescheduled tasks

11691 11/18/2013 06:45 AM Aaron Marcuse-Kubitza

planning/timeline/timeline.2013.xls: added timespan checkmarks

11690 11/18/2013 06:44 AM Aaron Marcuse-Kubitza

planning/timeline/timeline.2013.xls: hid completed tasks

View all revisions | View revisions

Also available in: Atom