Project

General

Profile

# Date Author Comment
12002 01/23/2014 01:22 AM Aaron Marcuse-Kubitza

fix: inputs/SALVIAS/salvias_plots.~.clean_up.sql: Remove private data that should not be publicly visible: also need to remove metadata-only plots

11982 01/20/2014 10:10 PM Aaron Marcuse-Kubitza

fix: inputs/SALVIAS/salvias_plots.~.clean_up.sql: Delete rows that do not satisfy foreign key constraints: also need to do this for plotObservations, since the refreshed data contains dangling rows for that as well

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).

8067 03/16/2013 06:46 AM Aaron Marcuse-Kubitza

Refreshed SALVIAS

6167 11/14/2012 04:47 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/: Updated to new salvias_plots export on nimoy, which has a different schema

6166 11/14/2012 04:03 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Moved Ensure globally unique column names to end to match VegBank order

6163 11/14/2012 03:18 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Remove private data that should not be publicly visible, indicated by plotMetadata.AccessCode = 1

6162 11/14/2012 03:17 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Enable cascading deletes by adding the necessary fkeys

6126 11/13/2012 03:25 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Rename lookup_MethodCode.Description to lookup_MethodCode_Description to make it globally unique when joined with plotMetadata