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 about 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
_no_import 0 Bytes 11760 about 11 years Aaron Marcuse-Kubitza inputs/CVS/: don't import joined tables, becaus...
create.sql 230 Bytes 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
header.csv 2.18 KB 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
map.csv 6.42 KB 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
new_terms.csv 2.68 KB 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
postprocess.sql 888 Bytes 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
run 63 Bytes 11749 about 11 years Aaron Marcuse-Kubitza inputs/CVS/: switched to new-style import, usin...
test.xml.ref 14.7 KB 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
unmapped_terms.csv 2.73 KB 11809 almost 11 years Aaron Marcuse-Kubitza fix: inputs/CVS/taxonObservation_/create.sql: m...
  • 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).

11809 12/03/2013 02:57 PM Aaron Marcuse-Kubitza

fix: inputs/CVS/taxonObservation_/create.sql: mapped identifiedBy, which involves joining to party

11808 12/03/2013 02:35 PM Aaron Marcuse-Kubitza

inputs/CVS/cvs.~.clean_up.sql: don't rename taxonInterpretation.PARTY_ID, so that this can be USING-joined to party in inputs/CVS/taxonObservation_/create.sql

11799 12/03/2013 05:19 AM Aaron Marcuse-Kubitza

fix: inputs/CVS/taxon_observation.**/map.csv: omit authorPlantName because it is not specific to the taxonInterpretation row (this is in a separate taxonInterpretation for the original determination instead)

11775 11/26/2013 01:42 PM Aaron Marcuse-Kubitza

inputs/CVS/taxonObservation_/map.csv: removed taxonObservation_-- prefix from terms that do not need to be table-specific (like for VegBank)

11773 11/26/2013 01:30 PM Aaron Marcuse-Kubitza

fix: inputs/CVS/taxonObservation_/map.csv: plantConcept_ columns: synced input and output column names to their names in plantConcept_

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

11759 11/26/2013 05:53 AM Aaron Marcuse-Kubitza

inputs/CVS/: added taxon_observation.** left-join of the tables, using the steps at http://wiki.vegpath.org/Left-joining_a_datasource. this involves renaming taxonOccurrenceID->taxonOccurrenceID__overall_plot so that it can then be joined together with aggregateOrganismObservationID to create the full taxonOccurrenceID (as in VegBank).

11757 11/25/2013 10:14 PM Aaron Marcuse-Kubitza

inputs/CVS/taxonObservation_/map.csv: mapped TAXONINTERPRETATION_ID to identificationID

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

View revisions

Also available in: Atom