Revision 13939
Added by Aaron Marcuse-Kubitza over 10 years ago
| postprocess.sql | ||
|---|---|---|
| 1 | 1 |
SELECT util.search_path_append('util');
|
| 2 | 2 |
|
| 3 |
SELECT mk_derived_col((:table_str, 'eventDate'), |
|
| 4 |
$$"authorEventCode"$$); |
|
| 5 |
|
|
| 3 | 6 |
SELECT mk_derived_col((:table_str, 'locationRemarks'), |
| 4 | 7 |
$$_alt("locationRemarks_1", "locationRemarks_2")$$);
|
| 5 | 8 |
-- _alt() is fine because only one of these is ever populated |
Also available in: Unified diff
fix: inputs/Madidi/LocationObservation/postprocess.sql: populated missing eventDate from PlotInventoryName (authorEventCode)