Revision 11375
Added by Aaron Marcuse-Kubitza over 10 years ago
| postprocess.sql | ||
|---|---|---|
| 57 | 57 |
SELECT mk_derived_col((:table_str, 'latLongInCountry' ), $$map_geovalidity("latLongInCountry_verbatim" )$$); -- runtime: 1.5 min ("Time: 95967.016 ms") @starscream
|
| 58 | 58 |
SELECT mk_derived_col((:table_str, 'latLongInStateProvince'), $$map_geovalidity("latLongInStateProvince_verbatim")$$); -- runtime: 1.5 min ("Time: 95003.576 ms") @starscream
|
| 59 | 59 |
SELECT mk_derived_col((:table_str, 'latLongInCounty' ), $$map_geovalidity("latLongInCounty_verbatim" )$$); -- runtime: 1.5 min ("Time: 94405.944 ms") @starscream
|
| 60 |
|
|
| 61 |
SELECT mk_derived_col((:table_str, 'geovalid'), |
|
| 62 |
$$_and("latLongDomainValid", "latLongInCountry", "latLongInStateProvince", "latLongInCounty")$$
|
|
| 63 |
); -- runtime: 3 min ("Time: 173062.394 ms") @starscream
|
|
Also available in: Unified diff
inputs/.geoscrub/geoscrub_output/postprocess.sql: added geovalid derived column, for use by analytical_stem_view