Changes

The vcdb3 portcogeo table was saved as vcdb3portcogeo.txt and uploaded to vcdb4. Then a new table, '''companyneedsgeo''' was created with valid addresses that could be geolocated.There were less than 200 repeat addresses (see examples below) out of 5519 to be geocoded. SELECT address, count(*) FROM companyneedsgeo GROUP BY address HAVING COUNT(*) >1; /* address count 501 Massachusetts Avenue, Cambridge, MA, 02139 4 479 Jessie Street, San Francisco, CA, 94103 4 745 Atlantic Avenue, Boston, MA, 02111 4 80 State Street, Albany, NY, 12207 4 953 Indiana Street, San Francisco, CA, 94107 5 79 Madison Avenue, New York, NY, 10016 5 400 Technology Square, Tenth Floor, Cambridge, MA, 02139 6 440 North Wolfe Road, Sunnyvale, CA, 94085 7 */ Then run [[Geocode.py]] on the output file (broken into 2500 address queries). python3 Geocode.py companyneedsgeo1-2499.txt