Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/VegBank/plot_ @ 13649

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 4514 over 12 years Aaron Marcuse-Kubitza inputs/VegBank/: Added plot_/
VegBIEN.csv 42 Bytes 10943 over 11 years Aaron Marcuse-Kubitza inputs/VegBank/: switched to new-style import, ...
_no_import 0 Bytes 11013 over 11 years Aaron Marcuse-Kubitza inputs//: don't import joined tables, because t...
create.sql 1.24 KB 11601 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/VegBank/: need to remove inter-d...
header.csv 1.04 KB 11801 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/plot/postprocess.sql: locality: ...
map.csv 2.29 KB 11801 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/plot/postprocess.sql: locality: ...
new_terms.csv 220 Bytes 11601 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/VegBank/: need to remove inter-d...
run 63 Bytes 10943 over 11 years Aaron Marcuse-Kubitza inputs/VegBank/: switched to new-style import, ...
test.xml.ref 5.98 KB 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
unmapped_terms.csv 741 Bytes 11801 about 11 years Aaron Marcuse-Kubitza inputs/VegBank/plot/postprocess.sql: locality: ...
  • 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).
11801 12/03/2013 06:51 AM Aaron Marcuse-Kubitza

inputs/VegBank/plot/postprocess.sql: locality: include the site name (authorlocation), because this is part of the unique specification of the place that was sampled
11601 11/08/2013 10:28 PM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/: need to remove inter-datasource duplicates from plot instead of the left-joined plot_ table, because the fkeys needed to do the cascading deletes are all to the plot table. this requires doing the column-renaming and postprocessing on plot before it's left-joined.
11600 11/08/2013 09:57 PM Aaron Marcuse-Kubitza

inputs/VegBank/plot_/create.sql: updated runtime (5 s) for previous bugfix
11488 10/30/2013 04:23 PM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/plot_/postprocess.sql: coordinateUncertaintyInMeters__from_fuzzing: need to convert km to m in the fuzzing radii. updated derived cols runtimes.
11487 10/30/2013 04:05 PM Aaron Marcuse-Kubitza

inputs/VegBank/plot_/postprocess.sql: remove duplicated CVS plots (2323 of 7079 CVS plots are removed by this)
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
11265 10/13/2013 12:10 AM Aaron Marcuse-Kubitza

inputs/VegBank/plot_/create.sql: documented runtime (5 min)
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
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