You can easily manipulate those indeed. I also use the GEOMETRY fields, its
a bit hard to wrap your head around at first. One thing to remember is that
almost all calculations done by the database use MBR, this is a rectangle
around the geometry.
Some handy functions:
GeomFromText("POINT(54.2 4.8)"); <- a new point
GeomFromText("POLYGON(54.2 4.8, 50.1 4.1)"); <- a new polygon
AsText(geometryfield) <- returns the string value of the binary field
2008/11/22 Andy R <[EMAIL PROTECTED]>
>
> The best solution for using GIS data from MYSQL:
> http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html
>
> On 21 Nov., 23:59, sc0rpi0 <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > After reading Pamela's tutorial about using php&mysql in google maps
> > (http://code.google.com/support/bin/answer.py?
> > answer=65622&topic=11367&ctx=sibling) i was wondering how would i do
> > to represent a polygon in a mysql database instead of a single marker?
> >
> > Since each marker add a different key how would i connect different
> > points to being from the same polygon?
> >
>
--
Bjorn Brala
----------------
GeoStart.nl- Google maps - Swis Webdesign
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
