MySQL Forums
Forum List  »  GIS

Mysql 4.1.7 GIS spatial extension
Posted by: Ante Drnasin
Date: December 03, 2004 05:48AM

Anyone has some experience with MySQL GIS functions?I need some help...

I have entered some .shp files to column is GEOMETRY and MULTIPOLyGONS are entered to this fields and are shown as binary if you look into that field...ok....I managed to use SELECT AsText(ogc_geom) as trt FROM test_table
and I got

MULTIPOLYGON(((580764.3 141098.38,580763.03 141109.86,580771.82 141110.87,580773.08 141099.89,580764.3 141098.38)))

which is ok....but as you see the MULTIPOLYGON consists from several points...

is there any SQL way so that I extract POINTS from that MULTYPOLIGON so I don't have to parse the string i got back via programming language?

Any help would be appriciated...

Options: ReplyQuote

Written By
Mysql 4.1.7 GIS spatial extension
December 03, 2004 05:48AM
December 06, 2004 07:33AM
December 06, 2004 07:34AM
December 18, 2004 11:34PM
February 17, 2005 01:14AM
January 25, 2008 12:08AM

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.