Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  logs 8801 about 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
.map.csv.last_cleanup 0 Bytes 8164 over 11 years Aaron Marcuse-Kubitza inputs/FIA/*/import: Use map_table to set colum...
VegBIEN.csv 42 Bytes 10174 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/input.Makefile: %/VegBIEN.csv: f...
_no_import 0 Bytes 10052 almost 11 years Aaron Marcuse-Kubitza added inputs/FIA/*/_no_import to src tables tha...
header.csv 464 Bytes 8164 over 11 years Aaron Marcuse-Kubitza inputs/FIA/*/import: Use map_table to set colum...
map.csv 1.41 KB 10947 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/*/map.csv: use -- to separate the ta...
new_terms.csv 940 Bytes 10947 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/*/map.csv: use -- to separate the ta...
postprocess.sql 486 Bytes 10086 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/*/postprocess.sql: removed svn:execu...
run 63 Bytes 10082 almost 11 years Aaron Marcuse-Kubitza added inputs/FIA/*/run. these do not yet use th...
test.xml.ref 9.69 KB 14454 almost 10 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: prefixed ...
unmapped_terms.csv 829 Bytes 10947 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/*/map.csv: use -- to separate the ta...
  • svn:ignore: *

Latest revisions

# Date Author Comment
14454 08/11/2014 03:40 AM Aaron Marcuse-Kubitza

bugfix: mappings/VegCore-VegBIEN.csv: prefixed taxonomic ranks: use _concat_nullify() so that the prefix is only added if the epithet is non-NULL

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

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).

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.

10947 09/14/2013 04:34 PM Aaron Marcuse-Kubitza

inputs/FIA/*/map.csv: use -- to separate the table and column name instead of - , to conform with the u-name format (wiki.vegpath.org/u-name#format), which works even when only one of _- can be used in the name. -s are needed in this case to linewrap the column on a separate line as the table in phpPgAdmin.

10866 09/04/2013 11:06 PM Aaron Marcuse-Kubitza

inputs/*/*/test.xml.ref: updated source.shortname for new datasource name, which now starts out with .new suffix

10174 07/06/2013 03:55 PM Aaron Marcuse-Kubitza

bugfix: inputs/input.Makefile: %/VegBIEN.csv: for new-style datasources, use a symlink to mappings/VegCore-VegBIEN.csv directly instead of prefiltering VegCore-VegBIEN.csv to include only the columns in map.csv. prefiltering used to be performed as part of mapping the map.csv VegCore output terms to VegBIEN using bin/join, but is no longer needed because the staging table columns are now VegCore terms. instead, the full VegCore-VegBIEN.csv is needed so that derived columns added in stage I or II validations are detected by bin/map (rather than just the original source columns in map.csv).

10090 06/27/2013 12:23 PM Aaron Marcuse-Kubitza

added inputs/FIA/*/{VegBIEN.csv,test.xml.ref}, which are now generated by the mapping process for the joined-together tables (even though they are not used by the import, because only occurrence_all is imported)

10086 06/27/2013 12:12 PM Aaron Marcuse-Kubitza

inputs/FIA/*/postprocess.sql: removed svn:executable attribute using `svn pdel svn:executable ...` now that these are not shell scripts

View revisions

Also available in: Atom