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.