Geocoding Inventor Locations

From edegan.com
Revision as of 00:26, 30 July 2009 by imported>Ed
Jump to navigation Jump to search

This page details the various matching techniques used to Geocode inventor locations in the NBER patent data. Geocoding inventor locations entails matching the inventor addresses provided in the patent data to known locations through-out the world and recording their longitude and latitude.

Reference Data

The reference data for the locations (which provides the longitude and latitudes) is taken from the (U.S.) National Geospatial-Intelligence Agency's GEOnet Names Server which covers the world excluding the U.S. and Antartica.

The perl module (GNS.pm) loads, indexes and provides key variables from this data.


The Source And Reference Files

Source files are currently extracted from the NBER patent data on a per country basis. The original format of the source files was:

postcode WKU CTY city county

Where WKU is the patent number and CTY is an address field. The postcode, city and county are derived fields, either extracted from CTY by an algorithm or hand coded. These fields are error prone but contain some important information, particular regarding "historical curiosities", and approximately 1k of hand-corrected typos. As a first pass, however, the address fields are regenerated in the matching script.

Countries that are being processed include:

  1. The UK (Source file: UK-PatentInventorLocations.txt, Reference file: GNS-UK.txt)

Postal Codes

Postal codes, known as ZIP codes in the U.S., vary by national jurisdiction and for historical reasons. The following postal codes formats are posted for reference:

  • United Kingdom (Sourced from Wikipedia): A9 9AA, A99 9AA, A9A 9AA, AA9 9AA, AA99 9AA, AA9A 9AA. Simple Regex: ([A-Z]{1,2}[0-9]{1,2}[A-Z]{0,1}\s[0-9][A-Z]{2,2})