Changes

The ptoproperty_cleaned documentids were checked again to see which numbers would watch with verify the patent kind of different patents as specified in the ptoproperty tables.  First the table ptopropertynd was made, including only the distinct documentids in ptoproperty_cleaned.   DROP ptopropertynd; CREATE TABLE ptopropertynd AS SELECT DISTINCT * FROM ptoproperty; --27266638 By creating this table, I also address the duplications caused by the kind XO. The breakdown of