MySQL Forums
Forum List  »  GIS

Re: Creating Spatial View
Posted by: Florence Tan
Date: November 02, 2010 03:05AM

After some search and testing, yes, it's possible. I managed to create a view with a point from existing table columns.

e.g
CREATE OR REPLACE VIEW view1 AS select
name,
longitude,
latitude,
point(longitude,latitude) geom_location
from table1

Options: ReplyQuote


Subject
Views
Written By
Posted
4438
November 01, 2010 03:18AM
2839
November 02, 2010 01:57AM
Re: Creating Spatial View
3383
November 02, 2010 03:05AM


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.