doolin/patentprocessor — pull request #10 by laironald (2012-07-02 01:28:00+00:00)
Title: some refactoring

modified the SQLite library. hopefully its cleaner.
able to read in GNS / NATL / Typos databases

General idea
Inventor --> Add Long/Lat
Assignee --> Add Long/Lat
*Will not have full coverage

B2_LocationMatch creates a dataset which when merging against
Note: Assignee does not have Zipcode (which tends to be shotty anyways) --
This likely will grab the "FIRST" zipcode centroid rather than the city centroid
Inventor does -- Inventor also has "Street Address" but use Lat/Long
Works in level of granular > coarse (most coarse = City, State, Country) -- when applicable

Assignees also use pdpAsg matches for disambiguation purposes. the bulk of that code should be in orgClean.py

Note: organizations are extremely messy. The name "Hewlett Packard" has probably ~100 variations.