MySQL Forums
Forum List  »  GIS

Help with Spatial Extension
Posted by: Peter Battaglia
Date: April 17, 2007 08:19PM

Hello,

I am having problems getting geometry into my DB table. I am using XAMPP which uses MySQL 5.0. I built my table with a column of type "geometry". I have been able to manually enter a point, but when I try and enter another, different point, it gives me an error regarding "duplicate geometry".

I'm also having issues inserting data through my php scripts. Below is one of the queries I am using:
$insert_statement = "INSERT INTO `order`(geom) VALUES (GeomFromText(POLYGON('$wkt_poly')))";

Where $wkt_poly = (39.75326104990142 -104.97015953063965 , 39.74930171012357 -104.95805740356445 , 39.74633205595244 -104.96458053588867 , 39.74633205595244 -104.96458053588867 , 39.75326104990142 -104.97015953063965)

Thoughts?

Also, anyone know if it's possible to access mysql command line with xampp??
Thanks!



Edited 1 time(s). Last edit at 04/17/2007 08:20PM by Peter Battaglia.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help with Spatial Extension
4468
April 17, 2007 08:19PM


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.