Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 13771 over 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/taxonomy/: moved into schemas/V...
  backups 13902 over 10 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 13866 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: insert na...
  config 13553 over 10 years Aaron Marcuse-Kubitza removed no longer used config/VirtualBox_VMs/Ve...
  derived 13854 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/web_app/protocol/
  downloads 13537 over 10 years Aaron Marcuse-Kubitza added downloads/
  exports 13929 over 10 years Aaron Marcuse-Kubitza exports/2014-6-4.Iara_Lacher.reserve_prioritiza...
  inputs 13883 over 10 years Aaron Marcuse-Kubitza inputs/publishable datasources.xlsx: updated
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 13860 over 10 years Aaron Marcuse-Kubitza lib/tnrs.py: dirty: documented that this actual...
  mappings 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  planning 13880 over 10 years Aaron Marcuse-Kubitza planning/meetings/BIEN conference call availabi...
  schemas 13928 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/public_.sql: 2014-6-4.Iara_Lach...
  validation 13844 over 10 years Aaron Marcuse-Kubitza validation/aggregating/plots/bien3_validations_...
  web 13831 over 10 years Aaron Marcuse-Kubitza bugfix: web/.phpPgAdmin/.htaccess: : handlers: ...
  wiki 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
.htaccess 326 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.17 KB 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
Makefile 12.7 KB 13848 over 10 years Aaron Marcuse-Kubitza /Makefile, lib/phpPgAdmin.login.php.diff: publi...
README.TXT 34 KB 13877 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Mac settings backup: backu...
fix_perms 97 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
13929 07/08/2014 04:17 PM Aaron Marcuse-Kubitza

exports/2014-6-4.Iara_Lacher.reserve_prioritization.csv.run: documented runtime (7.5 min) and rowcount (3.5 million)

13928 07/08/2014 03:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: fixed slowdown in materializing the view, which was caused by source__observation_type(), by replacing this with a LEFT JOIN as was done for is_threatened_iucn

13927 07/07/2014 07:33 AM Aaron Marcuse-Kubitza

schemas/util.sql: in_south_america(): optimized by using BETWEEN instead of util.contained_within__no_dateline(). this reduces the filter time for 2014-6-4.Iara_Lacher.reserve_prioritization by about 10%.

13926 07/07/2014 07:26 AM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: is_threatened_iucn: generate this much faster by doing a LEFT JOIN, which can reuse the same in-memory hash index for every row

13925 07/07/2014 07:04 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: wrapper functions can't use util-schema types because these will cause the wrapper function to be cascadingly dropped when the util schema is reinstalled

13924 07/07/2014 06:55 AM Aaron Marcuse-Kubitza

bugfix: in_south_america(): must use util.contained_within__no_dateline() instead of util.contained_within_approx() to ensure that the more accurate geometry logic is used

13923 07/07/2014 06:51 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: source__observation_type(): don't display NOTICEs about the search_path, because this function will be called millions of times

13922 07/07/2014 06:48 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: in_iucn_red_list(): don't display NOTICEs about the search_path, because this function will be called millions of times

13921 07/07/2014 06:43 AM Aaron Marcuse-Kubitza

schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added is_threatened_iucn

13920 07/07/2014 06:37 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added in_iucn_red_list()

View revisions

Also available in: Atom