schemas/vegbien.sql: locationevent__pull_forward_from_parent(): renamed to locationevent_pull_forward_from_parent_for_stratum() since it actually has a filter that causes it to apply only to stratum events

added validation/aggregating/, containing folders for Brad's scripts (the scripts themselves cannot be in the repository because they are not UCSB-owned)

web/links/index.htm: updated to Firefox bookmarks: svn: added steps to add a file containing (append to the path)

web/links/index.htm: updated to Firefox bookmarks: `mysql`: added commands to get interactive formatting (including echoed queries) when inputting from a file, and to get raw formatting when inputting from the console. git: added equivalent to `svn update`.

bugfix: schemas/vegbien.sql: commconcept: added missing unique constraint on commdescription, which is also an identifying field in addition to the ID (which is in commname.commname)

inputs/publishable datasources.xlsx: updated

inputs/publishable datasources.xlsx: updated

fix: inputs/SALVIAS/projects/postprocess.sql: remove private data that should not be publicly visible: remove projects that do not have "There are no specific use conditions attached to this dataset"

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

bugfix: inputs/SALVIAS/plotMetadata_/map.csv: things mapped to project_participant: remapped to event__participant because these actually relate to the event, not the project, even though they seem like project-related fields

mappings/VegCore-VegBIEN.csv: event__participant: allow multiple event__participant columns

fix: inputs/SALVIAS/plotMetadata_/map.csv, inputs/Madidi/LocationObservation/map.csv: things mapped to communityID: remapped to communityName, which is what's used in analytical_stem (communityID is for numeric IDs)

bugfix: schemas/vegbien.sql: locationevent__communities(): inner-join to commdetermination instead of left-joining, so that this does not produce community entries (which occur because there is one commclass per locationevent, but only some commclasses will then have a commdetermination)

inputs/SALVIAS/plotMetadata_/create.sql, map.csv: expanded plot_administrator:party_code_party_ and mapped plot_administrator_name to a 2nd project_participant

mappings/VegCore-VegBIEN.csv: project_participant: use [!...] negative lookahead assertion so that multiple project_participant columns will properly map to separate projectcontributor rows

fix: lib/Parser.py: syntax_err(): error message: lightened the shade of gray so the boundary between the strings before and after the error would be clearer

inputs/SALVIAS/plotMetadata_/map.csv: mapped PrimOwnerID_name->project_participant

inputs/SALVIAS/plotMetadata_/create.sql: added join to PrimOwnerID:party_code_party_

bugfix: inputs/SALVIAS/import_order.txt: added party_code_party_

bugfix: inputs/SALVIAS/party_code_party_/create.sql: need to remove duplicate entries in party_code_party

schemas/vegbien.sql: projectcontributor: added missing unique constraint

web/links/index.htm: updated to Firefox bookmarks: OS X 10.9 Mavericks upgrade: added links for whether to upgrade (conclusion: don't, it breaks existing programs)

inputs/SALVIAS/party_code_party_/map.csv: mapped fullname->event_participant_name for use by other tables

mapped inputs/SALVIAS/party_code_party_/

planning/resources/dev_machine.specs/sys_info.spx+/system_power_settings.txt: updated: enabled PrioritizeNetworkReachabilityOverSleep

/README.TXT: Testing: added pointer to development machine specs

added planning/resources/dev_machine.specs/

inputs/SALVIAS/_MySQL/salvias_plots.*.sql: refreshed. this adds the party and party_code_party tables Brad provided for mapping the plot contributors.

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

inputs/SALVIAS/run_: documented *.sql install runtime (3 min), as separate from the full `datasrc_make reinstall` runtime (3.5 min)

inputs/SALVIAS/run_: refresh(): `datasrc_make reinstall`: updated runtime. documented that runtimes are from starscream.

added inputs/SALVIAS/run_, which includes a refresh() target

lib/runscripts/in_datasrc_dir.run: datasrc_make(): use `if remaking ...` instead of accessing $_remake manually, for clarity

bugfix: lib/runscripts/in_datasrc_dir.run: datasrc_make(): use set_make_vars and $_remake as required in lib/sh/make.sh `remaking`

lib/sh/make.sh: remaking alias: documented that you MUST use set_make_vars at the beginning of any function that uses this, so that $_remake is properly set to $remake and not left at its previous value

web/links/index.htm: updated to Firefox bookmarks. git: added instructions to migrate from svn.

web/links/index.htm: updated to Firefox bookmarks. git: added instructions to migrate from svn.

web/links/index.htm: updated to Firefox bookmarks. added instructions for running `svn switch` after moving everything into /trunk/ (for us, use `svn switch --force https://code.nceas.ucsb.edu/code/projects/bien/trunk # runtime: <1 min`).

web/links/index.htm: updated to Firefox bookmarks. added instructions for running `svn switch` after moving everything into /trunk/ (for us, use `svn switch --force https://code.nceas.ucsb.edu/code/projects/bien/trunk # runtime: <1 min`).

/: re-set svn:ignore on new root (/trunk/)

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

added standard svn dirs branches, tags, trunk