US Address manipulation

• Project ID:

  1462102

• Project Type:

  Fixed

• Budget:

  $250-$750 USD
  (Approx. $333-$1000 NZD)

Project Description:

This project calls for creating a simple app to verify US address and provide functionality to determine if an address is in a location. Please view the attached screen view.

Application Flow (Asterix * denotes required functionality which is detailed afterwards):
---------------------
1) User will provide address* in "Preset" box which will be validated and completed*.
If address is good add it to the database table* otherwise show report.
2) User will provide address* in "Search" box which will be validated and completed*.
If address is good add it to the database table* and find if it falls within the boundaries of an entry in the db table and return it's id.

Detailed description for required functionality:
---------------------------------------------------------
1) "Provide Address" :
State is mandatory, following details assume it has been provided.

2) "Validated and completed"
Verify address details are valid by using Googles address services (map?geolocation?other) which may require key and some sort of registration. At first use sandbox/test account for testing and provide instructions how to register to real account/service.
If an error/mismatch is found, simply dump options as php array with fields as keys.
e.g $options = array (
[0] => array ('state'=>'other','county'=>'other'....)
[1] => array ('state'=>'other','county'=>'other'....)
...
)
If user provides only Zip, find city & county, if user provides city, find county.

3) "Database table"
You must store every valid completed address request from either form, in the database.
Store the following details at least: id(unique),state,county,city,zip,type(1 for FINDME, 2 for PRESET)
[ if user provided county, naturally city and zip will be blank]
If you need other parameters (geolocation, boundaries, etc) to use in the "find" portion, of course define and store them too.

Last Notes:
---------------
1) Please, by no means should you waste time on html or design, this is a sandbox display to see the code is good before we approve the project is complete.
2) There are many issues with googles api regarding city, locality, neighborhood and what not. The app you create will be tested against few use-cases to see it works well. We can provide these use-cases if you wish.
3) We assume that if you have knowledge and have created ths type of address validations, this should be no big project.

Thank you very much for reading and submitting your quote.

Additional Project Description:

02/23/2012 at 5:01 NZDT:
I was told the description may be a bit hard to read, I added a pdf with project definitions.

Skills required:

Geolocation, MySQL, PHP

Additional Files:

screen.jpg address+project+definition.pdf