Basic GEO-LOCATION GPS php class

In Progress Posted Sep 22, 2012 Paid on delivery
In Progress Paid on delivery

This small project is to create two tables in a mysql database to hold POI GPS data and to create a basic php class to retrieve, insert, update, delete data from the table. The class must also do some location calculations such as distance, speed, POI within an area, etc. There is some ajax/JSON involved.

Please review the attached document for details. It is OpenOffice format.

Please post bids, time it will take and any experience that you have had with location based GPS apps.

I may not be able to respond right away to any inquiries because I will be out of town for a few days.

This is what is in the attached file


Requirements
Create a geo-spatial class that will handle geo-spatial data using php and mysql. The data must be maintained so that distance between point and within boundaries have an accuracy of +-10 feet/meters. This means that the fields holding the location parameters must have a data-type with the precision for such calculations. The class will return data, allow for insert, update, and deleting of records.

Also a test page will be created to test the functionality of the class. The test page will have:
a list of geo locations checkboxes
a list of types checkboxes
start textbox
limit textbox
radius textbox
radio button for each method to test
radio options for display as list or display on map
submit button to submit the page to the method to test and return a page displaying the results either marked on a google map or in a table list as indicated by the radio button
an link to submit the page to the method to test via ajax and display the result in a div containing either marked on a google map or in a table list as indicated by the radio button

The database will have 2 tables. One will hold geo-data for points of interests(POI) and the other will hold a list of available POI types. Should contain a geo-spatial point column which is indexed. Indexes should be on any other columns needed for optimization and for return results quickly. The poi table wil be populated with 1 million rows for testing and queries should return results in less than 1.5 seconds (See example procedure below to populate table with random gps data).

all data will be sanitized before going into the database.

Example tables:
POI table
poi_serno unique record identifier
lat latitude
lng longitude
location geo-spatial point
direction dattype unknown ( See below in methods)
poi_type_serno fk to poi_type_table
create_dt
create_by
last_change_dt
last_change_by

POI_TYPE table
poi_type_serno unique record identifier
short_descr Short description for this type
long_descr Long description for this type
create_dt
create_by
last_change_dt
last_change_by

Geo class with the following methods:
**Note each method will have a JSON conterpart. The JSON method will accept the inputs as JSON format and the returned data will be in JSON format for ajax calls.

Each method name and parameters may need adjusting to work correctly. The lat and lng data will be read from a gps device and or a mapping service such as google, yahoo, etc.

1) getPOI(lat,lng, type, radius, start,limit)
1. type is optional
2. return array of (lat,lng) for all records within the radius
3. if type supplied then only of that type otherwise all
4. start and limit is optional to designate which records to return for paging
5. if start is null and limit is passed then only return the number of records in limit
2) getDistance(lata,lnga,latb,lngb,unit_of_measure)
1. return distance between two points in unit of measure supplied
2. units of measure: feet, miles, meters, kilometers
3. accuracy must be +- 10 feet/meters
3) getDistance(lata,lnga,latb,lngb,unit_of_measure) ARRAY
1. return distance between two points(lat/lnga and lat/lngb) in unit of measure supplied in an array along with the input parameters
2. units of measure: feet, miles, meters, kilometers
3. accuracy must be +- 10 feet/meters
4) getSpeed(lata,lnga, timea, latb, lngb, timeb, unit_of_measure) – for single record and array of records
1. return speed between two points in unit of measure supplied
2. units of measure: mph, kph
accuracy must be +- 1 mph/kph
5) getdirection(lata,lnga, timea, latb, lngb) – for single record and array of records
1. returns the direction between point a and point b. The example is traveling south down a road and location “a” is marked. you keep traveling south and then mark position”b. So the direction for position “b” can be obtained as south by comparing gps point “a” to gps point “b”. Point “b” is stored in the database with some sort of ide

AJAX HTML5 Mobile App Development MySQL PHP

Project ID: #2508375

About the project

11 proposals Remote project Active Oct 2, 2012

Awarded to:

drnsolutions

PLEASE CHECK OUR EARNING, REVIEW AND FEEDBACK... We checked your post and understood as well. For detail bid please check private message board(PMB). Thanks.

$200 USD in 7 days
(11 Reviews)
5.0

11 freelancers are bidding on average $300 for this job

programac

P.M.B for details

$300 USD in 14 days
(36 Reviews)
5.4
mxicoders

Dear Sir/Madam How is your week-end? I would like to present our company as well established company and having good experience in open-source customization and web and smartphone application development We were not More

$300 USD in 10 days
(8 Reviews)
4.8
nptganapathy

I have worked with mySQL and PHP. Your topic is very interesting. Hope to get a chance to work on this. Thanks.

$300 USD in 15 days
(3 Reviews)
2.7
olivesofttech1

My teams are very interested in your project and would like to go for the project. Please let me know your best time so that we can discuss the project in more details and finalize it. Just consider once, you will not More

$300 USD in 12 days
(1 Review)
2.0
software4moving

I would like to request you to read the Private Message carefully. Thanks

$500 USD in 5 days
(0 Reviews)
0.0
P78FEjgH2

Custom software development (<b><i>Removed by Admin</i></b>)

$300 USD in 1 day
(0 Reviews)
0.0
rsen75

Kindly check PM

$250 USD in 6 days
(0 Reviews)
0.0
redextechnology

Hi, We are a startup company in India and are taking Android and Iphone projects. We are very efficient in location based applications and have also deliver a similar app to one of the customers. More info is in PMB More

$250 USD in 10 days
(0 Reviews)
0.0
KFBQ380xo

Custom software development (<b><i>Removed by Admin</i></b>)

$300 USD in 1 day
(0 Reviews)
0.0