Project

General

Profile

« Previous | Next » 

Revision 11917

inputs/CVS/^taxon_observation.**.sample/create.sql: added Mike Lee's additional plots used to validate confidentiality-related fields (wiki.vegpath.org/CVS_validation#plots-to-include)

View differences:

inputs/CVS/^taxon_observation.**.sample/create.sql
77 77
, "individualCount"
78 78
, "accessionNumber"
79 79
FROM "taxon_observation.**"
80
WHERE "locationName" IN ('005-02-0301', '041-09-0577', '088-08-1204', '114-01-0043', '001-04-0226', '067-ANGE-6', '052-02-080')
80
WHERE "locationName" IN ('005-02-0301', '041-09-0577', '088-08-1204', '114-01-0043', '001-04-0226', '067-ANGE-6', '052-02-080', '003-03-0077', '067-DAVY-19')
81 81
	-- see wiki.vegpath.org/Spot-checking#CVS
82 82
; -- runtime: ~0 ("91.804 ms") @starscream

Also available in: Unified diff