On 15/09/2007, Babu Naidu <[EMAIL PROTECTED]> wrote: > I am trying to convert Google Maps GMap.getBounds() (which returns LatLng > for south west and LatLng for north east) > to POLYGON( ) ewkt format. This is to query for points within that POLYGON. > > I think I figured out the format and I would like to verify it with experts > here. I have southwest Lat Lng and northeast LatLng > considering Y=Lng and X=Lat > > POLYGON(maxY maxX, > maxY minX, > minY minX, > minY maxX, > maxY maxX) > > Is this the right way to create a POLYGON? could you please point me to docs > if available that explain this format?
X should be Longitude, and Y Latitude. Always. in WKT you need double-brackets for a polygon, and the common convention is to do boxes in the following sequence: POLYGON((minx miny, maxx miny, maxx maxy, minx maxy, minx miny)) If you don't need to make WKT you could do the following instead, which creates a geometry you can use in queries, etc: MakeBox2D(MakePoint(minx, miny), MakePoint(maxx, maxy)) hth, Rob :) _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
