Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  .NCBI 12029 almost 11 years Aaron Marcuse-Kubitza inputs/.geoscrub/county_centroids/test.xml.ref,...
  .TNRS 12779 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  .archive 11717 about 11 years Aaron Marcuse-Kubitza inputs/: removed SALVIAS-CSV, because this is a...
  .geoscrub 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  .herbaria 12879 over 10 years Aaron Marcuse-Kubitza mappings/VegCore.htm: regenerated from wiki: re...
  ACAD 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  ARIZ 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  BRIT 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  CTFS 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  CVS 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  FIA 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  GBIF 12988 over 10 years Aaron Marcuse-Kubitza added inputs/GBIF/_src/0001000-131106143450413....
  HIBG 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  HVAA 12963 over 10 years Aaron Marcuse-Kubitza fix: inputs/*/*/map.csv: remapped occurrenceID-...
  IRMNG 12967 over 10 years Aaron Marcuse-Kubitza lib/sh/make.sh: self_make(): renamed to with_rm...
  IUCN 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  JBM 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  MO 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  MT 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  Madidi 13055 over 10 years Aaron Marcuse-Kubitza added inputs/Madidi/_src/ to match wiki steps i...
  NCU 12963 over 10 years Aaron Marcuse-Kubitza fix: inputs/*/*/map.csv: remapped occurrenceID-...
  NVS 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  NY 13143 over 10 years Aaron Marcuse-Kubitza fix: inputs/NY/validations.sql, schemas/vegbien...
  QFA 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  REMIB 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  SALVIAS 13125 over 10 years Aaron Marcuse-Kubitza inputs/SALVIAS/run_: `make inputs/SALVIAS/valid...
  SpeciesLink 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  TEAM 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  TEX 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  TRT 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  TRTE 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  TurboVeg 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  U 13075 over 10 years Aaron Marcuse-Kubitza fix: inputs/U/Specimen/map.csv: Genus: remapped...
  UBC 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  UNCC 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  VASCAN 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  VegBIEN 12112 almost 11 years Aaron Marcuse-Kubitza fix: inputs/VegBIEN/Redmine/wiki/.htaccess: red...
  VegBank 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  WIN 12886 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate.institut...
  XAL 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  analytical_db 11567 about 11 years Aaron Marcuse-Kubitza added inputs/analytical_db/_archive/
  bien2_traits 13067 over 10 years Aaron Marcuse-Kubitza inputs/bien2_traits/run: documented `make input...
  bien_web 12963 over 10 years Aaron Marcuse-Kubitza fix: inputs/*/*/map.csv: remapped occurrenceID-...
  newWorld 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
  test_taxonomic_names 13113 over 10 years Aaron Marcuse-Kubitza fix: inputs/test_taxonomic_names/Taxon/map.csv:...
.htaccess 334 Bytes 8513 over 11 years Aaron Marcuse-Kubitza added .htaccess files for inputs/, schemas/ bec...
.rsync_filter.download 18 Bytes 10043 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: test*.xml: turn on syncin...
.rsync_filter.starscream.download 24 Bytes 10039 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: install.log.sql: only exc...
.rsync_filter.starscream.upload 24 Bytes 10039 over 11 years Aaron Marcuse-Kubitza inputs/.rsync_ignore: install.log.sql: only exc...
.rsync_filter.vegbiendev.upload 18 Bytes 10067 over 11 years Aaron Marcuse-Kubitza inputs/: don't upload test*.xml to jupiter on v...
BIEN2.datasources.xlsx 14.8 KB 3607 over 12 years Aaron Marcuse-Kubitza Added inputs/BIEN2.datasources.xlsx (formerly b...
Makefile 540 Bytes 10026 over 11 years Aaron Marcuse-Kubitza inputs/Makefile: download-logs: use bin/sync_up...
datasource_release_status.xlsx 33 Bytes 11942 almost 11 years Aaron Marcuse-Kubitza inputs/datasource_release_status.xlsx: renamed ...
import.stats.xls 1.2 MB 12158 almost 11 years Aaron Marcuse-Kubitza inputs/import.stats.xls: updated import times
input.Makefile 19.1 KB 13018 over 10 years Aaron Marcuse-Kubitza lib/common.Makefile: added $(nice) and use it e...
publishable datasources.xlsx 6.06 KB 12005 almost 11 years Aaron Marcuse-Kubitza inputs/publishable datasources.xlsx: updated
publishable datasources.xlsx.url 88 Bytes 11942 almost 11 years Aaron Marcuse-Kubitza inputs/datasource_release_status.xlsx: renamed ...
run 207 Bytes 12891 over 10 years Aaron Marcuse-Kubitza inputs/run: postprocess(): documented runtime o...
  • svn:ignore: .~*

Latest revisions

# Date Author Comment
13143 04/16/2014 02:04 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql, schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: count lat/longs together instead of separately, because the DISTINCT is by coordinate pair, not individual coordinate value (which wouldn't make much sense)

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

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

13126 04/14/2014 03:58 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: documented slow queries: _specimens_12_distinct_collector_name_collect_num_date_w_count

13125 04/14/2014 03:23 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/run_: `make inputs/SALVIAS/validate`: documented slow queries (_plots_06a_list_of_stems). these may need to have their query plans rechecked.

13124 04/14/2014 03:22 PM Aaron Marcuse-Kubitza

inputs/NY/run, inputs/SALVIAS/run_: `make inputs/.../validate`: updated runtime (+2 min)

13123 04/10/2014 04:06 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: specimens*_of_unique_verbatim_author_taxa_with_genus: use scientificName rather than the concatenated ranks, because that is what is imported to taxonlabel.taxonomicname

13115 04/10/2014 02:24 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: mapped subspecies to new taxonverbatim.subspecies for easier access by validations queries

View revisions

Also available in: Atom