MySQL offers ENVELOPE() to find the minimum bounding rectangle of a geometric object.
The result is a polygon with four segments, defined by five points. It took me a while to make sense of it, partially because the only documentation that I’ve run across so far for POLYGON() syntax is in the ENVELOPE() function mentioned above. I also had to draw a picture to think it through.
They write this: POLYGON(( MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY )), I think this (in pseudocode-ish form): POLYGON(( $point_a, $point_b, $point_c, $point_d, $point_a )), with the $point_s corresponding to the diagram.
Posted June 13, 2008 by Casey Bisson
Categories: Technology. Tags: geolocation, MBR, minimum bounding rectangle, mysql, MySQL spatial functions, spatial data, spatial functions.
1 Comment(s)
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
www.geo.pk (27) - www.geo urdu.com (18) - XXX89COM (11) - www.Geonews.pk (10) - www.geo news urdu.com (8) - point (7) - www.googalearth.com (6) - minimum bounding rectangle (6) - googalearth (6) - www.geo.tv.urdu.com (5) - googalearth.com (5) - www.googalearth (5) - Minimal Bounding Rectangle (4) - www.pink games.com (4) - geo.tv/urdu.com (4) - geo.urdu.com (3) - www. googalearth.com (3) - ww.urdu.com (3) - urdu.com.pk (3) - www.geo.tv.com (3) - www.geo tv.com (3) - geo urdu.com (3) - miny brewery (2) - minimum bounding rectangle US state (2) - geonews urdu.com (2) - minimum bounding rectangle. (2) - mysql spatial find MBR (2) - 89.COM ANIMALS.COM (2) - www.arab games.com (2) - geonews.urdu (2) - www.geo urdu.com, (2) - www.geo news urdu .com (2) - geonews.pk (2) - www.geo.news.urdu.com (2) - www.urdu.com (2) - www.pk urdu.com (2) - www.geo.tv.urdu (2) - animals vidio (2) - orld sex,com (1) - ww.urdu news.com (1) - ww.urdu geo tv .com (1) - www.pk.urdu.com (1) - www.geo news.urdu.com (1) - world urdu.com (1) - pinck games.com (1) - ww.urdu (1) - www.geo.pk] (1) - www.vidio animals sex.com (1) - 89.com.animals (1) - Polygon bounding rect (1) - www-geourdu.com (1) - xxx video in urdu.com (1) - geo.tv.urdu.com (1) - www.geo.tv.urdu.com. (1) - HTTP WW 89 AR COM (1) - geonews/urdu.com (1) - www.geonews.urdu.com/ (1) - draw a bounding rectangle to a polygon (1) - www.geo.tv urdu (1) - www.geonews.urdu.com (1) - www.geo urdutv (1) -
so i’m looking at all your posts about mysql and gis, and i’m kinda curious what you’re working on - might it be relating LCSH geographic subdivisions to map data? now there’s a world of fun and discovery!