best solution for integrating longitude and latitude into another Database in mySQL

15 pts.
Tags:
Database management
MySQL
MySQL Database
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    We would need to know much more details about your requirements and how the information is related, to be able to answer your question.
    68,585 pointsBadges:
    report
  • Tcollins
    The common link between the two databases is the zip code - does this help?
    15 pointsBadges:
    report
  • Twlp123
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following