Changes

Jump to navigation Jump to search
====Cleaning up the USPTO Assignee Data====
Existing documentation that seems relevant to cleaning/moving the UPSTO Assignee data over from the RDP database:http://mcnair.bakerinstitute.org/wiki/USPTO_Bulk_Data_Processinghttp://mcnair.bakerinstitute.org/wiki/PTO_Tableshttp://mcnair.bakerinstitute.org/wiki/USPTOAssigneesData The xml_parser2.plx creates four tables: Assignment, Assignees, Assignors, and Properties. These appear to correspond to ptoassignment, ptoassignee, ptoassignor, and ptoproperty, respectively in the "patent" database. There is another pto table called "ptopatentfile" that has the following schema, but I cannot find out how it is populated; the xml_parser2.plx does not create this table.  Table "public.ptopatentfile" Column | Type | Modifiers | Storage | Stats target | Description ------------------------+-----------------------+-----------+----------+--------------+------------- reel_no | integer | | plain | | frame_no | integer | | plain | | action_key_code | character varying(10) | | extended | | uspto_transaction_date | date | | plain | | uspto_date_produced | date | | plain | | version | numeric | | main | |   

Navigation menu