158
edits
Changes
Jump to navigation
Jump to search
→GeoCoding Companies, Firms, and Branch Offices
A helpful page here is the [[Geocode.py]] page which explains how to use the Geocoding script. You will have to tweak the Geocode script when geocoding as each of these tables has a different primary key. It is vital that you include the primary keys in the file you input and output from the Geocoding script. Without these, you will not be able to join the latitudes and longitudes back to the firm, branch office, or company base tables.
Geocoding costs money since we are using the Google Maps API. The process doesn't cost much, but in order to save money I tried to salvage as many much of the preexisting geocode information I could find.
===Companies===
I found the table of old companies with latitudes and longitudes in vcdb2 and loaded these into vcdb3.
