google map, php, database combination

• Project ID:

  466323

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Bid on this project ONLY if you have created a dynamic google map with php, reading lat/lon from a database table.

We have a dynamically generated map with over 120 locations.
The map renders slowly because we are displaying all 120 markers.

I require someone with experience to create the following on a google map:

Stage 1:
Show map of North America, and only states where there are locations need to be highlighted.
when user click on a state zoom into the closest zoom that will accommodate ALL locations within that state. the states with locations must be displayed visibly different to states without locations.

Stage 2:
user presses a state. zoom into the state into level where all locations can be seen.
Group together all markers which are close to each other, for this zoom level. The marker should display a number which is the number of locations this marker represents.

Stage 3
clicking on this marker will zoom into this area (closest zoom to show all locations under the marker in stage 2). some locations MAY show under one marker (repeat procedure from stage 2, other locations will show their own location. clicking on a marker that is showing a single location will show it's address (a field in the database) and a url link (<a href="">) with the id (also from a database).

table locations:
CREATE TABLE `location` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`point_x` varchar(12) DEFAULT NULL,
`point_y` varchar(12) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`active` int(11) DEFAULT '1',
PRIMARY KEY (`id`)

CREATE TABLE `city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`state_id` int(11) DEFAULT NULL,
`groupid` int(11) DEFAULT '0',
PRIMARY KEY (`id`)

CREATE TABLE `states` (
`abbr` char(2) DEFAULT NULL,
`state_english` varchar(20) DEFAULT NULL,
`state_spanish` varchar(20) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '',
`stateID` int(11) NOT NULL AUTO_INCREMENT,
`active` int(11) DEFAULT '0',
PRIMARY KEY (`stateID`)

when showing states only show states that have locatins: you will need to do a select on states with join to city and location.

when show cities in a state only show cities which have locatins. you will need to select on cities with join on location.

only select locations which are active. location.active=1

All code to be written in PHP.

Successful bidder will be shown working example without the marker grouping which needs to be created.

another required feature is search by zip, with proximity in miles.
a box where user can enter a zip code in North America, and a select box with 10,20,50 miles, and a submit button.

when user enters the zip code and presses enter, then you need to present to user all location in the area of the zip, based on the distance. if no location near the requested zip code, zoom out until at least one location is found.

This project MUST be completed by Monday.
Only bid if you can deliver in the time frame and you have experience with google maps api.

Payment terms will be 50% when you show the code working on your hosted server. balance will be paid once we recieve the code and verify that it is working.
Sample data will be provided.

I expect you to ask necessary questions to clarify this project.

Good luck.

Skills required:

PHP, SQL