Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 almost 11 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 13088 over 10 years Aaron Marcuse-Kubitza _license/UCSB/LICENSE.TXT: use (c) verbatim fro...
  backups 13008 over 10 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 13077 over 10 years Aaron Marcuse-Kubitza bin/repl: match as whole-word text (like SQL id...
  config 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  derived 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  exports 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  inputs 13138 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/validations.sql: _specimens_13_c...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 13116 over 10 years Aaron Marcuse-Kubitza bugfix: lib/sh/util.sh: local_array/export_arra...
  mappings 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  planning 13053 over 10 years Aaron Marcuse-Kubitza planning/workflow/bien3_architecture/stage_I.pn...
  schemas 13136 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added is_castable()
  validation 13128 over 10 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/aggregating_val...
  web 13114 over 10 years Aaron Marcuse-Kubitza bugfix: web/.phpPgAdmin/.htaccess: work around ...
  wiki 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
.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.18 KB 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
Makefile 13.7 KB 13015 over 10 years Aaron Marcuse-Kubitza /Makefile: postgres_restart-Linux: documented t...
README.TXT 31.7 KB 13119 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: to i...
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
13138 04/15/2014 06:52 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: use new is_castable(), which is much more accurate than Brad's custom regexp for determining if something is numeric

13137 04/15/2014 06:29 PM Aaron Marcuse-Kubitza

inputs/NY/validations.-.util.sql: added util.is_castable() wrapper

13136 04/15/2014 06:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: added is_castable()

13135 04/15/2014 06:10 PM Aaron Marcuse-Kubitza

schemas/util.sql: added try_cast()

13134 04/15/2014 05:51 PM Aaron Marcuse-Kubitza

schemas/util.sql: added util.cast(), which allows casting to an arbitrary type without eval()

13133 04/14/2014 05:04 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: DISTINCT: added coordsaccuracy_m

13132 04/14/2014 05:02 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: coordinates_unique: added coordsaccuracy_m

13131 04/14/2014 04:56 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to DISTINCT the values that are being counted, because the coordinates_unique unique constraint includes other columns as well, so there may be multiple instances of each lat/long

13130 04/14/2014 04:51 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to include both lat and long in the value to DISTINCT on

13129 04/14/2014 04:48 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to DISTINCT the values that are being counted, because they are merged by the coordinates_unique unique constraint in the import

View revisions

Also available in: Atom