Todd Miner wrote:
What I'd really like to see is a mashup of the posted addresses on
the ward web site with Google maps.  Since I work at the stake level,
I'd love to see all the stake members pinpointed on a map with
different color pushpins for their ward assignments.  I'm sure this
is possible, and I have even found websites that will publish my
spreadsheet full of addresses via Google maps - but they charge for
their services.

Sounds like a great open source project.  :)

Here's a resend of an earlier e-mail about how to put together your own Google ward map:

Another project I've attempted recently (and which I've seen discussed in earlier posts) is using Google Maps in conjunction with a ward list to see where members live. I've put together some of the files I used for this and have compiled instructions on how someone might do something similar.

These are the steps:

0.  Download http://www.mandarintools.com/download/wardmap.zip
1.  Open official Ward website and select "Membership Directory"
2.  Select "Abbreviated" to get entire ward list.
3.  Select all and save to a separate text file: "directory.txt".
4.  Take off the header and footer lines.
5. Run the Perl script "getlatlon.pl" (from the zip file) to convert the addresses to latitude and longitude coordinates, saved in a file called "warddata.xml" - This script calls out to the geocoder.us website and requires the program "wget". This could also be done with the geocoder perl module. - Some massaging of your ward directory may be necessary. I found a lot of incomplete addresses, addresses with misspellings, etc. All addresses that can't be found are saved to the file notfound.txt. Save and forward this the the membership clerk to correct the official list. 6. Check the notfound.txt to look for errors and repeat step 5 until satisfied. 7. Edit wardmap.html line 12 and change YOURGOOGLEMAPKEY to your own Google Map Key, available at http://www.google.com/apis/maps/ .
   - Keep track of the directory you specify for the maps during sign-up
8. Edit wardmap.html line 38 to reflect longitude and latitude coordinates that are the center your ward and not the middle of Pittsburgh. 9. Save warddata.xml and wardmap.html (in wardmap.zip) to a password-protected directory on a web server (the password protection isn't necessary, but a really good idea). This will be the same directory specified when signing up for the Google Maps API Key. 10. Visit wardmap.html and click on individual member's markers to see more information.

There are lots of other possible extensions (find five closest members, etc.) that could be added. A lot of bugs probably still need to be fixed also.
_______________________________________________
Ldsoss mailing list
[email protected]
http://lists.ldsoss.org/mailman/listinfo/ldsoss

Reply via email to