Revision 5869
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 551 | 551 |
`scientificName` text, |
| 552 | 552 |
`scientificNameAuthorship` text, |
| 553 | 553 |
`scientificNameWithMorphospecies` text, |
| 554 |
`coverPercent` double precision, |
|
| 554 | 555 |
`individualCount` text, |
| 555 | 556 |
`individualCount_1_to_2_5cm` text, |
| 556 | 557 |
`individualCount_2_5_to_10cm` text, |
| schemas/vegbien.sql | ||
|---|---|---|
| 1055 | 1055 |
"scientificName" text, |
| 1056 | 1056 |
"scientificNameAuthorship" text, |
| 1057 | 1057 |
"scientificNameWithMorphospecies" text, |
| 1058 |
"coverPercent" double precision, |
|
| 1058 | 1059 |
"individualCount" bigint, |
| 1059 | 1060 |
"individualCount_1_to_2_5cm" bigint, |
| 1060 | 1061 |
"individualCount_2_5_to_10cm" bigint, |
Also available in: Unified diff
schemas/vegbien.sql: analytical_aggregate_view: Added coverPercent, which is the sum of all coverPercents for that species