Revision 13138
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/NY/validations.sql | ||
|---|---|---|
| 258 | 258 |
WHERE ("Ecatalog_all"."decimalLatitude" IS NOT NULL)) AS "allLats",
|
| 259 | 259 |
( SELECT count(DISTINCT ROW("Ecatalog_all"."decimalLatitude", "Ecatalog_all"."decimalLongitude")) AS count
|
| 260 | 260 |
FROM "Ecatalog_all" |
| 261 |
WHERE ("Ecatalog_all"."decimalLatitude" ~ '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'::text)) AS "decimalLats",
|
|
| 261 |
WHERE is_castable("Ecatalog_all"."decimalLatitude", NULL::double precision)) AS "decimalLats",
|
|
| 262 | 262 |
( SELECT count(DISTINCT ROW("Ecatalog_all"."decimalLatitude", "Ecatalog_all"."decimalLongitude")) AS count
|
| 263 | 263 |
FROM "Ecatalog_all" |
| 264 | 264 |
WHERE ("Ecatalog_all"."decimalLongitude" IS NOT NULL)) AS "allLongs",
|
| 265 | 265 |
( SELECT count(DISTINCT ROW("Ecatalog_all"."decimalLatitude", "Ecatalog_all"."decimalLongitude")) AS count
|
| 266 | 266 |
FROM "Ecatalog_all" |
| 267 |
WHERE ("Ecatalog_all"."decimalLongitude" ~ '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'::text)) AS "decimalLongs";
|
|
| 267 |
WHERE is_castable("Ecatalog_all"."decimalLongitude", NULL::double precision)) AS "decimalLongs";
|
|
| 268 | 268 |
|
| 269 | 269 |
|
| 270 | 270 |
-- |
Also available in: Unified diff
fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: use new is_castable(), which is much more accurate than Brad's custom regexp for determining if something is numeric