root/trunk/inputs/Madidi/LocationObservation/postprocess.sql @ 14143
| 1 | 10346 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | 13964 | aaronmk | SELECT mk_derived_col((:table_str, 'verbatimEventDate'), |
| 4 | 13939 | aaronmk | $$"authorEventCode"$$); |
| 5 | |||
| 6 | 13964 | aaronmk | SELECT mk_derived_col((:table_str, 'eventDate'), |
| 7 | $$util.date_from_spanish("verbatimEventDate")$$); |
||
| 8 | |||
| 9 | 10346 | aaronmk | SELECT mk_derived_col((:table_str, 'locationRemarks'), |
| 10 | $$_alt("locationRemarks_1", "locationRemarks_2")$$); |
||
| 11 | -- _alt() is fine because only one of these is ever populated
|