Revision 11375
Added by Aaron Marcuse-Kubitza over 10 years ago
| inputs/.geoscrub/geoscrub_output/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
|
|
| inputs/.geoscrub/geoscrub_output/test.xml.ref | ||
|---|---|---|
| 59 | 59 |
<geovalid> |
| 60 | 60 |
<_alt> |
| 61 | 61 |
<2>false</2> |
| 62 |
<1> |
|
| 63 |
<_and> |
|
| 64 |
<1>$latLongDomainValid</1> |
|
| 65 |
<2>$latLongInCountry</2> |
|
| 66 |
<3>$latLongInStateProvince</3> |
|
| 67 |
<4>$latLongInCounty</4> |
|
| 68 |
</_and> |
|
| 69 |
</1> |
|
| 62 |
<1>$geovalid</1> |
|
| 70 | 63 |
</_alt> |
| 71 | 64 |
</geovalid> |
| 72 | 65 |
</place> |
Also available in: Unified diff
inputs/.geoscrub/geoscrub_output/postprocess.sql: added geovalid derived column, for use by analytical_stem_view