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 4368 over 12 years Aaron Marcuse-Kubitza inputs/CTFS/: Added TaxonOccurrence/ and its jo...
VegBIEN.csv 42 Bytes 10419 over 11 years Aaron Marcuse-Kubitza inputs/CTFS/: switched to new-style import, usi...
_no_import 0 Bytes 7790 almost 12 years Aaron Marcuse-Kubitza inputs/CTFS/: Switched global _no_import to tab...
create.sql 248 Bytes 11865 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/CTFS/import_order.txt: added *.s...
header.csv 525 Bytes 5695 about 12 years Aaron Marcuse-Kubitza inputs/*/*/header.csv: Regenerated for new stag...
map.csv 1.16 KB 11877 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/CTFS/TaxonOccurrence*/map.csv: t...
new_terms.csv 45 Bytes 7216 almost 12 years Aaron Marcuse-Kubitza input.Makefile: Maps validation: %/new_terms.cs...
run 63 Bytes 10419 over 11 years Aaron Marcuse-Kubitza inputs/CTFS/: switched to new-style import, usi...
test.xml.ref 8.04 KB 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
unmapped_terms.csv 466 Bytes 11877 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/CTFS/TaxonOccurrence*/map.csv: t...
  • svn:ignore: *

Latest revisions

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

11877 12/09/2013 06:56 PM Aaron Marcuse-Kubitza

bugfix: inputs/CTFS/TaxonOccurrence*/map.csv: things mapped to taxonObservationID: remapped to taxonOccurrenceID since taxonObservationID is not mapped to anything in VegBIEN (denormalized VegCore doesn't distinguish between taxon occurrences and taxon observations of them)

11865 12/06/2013 07:46 AM Aaron Marcuse-Kubitza

bugfix: inputs/CTFS/import_order.txt: added *.src so that these would be installed under new-style import as well. this means that their columns will now be automapped, requiring the names to be renamed to VegCore names in */create.sql. note that VegCore taxonOccurrenceID has been renamed to taxonObservationID since this was last run.

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.

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

10419 07/25/2013 01:59 PM Aaron Marcuse-Kubitza

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

10257 07/11/2013 12:09 PM Aaron Marcuse-Kubitza

inputs/*/*/map.csv: added distinguishing #... suffix (e.g. UNUSED#institutionID) to the special terms OMIT, PRIVATE, UNUSED (VegCore.vegpath.org#Special-terms) to avoid creating a collision in the staging table renaming

10206 07/10/2013 02:17 AM Aaron Marcuse-Kubitza

inputs/CTFS/*/map.csv: added *.src.row_num from joined tables so that the map.csv input columns would match the staging table. this is needed for the staging table column renaming, which is positional rather than name-based to work with any existing column name.

View revisions

Also available in: Atom