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.
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.