Revision 5978
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/SALVIAS/verify/plots.ref.sql | ||
|---|---|---|
| 2 | 2 |
SELECT count(*) AS count FROM projects; |
| 3 | 3 |
|
| 4 | 4 |
SELECT 'projects' AS ___; |
| 5 |
SELECT CAST(project_id AS text) AS project FROM projects ORDER BY project;
|
|
| 5 |
SELECT CAST(project_name AS text) AS project FROM projects ORDER BY project;
|
|
| 6 | 6 |
|
| 7 | 7 |
SELECT 'each project''s # locations' AS ___; |
| 8 | 8 |
SELECT |
| inputs/SALVIAS/verify/plots.ref | ||
|---|---|---|
| 5 | 5 |
___ |
| 6 | 6 |
projects |
| 7 | 7 |
project |
| 8 |
1
|
|
| 9 |
10
|
|
| 10 |
11
|
|
| 11 |
12
|
|
| 12 |
13
|
|
| 13 |
14
|
|
| 14 |
17
|
|
| 15 |
18
|
|
| 16 |
19
|
|
| 17 |
2
|
|
| 18 |
21
|
|
| 19 |
22
|
|
| 20 |
23
|
|
| 21 |
24
|
|
| 22 |
25
|
|
| 23 |
26
|
|
| 24 |
3
|
|
| 25 |
5
|
|
| 26 |
6
|
|
| 27 |
7
|
|
| 28 |
8
|
|
| 29 |
9
|
|
| 8 |
ACA Amazon Forest Inventories
|
|
| 9 |
Bonifacino Forest Transects
|
|
| 10 |
Boyle Transects
|
|
| 11 |
Cam Webb Borneo Plots
|
|
| 12 |
DeWalt Bolivia forest plots
|
|
| 13 |
Enquist Lab Transect Dataset
|
|
| 14 |
Gentry Transect Dataset
|
|
| 15 |
INW Vegetation Plots
|
|
| 16 |
Inventarios de Bosques de la Costa del Ecuador
|
|
| 17 |
Inventarios de Bosques en Ecuador
|
|
| 18 |
La Selva Secondary Forest Plots
|
|
| 19 |
Madidi Permanent Plots
|
|
| 20 |
Madidi Savana Line Transects
|
|
| 21 |
Madidi Transects
|
|
| 22 |
Noel Kempff Forest Plots
|
|
| 23 |
Noel Kempff Savanna Plots
|
|
| 24 |
OTS Transects
|
|
| 25 |
Pilon Lajas Treeplots Bolivia
|
|
| 26 |
RAINFOR - 0.1 ha Madre de Dios, Peru
|
|
| 27 |
RAINFOR - 1 ha Peru
|
|
| 28 |
SERBO Selva Seca Oaxaca
|
|
| 29 |
test
|
|
| 30 | 30 |
___ |
| 31 | 31 |
each project's # locations |
| 32 | 32 |
project locations_count |
Also available in: Unified diff
inputs/SALVIAS/verify/plots.ref.sql: Use project_name instead of project_id as the ID to list for each project, since the SALVIAS projects table is now mapped to the DB and the project_name is used as project.projectname