Data Anomaly in Public Records
Through the Freedom of Information Act we are able to obtain database dumps from the Washington State BioTrack database. Here's a small anomaly we've noticed on this one.
Keep in mind, this is a system that is supposed to guarantee unique identifiers for all plants and inventory and provide robust tracking.
select id from inventory group by id having count(id) > 1;<br /> 0214523902408153<br />
Everyone knows that quality database systems don't enforce unique indexes on their system.
We reported this issue originally in Sept 2015 and again in Aug 2016.