15 pts.
 best solution for integrating longitude and latitude into another Database in mySQL
I have databases with longititude and latitude and one with Business Info - What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?

Software/Hardware used:
mySQL
ASKED: December 13, 2009  8:26 PM
UPDATED: December 17, 2009  11:35 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

We would need to know much more details about your requirements and how the information is related, to be able to answer your question.

 63,535 pts.

 

The common link between the two databases is the zip code – does this help?

 15 pts.

 

generally speaking, you are referring to GIS mapping coordinates. Lattitudes and longitudes (also include alttitude) are spatial object s, representing points and are captured from satelite signal using a GIS receiver, converted to 2 dimensional points and finally to pixel points on the flat screen and representing Points (x, y coordinates) on the flat map. A series of ordered points can represent a polygon (boundaries – eg country or area), a line (eg. road, river etc). A point ( x,y coordinates) can also be a node (represent a intersection, junction of roads. A point represent a location eg city, towns, address etc.

As for your question, if you think you need to use the logitudes/lattitude data wih your business info and turn into an application,, then merge them. To merge them, look for the common denominator, ie. a field which is common to both, and then create relevant tables in the business database to import the longitude/lattitude data into.The common field is the link between the coordinates and the business info. More importantly, you need to create an application out of this merger

it may interest you to find out what the coordinates represent. Try using a google map(of your country) and plot the points on it. You may be suprsed at what yousee.

 165 pts.