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
User contributed tags for this post:
www.geo urdu.com (27) - www.geo.pk (27) - minimum bounding rectangle (15) - googalearth (15) - mysql mbr (14) - geotvurdu (12) - www.googalearth.com (10) - point (10) - WWW.GEONEWS URDU.COM (10) - www.Geonews.pk (10) - www.googalearth (9) - www.geo news urdu.com (8) - javascript bounding rect (8) - www.geo.tv.urdu.com (7) - ww.drawn-sex.com (7) - geo urdu.com (7) - geo.urdu.com (7) - googalearth.com (6) - ww.geo.tv.com (5) - Minimal Bounding Rectangle (5) - www.geotv.com urdu (5) - http;//.www.geo.tv.urdupoint.com (5) - javascript bounding rectangle (5) - MBR mysql (5) - www.pink games.com (4) - sex images urdu point (4) - www.geotv/urdu.com (4) - geo.tv/urdu.com (4) - www.geonews.urdu.com (4) - ww.urdu.com (4) - www.urdutv.com.in (4) - www.geo.tv.com (4) - minimum bounding rectangle calculate (4) - www.geo tv.com (4) - www.geotv.com (4) - w w w.world.sex.com (4) - www.geourdu.com (3) - www.urdu.com.pk (3) - urdu.com.pk (3) - mysql gis points in rectangle (3) - Polygon bounding rectangle (3) - www. googalearth.com (3) - www.geo.tv/urdu.com (3) - www.geonews.urdu.pk.com (3) - draw a bounding rectangle (3) - Calculate the minimum bounding rectangle for the objects (3) - urdutv sex'com in (3) - 1-world-sex.com (3) - urdu.com (3) - urdutv (3) - geo urdu (3) - w/w/world/sex.com.pk (2) - www.geo urdu.com, (2) - minimum bounding rectangle US state (2) - calculating image bounding rectangle (2) - geonews urdu.com (2) - wwurdu.point.com (2) - www.geo news urdu .com (2) - arcgis draw bounding rectangles polygons (2) - calculate bounding rectangle of a polygon (2) - www.urdu sex story write in urdu.com.pk (2) - javascript boundingrect (2) - mysql GIS bounding rectangle (2) - minimum bounding rectange” (2) - ww/geourdu (2) - RECTANGLE STUFF (2) - minimal rect (2) - find minimum rectangle (2) - ww.geo 8 sex (2) - BOUNDING SEX IMAGES (2) - urdusex.pk.com (2) - arcgis bounding rectangle (2) - image bounding rectangle (2) - www.geotvurdu (2) - pk urdu sex (2) - ww.drawn.sex.com (2) - 2www.worldsex.com. (2) - ArcGIS minimum bounding rectangle (2) - GEO URDU SEX (2) - GEOTVURDU.COM (2) - www.pk urdu.com (2) - www.pk.urdu.com (2) - ww.urdu (2) - find MBR (2) - pinck games.com (2) - www.orld sex phots (2) -
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!