CVS issues¶
- Table of contents
- CVS issues
Coordinate fuzzing is sometimes used¶
Which coordinates do we want to put in VegBIEN?
Rows affected: 13% (38,729 of 300,017)
Sample rows:
row_num | authorObsCode | realLatitude | realLongitude | locationAccuracy-m | publicLatitude | publicLongitude | confidentialityStatus |
27064 | 005-03-0316 | [hidden] | [hidden] | 10 | 36 | -81.8 | 2 |
275667 | 082-01-1100 | [hidden] | [hidden] | 6 | <NULL> | <NULL> | 0 |
Query:
SELECT * FROM "CVS"."Organism" WHERE "publicLatitude" IS DISTINCT FROM "realLatitude" OR "publicLongitude" IS DISTINCT FROM "realLongitude" ORDER BY row_num