MySQL Forums
Forum List  »  GIS

Creating a Spatial database and query..
Posted by: Ali kKhan
Date: June 14, 2007 11:32AM

Hey. New to using spatial databases so a few questons. Essentially we want to load a list of countries and when one clicks on a map the coordinates long/lat are sent to a page.

We want at able with countries and their poly info. We have the bounding boxes for all countries (BBox West/North?East/South). The question is what sort of database do we need to create or table schema and what sort of query do we need to run. I think this is the query but im not sure

SET @g2 = GeomFromText('Point(long lat)');
SELECT MBRContains(@g2)

replace the long lat with the appropriate coordinates obviously.

Options: ReplyQuote


Subject
Views
Written By
Posted
Creating a Spatial database and query..
6835
June 14, 2007 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.