I would like to see all association members addresses on a Google map or a Map

Developers General
#1

Dear all,

I’ve got a table containing the addresses of about 2000 members and I would like to see this population over a map to understanding concentration or not on territory.
Have you got some hint on where to start and which are the steps in order to reach my goal ??

Many thanks
Giovannino

Attachment: somethink like that where pointing the little label you can see Last and first name and address

GoogleMaps_MoveLocationPointers_1.jpg

#2

Check out: https://developers.google.com/maps/documentation/staticmaps/#quick_example

#3

Thanks for the link.
For a non pro developer is there something more eatable… I mean something that use Scriptcase functions or an easy sample did with it ?
Thanks

#4

I havent seen any. This is rather more a google question then a scriptcase question.
I did find this http://minimizr.com/blog/2006/10/minimal-how-to-use-google-maps-api-with-php/
and this https://developers.google.com/maps/articles/phpsqlajax_v3
This should at least get you properly started.
More can be find by googling: php google maps pins

#5

Thanks so much again. It will be very hard for my skill level but… I will try the same to do samething in next future.
Bye Bye
Giovannino

#6

Not to discourage you, but you need to generate a javascript to be executed on the client side. Reason is that you are limited in the number of access attempts to GoogleMaps. So if you do it all on the server you will be hit by limitations. Best approach is to store the lang/att coordinates once based upon the addresses in the database. Then generate the javascript as documented on google. I did it often, but it’s not something for novice people imho.

#7

OK !
There is also an interesting tool www.batchgeo.com.
I did it manually for free and it’s quite easy. If you need a dinamic updating you have to pay an high fee.
Have a look and tell me your considerations.
Bye
Giovannino