Project

General

Profile

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