Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  logs 8801 over 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
.map.csv.last_cleanup 0 Bytes 6742 almost 12 years Aaron Marcuse-Kubitza inputs/CVS/: Refreshed data with new export fro...
VegBIEN.csv 42 Bytes 11749 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
_no_import 0 Bytes 11760 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: don't import joined tables, becaus...
create.sql 142 Bytes 11718 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/CVS/observation_/create.sql: onl...
header.csv 3.18 KB 6742 almost 12 years Aaron Marcuse-Kubitza inputs/CVS/: Refreshed data with new export fro...
map.csv 9.33 KB 11754 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: prepended the table name to each c...
new_terms.csv 9.14 KB 11754 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: prepended the table name to each c...
postprocess.sql 304 Bytes 11749 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
run 63 Bytes 11749 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
test.xml.ref 2.23 KB 11749 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
unmapped_terms.csv 5.72 KB 11754 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/: prepended the table name to each c...
  • svn:ignore: *

Latest revisions

# Date Author Comment
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).

11760 11/26/2013 05:54 AM Aaron Marcuse-Kubitza

inputs/CVS/: don't import joined tables, because they are now imported in the taxon_observation.** left-join instead

11754 11/25/2013 09:43 PM Aaron Marcuse-Kubitza

inputs/CVS/: prepended the table name to each column name to prevent column collisions, using the steps at http://wiki.vegpath.org/Left-joining_a_datasource

11749 11/25/2013 07:52 PM Aaron Marcuse-Kubitza

inputs/CVS/: switched to new-style import, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource

11720 11/21/2013 01:11 PM Aaron Marcuse-Kubitza

inputs/CVS/observation_/postprocess.sql: added pkey from the primary joined table. added _parent index to facilitate joins.

11718 11/21/2013 01:01 PM Aaron Marcuse-Kubitza

bugfix: inputs/CVS/observation_/create.sql: only include one soilObs for each observation (using DISTINCT ON), rather than just left-joining them

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.

11105 09/28/2013 10:40 PM Aaron Marcuse-Kubitza

bugfix: mappings/VegCore-VegBIEN.csv: stratum's locationevent: link this to the parent locationevent, so that the parent locationevent's information (such as locationeventcontributors) is accessible to the stratum's locationevent

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

View revisions

Also available in: Atom