pull records from postgres that lack a lat/long position value and update accordingly via google's geocoding api

addLocations.js

var pg = require('pg');
var request = require('request');

function getUrl(location) {
	return 'https://maps.googleapis.com/maps/api/geocode/json?address=' + location.address + ', ' + location.city + ', ' + location.state + ' ' + location.zip_code;
}

var count = 0;

pg.connect(connString, function(err, client, done) {
	if (err) throw err;
	client.query('SELECT id, address, city, state, zip_code FROM companies WHERE pos IS NULL', function(err, result) {
		if (err) throw err;
		console.log(result.rows.length + ' to go');
		result.rows.forEach(function(company, i) {
			request(getUrl(company), function(err, res, body) {
				if (err) throw err;
				body = JSON.parse(body);
				if (body.status == 'OK') {
					var location = body.results[0].geometry.location;
					client.query('UPDATE companies SET pos = point($1, $2) WHERE id = $3;', [location.lng, location.lat, company.id], function(err, result) {
						if (err) throw err;
						console.log('Done ' + ++count);
						/*console.log(company.id);
						console.log(location);
						console.log(getUrl(company));*/
						if (count === 1500) process.exit();
					});
				} else {
					console.log('ERROR: AT COMPANY ID ' + company.id);
				}
			});
		});
	});
});