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


Subject
Views
Written By
Posted
Mysql 4.1.7 GIS spatial extension
5048
December 03, 2004 05:48AM
3293
December 06, 2004 07:33AM
3161
December 06, 2004 07:34AM
3431
December 18, 2004 11:34PM
3210
February 17, 2005 01:14AM
3145
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.