Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  logs 10168 over 11 years Aaron Marcuse-Kubitza inputs/*/*/logs: updated svn:ignore
.map.csv.last_cleanup 0 Bytes 4929 about 12 years Aaron Marcuse-Kubitza inputs/VegBank/: Added stemcount/
VegBIEN.csv 42 Bytes 10943 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/: switched to new-style import, ...
_no_import 0 Bytes 11013 about 11 years Aaron Marcuse-Kubitza inputs//: don't import joined tables, because t...
create.sql 79 Bytes 6746 almost 12 years Aaron Marcuse-Kubitza inputs/VegBank/: Joined together taxonimportanc...
header.csv 259 Bytes 6746 almost 12 years Aaron Marcuse-Kubitza inputs/VegBank/: Joined together taxonimportanc...
map.csv 1.52 KB 11095 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/VegBank/: taxonOccurrenceID: inc...
new_terms.csv 904 Bytes 11022 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/stemcount_/map.csv: stratum_id: ...
postprocess.sql 649 Bytes 11095 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/VegBank/: taxonOccurrenceID: inc...
run 63 Bytes 10943 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/: switched to new-style import, ...
test.xml.ref 1.62 KB 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
unmapped_terms.csv 454 Bytes 11095 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/VegBank/: taxonOccurrenceID: inc...
  • 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).

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.

11095 09/28/2013 05:04 AM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/: taxonOccurrenceID: include the aggregateOrganismObservationID in this so that there is one taxonoccurrence for each stratum's taxonImportance. this allows the different strata to have separate taxonoccurrences that are associated with the stratum-specific locationevents, rather than all being lumped into one taxonoccurrence, with only one locationevent.

11022 09/19/2013 06:46 PM Aaron Marcuse-Kubitza

inputs/VegBank/stemcount_/map.csv: stratum_id: removed table prefix so it can be used as a join column

11013 09/19/2013 02:55 AM Aaron Marcuse-Kubitza

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

11007 09/18/2013 10:28 PM Aaron Marcuse-Kubitza

inputs/VegBank/stemcount_/postprocess.sql: moved stemcount___parent index before the derived columns section because it does not depend on them

11006 09/18/2013 10:26 PM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/stemcount_/postprocess.sql: added missing index on taxonOccurrenceID, needed for the 1:many portion of the taxon_observation.** left-join

10992 09/15/2013 01:54 PM Aaron Marcuse-Kubitza

inputs/VegBank/stemcount_/postprocess.sql: added primary key. note that the inserted row count changes, most likely because the rows are now in sorted order.

10944 09/12/2013 06:43 PM Aaron Marcuse-Kubitza

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

View revisions

Also available in: Atom