Revision 14556
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.geoscrub/geoscrub_output/postprocess.sql | ||
|---|---|---|
| 49 | 49 |
2: Point is <=5km from putative GADM polygon, but still outside it |
| 50 | 50 |
3: Point is in (or on border of) putative GADM polygon |
| 51 | 51 |
" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT) |
| 52 |
|
|
| 53 |
0=>false: unscrubbable names should be geo*in*valid, according to Brad: |
|
| 54 |
"I recommend that for Canada and the US, we do NOT mark as geovalid any record |
|
| 55 |
which cannot be validated at least to the second-level political division" |
|
| 56 |
(mailto:bboyle@email.arizona.edu?Brad_Boyle.2014-8-19-17:50PT.Re:_[Bien-db]_NSR_batch_run) |
|
| 52 | 57 |
*/ |
| 53 |
SELECT util._map('-1=>NULL, 0=>NULL, 1=>false, 2=>true, 3=>true', $1::text)::boolean
|
|
| 58 |
SELECT util._map('-1=>NULL, 0=>false, 1=>false, 2=>true, 3=>true', $1::text)::boolean
|
|
| 54 | 59 |
$BODY$ |
| 55 | 60 |
LANGUAGE sql IMMUTABLE |
| 56 | 61 |
COST 100; |
Also available in: Unified diff
fix: inputs/.geoscrub/geoscrub_output/postprocess.sql: map_geovalidity(): unscrubbable names should actually be geo*in*valid, not geovalid=NULL, according to Brad