Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  Source 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  TraitObservation 12060 almost 11 years Aaron Marcuse-Kubitza inputs/bien2_traits/TraitObservation/postproces...
  _MySQL 6881 about 12 years Aaron Marcuse-Kubitza Added inputs/bien2_traits/
  logs 10169 over 11 years Aaron Marcuse-Kubitza inputs/*/logs: updated svn:ignore
  verify 12018 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: add!: verify/: also svn:...
Makefile 27 Bytes 10177 over 11 years Aaron Marcuse-Kubitza inputs/*/: added top-level Makefile which inclu...
import_order.txt 24 Bytes 6881 about 12 years Aaron Marcuse-Kubitza Added inputs/bien2_traits/
run 87 Bytes 10260 over 11 years Aaron Marcuse-Kubitza inputs/*/ which do not contain any explicit col...
table.run 81 Bytes 10179 over 11 years Aaron Marcuse-Kubitza inputs/*/: added table.run for use by the table...
validations.-.util.sql 316 Bytes 12246 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/bien2_traits/validations.sql: us...
validations.sql 4.99 KB 12246 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/bien2_traits/validations.sql: us...
validations.sql.run 94 Bytes 12213 almost 11 years Aaron Marcuse-Kubitza added inputs/bien2_traits/validations.sql.run
  • svn:ignore: *

Latest revisions

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

bugfix: inputs/bien2_traits/validations.sql: use a wrapper function for util.ifnull() so that the views don't get dropped when the util schema is reinstalled

12224 02/14/2014 03:09 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql, schemas/vegbien.sql, lib/runscripts/validations.pg.sql.run, inputs/bien2_traits/validations.sql: added _ to beginning of each view name so the validation views would sort at the top in the datasource's tables list. this will also make the validation result sets easily distinguishable from the data tables.

12221 02/14/2014 12:20 PM Aaron Marcuse-Kubitza

added inputs/bien2_traits/validations.sql, from validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql

12213 02/14/2014 11:00 AM Aaron Marcuse-Kubitza

added inputs/bien2_traits/validations.sql.run

12060 02/06/2014 01:14 PM Aaron Marcuse-Kubitza

inputs/bien2_traits/TraitObservation/postprocess.sql: remove rows with no taxon name, which are invalid, and which helps simplify the aggregating validations queries

12018 02/02/2014 12:49 AM Aaron Marcuse-Kubitza

inputs/input.Makefile: add!: verify/: also svn:ignore *.tsv, *.txt

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11705 11/21/2013 12:24 AM Aaron Marcuse-Kubitza

copyright scrub: inputs/: removed data provider-owned schema and documentation files, which are not BIEN copyright and should not be part of what is submitted for open-sourcing. these files will remain accessible via the web interface (fs.vegpath.org), but will not be in the repository.

11396 10/21/2013 07:14 PM Aaron Marcuse-Kubitza

fix: bin/map: put template: comment out the "Put template:" label so that the output is valid XML, and displays properly in a browser rather than showing a syntax error

11107 09/29/2013 08:58 PM Aaron Marcuse-Kubitza

bugfix: mappings/VegCore-VegBIEN.csv: nest all taxonoccurrences inside a stratum event, so that the parent locationevent is always fully populated before child locationevents point to it. (previously, a stub parent event was created when the child event was imported first, which blocked the fully-populated parent event from being inserted later on.) this uses auto-folding (for VegBank/CVS) and auto-forwarding (for other datasources) to prune empty stratum events for taxonoccurrences that don't have strata. (see wiki.vegpath.org/Auto-folding, wiki.vegpath.org/Auto-forwarding for more info about these normalization techniques.) note that the inserted row counts stay exactly the same for all datasources except VegBank (which was being fixed), indicating that this signficant change to the mappings did not change the semantics of the import of taxonoccurrences.

View revisions

Also available in: Atom