Batchgeo

[Guest guest]

FYI. Cool website (http://www.batchgeo.com/) that I used to map all my

patients' addresses. Gives a Google map with lots of markers- interesting

visual representation of patient panel.

Here's what I did:

1) create .csv (comma separated values) file with address, city, state, zipcode

(no patient names)

2) display file in spreadsheet to make sure columns are lining up correctly

3) select all, copy

4) go to www.batchgeo.com and paste data into box

5) followed directions on website and waited about 30 minutes for it to process

the 1233 records I pasted

6) emailed link to the map to myself

7) look at map

Addendum: for anyone interested the the SQL command to create the file on my

system was-

SELECT address, city, state, zipcode INTO OUTFILE '/tmp/address.csv' FIELDS

TERMINATED BY '|' OPTIONALLY ENCLOSED BY " " LINES TERMINATED BY '\n' FROM

demographics;

I used '|' as a separator because I had commas in the address field that created

a problem if I used them to separate fields.

Mike Barron