Basic GEO-LOCATION GPS php class
$30-300 USD
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
Project ID: #2508375
About the project
Awarded to:
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.
11 freelancers are bidding on average $300 for this job
I have worked with mySQL and PHP. Your topic is very interesting. Hope to get a chance to work on this. Thanks.
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
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