Revision 13150
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/NY/validations.sql | ||
|---|---|---|
| 319 | 319 |
-- |
| 320 | 320 |
|
| 321 | 321 |
CREATE VIEW _specimens_15_list_distinct_locality_descriptions AS |
| 322 |
SELECT DISTINCT "Ecatalog_all".locality__main AS "localityDescription"
|
|
| 322 |
SELECT DISTINCT "Ecatalog_all".locality AS "localityDescription" |
|
| 323 | 323 |
FROM "Ecatalog_all" |
| 324 |
WHERE ("Ecatalog_all".locality__main IS NOT NULL);
|
|
| 324 |
WHERE ("Ecatalog_all".locality IS NOT NULL);
|
|
| 325 | 325 |
|
| 326 | 326 |
|
| 327 | 327 |
-- |
Also available in: Unified diff
fix: inputs/NY/Ecatalog_all/map.csv, postprocess.sql: remapped substrate, vegetation to locationRemarks